Method and apparatus for storing data

An apparatus for storing data, the apparatus comprising:

• at least one processor;
• and
• a memory storing instructions, which when executed by the at least one processor, cause the at least one processor to perform operations, the operations comprising:
• judging whether a remaining storage space in a compressed data page is greater than a storage space threshold, in response to to-be-stored data to be written to the compressed data page in a cache storage region of a database, the cache storage region including non-compressed data pages for storing the to-be-stored data and compressed data pages for storing compressed data corresponding to the to-be-stored data, wherein the storage space threshold is greater than a size of a record being written to the compressed data page and occupying the smallest storage space among records stored in the compressed data page, each of the records stored in the compressed data page being compressed data written to the compressed data page during one write;
• determining a non-compressed data page among the non-compressed data pages for generating second compressed data page, when the remaining storage space in the compressed data page is smaller than the storage space threshold;
• and
• compressing the determined non-compressed data page to generate the second compressed data page, such that compressed data corresponding to the to-be-stored data is stored using the generated second compressed data page when compressed data corresponding to the to-be-stored data is written to the compressed data page next time.

A non-transitory computer storage medium, the non-transitory computer storage medium stores a computer readable instruction that can be executed by a processor, when the computer readable instruction is executed by the processor, the processor executes a method for storing data, the method comprising:

• judging whether a remaining storage space in a compressed data page is greater than a storage space threshold, in response to to-be-stored data to be written to the compressed data page in a cache storage region of a database, the cache storage region including non-compressed data pages for storing the to-be-stored data and compressed data pages for storing compressed data corresponding to the to-be-stored data, wherein the storage space threshold is greater than a size of a record being written to the compressed data page and occupying the smallest storage space among records stored in the compressed data page, each of the records stored in the compressed data page being compressed data written to the compressed data page during one write;
• when the remaining storage space in the compressed data page is smaller than the storage space threshold, determining a non-compressed data page among the non-compressed data pages for generating second compressed data page;
• and
• compressing the determined non-compressed data page to generate the second compressed data page, such that compressed data corresponding to the to-be-stored data is stored using the generated second compressed data page when compressed data corresponding to the to-be-stored data is written to the compressed data page next time.