International Business Machines Corporation

Steven Sit

Daniel Martin DeKimpe

Nathan Gevaerd Colossi

Tamuyen Phung

A system, method, and program for improving the performance for SQL queries. Multidimensional metadata associated with a cube model metadata object is obtained. One or more summary tables to be built are automatically identified based on the obtained multidimensional metadata. One or more indexes to create are automatically identified based on the obtained multidimensional metadata.

Improving performance of database queries

An apparatus for processing data relating to software defects operates within an on-line analytical processing environment that includes an on-line analytical processing presentation tool (). An on-line analytical processing cube model builder () builds a plurality of interrelated tables () with on-line analytical processing cube model metadata (). The cube model () is configured to be processed by the associated on-line analytical processing presentation tool (). A data extraction tool () communicates with a defect tracking database () containing said data relating to software defects. The data extraction tool () extracts said data from the defect tracking database (), transforms the extracted data into the software defect entries, and loads the software defect entries into the tables ().

Growing community of inventors

San Jose, CA, United States of America

Steven Sit