The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Nov. 08, 2011
Filed:
Aug. 05, 2008
Oliver Augenstein, Weil im Schoenbuch, DE;
Namik Hrle, Boeblingen, DE;
Thomas Ritter, Herrenberg, DE;
Andreas Uhl, Gaeufelden-Nebringen, DE;
Oliver Augenstein, Weil im Schoenbuch, DE;
Namik Hrle, Boeblingen, DE;
Thomas Ritter, Herrenberg, DE;
Andreas Uhl, Gaeufelden-Nebringen, DE;
International Business Machines Corporation, Armonk, NY (US);
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.