Optimizing Database Definitions in an Existing Database
AssigneeInternational Business Machines Corporation
InventorsMichael Battaglia, Heather A. Smith
Life of this patent
Estimating the term…
Abstract
A mechanism is provided in a data processing system for optimizing a database definition of an existing database. The mechanism receives usage data for the existing database. The mechanism queries a knowledgebase for information about database objects of the existing database. The mechanism executes optimization logic to generate a set of database commands based on the usage data and information about database objects. The set of database commands, when executed against a database definition of the existing database, optimize one or more database objects of the existing database. The mechanism returns the set of optimization commands.
Claims20
A method, in a data processing system, for optimizing a database definition of an existing database, the method comprising:
- receiving usage data for the existing database;
- querying a knowledgebase for information about database objects of the existing database;
- executing optimization logic to generate a set of database commands based on the usage data and information about database objects, wherein the set of database commands, when executed against a database definition of the existing database, optimize one or more database objects of the existing database;
- and
- returning the set of optimization commands.
A computer program product comprising a computer readable storage medium having a computer readable program stored therein, wherein the computer readable program, when executed on a computing device, causes the computing device to:
- receive usage data for an existing database;
- query a knowledgebase for information about database objects of the existing database;
- execute optimization logic to generate a set of database commands based on the usage data and information about database objects, wherein the set of database commands, when executed against a database definition of the existing database, optimize one or more database objects of the existing database;
- and
- return the set of optimization commands.
An apparatus comprising:
- a processor;
- and
- a memory coupled to the processor, wherein the memory comprises instructions which, when executed by the processor, cause the processor to:
- receive usage data for an existing database;
- query a knowledgebase for information about database objects of the existing database;
- execute optimization logic to generate a set of database commands based on the usage data and information about database objects, wherein the set of database commands, when executed against a database definition of the existing database, optimize one or more database objects of the existing database;
- and
- return the set of optimization commands.
Dependencies are inferred from the claim text.