Easily Access and Maintain Time-Based Versioned Data (Slowly-Changing-Dimension)
Retrieves a named table from a given schema on the connection
List the available tables on the connection
Close connection to the database
Create the indexes on table
Create a table with the SCDB log structure if it does not exists
Create a historical table from input data
Sets, queries and removes locks for database tables
Determine the type of timestamps the database supports
Delete table at function exit
Pipe operator
SCDB: Easily Access and Maintain Time-Based Versioned Data (Slowly-Cha...
Test if a schema exists in given connection
Slices a data object based on time / date
Test if a table exists in database
Create a name for a temporary table
tidyr::unite for tbl_dbi
Update a historical table
Import and export a data-chunk with history from historical data
Computes an checksum from columns
Filters .data according to all records in the filter
Opens connection to the database
Get the current schema/catalog of a database-related objects
Convenience function for DBI::Id
Combine any number of tables, where each has their own time axis of va...
Checks if table contains historical data
SQL Joins
Logger: Complete logging to console, file and database
LoggerNull: The no-logging Logger
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).
Useful links