System and method for real time data aggregation in a virtual cube in a multidimensional database environment

A method for real time data aggregation in a virtual cube in a multidimensional database, comprising:

• providing a computer that includes one or more microprocessors;
• operating a multidimensional database server on the computer;
• storing a multidimensional database on the multidimensional database sever;
• creating a plurality of real-time data cubes of the multidimensional database on the multidimensional database server, wherein each of the plurality of real-time data cubes is associated with a data attribute;
• creating a transparent partition of the multidimensional database on the multidimensional database server, wherein the transparent partition resides on top of said plurality of real-time data cubes;
• operating a provider service of the multidimensional database sever to provide a plurality of connections to a database comprising a source of real-time data external to the multidimensional database, wherein the source of real-time data comprises a plurality of source data aggregation clients;
• receiving a query directed at the multidimensional database;
• querying the provider service with said plurality of real-time data cubes, the query comprising an identification of the source of real-time data external to the multidimensional database;
• providing each of said plurality of real-time data cubes with on-demand access via said plurality of connections to the database comprising the source of real-time data external to the multidimensional database;
• and
• using data responsive to the query from the source of real-time data within the multidimensional cube without said data responsive to the query being stored within the multidimensional database.

A non-transitory computer readable storage medium having for real time data aggregation in a virtual cube in a multidimensional database operating on a computer that includes one or more microprocessors, which instructions, when read and executed cause the computer to perform steps comprising:

• operating a multidimensional database server on the computer;
• storing a multidimensional database on the multidimensional database sever;
• creating a plurality of real-time data cubes of the multidimensional database on the multidimensional database server, wherein each of the plurality of real-time data cubes is associated with a data attribute;
• creating a transparent partition of the multidimensional database on the multidimensional database server, wherein the transparent partition resides on top of said plurality of real-time data cubes;
• operating a provider service of the multidimensional database sever to provide a plurality of connections to a database comprising a source of real-time data external to the multidimensional database, wherein the source of real-time data comprises a plurality of source data aggregation clients;
• receiving a query directed at the multidimensional database;
• querying the provider service with said plurality of real-time data cubes, the query comprising an identification of the source of real-time data external to the multidimensional database;
• providing each of said plurality of real-time data cubes with on-demand access via said plurality of connections and said plurality of source data aggregation clients to the database comprising the source of real-time data external to the multidimensional database;
• and
• using data responsive to the query from the source of real-time data within the multidimensional database without said data responsive to the query being stored in the multidimensional database.