The hardware and bandwidth for this mirror is donated by dogado GmbH, the Webhosting and Full Service-Cloud Provider. Check out our Wordpress Tutorial.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]dogado.de.
dbMatrix objects support Arith and
Ops operations. We will demonstrate how to perform
arithmetic operations on dbSparseMatrix objects.
Note on sparse matrices: a
dbSparseMatrix stores only non-zero values. Operations that
turn 0 into something else, such as x + 1,
1 / x, exp(x) or x == 0, first
fill in the zeros, which can use a lot of space for large matrices. This
only happens when options(dbMatrix.allow_densify = TRUE) is
set; otherwise these operations give an error. log(),
log2() and log10() are the exception: they
transform only the stored values and leave zeros at 0. See
?dbMatrix_options and
?Math,dbMatrix-method.
Please report problems on GitHub.
Let’s create a simple sparse matrix for demonstration:
# Create a sparse matrix
set.seed(42)
dgc <- Matrix::rsparsematrix(100, 50, density = 0.1, rand.x = function(n) rpois(n, 5) + 1)
rownames(dgc) <- paste0("gene_", seq_len(100))
colnames(dgc) <- paste0("cell_", seq_len(50))
dplyr::glimpse(dgc)
#> Formal class 'dgCMatrix' [package "Matrix"] with 6 slots
#> ..@ i : int [1:500] 1 7 15 26 32 38 48 81 90 93 ...
#> ..@ p : int [1:51] 0 12 22 33 38 46 54 66 80 89 ...
#> ..@ Dim : int [1:2] 100 50
#> ..@ Dimnames:List of 2
#> .. ..$ : chr [1:100] "gene_1" "gene_2" "gene_3" "gene_4" ...
#> .. ..$ : chr [1:50] "cell_1" "cell_2" "cell_3" "cell_4" ...
#> ..@ x : num [1:500] 4 7 5 7 3 8 4 5 4 7 ...
#> ..@ factors : list()The matrix contains 100 rows (genes) and 50 columns (cells). Like most single-cell RNA-seq data, the matrix is sparse.
Let’s create a dbSparseMatrix object from the above
dgc object.
# Note: by default the constructor creates a dbMatrix object in-memory
con <- DBI::dbConnect(duckdb::duckdb(), ":memory:")
dbsm <- dbMatrix(
value = dgc,
con = con,
name = "test_matrix",
class = "dbSparseMatrix",
overwrite = TRUE
)
# preview the object
dbsm
#> 100 x 50 dbMatrix of class "dbSparseMatrix"
#> [[ Colnames 'cell_1', 'cell_2', 'cell_3' ... suppressing 44 ...'cell_48', 'cell_49', 'cell_50' ]]
#>
#> gene_1 . . . . . . 5.0000000 .
#> gene_2 4.0000000 . . . . . . .
#> gene_3 . 7.0000000 . . . 8.0000000 . 3.0000000
#>
#> ......suppressing 40 columns and 94 rows
#>
#> gene_98 . . . . . . . .
#> gene_99 . . 5.0000000 . . . . .
#> gene_100 7.0000000 . . . . . . .dbMatrix emulates scalar arithmetic in the
Matrix package.
Note: Addition or subtraction with non-zero addends on a
dbSparseMatrix results in a dbDenseMatrix.
dbsm + 1
#> ℹ Performing on-the-fly densification (cold path). See ?dbMatrix_options for details.
#> 100 x 50 dbMatrix of class "dbDenseMatrix"
#> [[ Colnames 'cell_1', 'cell_2', 'cell_3' ... suppressing 44 ...'cell_48', 'cell_49', 'cell_50' ]]
#>
#> gene_1 1.0000000 1.0000000 1.0000000 1.0000000 1.0000000 1.0000000 6.0000000
#> gene_2 5.0000000 1.0000000 1.0000000 1.0000000 1.0000000 1.0000000 1.0000000
#> gene_3 1.0000000 8.0000000 1.0000000 1.0000000 1.0000000 9.0000000 1.0000000
#>
#> ......suppressing 40 columns and 94 rows
#>
#> gene_98 1.0000000 1.0000000 1.0000000 1.0000000 1.0000000 1.0000000 1.0000000
#> gene_99 1.0000000 1.0000000 6.0000000 1.0000000 1.0000000 1.0000000 1.0000000
#> gene_100 8.0000000 1.0000000 1.0000000 1.0000000 1.0000000 1.0000000 1.0000000
dbsm * 100
#> 100 x 50 dbMatrix of class "dbSparseMatrix"
#> [[ Colnames 'cell_1', 'cell_2', 'cell_3' ... suppressing 44 ...'cell_48', 'cell_49', 'cell_50' ]]
#>
#> gene_1 . . . . . . 500.0000000
#> gene_2 400.0000000 . . . . . .
#> gene_3 . 700.0000000 . . . 800.0000000 .
#>
#> ......suppressing 40 columns and 94 rows
#>
#> gene_98 . . . . . . .
#> gene_99 . . 500.0000000 . . . .
#> gene_100 700.0000000 . . . . . .dbMatrix also supports matrix arithmetic for
dbMatrix objects that are conformable.
dbsm + dbsm
#> 100 x 50 dbMatrix of class "dbSparseMatrix"
#> [[ Colnames 'cell_1', 'cell_2', 'cell_3' ... suppressing 44 ...'cell_48', 'cell_49', 'cell_50' ]]
#>
#> gene_1 . . . . . . 10.0000000 .
#> gene_2 8.0000000 . . . . . . .
#> gene_3 . 14.0000000 . . . 16.0000000 . 6.0000000
#>
#> ......suppressing 40 columns and 94 rows
#>
#> gene_98 . . . . . . . .
#> gene_99 . . 10.0000000 . . . . .
#> gene_100 14.0000000 . . . . . . .dbsm * dbsm
#> 100 x 50 dbMatrix of class "dbSparseMatrix"
#> [[ Colnames 'cell_1', 'cell_2', 'cell_3' ... suppressing 44 ...'cell_48', 'cell_49', 'cell_50' ]]
#>
#> gene_1 . . . . . . 25.0000000 .
#> gene_2 16.0000000 . . . . . . .
#> gene_3 . 49.0000000 . . . 64.0000000 . 9.0000000
#>
#> ......suppressing 40 columns and 94 rows
#>
#> gene_98 . . . . . . . .
#> gene_99 . . 25.0000000 . . . . .
#> gene_100 49.0000000 . . . . . . .The matrix product (%*%) is not supported yet.
sessionInfo()
#> R version 4.6.0 (2026-04-24)
#> Platform: x86_64-pc-linux-gnu
#> Running under: Ubuntu 24.04.4 LTS
#>
#> Matrix products: default
#> BLAS: /usr/lib/x86_64-linux-gnu/blas/libblas.so.3.12.0
#> LAPACK: /usr/lib/x86_64-linux-gnu/lapack/liblapack.so.3.12.0 LAPACK version 3.12.0
#>
#> locale:
#> [1] LC_CTYPE=C.UTF-8 LC_NUMERIC=C LC_TIME=C.UTF-8
#> [4] LC_COLLATE=C LC_MONETARY=C.UTF-8 LC_MESSAGES=C.UTF-8
#> [7] LC_PAPER=C.UTF-8 LC_NAME=C LC_ADDRESS=C
#> [10] LC_TELEPHONE=C LC_MEASUREMENT=C.UTF-8 LC_IDENTIFICATION=C
#>
#> time zone: America/New_York
#> tzcode source: system (glibc)
#>
#> attached base packages:
#> [1] stats graphics grDevices utils datasets methods base
#>
#> other attached packages:
#> [1] dbMatrix_0.2.0
#>
#> loaded via a namespace (and not attached):
#> [1] bit_4.6.0 Matrix_1.6-5 jsonlite_2.0.0
#> [4] dplyr_1.2.1 compiler_4.6.0 tidyselect_1.2.1
#> [7] Rcpp_1.1.1-1.1 blob_1.3.0 nanoarrow_0.8.0
#> [10] pins_1.4.2 assertthat_0.2.1 dbProject_0.0.0.9002
#> [13] jquerylib_0.1.4 arrow_24.0.0 yaml_2.3.12
#> [16] fastmap_1.2.0 lattice_0.22-5 R6_2.6.1
#> [19] generics_0.1.4 knitr_1.51 tibble_3.3.1
#> [22] MatrixGenerics_1.24.0 DBI_1.3.0 bslib_0.10.0
#> [25] pillar_1.11.1 connections_0.2.1 rlang_1.2.0
#> [28] cachem_1.1.0 xfun_0.57 sass_0.4.10
#> [31] bit64_4.8.0 otel_0.2.0 cli_3.6.6
#> [34] withr_3.0.2 magrittr_2.0.5 digest_0.6.39
#> [37] grid_4.6.0 rscontract_0.1.2 dbplyr_2.5.2
#> [40] lifecycle_1.0.5 vctrs_0.7.3 evaluate_1.0.5
#> [43] glue_1.8.1 data.table_1.18.2.1 duckdb_1.5.2
#> [46] rmarkdown_2.31 purrr_1.2.2 matrixStats_1.5.0
#> [49] tools_4.6.0 pkgconfig_2.0.3 htmltools_0.5.9These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.
Health stats visible at Monitor.