Auxiliary Table for Database Record Archiving
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database archiving methods are computationally intensive and lack metadata management, leading to potential inconsistencies and inefficiencies in record deletion and audit trail generation.
Innovation Solution
An auxiliary table is created in the database to store metadata for active records, allowing for 'smart deletion' without comparing archived and active records, and tagging records for updates to ensure accurate deletion and reporting.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If complete data comparison is performed before deletion, then data consistency is ensured, but computational cost and time increase significantly
Solution Approach 1:
The patent applies preliminary action by maintaining metadata information about active records in the database before archiving. This metadata includes record identifiers and other key attributes that enable verification without full data comparison. When archiving occurs, the system uses this pre-maintained metadata to efficiently verify deletions, eliminating the need for expensive post-archiving data comparisons while ensuring data consistency.
2Measurement precision
If record comparison is performed after archiving, then deletion accuracy is improved, but system resources are consumed for fetching and comparing archived records
Solution Approach 1:
The patent extracts only the essential metadata information needed for verification purposes and maintains it in the database before archiving. Instead of storing or comparing complete archived records, the system extracts and retains only the critical identifiers and attributes necessary for accurate deletion verification. This extraction approach enables precise deletion accuracy while minimizing system resource consumption during the verification process.
3Quantity of substance
If no metadata is maintained for archived records, then storage space is optimized, but data integrity and audit trail capabilities are compromised
Solution Approach 1:
The patent applies local quality by maintaining metadata information locally in the database for records that are candidates for archiving or have been archived. Rather than maintaining complete metadata for all archived records (which would consume significant storage), the system selectively maintains metadata for active records and uses this local metadata storage to enable verification and audit trail capabilities without compromising overall storage capacity.
4Ease of operation
If partition-based archiving is used, then deletion process is simplified, but granularity of control and verification capability are reduced
Solution Approach 1:
The patent segments the verification process by maintaining metadata for individual records or small groups of records rather than requiring verification at the partition level. This segmentation enables the system to perform deletions and verifications with fine-grained control over specific records while maintaining the simplicity of batch processing. The metadata structure allows selective verification of deleted records without requiring complex partition-level verification procedures.
Data Source
AI summary
Methods and apparatus, including computer program products, implementing and using techniques for archiving an active record in a database. An auxiliary table is created in the database. The auxiliary table can store metadata information about active records to be archived and deleted from the database. An active record to be deleted from the database is selected. Metadata information is stored in the auxiliary table for the selected active record. The selected active record is archived into a data storage device. The selected active record is deleted from the database, based on the update information in the auxiliary table, without comparing column data for the archived record in the data storage device and the active record in the database prior to deletion of the active record from the database.