International Business Machines Corporation

Craig Reginald Tomlyn

William Earl Malloy

Daniel Martin DeKimpe

Gary J Robinson

Simon Edward Moore

Suzanna Khatchatrian

Khiem Phu Pham

Mir Hamid Pirahesh

Jing James Xu

Jun Song Wang

Ji Hui Yang

Thanh Lam Hoang

Nathan Gevaerd Colossi

Lin Ju

John Dillon Eversman

Voranouth Supadulya

John Squires Poelman

Jishuo Yang

Embodiments for managing feature engineering with relational data are provided. A graphical user interface (GUI) that provides a user with the ability to upload a plurality of tables, select joins between the plurality of tables, and select keys for the joins is provided. Responsive to receiving user input indicative of selecting joins between the plurality of tables and selecting keys for the joins utilizing the GUI, the user selections are automatically validated and actions associated with at least some of the plurality of tables are dynamically performed based on the user selections. Information associated with the user selections and the validating is provided. The information includes a recommendation to link a third key in the at least some of the plurality of tables to a fourth key in the at least some of the plurality of tables.

Methods and systems for visual management of relational data

Provided is a system, method, and program for specifying multidimensional calculations. Selection of a subset of a cube model metadata object that is generated from a facts metadata object and one or more dimension metadata objects is received. The facts metadata object references one or more measure metadata objects. A statement is generated for retrieving multidimensional information using metadata in the cube model metadata object and the measure metadata objects, wherein each of the measure metadata objects specifies one or more aggregations.

Method, system, and program for specifying multidimensional calculations for a relational OLAP engine

Systems and computer products that present typically large amounts of entity information with a graphical display that efficiently maps the display of a large number of OLAP objects to related relational database tables thereby retaining contextual information about the data associated with the objects and tables. The efficient mapping is enabled by the use of areas that contain and include objects. The preferred embodiment of the present invention enhances analysis, by OLAP techniques, of the objects and the associated relational database information. An embodiment of the present invention further operates in a recursive manner by enabling the objects to include and contain additional objects.

Systems and computer program products to manage the display of data entities and relational database structures

Systems, methods, and computer products that efficiently present large amounts of entity information with a graphical display that retains all or most of the relevant contextual information. More particularly, the preferred embodiment of the present invention enables efficient analysis of data with a graphical display that minimizes distortion of the text in the graphical display, that retains contextual information associated with data objects in the graphical display, and that positions the objects to optimally represent relational database associations.

Modifying the graphical display of data entities and relational database structures

Methods that present typically large amounts of entity information with a graphical display that efficiently maps the display of a large number of OLAP objects to related relational database tables thereby retaining contextual information about the data associated with the objects and tables. The efficient mapping is enabled by the use of areas that contain and include objects. The preferred embodiment of the present invention enhances analysis, by OLAP techniques, of the objects and the associated relational database information. An embodiment of the present invention further operates in a recursive manner by enabling the objects to include and contain additional objects.

Methods to manage the display of data entities and relational database structures

A technique for efficiently updating a key table during outline restructure of a multi-dimensional database. 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 restructured. Then, a key table of the relational database is rebuilt to correspond to the restructured multidimensional database.

Efficiently updating a key table during outline restructure of a multi-dimensional database

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.

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

A method, apparatus, and article of manufacture for using a relational database management system to support on-line analytical processing (OLAP) systems. A multi-dimensional database is defined having a set of multi-dimensional data blocks and a set of identifiers comprising selected dimensions of multi-dimensional data for identifying particular ones of the multi-dimensional data blocks. The set of identifiers provides an ordering of the multi-dimensional data blocks using multi-dimensional member identifiers and holds usage information and age information about the multi-dimensional data blocks. The data in the set of multi-dimensional data blocks is stored in a relational database that represents the multi-dimensional database. Then, a set of rows representing a multi-dimensional data block is accessed from the relational database.

Relational emulation of a multi-dimensional database index

A method, apparatus, and article of manufacture for using a relational database management system to support on-line analytical processing (OLAP) systems. A relational database has a fact table and at least one related dimension table. A dimension identifier is received that identifies a data block in a multi-dimensional database. The dimension identifier comprises one or more multi-dimensional member identifiers. Rows are accessed from the fact table through the related dimension tables using the received dimension identifier. Then, the accessed rows are formatted as a data block for the multi-dimensional database.

Growing community of inventors

San Jose, CA, United States of America

Craig Reginald Tomlyn