Automatic Synthesis and Presentation of OLAP Cubes from Semantically Enriched Data Sources
First Claim
Patent Images
1. A method of organizing data storage executed by a computer system comprised of one or more computers comprising:
- receiving data representing a database schema;
generating a first data structure that encodes an ontological representation derived from the received database schema;
receiving data representing an OLAP cube data structure associated with an at least one cube dimension label;
generating a second data structure representing a mapping from the first data structure to the at least one OLAP cube dimension labels;
storing the second data structure;
receiving data representing a data search query compatible with the OLAP cube data structure; and
translating the received query to a data search query compatible with a database that uses the received schema by using the generated second data structure.
0 Assignments
0 Petitions
Accused Products
Abstract
This system comprises methods that simplify the creation of multidimensional OLAP models from one or more semantically enabled data sources. The system also comprises methods enabling interoperability between existing OLAP end-user interfaces, the system'"'"'s representation of OLAP and the underlying data sources. This includes web-enabled OLAP interfaces.
-
Citations
26 Claims
-
1. A method of organizing data storage executed by a computer system comprised of one or more computers comprising:
-
receiving data representing a database schema; generating a first data structure that encodes an ontological representation derived from the received database schema; receiving data representing an OLAP cube data structure associated with an at least one cube dimension label; generating a second data structure representing a mapping from the first data structure to the at least one OLAP cube dimension labels; storing the second data structure; receiving data representing a data search query compatible with the OLAP cube data structure; and translating the received query to a data search query compatible with a database that uses the received schema by using the generated second data structure. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16)
-
-
17. A computer system comprised of a data memory comprising:
-
a module adapted by logic to receive data representing a first data search query compatible with an OLAP data source; a data processing module adapted by logic to automatically generate a data structure stored in the data memory that encodes an ontological representation derived from a database schema stored in the computer system that is associated with a database; and a data processing module adapted by logic to automatically translate the received first query into a second data search query by using the generated data structure derived from the database schema associated with the database. - View Dependent Claims (18, 19, 20, 21, 22, 23, 24, 25, 26)
-
Specification