CPC G06F 16/275 (2019.01) [G06F 16/215 (2019.01); G06F 16/221 (2019.01); G06F 16/2282 (2019.01)] | 18 Claims |
1. A method, at a computation node of a database system, for managing storage of data in a primary database and a replica database, the method comprising:
storing, by the computation node, the data arranged in a sequence of rows in a first storage format at the primary database, the storing the data in the primary database includes storing each group of rows in a plurality of groups of rows in the data into a heap file of a fixed length, and storing the data in the replica database includes storing a fixed number of columns in each group of rows into a corresponding compression unit (CU) of a fixed number of entries;
determining, by the computation node, a second sequence of rows according to one of the first storage format and a second storage format, wherein the first storage format is a row store (RS) and the second storage format is a column store (CS), or wherein the first storage format is a column store (CS) format and the second storage format is a row store (RS) format; and
storing, by the computation node, the data arranged in the second sequence of rows in the second storage format at the replica database.
|