CPC G06F 16/278 (2019.01) [G06F 16/2282 (2019.01)] | 20 Claims |
1. A system comprising:
a database that stores a database table; and
at least one processor configured to:
detect a trigger event that triggers the extending of a current data partitioning definition defined for partitioning data stored in the database table, wherein:
the extending comprises replacing the current data partitioning definition with a new data partitioning definition;
the trigger event triggers the generation of the new data partitioning definition; and
detecting the trigger event comprises detecting that a new piece of data added to the database table is not assigned a data partition based on the current data partitioning definition;
obtain a partition configuration to generate the new data partitioning definition,
wherein the partition configuration comprises one or more of:
a configuration for a range-based partitioning including a new range for at least one datatype of the database table, wherein the at least one datatype is included in the current partitioning definition for the database table; and
a configuration for a case-based partitioning including a new logical condition for partitioning the data in the database table based on one or more data types of the database table;
obtain the current data partitioning definition of the database table;
generate the new data partitioning definition for the database table based on the current data partitioning definition and the partition configuration; and
perform data partitioning for the database table based on the new data partitioning definition, wherein the new data partitioning definition assigns a data partition to the new piece of data from the database table.
|