Method and apparatus for operating on data with a conceptual data manipulation language
First Claim
1. A method for operating on data stored on a computer readable medium, comprising:
- creating a database of conceptual information and physical information about the data, wherein the conceptual information is mapped to the physical information, and storing the database on a computer readable data storage medium;
receiving a conceptual request to operate on the data, wherein the conceptual request is in a form related to a conceptual organization of the data; and
in response to the conceptual request, creating a data manipulation request to operate on the data by referencing the database of conceptual information and physical information about the data, and wherein the data manipulation request references the data at least in part in a manner related to a physical organization of the data.
2 Assignments
0 Petitions
Accused Products
Abstract
A data services layer is disclosed which maintains a dictionary of conceptual information and physical information about the data. Machine-readable requests to access the data are in a form related to a conceptual organization of the data, and is not specific to a physical organization of the data. A machine-readable query to obtain a subset of the data is produced by referencing the dictionary of conceptual and physical information about the data. The conceptual information is obtained from an object-relational-model of the data, and the physical information indicates how the data is organized on the data storage medium. Requests are written in a conceptual query language (CQL) which substantially uses terms belonging to or derived from a natural language. CQL includes terms in the classes of names and concepts, and wherein name terms are used to describe objects in the object-relational-model of the data, and concept terms are used to specify the data subset desired. Concept terms specify Facts desired from the data, and filters and sort specifications to be applied to the Facts. In an example embodiment, the data is organized in rows, and CQL includes a select command that retrieves data in rows. A set of data representing a profile of performance characteristics related to how to retrieve data is provided, and queries are formed based at least in part on the performance characteristics.
376 Citations
48 Claims
-
1. A method for operating on data stored on a computer readable medium, comprising:
-
creating a database of conceptual information and physical information about the data, wherein the conceptual information is mapped to the physical information, and storing the database on a computer readable data storage medium;
receiving a conceptual request to operate on the data, wherein the conceptual request is in a form related to a conceptual organization of the data; and
in response to the conceptual request, creating a data manipulation request to operate on the data by referencing the database of conceptual information and physical information about the data, and wherein the data manipulation request references the data at least in part in a manner related to a physical organization of the data. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 35, 36)
-
-
26. Apparatus for operating on data stored on a computer readable medium, comprising:
-
a database of conceptual information and physical information about the data, the database stored on a computer readable data storage medium;
one or more software components configured to execute on a computer and receive a machine-readable request to operate on the data, wherein the request is in a form related to a conceptual organization of the data; and
the one or more software components further configured to produce a machine-readable query to operate on the data, wherein the query is formed by referencing the database of conceptual information and physical information about the data. - View Dependent Claims (27, 28, 29, 30, 31, 32, 33, 34)
-
-
37. Apparatus for operating on data stored on a computer readable medium, comprising:
-
a database of conceptual information and physical information about the data, the database stored on a computer readable data storage medium;
means for receiving a machine-readable request to operate on the data, wherein the request is in a form related to a conceptual organization of the data; and
means for producing a machine-readable query to operate on the data, wherein the query is formed by referencing the database of conceptual information and physical information about the data. - View Dependent Claims (38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48)
-
Specification