Database View Maintenance for Core and Extension Tables
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Manual updates between the core and extension tables of a database can lead to inconsistencies due to shared primary keys, particularly when updating records with specific end dates, causing issues in finding and updating corresponding records in the extension table.
Innovation Solution
A method that automatically synchronizes and maintains data consistency between the core and extension tables by presenting maintenance views, receiving user inputs, and modifying the extension tables to reflect changes made to the core tables, ensuring that both tables are updated accordingly, even when the update involves splitting records into multiple entries based on specific date ranges.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If manual updates are performed between core and extension tables, then flexibility in modifying each table is improved, but data consistency between tables deteriorates
Solution Approach 1:
The system implements automatic feedback mechanisms where updates to core tables trigger corresponding updates in extension tables, and vice versa. The computer automatically detects changes in one table and propagates them to the other table, ensuring consistency without requiring manual intervention. This feedback loop resolves the contradiction by maintaining reliability while preserving flexibility.
Solution Approach 2:
The patent introduces an intermediary computer system that mediates between core and extension tables. This intermediary automatically manages the synchronization process, handling the complexity of maintaining consistency while allowing independent modification of each table. The intermediary acts as a bridge that ensures data integrity without restricting flexibility.
2Reliability
If automatic synchronization is implemented between core and extension tables, then data consistency is improved, but system complexity increases
Solution Approach 1:
The system implements self-service automation where the computer autonomously performs synchronization tasks without requiring complex external management. The automatic update mechanism handles itself, detecting changes and propagating them between tables without human intervention or complex orchestration, thus maintaining reliability while minimizing added complexity.
Solution Approach 2:
The patent merges the synchronization functionality into the existing database system architecture. Rather than adding separate complex synchronization systems, the automatic update mechanism is integrated directly into the database management process, combining data storage and data consistency maintenance into a unified system that reduces overall complexity.
3Manufacturing precision
If records are split into multiple entries based on date ranges, then data specificity is improved, but difficulty in finding and updating records increases
Solution Approach 1:
The patent adds temporal dimensionality to the record structure by splitting records into multiple entries based on date ranges. Each entry is associated with specific time periods, allowing precise data specificity while maintaining findability through the primary key. The computer uses this dimensional organization to efficiently locate and update the correct entries without difficulty.
Solution Approach 2:
The patent replaces manual mechanical search and update processes with automated computer-based systems. Instead of manually searching through split records, the computer automatically identifies and updates the correct entries using the primary key and date range criteria, eliminating the difficulty of detecting and measuring record locations while preserving data specificity.
Data Source
AI summary
A method performed by a processor allows an individual to update or maintain a database including a core and an extension. The core contains core tables including general data and the extension contains extension tables including specific data. The core tables and the extension tables have the same primary keys and the specific data are an extension of the general data. The method includes receiving an input from the individual for modifying the database, modifying the core using the received input, and automatically modifying the extension to reflect the modifying of the core.