 Method and apparatus for transforming data |
| Systems implementing the invention provide users with a set of tools for transforming data from ... |
|
| Providing access to user interface elements of legacy application programs |
| An architecture is provided that enables an accessibility aid to directly access and manipulate ... |
|
| Translation of object queries involving inheritence |
| Join expressions, expressed in terms of objects, are translated into a relational database join ... |
|
| Development system with application browser user interface |
| The present invention is embodied in a component-based, rapid application development (RAD) Java ... |
|
| Multi-processor JAVA subsystem |
| OF THE INVENTION Reference will now be made in detail to the preferred embodiments of the ... |
|
| Context programming in object-oriented environments |
| The present invention is directed to control of time structured or other context related data by ... |
|
| Method and apparatus for centralized management of a storage virtualization engine and data services |
| In accordance with the principles of the invention, an SVE control system uses management software ... |
|
| Prime implicates and query optimization in relational databases |
| The improved normalization methodology of the present invention is based on Socher's minimization ... |
|
|
Performance of table insertion by using multiple tables or multiple threads
| Details |
Inventors: DeKimpe, Daniel Martin; Malloy, William Earl; Moore, Simon Edward; Robinson, Gary;
Assignee: International Business Machines Corporation (Armonk, NY)
Primary Examiner: Vu; Kim
Assistant Examiner: Nguyen; Tam V
Attorney, Agent or Firm: Fay, Sharpe, Fagan, Minnich & McKee, LLP
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. |
|
DETAILED DESCRIPTION To overcome the limitations in the prior art described above, and to overcome other limitations that will become apparent upon reading and understanding the present specification, the present invention discloses a method, apparatus, and article of manufacture for improved performance of table insertion by using multiple tables or multiple threads.
According to an embodiment of the invention, 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.
|
|
Databases 
