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.2.1
Imports: checkmate, DBI, dbplyr (≥ 2.4.0), dplyr, glue, lubridate, methods, openssl, purrr, rlang, R6, RSQLite, stringr, tidyr, tidyselect, tidyverse, utils
Suggests: conflicted, knitr, rmarkdown, RPostgres, roxygen2, spelling, testthat (≥ 3.0.0), tibble
Published: 2023-11-30
Author: Rasmus Skytte Randløv ORCID iD [aut], Marcus Munch Grünewald ORCID iD [aut, cre]
Maintainer: Marcus Munch Grünewald <mmgr at ssi.dk>
BugReports: https://github.com/ssi-dk/SCDB/issues
License: GPL-3
URL: https://github.com/ssi-dk/SCDB
NeedsCompilation: no
Language: en-US
Materials: README NEWS
CRAN checks: SCDB results

Documentation:

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

Downloads:

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

Linking:

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