Automated Data Retention Policy Enforcement in SQL Server Environments: An AI-Governed Lifecycle Management Framework

Abstract

There are a vast number of interconnected transaction level facts that are contained within relational databases. These facts can collectively (or separately) represent an infinite number of business records. We provide a framework in this article that allows for the definition of business records that are stored in a database system as queries, followed by the specification of retention policies which are applied to those searches. When it comes to creating and executing records retention rules for relationally stored documents, we also emphasise many critical challenges that policy makers and database administrators need to take into consideration.