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.3
Imports: checkmate, DBI, dbplyr (≥ 2.4.0), dplyr, glue, lubridate, methods, openssl, purrr, rlang, R6, RSQLite, stringr, tidyr, tidyselect, tidyverse, utils
Suggests: conflicted, jsonlite, knitr, odbc, rmarkdown, RPostgres, roxygen2, spelling, testthat (≥ 3.0.0), tibble
Published: 2024-01-13
Author: Rasmus Skytte Randløv ORCID iD [aut, cre], Marcus Munch Grünewald ORCID iD [aut], 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: Basic principles
Slowly Changing Dimension methodology


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

Reverse dependencies:

Reverse imports: diseasystore


Please use the canonical form to link to this page.