System and method for performing just-in-time priming of a...

Details System and method for performing just-in-time priming of a... System and method for performing just-in-time priming of a...

2011-03-22

2011-03-22

Chen, Susan Y (Department: 2161)

Data processing: database and file management or data structures

Database and file access

Preparing data for information retrieval

C707S750000, C707S796000

Reexamination Certificate

active

07912838

ABSTRACT:
A system for retrieving stored data and/or index pages, receives a database request, generates an access plan for the database request for accessing data rows and/or index entries according to the statement, and generates a priming process by selecting a set of data and/or index pages. The set of data and/or index pages is a super-set or the exact set of the pages needed for accessing data rows and/or index entries according to the access plan. The present system retrieves the data and/or index pages of the set before executing the database request according to the access plan. The execution of the database request is performed by scanning the index and data pages preloaded into the cache. This reduces the number of necessary disk reads during execution.

REFERENCES:
patent: 5758146 (1998-05-01), Schiefer et al.
patent: 5778353 (1998-07-01), Schiefer et al.
patent: 5842196 (1998-11-01), Agarwal et al.
patent: 6195653 (2001-02-01), Bleizeffer et al.
patent: 6470330 (2002-10-01), Das et al.
patent: 6772139 (2004-08-01), Smith, III
patent: 2006/0041550 (2006-02-01), Bennett et al.

Affiliated with

Also associated with

Rating

System and method for performing just-in-time priming of a... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and method for performing just-in-time priming of a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for performing just-in-time priming of a... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2758672