Transformation of a physical query into an abstract query
First Claim
1. A method of generating an abstract query from a physical query, comprising:
- receiving, from a requesting entity, a physical query composed in a query language used to query a physical database;
generating, from the physical query, an intermediate representation of the physical query that indicates (i) data sources within the physical database containing data queried by the physical query, (ii) conditions specified by the physical query on the data queried and (iii) relationships between the data sources queried by the physical query; and
generating, from the intermediate representation, an abstract query composed from a plurality of logical fields, wherein each logical field specifies (i) a name used to identify the logical field, and (ii) a reference to an access method selected from at least two different access method types, wherein each of the different access methods types defines a different manner of exposing the data corresponding to the name of the logical field.
1 Assignment
0 Petitions
Accused Products
Abstract
Embodiments of the invention provide methods, systems, and articles of manufacture for transforming a physical query (e.g., written in SQL) into an abstract query than can be run against an abstract database described by a database abstraction model. In one embodiment, the transformation occurs as a multiple step process: first, transformation of the physical query into an intermediate representation, such as an abstract query plan, and second, transformation of the intermediate representation into an abstract query. There are thousands upon thousands of existing physical (e.g., SQL) queries. Rather than just abandon these existing queries in favor of an abstract database, embodiments of the present invention provide for reverse query processing, that is, for creating an abstract query of the abstract database from a physical query (e.g., an SQL query) of the physical database underlying the abstraction.
-
Citations
6 Claims
-
1. A method of generating an abstract query from a physical query, comprising:
-
receiving, from a requesting entity, a physical query composed in a query language used to query a physical database; generating, from the physical query, an intermediate representation of the physical query that indicates (i) data sources within the physical database containing data queried by the physical query, (ii) conditions specified by the physical query on the data queried and (iii) relationships between the data sources queried by the physical query; and generating, from the intermediate representation, an abstract query composed from a plurality of logical fields, wherein each logical field specifies (i) a name used to identify the logical field, and (ii) a reference to an access method selected from at least two different access method types, wherein each of the different access methods types defines a different manner of exposing the data corresponding to the name of the logical field. - View Dependent Claims (2, 3, 4, 5, 6)
-
Specification