NEWS.md

In jangorecki/dwtools: Data Warehouse related functions.

dwtools 0.8.3.9

• [x] Cube class with MDX like query support
• [x] dwtools introduction vignette
• [x] added JDBC support to db function
• [x] Entity-attribute-value (EAV) value calculation helper
• [x] R vs SQL benchmark vignette
• [x] new get.timing(), trunc.timing() functions for in-memory logs
• [x] change in timing (non-db) approach
• [x] no more 'timing' attribute
• [x] a lot of code simplification
• [x] shinyDW renamed to shinyBI
• [x] shinyBI hierarchy browsing using denormalized data
• [x] db - simplify code
• [x] dbCopy - update for new timing
• [x] updated tests, examples
• [x] removed as.xts.data.table due to PR to data.table

dwtools 0.8.2

• [x] shinyBI (previously shinyDW) supports build hierarchy
• [x] build hierarchy
• [x] data.equal.data.table
• [x] anonymize
• [x] improved db timing

dwtools 0.8.0

• [x] db simplified interface
• [x] tested on csv (default), SQLite, postgres
• [x] should works on any DBI/ODBC driver
• [x] setkey by col names or col positions
• [x] timing for vectorized args
• [x] auto timing
• [x] dbCopy tables migration wrapper
• [x] batch copy tables between connections
• [x] joinbyv - batch join tables
• [x] populate star schema data
• [x] idxv - DT binary search on multiple keys
• [x] timing function including logging to db
• [x] as.xts.data.table conversion method and reverse
• [x] vwap - tick data to OHLC and VWAP
• [x] pkgsVersion handy wrapper to compare packages version across libraries

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