Abstract: 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.

Abstract: 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.

Abstract: Methods and apparatus, including computer program products, implementing and using techniques for partitioning measures of an OLAP cube into one or more measure sets. One or more static partitioning criteria are applied to each measure in the OLAP cube. One or more dynamic partitioning criteria are applied to each measure in the OLAP cube. The measures are grouped into measure sets based on the applied static and dynamic partitioning criteria.

Abstract: 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.

Abstract: Disclosed is 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.