Abstract query plan

Details Abstract query plan Abstract query plan

2004-12-06

2008-12-02

Fleurantin, Jean B. (Department: 2162)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07461052

ABSTRACT:
A method and apparatus, and article of manufacture are provided to process an abstract query of a database abstraction constructed over an underlying physical data storage mechanism. The database may comprise a single data source, or a federated source spanning multiple systems. Embodiments of the invention process an abstract query by generating an intermediate representation of the abstract query. In one embodiment, the intermediate representation comprises an abstract query plan. An abstract query plan includes a combination of elements from the data abstraction model and elements relating to the underlying physical data storage mechanism. Once generated, a back-end component may easily traverse the abstract query plan to generate an SQL statement (or other resolved query) corresponding to the abstract query. Further, once constructed, the abstract query plan provides a platform for many different optimizations that may be selected by a user or by the runtime component inspecting the abstract query plan prior to creating the resolved query.

REFERENCES:
patent: 5471611 (1995-11-01), McGregor
patent: 6442543 (2002-08-01), Snodgrass et al.
patent: 6725227 (2004-04-01), Li
patent: 2003/0172056 (2003-09-01), Dettinger et al.
patent: 2004/0148278 (2004-07-01), Milo et al.
patent: 2004/0267760 (2004-12-01), Brundage et al.
U.S. Appl. No. 10/083,075, “Application Portability and Extensibility Through Database Schema and Query Abstraction”, filed Feb. 26, 2002 (ROC920020044US1).
U.S. Appl. No. 10/403,356, “Abstract Query Plan”, filed Mar. 31, 2003 (ROC920030008US1).

Affiliated with

Also associated with

Rating

Abstract query plan does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Abstract query plan, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Abstract query plan will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4031713