Prevention of redundant indexes in a database management system

Details Prevention of redundant indexes in a database management system Prevention of redundant indexes in a database management system

2008-08-05

2011-11-08

Morrison, Jay (Department: 2168)

Data processing: database and file management or data structures

Database and file access

Search engines

C707S741000

Reexamination Certificate

active

08055646

ABSTRACT:
A method and system for preventing redundant indexes in a database management system (DBMS). A received create-index command specifies a new index to be created for retrieving data from a table created by the DBMS and a redundancy check to be performed for the new index in conjunction with an action parameter in the create-index command. If the action parameter includes a REPORT value, each redundant index is stored and/or displayed and the new index is created. If the action parameter includes a PREVENT value and an existing index is redundant in view of the new index and the new index is not redundant in view of the existing index, the existing index is deleted and the new index is created. If the action parameter includes a PREVENT value and the new index is redundant in view of an existing index, the new index is not created.

REFERENCES:
patent: 5860066 (1999-01-01), Rouse
patent: 7047231 (2006-05-01), Grasshoff et al.
patent: 2003/0167255 (2003-09-01), GraBhoff et al.
patent: 2004/0015478 (2004-01-01), Pauly
patent: 2006/0085484 (2006-04-01), Raizman et al.

Affiliated with

Also associated with

Rating

Prevention of redundant indexes in a database management system does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Prevention of redundant indexes in a database management system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Prevention of redundant indexes in a database management system will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4255864