Systems and methods for specifying OLAP cube at query time

Abstract

Systems, methods, and storage media for generating an online analytical processing cube (MAP) are disclosed. Exemplary implementations may: receive a cube definition file; access a data-source; generate a data-source property configuration for the data-source using the cube definition file to; determine each of respective parsed data from the data-source is a key, attribute, or measure; and generate the OLAP cube by combining the cube definition file and the data-source property configuration for the determined parsed data from the data-source.

What is claimed is: 
     
       1. A system configured for generating an online analytical processing (OLAP) cube, the system comprising:
 one or more processors configured by machine-readable instructions to:
 receive a query comprising a request for information from a data-source of a relational data warehouse; 
 receive a cube definition file comprising a schema providing structured data organization of data in the data-source of; 
 parse data of the data-source to automatically generate a data-source property configuration for the data-source by automatically determining if one or more values of the data-source correspond to a key, an attribute, or a measure; 
 generate the OLAP cube based on the cube definition file and the data-source property configuration for the determined parsed data from the data-source; and 
 respond to the query with the information from the data-source, the information obtained based on the generated OLAP cube. 
 
 
     
     
       2. The system of  claim 1 , wherein a plurality of data-sources are parsed, and wherein the one or more processers are further configured by machine-readable instructions to:
 generate a respective data-source property configuration for each of the plurality of data-sources; and 
 generate the OLAP cube based on the cube definition file and the respective data-source property configuration for each of the plurality of data-sources. 
 
     
     
       3. The system of  claim 1 , wherein the one or more processors are further configured by machine-readable instructions to:
 determine a cube identifier based on the query; 
 retrieve objects from the data-source, the data-source being associated with the cube identifier; 
 generate an OLAP context container based on the cube identifier provided in the query, wherein the OLAP context container comprises a mapping between an OLAP model and the relational data warehouse; and 
 respond to the query based on the generated OLAP context container and retrieved objects from the data-source. 
 
     
     
       4. The system of  claim 3 , wherein the cached OLAP context container is updated by scanning the data source associated with the cube identifier for changes and updating the cached OLAP context container whenever a cube definition of the data source has changed. 
     
     
       5. The system of  claim 4 , wherein the cached OLAP context container is stored in an in-memory cache of a cube, wherein the data source associated with the cube identifier comprises the cube. 
     
     
       6. The system of  claim 3 , wherein the data-source property configuration is generated at query time responsive to receiving the query. 
     
     
       7. A method of generating an online analytical processing cube, executing on a computing device, the method comprising:
 receiving a query comprising a request for information from a data-source of a relational data warehouse; 
 receiving a cube definition file comprising a schema providing structured data organization of data in the data-source; 
 parsing data of the data-source to automatically generate a data-source property configuration for the data-source by automatically determining if one or more values of the data-source correspond to a key, an attribute, or a measure; 
 generating the OLAP cube based on the cube definition file and the data-source property configuration for the determined parsed data from the data-source; and 
 responding to the query with the information from the data-source, the information obtained based on the generated OLAP cube. 
 
     
     
       8. The method of  claim 7 , wherein a plurality of data-sources parsed, and wherein the method comprises:
 using the cube definition file to generate a respective data-source property configuration for each of the plurality of data-sources, and 
 generating the OLAP cube based on the cube definition file and the respective data-source property configuration for each of the plurality of data-sources. 
 
     
     
       9. The method of  claim 7 , comprising:
 determining a cube identifier based on the query. 
 
     
     
       10. A non-transient computer-readable storage medium having instructions embodied thereon, the instructions being executable by one or more processors to perform a method for generating an online analytical processing (OLAP) cube, the method comprising:
 receiving a query comprising a request for information from a data-source of a relational data warehouse; 
 receiving a cube definition file comprising a schema providing structured data organization of data in the data-source; 
 parsing data of a data-source to automatically generate a data-source property configuration for the data-source by automatically determining if one or more values of the data-source correspond to a key, an attribute, or a measure; 
 generating the OLAP cube based on the cube definition file and the data-source property configuration for the determined parsed data from the data-source; and 
 responding to the query with the information from the data-source, the information obtained based on the generated OLAP cube. 
 
     
     
       11. The computer-readable storage medium of  claim 10 , wherein a plurality of data-sources are parsed, and wherein the method comprises:
 using the cube definition file to generate a respective data-source property configuration for each of the plurality of data-sources, and 
 generating the OLAP cube based on the cube definition and the respective data-source property configuration for each of the plurality of data-sources. 
 
     
     
       12. A system configured for operating a query system, the system comprising:
 one or more processors configured by machine-readable instructions to:
 receive a query comprising a request for information from a data-source of a relational data warehouse; 
 determine a cube identifier based on the query; 
 retrieve objects from the data-source, wherein the data-source is associated with the cube identifier; 
 automatically generate an OLAP context container based on the query, wherein the OLAP context container comprises a mapping between an OLAP model and the relational data warehouse; and 
 respond to the query with the information from the data-source obtained based on the generated OLAP context container and retrieved objects from the data source. 
 
 
     
     
       13. The system of  claim 12 ,
 wherein the OLAP context container is generated by updating a cached OLAP context container; 
 wherein the cached OLAP context container is updated by scanning the data-source associated with the cube identifier for changes; and 
 wherein the cached OLAP context container is updated by updating the OLAP context container whenever a cube definition of the data-source has changed. 
 
     
     
       14. The system of  claim 13 , wherein the cached OLAP context container is stored in an in-memory cache of a cube, wherein the data-source associated with the cube identifier comprises the cube. 
     
     
       15. A method of operating a query system comprising:
 receiving a query comprising a request for information from a data-source of a relational data warehouse; 
 determining a cube identifier based on the query; 
 retrieving objects from the data-source, wherein the data-source is associated with the cube identifier; 
 automatically generating an OLAP context container based on the query, wherein the OLAP context container comprises a mapping between an OLAP model and the relational data warehouse; and 
 responding to the query with the information from the data-source obtained based on the generated OLAP context container and retrieved objects from the data source. 
 
     
     
       16. The method of  claim 15 ,
 wherein the OLAP context container is generated by updating a cached OLAP context container; 
 wherein the cached OLAP context container is updated by scanning the data-source associated with the cube identifier for changes; and 
 wherein the cached OLAP context container is updated by updating the cached OLAP context container whenever a cube definition of the data-source has changed. 
 
     
     
       17. The method of  claim 16 , wherein the cached OLAP context container is stored in an in-memory cache of a cube, wherein the data-source associated with the cube identifier comprises the cube. 
     
     
       18. A non-transient computer-readable storage medium having instructions embodied thereon, the instructions being executable by one or more processors to perform a method for operating a query system, the method comprising:
 receiving a query comprising a request for information from a data-source of a relational data warehouse; 
 determining a cube identifier based on the query; 
 retrieving objects from the data-source, wherein the data source is associated with the cube identifier; 
 automatically generating an OLAP context container based on the query, wherein the OLAP context container comprises a mapping between an OLAP model and the relational data warehouse; and 
 responding to the query with the information from the data-source obtained based on the generated OLAP context container and retrieved objects from the data-source. 
 
     
     
       19. The computer-readable storage medium of  claim 18 ,
 wherein the OLAP context container is generated by updating a cached OLAP context container; 
 wherein the cached OLAP context container is updated by scanning the data-source associated with the cube identifier for changes; and 
 wherein the cached OLAP context container is updated by updating the cached OLAP context container whenever a cube definition of the data-source has changed. 
 
     
     
       20. The computer-readable storage medium of  claim 19 , wherein the cached OLAP context container is stored in an in-memory cache of a cube, wherein the data-source associated with the cube identifier comprises the cube.