System for accessing a relational database using semantic queries
This invention is a system for integrating data sets organized in one organization type with data sets organized in a second organization type so that data queries submitted to be processed in the manner of the first organization type can be translated into queries usable by the data set in the second data organization type and the results returned to satisfy the first query.
1. A system comprised of one or more computers for executing a digitally encoded first query that is expressed in a query language operable on a first type of data organization, on the data contents of a pre-existing data set in a second type of data organization comprised of a corresponding data organization schema encoded in a schema data file, said system comprising:
a computer memory comprised of stored data encoding the first query;
a translating module comprised of logic configured to automatically translate the stored first query into a digitally encoded second query expressed in a query language compatible with the second data organization type by using a mapping data structure stored in a computer memory comprising said system, said data structure embodying a synthetic domain model representation of the second data organization schema derived from the schema data file, in order to create the second query; and
a system comprised of the pre-existing data set of the second organization type configured by logic to execute the second query on the pre-existing data set.
2. A method executed by a computer system comprised of one or more computers, for executing a digitally encoded first query that is expressed in a query language operable on a first type of data organization, on the data contents of a pre-existing data set in a second type of data organization comprised of a corresponding data organization schema encoded in a schema data file, said method comprising:
retrieving from a data storage device data encoding the first query, said first query being expressed in a query language operable on the first type of data organization;
automatically translating the first query into a second digitally encoded translated query expressed in a query language compatible with the second type of data organization by using a mapping data structure stored in a computer memory comprising said computer system, said data structure embodying a synthetic domain model representation of the second type of data organization in order to create a data object representing the second translated query; and
executing the second query on the pre-existing data set of the second type of data organization.
3. A computer readable storage device comprised of data representing computer instructions that when executed perform the steps of:
executing a digitally encoded first query that is expressed in a query language operable on a first type of data organization, on the data contents of a pre-existing data set in a second type of data organization comprised of a corresponding data organization schema encoded in a schema data file, by:
retrieving from a data storage device data encoding the first query, said first query being expressed in a query language operable on the first type of data organization; automatically translating the first query into a second digitally encoded translated query expressed in a query language compatible with the second type of data organization by using a mapping data structure stored in a computer memory comprising said computer system, said data structure embodying a synthetic domain model representation of the second type of data organization in order to create a data object representing the second translated query; and
executing the second query on the pre-existing data set of the second type of data organization.