System and method for data pruning via dynamic partition management

A system for single key partition of data related to a railroad system, comprising:

• a memory including a database with a plurality of partitions, tables, or jobs;
• 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:
• receiving a single key verification instruction to execute a single key partition function to parse data based on a partition;
• executing a single key initialization based on the partition of data;
• receiving a member list of data clusters in the database;
• identifying whether a cluster in the database includes a single key partition;
• determining a definition for an optional input parameter;
• determining a single key range for the single key partition;
• and
• generate alter statements for table manipulation corresponding with the single key partition.