Predictive database pool preparation

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

07908268

ABSTRACT:
A method, system, and computer program product are provided for operating a relational database management system (RDBMS). In order to operate a RDBMS, information is read from a first execution plan in response to an execution request for a second individual database statement of a second sequence of database statements. The information is processed and pool resource requirements for execution of further individual database statements of the second sequence of database statements are evaluated. A preparation request is sent for pool modification based on the evaluated pool resource requirements to an asynchronous pool preparation queue. Then the second individual database statement of the second sequence of database statements is executed. The information indicative of the progression of execution of the second individual database statement is stored in a position register.

REFERENCES:
patent: 4829427 (1989-05-01), Green
patent: 7610460 (2009-10-01), Watanabe et al.
Kabra et al, Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans, 1998, ACM, SIGMOD '98, pp. 106-117.
Yeh et al, Two-Level Adaptive Training Branch Prediction, 1991, ACM, Proceedings of the 24thannual international symposium on Microarchitecture, 51-61.
Gounaris et al, Adapquery Processing: A Survey, 2002, Springer-Verlag, vol. 2405/2002, 11-25.

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

Predictive database pool preparation does not yet have a rating. At this time, there are no reviews or comments for this patent.

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

Rate now

     

Profile ID: LFUS-PAI-O-2782794

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