Dynamic incremental updating of data cubes

A computer program product for dynamic incremental updating of online analytical processing (OLAP) data cubes, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a computing device to cause the computing device to:

• identify aggregate computing functions for each of a plurality of standard query language (SQL) queries of a target data cube to be updated, wherein the target data cube is in a multidimensional form for storing OLAP data in the form of numeric values organized in fields;
• incrementally calculate the aggregate computing functions based on a current aggregated value obtained from an updated aggregated field database, and a value of one of a plurality of data fields obtained from real-time transactional event data;
• repeat the incremental calculation for each of the plurality of SQL queries to obtain updated field data for the target data cube;
• and
• update the updated aggregated field database with the updated field data,
• wherein incrementally calculating the aggregate computing functions and updating the updated aggregated field database are performed dynamically in an ongoing basis.

A system for dynamic incremental updating of online analytical processing (OLAP) data cubes, comprising:

• a CPU, a computer readable memory and a computer readable storage medium associated with a computing device;
• program instructions to identify aggregate computing functions for each of a plurality of standard query language (SQL) queries of a target data cube to be updated, wherein the target data cube is in a multidimensional form for storing OLAP data in the form of numeric values organized in fields;
• program instructions to incrementally calculate the aggregate computing functions based on a current aggregated value obtained from an updated aggregated field database, and a value of one of a plurality of data fields obtained from real-time transactional event data;
• program instructions to repeat the incremental calculation for each of the plurality of SQL queries to obtain updated field data for the target data cube;
• and
• program instructions to update the updated aggregated field database with the updated field data,
• wherein incrementally calculating the aggregate computing functions and updating the updated aggregated field database are performed dynamically in an ongoing basis, and
• wherein the program instructions are stored on the computer readable storage medium for execution by the CPU via the computer readable memory.