Database System Autonomous Data Deletion Engine
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database systems face inefficiencies in implementing data retention policies, as applications are burdened with determining and executing data deletions, which can impact processing capacity and data privacy.
Innovation Solution
A database system with a transaction engine, event/timer handler, deletion monitor, access condition module, and deletion engine that autonomously manages data item deletions based on pre-defined deletion timing information, relieving the application of this responsibility and optimizing data storage.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Object-affected harmful factors
If applications manually determine and execute data deletions, then data privacy and storage efficiency are improved, but processing capacity and application complexity increase
Solution Approach 1:
The database system performs self-service by autonomously monitoring deletion timing information and executing deletions without requiring application intervention. The database engine automatically checks retention policies, identifies expired data, and removes it, thereby maintaining data privacy while freeing application processing capacity for other tasks.
Solution Approach 2:
The patent introduces an intermediary mechanism within the database system that handles the deletion logic between the application and the actual data removal. This intermediary layer (including deletion timing information storage and automated deletion engines) absorbs the complexity of data privacy management, allowing applications to focus on business logic while the database maintains security and storage efficiency.
2Reliability
If applications manually manage data deletions, then data retention policy compliance is improved, but application complexity and processing demands increase
Solution Approach 1:
The database system implements self-service by embedding retention policy compliance directly into its operational logic. The database automatically monitors deletion timing information, evaluates retention policies, and executes deletions without requiring applications to implement complex compliance logic, thereby maintaining reliability while reducing application complexity.
Solution Approach 2:
The patent applies preliminary action by storing deletion timing information and retention policy definitions in advance within the database system. This pre-configured framework allows the database to automatically comply with retention policies without requiring applications to perform complex real-time compliance checks, thereby maintaining reliability while simplifying application logic.
3Quantity of substance
If applications execute data deletions, then data storage efficiency is improved, but processing time and resource consumption increase
Solution Approach 1:
The database system performs self-service by autonomously managing data deletion operations. The database engine automatically identifies and removes expired data based on stored timing information, achieving storage efficiency without requiring applications to allocate processing time and resources for deletion operations.
Solution Approach 2:
The patent implements preliminary action by pre-storing deletion timing information and retention policy definitions in the database. This advance preparation allows the database to efficiently execute deletions when needed without requiring applications to perform time-consuming analysis or processing, thereby achieving storage efficiency while minimizing processing time overhead.
Data Source
AI summary
Example systems and methods of deleting data stored in a database system are presented. In one example, a plurality of data items is received from an application and stored at the database system. Also received from the application and stored at the database system is deletion timing information for each of the data items. The deletion timing information for a data item may indicate when the data item is to be deleted from the database system. At least one of the data items may be deleted at the database system at a time indicated by its corresponding deletion timing information without assistance from the application.