Data warehouse queries using SPARQL
Disclosed is a system allowing to query data warehouses using SPARQL. An aspect of the system may support the representation of multidimensional data as virtual graphs. Another aspect of the system may provide mapping of SPARQL queries directed against multidimensional data vis-à-vis the graphs to native queries directed against the multidimensional data. Responses from the native queries may then be translated to a SPARQL response format.
1. A computer-implemented method for querying a multidimensional database configured according to a dimensional model, the method comprising:
at a computing device having one or more processors and memory storing one or more programs for execution by the one or more processors:
receiving a Simple Protocol And Resource Description Framework Query Language (SPARQL) query;
generating a native query from the SPARQL query using a mapping file comprising metadata that describes a multidimensional database;
mapping a first Resource Description Framework (RDF) class specified in the SPARQL query with a first column in the multidimensional database;
mapping a first property corresponding to the first RDF class specified in the SPARQL query with first values corresponding to the first column in the multidimensional database;
executing the native query on the multidimensional database;
receiving a native result comprising data stored in the multidimensional database resulting from execution of the native query against the multidimensional database; and
generating a SPARQL result from the native result using the mapping file, the SPARQL result representing a response to the SPARQL query.
2. The method of claim 1 , wherein the multidimensional database is a data warehouse, the native query language is Structured Query Language (SQL), and the native query is expressed in SQL.
3. The method of claim 1 , wherein the multidimensional database is organized in a star schema.
4. The method of claim 1 , wherein the multidimensional database is organized in a snowflake schema.
5. The method of claim 1 , wherein the native result further comprises one or more aggregations of data stored in the multidimensional database that was retrieved in response to the native query.
6. The method of claim 1 , wherein the native query is expressed as an Multidimensional Expressions (MDX) query.
7. A database query system comprising:
a processor; and
a data storage device having stored thereon computer executable program code, which, when executed by the processor, causes the processor to perform a method of:
receiving a Simple Protocol And Resource Description Framework Query Language (SPARQL) query;
generating a native query from the SPARQL query using a mapping file comprising metadata that describes a multidimensional database;
mapping a first Resource Description Framework (RDF) class specified in the SPARQL query with a first column in the multidimensional database;
mapping a first property corresponding to the first RDF class specified in the SPARQL query with first values corresponding to the first column in the multidimensional database;
executing the native query on the multidimensional database;
receiving a native result comprising data stored in the multidimensional database resulting from execution of the native query against the multidimensional database; and
generating a SPARQL result from the native result using the mapping file, the SPARQL result representing a response to the SPARQL query.
8. The system of claim 7 wherein the multidimensional database is a data warehouse, the native query language is Structured Query Language (SQL), and the native query is expressed in SQL.
9. The system of claim 7 , wherein the multidimensional database is organized in a star schema.
10. The system of claim 7 , wherein the multidimensional database is organized in a snowflake schema.
11. The system of claim 7 , wherein the native result further comprises one or more aggregations of data stored in the multidimensional database that was retrieved in response to the native query.
12. The system of claim 7 , wherein the native query is expressed as an Multidimensional Expressions (MDX) query.
13. A non-transitory computer-readable storage medium having stored thereon computer executable program code, which, when executed by a computer, causes the computer to perform a method of:
receiving a Simple Protocol And Resource Description Framework Query Language (SPARQL) query;
generating a native query from the SPARQL query using a mapping file comprising metadata that describes a multidimensional database;
mapping a first Resource Description Framework (RDF) class specified in the SPARQL query with a first column in the multidimensional database;
mapping a first property corresponding to the first RDF class specified in the SPARQL query with first values corresponding to the first column in the multidimensional database;
executing the native query on the multidimensional database;
receiving a native result comprising data stored in the multidimensional database resulting from execution of the native query against the multidimensional database; and
generating a SPARQL result from the native result using the mapping file, the SPARQL result representing a response to the SPARQL query.
14. The non-transitory computer-readable storage medium of claim 13 , wherein the multidimensional database is a data warehouse, the native query language is Structured Query Language (SQL), and the native query is expressed in SQL.
15. The non-transitory computer-readable storage medium of claim 13 , wherein the multidimensional database is organized in a star schema.
16. The non-transitory computer-readable storage medium of claim 13 , wherein the multidimensional database is organized in a snowflake schema.
17. The non-transitory computer-readable storage medium of claim 13 , wherein the native result further comprises one or more aggregations of data stored in the multidimensional database that was retrieved in response to the native query.
18. The non-transitory computer-readable storage medium of claim 13 , wherein the native query is expressed as an Multidimensional Expressions (MDX) query.