What did this report look like in January?

That's easy with "back in time queries" and Warehouse Labels, a feature unique to LucidDB amongst open source databases.

Data Versioning

Reporting database always change. New data is added, data is updated, and old data is deleted. This happening on a consistent daily, hourly or even minute by minute presents a challenge to the BI developer.

Warehouse Labels, a feature unique to LucidDB amongst open source databases:

  • Allows simultaneous loading of the warehouse to occur as desired, while BI users see a consistent point in time version of the data.  Nothing annoys reporting users more than reports run “during a load” that give strange or worse yet, believable but incorrect data!

  • Enables any reporting tool to ask LucidDB what did this report look like yesterday, at the end of last month, or at the end of last year? One can provide reports that can be easily flashed back without any complicated ETL, and hand coded data versioning.

  • Compare data today versus last month.  What records have been added?  Dropped?  Which columns have changed?

Also equally important, Warehouse Labels is an intelligent, storage friendly approach to keep multiple versions of data.  LucidDB’s keeps track of changes and versions of data; it does NOT duplicate the entire database. As you add new data the database size grows incrementally.