Database-controlled information lifecycle management

A non-transitory computer readable medium containing program instructions for managing data lifecycle in a database, wherein execution of the program instructions by one or more processors of a computer system causes one or more processors to carry out the steps of:

• 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.

A system directed to managing data lifecycle, comprising of:

• a database, the database comprising of:
• a modeling layer,
• a rules layer,
• a service layer,
• a processor, wherein the processor is configured to perform the steps of:
• modeling a business object, with the modeling layer of the database, wherein the business object is a logical grouping of data tables in the database;
• assigning, with the 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 the 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.