SCDB: Easily Access and Maintain Time-Based Versioned Data (Slowly-Changing-Dimension)

A collection of functions that enable easy access and updating of a database of data over time. More specifically, the package facilitates type-2 history for data-warehouses and provides a number of Quality of life improvements for working on SQL databases with R. For reference see Ralph Kimball and Margy Ross (2013, ISBN 9781118530801).

Version: 0.4.0
Imports: checkmate, DBI, dbplyr (≥ 2.4.0), dplyr, glue, lifecycle, methods, openssl, parallelly, purrr, rlang, R6, stringr, tidyr, tidyselect, utils
Suggests: callr, conflicted, duckdb, jsonlite, knitr, lintr, odbc, rmarkdown, roxygen2, pkgdown, RPostgres, RSQLite, spelling, testthat (≥ 3.0.0), tibble, tidyverse, withr
Published: 2024-03-21
DOI: 10.32614/CRAN.package.SCDB
Author: Rasmus Skytte Randløv ORCID iD [aut, cre, rev], Marcus Munch Grünewald ORCID iD [aut], Lasse Engbo Christiansen ORCID iD [rev], Statens Serum Institut [cph, fnd]
Maintainer: Rasmus Skytte Randløv <rske at>
License: GPL-3
NeedsCompilation: no
Language: en-US
Materials: README NEWS
CRAN checks: SCDB results


Reference manual: SCDB.pdf
Vignettes: SCDB: Basic principles
Slowly Changing Dimension methodology


Package source: SCDB_0.4.0.tar.gz
Windows binaries: r-devel:, r-release:, r-oldrel:
macOS binaries: r-release (arm64): SCDB_0.4.0.tgz, r-oldrel (arm64): SCDB_0.4.0.tgz, r-release (x86_64): SCDB_0.4.0.tgz, r-oldrel (x86_64): SCDB_0.4.0.tgz
Old sources: SCDB archive

Reverse dependencies:

Reverse imports: diseasystore


Please use the canonical form to link to this page.