Database Archiving Consolidation for Performance Optimization
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Databases face performance issues and increased backup times due to infrequently accessed and outdated information, which conventional archival solutions fail to address effectively by not efficiently managing data across multiple tables and accommodating various file formats.
Innovation Solution
A method for archiving data from multiple database tables into a single archive table, where data values are monitored, identified for archival based on access thresholds, stored as archive files, and removed from active tables, allowing for efficient storage and management of infrequently accessed data in its original format.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If archived data is stored in its original format across multiple tables, then data accessibility and reference are maintained, but network resource demands increase and application performance slows
Solution Approach 1:
The patent merges data from multiple active database tables into a single archive table, consolidating what was previously distributed across multiple tables into one unified structure. This reduces the number of table references and queries needed, thereby improving application performance while maintaining data accessibility through the consolidated archive.
Solution Approach 2:
The archive table is designed to accommodate data from multiple original tables with different formats, making the archive table universal. It can store infrequently accessed data from various sources in its original formats while providing a unified access point, thus maintaining reliability without the performance penalties of multiple separate archive structures.
2Reliability
If archived data is stored in its original format, then data reference integrity is maintained, but the archive solution must accommodate multiple file formats increasing complexity
Solution Approach 1:
The archive table is designed as a universal container that can store data from multiple original tables in their original formats. This multi-functional design allows the single archive table to accommodate various file formats and data structures without requiring separate archive structures for each source table, thereby maintaining integrity while reducing overall complexity.
Solution Approach 2:
The patent segments the archiving process by creating separate archive tables for different data types or sources while maintaining a unified archive structure. This segmentation allows each original table's data to be archived in its original format while still organizing it within a manageable, single-table archive structure that reduces complexity compared to multiple separate archive tables.
3Ease of operation
If infrequently accessed data remains in active tables, then data is readily accessible, but backup time and network resource demands increase
Solution Approach 1:
The patent extracts infrequently accessed data from active database tables and moves it to an archive table. This extraction reduces the amount of data that needs to be maintained in active tables, thereby reducing backup time and network resource demands while preserving the ability to access the archived data when needed through the archive table.
Data Source
AI summary
A method for archiving to a single database table information located across multiple database tables. The method begins by monitoring at least one data value residing in the multiple database tables. After monitoring, the method continues by identifying at least one archival data value where each archival data value corresponds to a unique data value not exceeding a threshold. An end user provides the threshold used to identify the archival data values prior to execution of the method. After identifying the archival data values, the method continues by storing archive files in the single database table, each archive file comprising at least one archive data value. Finally, after storing the archive files in the single database table, the method concludes by removing from the multiple database tables each archival data value.