×

Abstract query plan

  • US 8,886,632 B2
  • Filed: 12/11/2007
  • Issued: 11/11/2014
  • Est. Priority Date: 12/06/2004
  • Status: Active Grant
First Claim
Patent Images

1. A method of providing an abstraction of a relational database, comprising:

  • defining a data abstraction model, wherein the data abstraction model comprises;

    (i) a plurality of logical fields, wherein each logical field identifies a name for the logical field and an access method that maps the logical field to a column of a table in the relational database, (ii) an indication of relationships between logical fields, and a (iii) a representation of the relational database that identifies relationships between data sources in the relational database;

    providing a query building interface configured to allow a user to compose an abstract query from the plurality of logical fields; and

    providing a runtime component configured to process an abstract query by generating an intermediate representation of the abstract query, wherein the intermediate representation of the abstract query comprises an abstract query plan, wherein the abstract query plan comprises (i) a plurality of table instances, wherein the each table instance includes an indication of a data source, each of the logical fields included in the abstract query that depend on data present on the indicated data source, and conditions used to limit the data selected from the indicated data source; and

    (ii) a set of join relationships that indicate how the plurality of table instances are related to one another relative to the abstract query; and

    (iii) a set of join relationships that indicate how the plurality of table instances are related to one another relative to the abstract query.

View all claims
  • 0 Assignments
Timeline View
Assignment View
    ×
    ×