Handling requests for data stored in database tables

Details Handling requests for data stored in database tables Handling requests for data stored in database tables

2011-05-31

2011-05-31

Hicks, Michael J (Department: 2165)

Data processing: database and file management or data structures

Database and file access

Query optimization

Reexamination Certificate

active

07953727

ABSTRACT:
Method for handling requests for data stored in database tables is provided. The method includes receiving a request for data stored in a database table, the database table including non-hash and hash columns, a hash column including hash values computed based on non-hash values in at least one non-hash column, generating database queries that are executable to retrieve data stored in the database table satisfying the request, each database query using a different combination of columns in the database table, ranking the database queries based on desirability, determining whether any of the database queries only uses indexed columns, responsive to one or more of the database queries only using indexed columns, selecting a highest ranked of the one or more database queries that only uses indexed columns for execution.

REFERENCES:
Graefe et al., “Dynamic Query Evaluation Plans”, ACM SIGMOD Record, vol. 18 , Issue 2, pp. 358-366, 1989 ACM.

Affiliated with

Also associated with

Rating

Handling requests for data stored in database tables does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Handling requests for data stored in database tables, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Handling requests for data stored in database tables will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2657114