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.1
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-10-03
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 ssi.dk>
BugReports: https://github.com/ssi-dk/SCDB/issues
License: GPL-3
URL: https://github.com/ssi-dk/SCDB, https://ssi-dk.github.io/SCDB/
NeedsCompilation: no
Language: en-US
Materials: README NEWS
CRAN checks: SCDB results

Documentation:

Reference manual: SCDB.pdf
Vignettes: SCDB: Basic principles (source, R code)
Slowly Changing Dimension methodology (source, R code)

Downloads:

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

Reverse dependencies:

Reverse imports: diseasystore

Linking:

Please use the canonical form https://CRAN.R-project.org/package=SCDB to link to this page.