Index selection in a multi-system database management system
AssigneeTeradata US, Inc.
InventorsDouglas Brown, John Mark Morris
Life of this patent
Estimating the term…
Abstract
A system includes a multi-system database management system having a plurality of database systems. An index selection subsystem combines sets of query information from respective ones of the plurality of database systems into a workload. The index selection subsystem then generates candidate indexes from the workload, and selects recommended indexes from the candidate indexes based on one or more criteria.
Claims23
A system, comprising:
- a multi-system database management system that includes a plurality of database systems with different configurations from each other, wherein each of the different configurations specifies the following:
- a number of database nodes and a number of access modules in each database node, a number of parsing engines, and a version of database software, and wherein each of the database systems can process data independently by using one or more processors;
- and
- an index selection subsystem that includes one or more processors operable to:
- combine sets of query information from each one of the plurality of database systems into a workload;
- generate, from the workload, one or more candidate indexes for each one of the plurality of the database systems;
- and
- select one or more recommended indexes from the candidate indexes for each one of the plurality of database systems at least partly based on the number of database nodes and the number of access modules in each database node, the number of parsing engines, and the version of database software of the configuration of each one of the plurality of database systems.
A method executed by a computer for use with a multi-system database management system that includes a plurality of database systems with different configurations from each other, wherein each of the different configurations specifies:
- a number of database nodes and a number of access modules in each database node, a number of parsing engines, and a version of database software, and wherein each of the database systems can process data independently by using one or more processors, the method comprising:
- retrieving query information from each one the plurality of database systems of the multi-system database management system;
- combining the query information into a workload;
- generating, from the workload, one or more candidate indexes for each one of the plurality of the database systems;
- and
- selecting one or more recommended indexes from the candidate indexes for each one of the plurality of database systems at least partly based on the number of database nodes and the number of access modules in each database node, the number of parsing engines, and the version of database software of the configuration of each one of the plurality of database systems.
An article comprising at least one computer-readable storage medium storing at least instructions that when executed cause a computer to:
- retrieve query information from each one of a plurality of database systems of a multi-system database management system, wherein each of the different configurations specifies:
- a number of database nodes and a number of access modules in each database node, a number of parsing engines, and a version of database software, and wherein the plurality of database systems have different configurations from each other, and wherein each of the database systems can process data independently by using one or more processors;
- combine the query information into a workload;
- generating, from the workload, one or more candidate indexes for each one of the plurality of the database systems;
- and
- select one or more recommended indexes from the candidate indexes for each one of the plurality of database systems at least partly based on the number of database nodes and the number of access modules in each database node, the number of parsing engines, and the version of database software of the configuration of each one of the plurality of database systems.
Dependencies are inferred from the claim text.