SCDB SCDB website

Overview

SCDB is a package for easily maintaining and updating data with a slowly changing dimension. More specifically, the package facilitates type-2 history for data warehouses and provide a number of quality-of-life improvements for working with SQL databases within R.

To better understand what a slowly changing dimension is and how and this packages provides it, see vignette("slowly-changing-dimension").

Installation

# Install SCDB from CRAN:
install.packages("SCDB")

# Alternatively, install the development version from github:
# install.packages("pak")
# pak::pak("ssi-dk/SCDB")
install.packages("SCDB", repos = c('https://ssi-dk.r-universe.dev', 'https://cloud.r-project.org'))

Usage

For basic usage examples, see vignette("SCDB").