Data Retirement Tool (DRT) -A Novel Tool for Data Archiving
Keywords:
Data archiving, Data Retirement tool (DRT), Near Republica Rapid Deletion (NRRD) algorithm, Partition Exchange, Procedural language/Structured Query Language (PLSQL), My Structures Query Language (MySQL)Abstract
Effective archiving of data and maintaining efficient performance is a crucial task for managing the exponential growth of data in the database domain. A data retirement tool (DRT), was developed to address this issue using a partitioning technique within the database. Initially implemented in a procedural language/ structured query language (PLSQL) environment, the tool was based on PLSQL and its specific packages. To extend the scope of study, the DRT tool was implemented in my structured query language (MySQL), and its efficiency was evaluated in this article. The performance of the algorithm was assessed under two conditions: one involving table partitioning during deletion and the other without it. Data removal was carried out at rates of 10%, 50%, and 90%, with the results illustrated in graphical form. The results were positive, consistent with the findings in the initial referenced article.
