John, the auditing manager at Acme Corporation, is tasked with managing invoices on a daily basis. He needs to retain invoices received from vendors for a period of seven years, as per the law. These documents have limited use after the financial year-end, but the organization can’t delete them from their database at that point of time. The documents, therefore, need to be moved to a separate DB to streamline day-to-day document management and also ensure compliance. The organization also needs to delete the documents after the retention period, if they are no longer required.