Method and apparatus for projecting the effect of...

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

C707S721000

Reexamination Certificate

active

07743052

ABSTRACT:
A database management system maintains a record of queries which can be executed against the database. For a given auxiliary database structure, an advisory function automatically reviews the query record and identifies those queries which might execute with greater efficiency using the auxiliary database structure, presenting analytical information to the user. Preferably, the auxiliary database structure is an index, and the information is used for determining whether to include the index in the database definition. Preferably, a query optimizer records potentially useful indexes when considering multiple alternative database optimizations, and this information is later retrieved to identify queries which would benefit from an index.

REFERENCES:
patent: 5913206 (1999-06-01), Chaudhuri et al.
patent: 5926813 (1999-07-01), Chaudhuri et al.
patent: 6223171 (2001-04-01), Chaudhuri et al.
patent: 2003/0088541 (2003-05-01), Zilio et al.
patent: 2003/0088546 (2003-05-01), Brown et al.
patent: 2003/0093408 (2003-05-01), Brown et al.
patent: 2005/0033730 (2005-02-01), Chaudhuri et al.
patent: 2005/0187917 (2005-08-01), Lawande et al.
patent: 2005/0203940 (2005-09-01), Farrar et al.
patent: 2005/0234900 (2005-10-01), Bossman et al.
Products: Application Performance Management: insure/INDEX, http://www.centerfieldtechnology.com/tools/insureindex.asp.
DB2 Autonomic Computing: Index Advisor, http://d25web1.torolab.ibm.com/function/dbt/SMART.nsf/0/2E944E6080C2036285256C5.

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

Method and apparatus for projecting the effect of... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and apparatus for projecting the effect of..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for projecting the effect of... will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-4174059

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