Monitoring usage of components in a database index

Details Monitoring usage of components in a database index Monitoring usage of components in a database index

2008-03-27

2010-06-01

Rones, Charles (Department: 2164)

Data processing: database and file management or data structures

Data integrity

Index maintenance

C707S688000

Reexamination Certificate

active

07730045

ABSTRACT:
Database indexes include multiple fields that are used to track how the components of the index are used. An index component monitoring mechanism tracks how the components of the index are used, and updates fields in the index accordingly. Such component-level statistics allow a query optimizer to make more intelligent decisions regarding when to build a new index and when to discard an index, and also provide information regarding which queries are using the index, the maintenance cost of the index, and the selectivity of the index when used to process a query.

REFERENCES:
patent: 5899988 (1999-05-01), Depledge et al.
patent: 6223171 (2001-04-01), Chaudhuri et al.
patent: 6353821 (2002-03-01), Gray
patent: 6353826 (2002-03-01), Seputis
patent: 6421662 (2002-07-01), Karten
patent: 6457014 (2002-09-01), Parker
patent: 6466942 (2002-10-01), Tolkin
patent: 6496830 (2002-12-01), Jenkins, Jr.
patent: 6778985 (2004-08-01), Jenkins, Jr.
patent: 7272589 (2007-09-01), Guay et al.
patent: 7496659 (2009-02-01), Coverdill et al.
patent: 2002/0123989 (2002-09-01), Kopelman et al.
patent: 2003/0093408 (2003-05-01), Brown et al.
patent: 2003/0204513 (2003-10-01), Bumbulis
patent: 2004/0181521 (2004-09-01), Simmen
patent: 2004/0181533 (2004-09-01), Santosuosso
patent: 2004/0236656 (2004-11-01), Megale et al.
patent: 2005/0108537 (2005-05-01), Puri et al.
patent: 2005/0144189 (2005-06-01), Edwards et al.
patent: 2005/0187917 (2005-08-01), Lawande et al.
patent: 2006/0020579 (2006-01-01), Freedman et al.
patent: 2006/0026279 (2006-02-01), Zigmond et al.
patent: 2007/0073644 (2007-03-01), Arnold et al.

Affiliated with

Also associated with

Rating

Monitoring usage of components in a database index does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Monitoring usage of components in a database index, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Monitoring usage of components in a database index will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4154162