| 摘要 |
According to an embodiment of the present disclosures, systems, methods, and non-transitory computer-readable mediums having program instructions thereon, provide for managing a data record's lifecycle with a database. The lifecycle of the data records in the database is managed and performed on the data records in the database and not on archived files. In an embodiment, the database includes a modeling layer, a rules layer, and a service layer. The modeling layer instructs the database (i) how a business object is set and (ii) how the database can retrieve the business object. The rules layer connects a rule to the business object with a database rules object. The service layer checks the data records of the business object to determine if a rule criteria defined by the corresponding database rules object is met. |
| 主权项 |
1. A computer-implemented method for managing data lifecycle in a database:
modeling a business object, with a modeling layer of the database, wherein the business object is a logical grouping of data tables in the database; assigning, with a rules layer of the database, a database rules object to the business object, wherein the database rules object contains rules pertaining to at least one of (i) minimum retention time of data records in the data tables corresponding to the business object, (ii) maximum retention time of the data records in the data tables corresponding to the business object, and (iii) time of destruction for the data records in the data tables corresponding to the business object; and upon determining, with a service layer of the database, that at least one data record in the data tables corresponding to the business object satisfies the rule pertaining to time of destruction, removing, with the service layer of the database, the at least one data record and other related data records corresponding the business object. |
