Patent ID: 11914619
Assignee: BNSF RAILWAY COMPANY
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 9:
10. A method of dropping data related to a railroad system from a database, comprising:
reading and parsing operations from a configuration file, wherein the read and parsed operations include an operation to drop data from a data object;
determining whether required file systems are accessible;
initializing variables used in executing drop detached data operations from the database in response to a determination that the required file systems are accessible;
collecting metric data about cluster members of the database;
generating, via a processor, 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;
receiving detached partitions that include data that can be deleted;
determining, via the processor, which of the detached partitions to drop;
generating a job to execute the drop instructions; and
executing, via the processor, the drop instructions to drop the detached partition.