Processing column-partitioned data for row-based operations in a database system

A method of operating a database system, the method comprising:

• generating, with a processor, a cache configured to include column values of rows of column-partitioned database tables that have been previously read by the processor, wherein each column-partitioned database table is partitioned into a plurality of column groups, wherein each column group comprises one or more entire columns of a respective column-partitioned database table, and wherein each column of the column groups is logically stored as a row;
• receiving, with a processor, a database query;
• identifying, with the processor, a row of a column-partitioned database table to be analyzed in response to the database query;
• determining, with the processor, if referenced column values of the requested row are stored in the cache;
• retrieving, with the processor, the referenced column values of the row in the request from the cache in response to the determination that the referenced column values are in the cache;
• and
• providing, with the processor, the referenced column values for evaluation with respect to query conditions of the query.

A computer-readable medium encoded with a plurality of instructions executable with a processor, the plurality of instructions comprising:

• instructions to generate a cache configured to include referenced column values of rows of column-partitioned database tables that have been previously read, wherein each column-partitioned database table is partitioned into a plurality of column groups, wherein each column group comprises one or more entire columns of a respective column-partitioned database table, and wherein each column of the column groups is logically stored as a row;
• instructions to identify a row of a column-partitioned database table to be analyzed in response to the database query in response to receipt of a database query;
• instructions to determine if referenced column values of the requested row are stored in the cache;
• instructions to retrieve the referenced column values of the row in the request from the cache in response to the determination that the column values are in the cache;
• and
• instructions to provide referenced column values for evaluation with respect to query conditions of the query.