International Business Machines Corporation

Daniel Martin DeKimpe

William Earl Malloy

Craig Reginald Tomlyn

Nathan Gevaerd Colossi

Steven Sit

Khiem Phu Pham

Gary J Robinson

Simon Edward Moore

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

A system automatically generates OLAP metadata objects for a multidimensional analysis program such as OLAP from SQL statements without involving the database administrator, and eliminates the need for database administrators to manually perform this analysis and design. The system deconstructs a set of SQL statements into tables and aggregates metrics for measures and joins. It recognizes that the relational database structure contains both dimension tables and fact tables. Over many SQL statements, fact tables will have a large measure metric while dimension tables will have a low measure metric. Tables are linked based on large join metrics; small join metrics are ignored. The present system builds the OLAP cube model from the fact tables, dimension tables, and joins. The analysis of the SQL statements allows the system to map the hierarchies within the dimension table, and provides the system with information about attribute relationships and cubes.

System and method for automatically building an OLAP model in a relational database

Various embodiments of a method, system and computer program product for optimization of a multidimensional model in a model based performance advisor are disclosed. The multidimensional model comprises groups. Each group has one or more levels. One or more recommended slices associated with the groups are determined based on a focus region.

Model based optimization with focus regions

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 ().

Method and apparatus for processing information on software defects during computer software development

A method, apparatus, and article of manufacture for improved performance of table insertion by using multiple tables or multiple threads. A command is executed in a computer to perform a database operation on a relational database stored on a data store connected to the computer. A multi-dimensional database is represented as a relational schema in the relational database, wherein the relational schema includes one or more base tables, related dimension tables, and a key table. Each of the base tables and the key table is accessed concurrently to perform the database operation.

Performance of table insertion by using multiple tables or multiple threads

A method, apparatus, and article of manufacture for improving multi-dimensional restructure performance by selecting a technique to modify a relational database based on a type of restructure. A command is executed in a computer to perform a database operation on a relational database stored on a data store connected to the computer. It is determined that a multi-dimensional database has been modified. Modifications to one or more original tables in a relational database corresponding to the multi-dimensional database are identified. A technique for modifying the relational database to correspond to the multidimensional database is selected based on the identified modifications.

Multi-dimensional restructure performance by selecting a technique to modify a relational database based on a type of restructure

A method, apparatus, and article of manufacture for improving multi-dimensional restructure performance when adding or removing dimensions and dimension members. A command is executed in a computer to perform a database operation on a relational database stored on a data store connected to the computer. It is determined that a multi-dimensional database has been modified. Then, it is determined that the modified multi-dimensional database requires modifications to one or more original tables in a relational database corresponding to the multi-dimensional database. The modifications are incorporated into one or more new tables by copying data from the original tables into the new tables.

Multi-dimensional restructure performance when adding or removing dimensions and dimensions members

A method, apparatus, and article of manufacture for DDL Extension layer that provides extended data definition language (DDL) capabilities for relational databases with multi-connections. A plurality of commands comprising data definition language statements and data modification language statements may be received from an application. Then, separate database connections for processing the data definition language statements and the data modification language statements are generated.

Extension of data definition language (DDL) capabilities for relational databases for applications issuing DML and DDL statements

A method, apparatus, and article of manufacture for DDL Extension layer that provides extended data definition language (DDL) capabilities for relational databases with multi-connections. A command is executed in a computer to perform a database operation on a relational database stored on a data store connected to the computer. The command is received from one of a plurality of applications. One or more compensating operations are logged for the command, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation. An identifier is associated with the compensating operations, wherein the identifier identifies a unit of work from which the command was received.

Extension of data definition language (DDL) capabilities for relational databases for applications issuing multiple units of work

A method, apparatus, and article of manufacture for DDL Extension layer that provides extended data definition language (DDL) capabilities for relational databases with logging. One or more commands are executed in a computer to perform a database operation on a relational database stored on a data store connected to the computer. For each command, one or more compensating operations is logged, wherein each compensating operation corresponds to an action to be performed for rollback or commit. Additionally, after logging, each command is committed as the command is executed.

Growing community of inventors

La Selva Beach, CA, United States of America

Daniel Martin DeKimpe