SCDB0.6.0 package

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

get_table

Retrieves a named table from a given schema on the connection

get_tables

List the available tables on the connection

close_connection

Close connection to the database

create_index

Create the indexes on table

create_logs_if_missing

Create a table with the SCDB log structure if it does not exists

create_table

Create a historical table from input data

db_locks

Sets, queries and removes locks for database tables

db_timestamp

Determine the type of timestamps the database supports

defer_db_cleanup

Delete table at function exit

pipe

Pipe operator

SCDB-package

SCDB: Easily Access and Maintain Time-Based Versioned Data (Slowly-Cha...

schema_exists

Test if a schema exists in given connection

slice_time

Slices a data object based on time / date

table_exists

Test if a table exists in database

unique_table_name

Create a name for a temporary table

unite.tbl_dbi

tidyr::unite for tbl_dbi

update_snapshot

Update a historical table

delta_loading

Import and export a data-chunk with history from historical data

digest_to_checksum

Computes an checksum from columns

filter_keys

Filters .data according to all records in the filter

get_connection

Opens connection to the database

get_schema

Get the current schema/catalog of a database-related objects

id

Convenience function for DBI::Id

interlace

Combine any number of tables, where each has their own time axis of va...

is.historical

Checks if table contains historical data

joins

SQL Joins

Logger

Logger: Complete logging to console, file and database

LoggerNull

LoggerNull: The no-logging Logger

nrow

nrow() but also works on remote tables

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

  • Maintainer: Rasmus Skytte Randløv
  • License: GPL-3
  • Last published: 2026-01-23