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.