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

Claim 9:
10. A method of detaching 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 detach data from a data object;
determining whether required file systems are accessible;
determining the number of partitions, tables, and jobs scheduled to be run and created;
generating 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;
determining, via a processor, 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;
disabling a table object prior to executing a detach command;
generating, via the processor, a detach data library; and
executing, via the processor, the detach library by generate executable statements to detach partitions from a database.