US 12,299,002 B2
System and method for data pruning via dynamic partition management
Robert McKinley Collins, Jr., Argyle, TX (US)
Assigned to BNSF Railway Company, Fort Worth, TX (US)
Filed by BNSF Railway Company, Fort Worth, TX (US)
Filed on Feb. 20, 2024, as Appl. No. 18/582,172.
Application 18/582,172 is a continuation of application No. 18/392,816, filed on Dec. 21, 2023.
Application 18/392,816 is a continuation of application No. 17/931,800, filed on Sep. 13, 2022, granted, now 11,868,371, issued on Jan. 9, 2024.
Application 17/931,800 is a continuation of application No. 17/506,283, filed on Oct. 20, 2021, granted, now 11,461,366, issued on Oct. 4, 2022.
Prior Publication US 2024/0193185 A1, Jun. 13, 2024
Int. Cl. G06F 16/27 (2019.01); G06F 16/22 (2019.01)
CPC G06F 16/278 (2019.01) [G06F 16/2282 (2019.01)] 16 Claims
OG exemplary drawing
 
1. A system for railroad data partitioning management, comprising:
a memory including a database with a plurality of partitions, tables, or data objects;
a configuration file including or more parameters, instructions, operations, or conditions related to database management; and
a processor operably coupled to the memory and capable of executing machine-readable instructions to perform program steps, the program steps comprising:
generating a first partition having data related to a first category;
generating a second partition having data related to a second category;
controlling operations via a configuration file that identifies one or more partitions and one or more rules, and includes one or more key pattern groups to classify the one or more partitions, wherein the one or more rules correspond with the categories of the first and second partitions and define a classification of whether one of the first and second partitions is a member of the one or more key pattern groups, wherein determining whether one of the first and second partitions is a member of the one or more key pattern groups includes validating the one or more key pattern groups by executing a key pattern when each of the one or more key pattern groups is determined to be valid and foreclosing execution of the key pattern when at least one key pattern group of the one or more key pattern groups is determined to be invalid;
processing a subset of the first partition data according to the one or more rules in the configuration file;
detaching partitions based on the one or more rules in the configuration file; and
deleting partitions based on the one or more rules in the configuration file.