TeeBI new free demo: One Billion cells in your laptop

[david berneda 45]

https://github.com/Steema/TeeBI/blob/master/demos/experiments/bigdata/OneBillion/readme.md

 

This demo shows TeeBI capabilities with big quantities of data, rows and cells.

 

• It first creates a default dummy database of One Billion cells (thousand millions).
• Data is saved to a disk file in your TEMP folder: "big_data.bi" (4.5GB) in aprox 4 seconds.
• Once data has been created it can be loaded again from disk in aprox 2.5 seconds.
• The "Query and Visualize" form uses this big data to do some visualizations.
  (Queries traversing so many millions of rows are not immediate, of course !)

• But you can run them in a normal laptop.

 

 // Sum the amount of Sales year by year, all rows:

   BIQuery1.Measures.Add(BigData['Sales']['Total'], TAggregate.Sum);
   BIQuery1.Dimensions.Add(BigData['Sales']['Date']).DatePart := TDateTimePart.Year;

   BIComposer1.Data := BIQuery1.Calculate;