Column oriented in-memory page caching

摘要

A one-dimensional array is allocated in an in-memory cache for each column in a set of tabular data. The data type of each one-dimensional array is set to be the same as the data type of the corresponding column in the tabular data. Once the one-dimensional arrays have been allocated in memory, a portion of the data from each column in the tabular data is stored in a corresponding one-dimensional array. The tabular data stored in the one-dimensional arrays in the cache may then be utilized to generate an on-screen display of a portion of the tabular data.

主权项

1. A computer-implemented method for column oriented in-memory page caching, the computer-implemented method comprising performing computer-implemented operations for:
receiving tabular data comprising a plurality of columns and a plurality of rows; receiving a request to display a portion of the tabular data; in response to receiving the request, allocating a one-dimensional array in a memory for each column of the tabular data requested to be displayed; setting a data type of each of the one-dimensional arrays to be the same as a data type for a corresponding column of tabular data; organizing each of the one-dimensional arrays into pages; configuring the one-dimensional arrays to store all or a portion of the tabular data from a plurality of the rows of each column of the tabular data; storing the data from the plurality of the rows of each column of the tabular data in the allocated one-dimensional arrays; and utilizing the data stored in the one-dimensional arrays to display the portion of the tabular data.