Obtaining a plan for executing a query in a relational database

Data processing: database and file management or data structures – Database and file access – Query optimization

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

Reexamination Certificate

active

07937385

ABSTRACT:
A plan for executing a query in a relational database is obtained. A query for accessing data in the relational database is received. The query specifies N tables in the relational database from which data is to be retrieved. A determination is made whether a syntax of the query matches a syntax of a plan in a plan cache for executing the query. Matches are identified between generic table formats of the N tables specified in the query to generic table formats of N tables specified in the plan responsive to the syntax of the query matching the syntax of a plan in the plan cache for executing the query. The plan for executing the query is obtained based on whether the syntax of the query matches the syntax of the plan and based on identified matches between the generic table formats of the N tables specified in the query to the generic table formats of the N tables specified in the plan.

REFERENCES:
patent: 5822750 (1998-10-01), Jou et al.
patent: 6353821 (2002-03-01), Gray
patent: 6665664 (2003-12-01), Paulley et al.
patent: 2005/0097118 (2005-05-01), Slutz
patent: 2006/0031189 (2006-02-01), Muras et al.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Obtaining a plan for executing a query in a relational database does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Obtaining a plan for executing a query in a relational database, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Obtaining a plan for executing a query in a relational database will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-2680809

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.