Lifecycle-based horizontal partitioning

A computer system for online transaction processing, wherein the computer system implements a computer program for dynamically and horizontally partitioning a table of a relational database, wherein the computer system comprises:

• a memory;
• and
• a processor,
• wherein the memory stores the relational database, the table of the relational database being of a column-store type and including:
• a main store, wherein the main store is organized as a column-store and horizontally partitioned into a plurality of partitions, and
• a delta store, wherein the delta store is organized as a column-store, wherein the delta store handles updates and inserts as an append operation, and wherein the delta store receives all inserts,
• wherein the computer program is executed by the processor to implement the following steps:
• inserting a first record into the table by appending it to the delta store,
• merging the delta store into the main store to store the first record in a first partition of the main store,
• changing an assignment of the first record from a first state to a second state, wherein the first state is mapped to the first partition, and the second state is mapped to a second partition of the main store, wherein changing the assignment of the first record relates to the first record transitioning through states of a dedicated lifecycle,
• storing the first record in the second partition and removing the first record from the first partition, and
• updating the first record in the main store by inserting a second record to the delta store and marking the first record as not valid,
• wherein the table further comprises attributes,
• wherein the attributes comprise at least one state attribute, wherein the at least one state attribute correspond to the states of the dedicated lifecycle,
• wherein each record comprises attribute values bijectively corresponding to the attributes,
• wherein each record comprises at least one state attribute value bijectively corresponding to the at least one state attribute, and
• wherein a state of a record depends on the at least one state attribute value.

A non-transitory computer-readable medium, wherein the non-transitory computer-readable medium stores a computer program for controlling a computer system for online transaction processing for dynamically and horizontally partitioning a table of a relational database, the computer system including a memory and a processor, the computer program controlling the computer system to execute processing comprising:

• implementing the relational database, the table of the relational database being of a column-store type and including:
• a main store, wherein the main store is organized as a column-store and horizontally partitioned into a plurality of partitions, and
• a delta store, wherein the delta store is organized as a column-store, wherein the delta store handles updates and inserts as an append operation, and wherein the delta store receives all inserts;
• inserting a first record into the table by appending it to the delta store;
• merging the delta store into the main store to store the first record in a first partition of the main store;
• changing an assignment of the first record from a first state to a second state, wherein the first state is mapped to the first partition, and the second state is mapped to a second partition of the main store, wherein changing the assignment of the first record relates to the first record transitioning through states of a dedicated lifecycle;
• storing the first record in the second partition and removing the first record from the first partition;
• and
• updating the first record in the main store by inserting a second record to the delta store and marking the first record as not valid,
• wherein the table further comprises attributes,
• wherein the attributes comprise at least one state attribute, wherein the at least one state attribute correspond to the states of the dedicated lifecycle,
• wherein each record comprises attribute values bijectively corresponding to the attributes,
• wherein each record comprises at least one state attribute value bijectively corresponding to the at least one state attribute, and
• wherein a state of a record depends on the at least one state attribute value.