Self-healing RDBMS optimizer

Details Self-healing RDBMS optimizer Self-healing RDBMS optimizer

2006-07-17

2008-08-19

Wong, Don (Department: 2163)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

07415455

ABSTRACT:
A method, computer program product, and system for triggering an update of statistics data used by a query optimizer of a relational database management system for determining an optimal execution plan for executing a received query request on a relational database is provided. A system dependent nominal performance value for executing the query request on a database system is determined. Additionally, an average actual performance value is determined by processing the query request. If a comparison between the average actual performance value and the system dependent nominal performance value yields a result which is greater than a first threshold value, an update cost value and a cost saving value are determined. If a comparison between the cost saving value and the update cost value yields a result which is greater than a second threshold value, the statistics data is updated.

REFERENCES:
patent: 6366901 (2002-04-01), Ellis
patent: 6438537 (2002-08-01), Netz et al.
patent: 6847978 (2005-01-01), Ellis et al.
patent: 7289999 (2007-10-01), Ellis et al.
patent: 7302422 (2007-11-01), Bossman et al.
patent: 2004/0243555 (2004-12-01), Bolsius et al.

Affiliated with

Also associated with

Rating

Self-healing RDBMS optimizer does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Self-healing RDBMS optimizer, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Self-healing RDBMS optimizer will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4007963