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
Bug report File report

Key Metrics

Version 0.2.1
Published 2023-11-30 3 days ago
Needs compilation? no
License GPL-3
CRAN checks SCDB results
Language en-US

Downloads

Last 24 hours 21 -42%
Last 7 days 74 +100%
Last 30 days 201 -14%
Last 90 days 695 +302%
Last 365 days 856

Maintainer

Maintainer

Marcus Munch Grünewald

mmgr@ssi.dk

Authors

Rasmus Skytte Randløv

aut

Marcus Munch Grünewald

aut / cre

Material

README
NEWS
Reference manual
Package source

Vignettes

Basic principles
Slowly Changing Dimension methodology

macOS

r-release

arm64

r-oldrel

arm64

r-release

x86_64

r-oldrel

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
lubridate
methods
openssl
purrr
rlang
R6
RSQLite
stringr
tidyr
tidyselect
tidyverse
utils

Suggests

conflicted
knitr
rmarkdown
RPostgres
roxygen2
spelling
testthat ≥ 3.0.0
tibble