Data Placement In Hybrid Data Layouts For Tiered HTAP Databases
AssigneeHasso-Plattner-Institut für Digital Engineering gG
InventorsHasso PLATTNER, Matthias UFLACKER, Martin BOISSIER, Rainer SCHLOSSER
Life of this patent
Estimating the term…
Abstract
Computer-implemented method for allocating columns of a table stored in a database system into at least two sets of columns, a first set and a second set, the data of the columns allocated to the first set being stored on a primary storage medium using a column-oriented data structure and the data of columns allocated to the second set being stored on a secondary storage medium using a row-oriented data structure, wherein the method comprises the step of allocating the columns of the table to the first and the second set autonomously on the basis of a performance-cost model.
Claims14
Computer-implemented method for allocating columns of a table stored in a database system into at least two sets of columns, a first set and a second set,
- the data of the columns allocated to the first set being stored on a primary storage medium using a column-oriented data structure and
- the data of columns allocated to the second set being stored on a secondary storage medium using a row-oriented data structure,
- characterized In that
- the method comprises the step of
- allocating the columns of the table to the first and the second set autonomously on the basis of a performance-cost model.
Dependencies are inferred from the claim text.