Patent ID: 9542424
Date: 2017-01-10
CPC Classifications: G06F

Claim:
1. A computer-implemented online transaction processing method for dynamically and horizontally partitioning a table of a relational database, wherein the method comprises the steps of: providing a computer system comprising the relational database, the table of the relational database being of a column-store type and including: 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.