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

1. A system for real time data aggregation in a virtual cube in a multidimensional database, comprising:

a computer that includes one or more microprocessors;

a multidimensional database server executing on the computer;

a multidimensional database stored on the multidimensional database sever;

a plurality of real-time data cubes of the multidimensional database wherein each of the plurality of real-time data cubes is associated with a data attribute;

a transparent partition of the multidimensional database, wherein the transparent partition resides on top of said plurality of real-time data cubes;

a provider service of the multidimensional database sever wherein the provider service provides a data source comprising 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 big data source comprising a plurality of source data aggregation clients, and wherein the data source provides on-demand access to the multidimensional cube to at least one of the plurality of source data aggregation clients;

wherein, in response to a query directed at the multidimensional database, each of said plurality of real-time data cubes is configured to query the data source, the query comprising an identification of the source of real-time data external to the multidimensional database;

wherein the data source provides 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.

2. The system of claim 1 , wherein targeted data from the at least one source of real-time data is fetched, by the data source, upon execution of the query.

3. The system of claim 2 , wherein the targeted data, upon being fetched by the data source, is utilized by the multidimensional database for one or more dynamic computations.

4. The system of claim 3 , wherein the one or more dynamic computations are based upon the query.

5. The system of claim 4 , the transparent partition resides on top of said plurality of real-time data cubes and one or more multidimensional database cubes.

6. The system of claim 1 , wherein:

each of the plurality of source data aggregation clients is associated with a separate one of the plurality of real-time data cubes of the multidimensional database.

7. The system of claim 1 , wherein:

the plurality of source data aggregation clients is deployed inside a big data cluster of the big data source.

8. 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 data source comprising a plurality of connections to a database comprising a source of real-time data external to the multidimensional database;

receiving a query directed at the multidimensional database;

querying the data source 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 targeted data from the source of real-time data within the multidimensional database without being stored therein.

9. The method of claim 8 , wherein targeted data from the source of real-time data is fetched, by the data source, upon execution of the query.

10. The system of claim 9 , wherein the targeted data, upon being fetched by the data source, is utilized by the multidimensional database for one or more dynamic computations.

11. The system of claim 10 , wherein the one or more dynamic computations are based upon the query.

12. The system of claim 11 , wherein the transparent partition resides on top of said plurality of real-time data cubes and one or more multidimensional database cubes.

13. The system of claim 8 , wherein:

each of the plurality of source data aggregation clients is associated with a separate one of the plurality of real-time data cubes of the multidimensional database.

14. The system of claim 13 ,

wherein the big data source comprises a plurality of source data aggregators, and

wherein the data source provides on-demand access to the multidimensional database to the at least one of the plurality of source data aggregators.

15. 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 data source comprising a plurality of connections to a database comprising a source of real-time data external to the multidimensional database;

receiving a query directed at the multidimensional database;

querying the data source 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 targeted data from the source of real-time data within the multidimensional database without being stored therein.

16. The non-transitory computer readable storage medium of claim 15 ,

wherein targeted data from the source of real-time data is fetched, by the data source associated with the multidimensional database, upon execution of the query.

17. The non-transitory computer readable storage medium of claim 16

wherein the targeted data, upon being fetched by the data source, is utilized by the multidimensional database for one or more dynamic computations.

18. The non-transitory computer readable storage medium of claim 17 , wherein the one or more dynamic computations are based upon the query.

19. The non-transitory computer readable storage medium of claim 18 , wherein the transparent partition resides on top of said plurality of real-time data cubes and one or more multidimensional database cubes.

20. The non-transitory computer readable storage medium of claim 18 ,

wherein the source of real-time data accessible by the data source comprises a big data source;

wherein the big data source comprises a plurality of source data aggregators, and

wherein the data source provides on-demand access to the multidimensional database to the at least one of the plurality of source data aggregators.