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

Claim 0:
1. An add partition system adapted to retrieve and add 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 the configuration file, wherein the read and parsed operations include an operation to add data to a data object;
determine whether required file systems are accessible;
initialize variables used in execution of adding data to the database in response to a determination that the required file systems are accessible;
collect metric data about cluster members of the database;
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; and
generate executable statements to add partitions to a table.