Patent ID: 9740724
Date: 2017-08-22
CPC Classifications: G06F

Claim:
1. A method for use with a database including a table including a set of supported partitions, the method comprising: creating a primary key definition having a predefined format for use as a range partitioning key for a table, with the predefined format including the following identifier fields: service-level entity context, random number, timestamp and instance, with instance being a unique number for each node in a clustered environment; assigning a default key generation format for the primary key definition, such that the default key generation format causes: (i) all primary keys for each instance of a first class entity to be generated with a common code, (ii) all primary keys of a set of correlated records for a particular organization to be generated randomly at the time they are initially stored in a first range of the table, and (iii) future data augmentations to the set of correlated records for the particular organization to be stored in the first range, thereby ensuring the first class entity is randomly distributed among the set of supported partitions of the table; generating a primary key for the first class entity for a first time, by generating a random number with a defined length, so that records relating to the first class entity will be randomly distributed among the set of supported partitions; generating subsequent augmentations when new correlated records are added, using the primary key of the first class entity to retrieve a value of service-level entity context field from the first class entity, thereby ensuring all other new primary keys are generated with the common code; creating a set of database tables with range partitioning on the primary keys generated; and saving all correlated records in a common database partition.