Method and apparatus for processing data of in-memory database

A data processing method performed by a computer device comprising at least one processor, comprising:

• receiving, by the at least one processor, a search condition comprising sorting information of a data record;
• searching, by the at least one processor, an index table, in which sorting information of a data record and a storage key to uniquely identify a compression partition comprising a corresponding data record are associated and stored in a volatile in-memory database, for a storage key associated with the sorting information included in the search condition;
• and
• searching, by the at least one processor, a first non-volatile storage means, in which a storage key and a compression partition are associated and stored, for a compression partition associated with the storage key associated with the sorting information included in the search condition,
• wherein the index table is backed up a second non-volatile storage means.

A computer device comprising:

• at least one processor implemented to execute a computer-readable instruction,
• wherein the at least one processor is implemented to:
• determine a partition for a data record, included in a table of a volatile in-memory database, based on sorting information of the data record;
• generate a compression partition by compressing the data record for each partition;
• associate and store the compression partition and a storage key to uniquely identify the compression partition in first non-volatile storage means;
• associate and store the storage key and the sorting information in an index table of the volatile in-memory database;
• and
• back up the index table to a second non-volatile storage means.