System and method for data pruning via dynamic partition management

Abstract

A system and method for managing data lifecycles that can provide an adaptable data management system configured to optimize the lifecycles of data and the reliability of databases. The system can provide data management systems with the ability to attach, detach, and drop segments of data based on key partitions of the data objects to optimize database utilization. By including the key partitions to the data objects, the database including the data objects can now perform data management operations based on the key partitions. The system, based on the key partitions, can identify a location of the data object to attach row entries, detach row entries from the existing tables, and delete the detached row entries from the database altogether. The system can operate on any relational database management system.

What is claimed is: 
     
       1. 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 associated with a single partition key, wherein a key pattern of the single partition key belongs to one of three key pattern groups, wherein determining the one of three key pattern groups to which the key pattern of the single partition key belongs includes validating the three key pattern groups against the partition associated with the single partition key by executing the key pattern when each of the three key pattern groups is determined to be valid and foreclosing execution of the key pattern when at least one key pattern group of the three key pattern groups is determined to be invalid; 
 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; 
 identifying whether a cluster in the database includes a single key partition, wherein the single key partition comprises exactly one of: the member, the date, or the group from the three key pattern groups; 
 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. 
 
 
     
     
       2. The system of  claim 1 , the program steps further comprising providing a user interface for modifying an administrative portion, including algorithms and thresholds. 
     
     
       3. The system of  claim 1 , wherein the partition includes a date, date range, group value, or member value. 
     
     
       4. The system of  claim 1 , the program steps further comprising comparing the identification of the cluster in the database with the single key partition to determine whether the cluster includes the single key partition. 
     
     
       5. The system of  claim 1 , the program steps further comprising identifying whether an input request includes the optional input parameter. 
     
     
       6. The system of  claim 5 , wherein the optional input parameter identifies whether the size of the data corresponding to the single key partition is greater than a normal size of a table in the database. 
     
     
       7. The system of  claim 1 , wherein the single key range for the single key partition can include month, week, day, or hour. 
     
     
       8. The system of  claim 1 , the program steps further comprising generating the alter statements to add a column to a table in the database to attach the data to the table based on the single key partition. 
     
     
       9. The system of  claim 1 , the program steps further comprising obtaining information regarding the number of jobs to be executed, the number of tablespaces to delete, or the number of jobs yet to be executed, and execute instructions corresponding to the foregoing information. 
     
     
       10. The system of  claim 1 , the program steps further comprising generating executable documents including the alter statements for use in another system. 
     
     
       11. A method of single key partition of data related to a railroad system, comprising:
 receiving a single key verification instruction to execute a single key partition function to parse data based on a partition associated with a single partition key, wherein a key pattern of the single partition key belongs to one of three key pattern groups, wherein determining the one of three key pattern groups to which the key pattern of the single partition key belongs includes validating the three key pattern groups against the partition associated with the single partition key by executing the key pattern when each of the three key pattern groups is determined to be valid and foreclosing execution of the key pattern when at least one key pattern group of the three key pattern groups is determined to be invalid; 
 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. 
 
     
     
       12. The method of  claim 11 , further comprising providing a user interface for modifying an administrative portion, including algorithms and thresholds. 
     
     
       13. The method of  claim 11 , wherein the partition includes a date, date range, group value, or member value. 
     
     
       14. The method of  claim 11 , further comprising comparing the identification of the cluster in the database with the single key partition to determine whether the cluster includes the single key partition. 
     
     
       15. The method of  claim 11 , further comprising identifying whether an input request includes the optional input parameter. 
     
     
       16. The method of  claim 15 , wherein the optional input parameter identifies whether the size of the data corresponding to the single key partition is greater than a normal size of a table in the database. 
     
     
       17. The method of  claim 11 , wherein the single key range for the single key partition can include month, week, day, or hour. 
     
     
       18. The method of  claim 11 , further comprising generating the alter statements to add a column to a table in the database to attach the data to the table based on the single key partition. 
     
     
       19. The method of  claim 11 , further comprising obtaining information regarding the number of jobs to be executed, the number of tablespaces to delete, or the number of jobs yet to be executed, and execute instructions corresponding to the foregoing information. 
     
     
       20. The method of  claim 11 , further comprising generating executable documents including the alter statements for use in another system.