dwtools: Data Warehouse tools
In jangorecki/dwtools: Data Warehouse related functions.

Extension for data.table package for Data Warehouse related functionalities.

The core functions includes:

db as Extracting and Loading tool in ETL terms.
CUBE cube class object and MDX like queries on it.
joinbyv a denormalization of star schema and snowflake schema to single table.
dw.populate populate star schema data.
timing measure timing and rows in-out, including logging to db and verbose messages.
build_hierarchy transform single dataset to star schema, columns allocation based on cardinalities in unique groupings of each pair.
idxv custom indices for in-memory processing.

All dot prefixed arguments are designed to be taken from the options, use them only in special cases, they may be removed from functions input args in future.
The base option digits.secs will be changed to 3 on package load.

jangorecki/dwtools documentation built on May 18, 2019, 12:24 p.m.