US 11,907,262 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 Oct. 2, 2022, as Appl. No. 17/937,454.
Application 17/937,454 is a continuation of application No. 17/506,283, filed on Oct. 20, 2021, granted, now 11,461,366.
Prior Publication US 2023/0120556 A1, Apr. 20, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/27 (2019.01); G06F 16/22 (2019.01)
CPC G06F 16/278 (2019.01) [G06F 16/2282 (2019.01)] 18 Claims
OG exemplary drawing
 
1. A detach partition system adapted to detach data related to a railroad system, comprising:
a memory including a database with a plurality of partitions, tables, clusters, or jobs;
a configuration file including operations 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:
read and parse operations from a configuration file, wherein the read and parsed operations include an operation to detach data from a data object;
determine whether required file systems are accessible;
determine the number of partitions, tables, and jobs scheduled to be run and created;
generate data structures based on key pattern groups defined for each partition, wherein the key pattern groups are used to identify which group each partition key belongs, wherein generating the data structures based on the key pattern groups includes generating the data structures when each key pattern group in the key pattern groups is determined to be valid and foreclosing generating the data structures when at least one key pattern group in the key pattern groups is determined to be invalid;
determine a table is partitioned when the table is organized according to a predetermined structure, wherein the predetermined structure includes columns of the table being organized based on an event code, an event type, a message, and a row identifier;
disable a table object prior to executing a detach command;
generate a detach data library; and
execute the detach library by generate executable statements to detach partitions from a database.