Back to results
US 2012/0254252 A1Published application
Input/output efficiency for online analysis processing in a relational database
AssigneeInternational Business Machines Corporation
InventorsYi Jin, Lei Li, Li Li Wang, Wan Chuan Zhang
Life of this patent
Estimating the term…
Abstract
Embodiments of the invention relate to improved input/output efficiency for online analysis processing in a relational database. An aspect of the invention includes selecting a table from a relational database. The table is split by column into sub-tables, with at least one of the sub-tables including at least two columns. Each sub-table is written into a corresponding table of a row-based storage database.
Claims18
A method comprising:
- selecting a table of a relational database;
- splitting, by a computer, the selected table by column into sub-tables, wherein at least one of the sub-tables includes at least two columns;
- and
- writing each of the sub-tables into corresponding tables of a row-based storage database.
1 more element
A data processing device comprising:
- a computer processor configured to perform a method comprising:
- selecting a table of a relational database;
- splitting the selected table by column into sub-tables, wherein at least one of the sub-tables includes at least two columns;
- and
- writing each of the sub-tables into corresponding tables of a row-based storage database.
2 more elements
A computer program product comprising:
- a computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising:
- computer readable program code configured for:
- selecting a table of a relational database;
- splitting the selected table by column into sub-tables, wherein at least one of the sub-tables includes at least two columns;
- and
- writing each of the sub-tables into corresponding tables of a row-based storage database.
3 more elements
Dependencies are inferred from the claim text.