Method, Apparatus and Data Structure for Copying Values of a Table of a Database

An apparatus for copying values of a table of a database between a primary memory and a secondary memory, comprising:

• a processor configured to:
• select one or more segments of the table, wherein the table is stored as a plurality of segments, 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, wherein a vertical partition comprises one or more columns of the table, wherein each of the plurality of segments comprises values at a cross-section of a stripe and a vertical partition, and wherein each of the plurality of segments stores adjacent column values in adjacent locations of the primary or the secondary memory;
• and
• copy the one or more segments between the primary memory and the secondary memory.