US 11,941,029 B2
Automatic extension of database partitions
Pradeep Gummalla, Secunderabad (IN); Krishna Mohan Sattiraju, Hyderabad (IN); Paparayudu Anaparti, Hyderabad (IN); and Maniappan Uppliappan, Chennai (IN)
Assigned to Bank of America Corporation, Charlotte, NC (US)
Filed by Bank of America Corporation, Charlotte, NC (US)
Filed on Feb. 3, 2022, as Appl. No. 17/649,903.
Prior Publication US 2023/0244696 A1, Aug. 3, 2023
Int. Cl. G06F 16/27 (2019.01); G06F 16/22 (2019.01)
CPC G06F 16/278 (2019.01) [G06F 16/2282 (2019.01)] 20 Claims
OG exemplary drawing
 
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.