Abstract:
A method for copying values of a table of a database between a primary memory and a secondary memory is provided, wherein the table is organized in a plurality of stripes and a plurality of vertical partitions, wherein a stripe comprises at least two rows of the table and a vertical partition comprises one or more columns of the table, wherein the table is stored as a plurality of segments, wherein a segment comprises values at a cross-section of a stripe and a vertical partition, and wherein a segment stores adjacent column values in adjacent locations of the primary or the secondary memory, the method comprising a step of selecting one or more segments and copying the one or more selected segments between the primary memory and the secondary memory.