Performance of table insertion by using multiple tables or multiple threads
AssigneeInternational Business Machines Corporation
InventorsDaniel Martin DeKimpe, William Earl Malloy, Simon Edward Moore, Gary Robinson
Life of this patent
Estimating the term…
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.
Claims45
A method of executing a command in a computer to perform a database operation on a relational database stored on a data store connected to the computer, the method comprising the steps of:
- representing a multi-dimensional database 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;
- and
- concurrently accessing each of the base tables and the key table to perform the database operation.
An apparatus for executing a command in a computer, comprising:
- a computer having a data store coupled thereto, wherein the data store stores a relational database;
- and
- one or more computer programs, performed by the computer, the one or more computer programs representing a multi-dimensional database 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, and the one or more computer programs further concurrently accessing each of the base tables and the key table to perform a database operation.
An article of manufacture comprising a program storage medium readable by a computer and embodying one or more instructions executable by the computer to perform method steps for executing a command to perform a database operation on a relational database stored on a data store connected to the computer, the method comprising the steps of:
- representing a multi-dimensional database 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;
- and
- concurrently accessing each of the base tables and the key table to perform the database operation.
Dependencies are inferred from the claim text.