CRAN/E | SCDB

SCDB

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

Installation

About

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).

github.com/ssi-dk/SCDB
ssi-dk.github.io/SCDB/
Bug report File report

Key Metrics

Version 0.4.0
Published 2024-03-21 37 days ago
Needs compilation? no
License GPL-3
CRAN checks SCDB results
Language en-US

Downloads

Yesterday 9 0%
Last 7 days 76 -31%
Last 30 days 327 -35%
Last 90 days 1.134 +11%
Last 365 days 2.776

Maintainer

Maintainer

Rasmus Skytte Randløv

rske@ssi.dk

Authors

Rasmus Skytte Randløv

aut / cre / rev

Marcus Munch Grünewald

aut

Lasse Engbo Christiansen

rev

Statens Serum Institut

cph / fnd

Material

README
NEWS
Reference manual
Package source

Vignettes

SCDB: Basic principles
Slowly Changing Dimension methodology

macOS

r-release

arm64

r-oldrel

arm64

r-release

x86_64

Windows

r-devel

x86_64

r-release

x86_64

r-oldrel

x86_64

Old Sources

SCDB archive

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

Reverse Imports

diseasystore