Apparatus and Method for Autonomic Index Creation, Modification and Deletion

Inactive Publication Date: 2007-12-13
IBM CORP
View PDF4 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Benefits of technology

[0008]According to the preferred embodiments, an index advice record engine generates and stores index advice records. An index advice policy mechanism allows a user to define an index advice policy that specifies criteria for autonomic index creation, modification and deletion. An autonomic index mechanism reads the index advice records, compares this information with the criteria in the user-defined index advice policies, and determines whether an index should be created, modified or deleted based on the information in the index advice records and the index advice policies. By automating the process of creating, modifying and deleting indexes according to user-defined policies, the preferred embodiments alleviate human users from most of the work of manually creating, modifying and deleting indexes.

Problems solved by technology

Without a way to autonomically create, modify and delete indexes, the database industry will continue to suffer from inefficient, manual methods of managing indexes.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Apparatus and Method for Autonomic Index Creation, Modification and Deletion
  • Apparatus and Method for Autonomic Index Creation, Modification and Deletion
  • Apparatus and Method for Autonomic Index Creation, Modification and Deletion

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024]There are many different types of databases known in the art. The most common is known as a relational database (RDB), which organizes data in tables that have rows that represent individual entries or records in the database, and columns that define what is stored in each entry or record.

[0025]To be useful, the data stored in databases must be able to be efficiently retrieved. The most common way to retrieve data from a database is to generate a database query. For example, lets assume there is a database for a company that includes a table of employees, with columns in the table that represent the name, address, phone number, gender, and salary of each employee. With data stored in this format, a query could be formulated that would retrieve the records for all female employees that have a salary greater than $40,000. Similarly, a query could be formulated that would retrieve the records for all employees that have a particular area code or telephone prefix.

[0026]Sometimes i...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

An index advice record engine generates and stores index advice records. An index advice policy mechanism allows a user to define an index advice policy that specifies criteria for autonomic index creation, modification and deletion. An autonomic index mechanism reads the index advice records, compares this information with the criteria in the user-defined index advice policies, and determines whether an index should be created, modified or deleted based on the information in the index advice records and the index advice policies. By automating the process of creating, modifying and deleting indexes according to user-defined policies, the preferred embodiments alleviate human users from most of the work of manually creating, modifying and deleting indexes.

Description

CROSS-REFERENCE TO RELATED APPLICATIONS[0001]This patent application is related to a co-pending patent application entitled “Continual Generation of Index Advice”, Ser. No. 11 / 239,617 filed on Sep. 29, 2005, and is also related to co-pending patent application entitled “Apparatus and Method for Autonomic Index Creation,” Ser. No. ______ filed ______, and “Apparatus and Method for Autonomic Index Creation, Modification and Deletion”, Ser. No. ______ filed ______. All three of these related patent applications are incorporated herein by reference.BACKGROUND OF THE INVENTION[0002]1. Field of the Invention[0003]This invention generally relates to database systems, and more specifically relates to an apparatus and method for optimizing database performance using indexes.[0004]2. Background Art[0005]Database systems have been developed that allow a computer to store a large amount of information in a way that allows a user to search for and retrieve specific information in the database. F...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F7/00
CPCG06F17/30336G06F16/2272
InventorANDERSON, MARK JOHNBESTGEN, ROBERT JOSEPHFLANAGAN, JAMES MICHAELFORSTIE, SCOTTSCHREIBER, THOMAS JAMES
OwnerIBM CORP