Temporal Metadata for Automatic Database Data Updates
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database systems fail to ensure data remains current and accurate over time, particularly for information that changes predictably or non-predictably, leading to stale data values.
Innovation Solution
A database server stores metadata specifying the time and manner in which data should change, allowing it to automatically update data when the specified time is satisfied, using a temporal metadata table to manage and execute commands for data modification.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If data is stored statically in traditional database systems, then data storage simplicity is maintained, but data currency and accuracy deteriorate over time
Solution Approach 1:
The patent applies preliminary action by storing metadata in advance that specifies future data changes. The metadata includes change instructions and timestamps that trigger automatic updates without requiring continuous manual intervention. This allows the system to proactively prepare for and execute data updates at predetermined times, ensuring data currency while maintaining simple management operations.
Solution Approach 2:
The patent implements self-service by enabling data to update itself automatically based on stored metadata. When the database server encounters metadata with a satisfied timestamp condition, it automatically executes the specified data changes without human intervention. This self-updating mechanism ensures data remains current while reducing the complexity of manual data management tasks.
2Reliability
If manual updates are performed to keep data current, then data accuracy is improved, but time consumption and operational effort increase
Solution Approach 1:
The system performs preliminary action by pre-storing metadata that contains both the update instructions and the trigger conditions. This allows data updates to be executed automatically at predetermined times or conditions without requiring manual intervention, thereby maintaining data accuracy while eliminating the time loss associated with manual update operations.
Solution Approach 2:
The patent implements feedback by having the database server continuously monitor metadata timestamps and automatically trigger updates when conditions are satisfied. This closed-loop feedback mechanism ensures data remains accurate by automatically detecting when updates are needed and executing them, eliminating the need for manual checking and updating that consumes time.
3Productivity
If data changes are managed without temporal metadata, then system simplicity is maintained, but data staleness increases
Solution Approach 1:
The patent applies preliminary action by storing temporal metadata in advance that specifies when and how data should change. This metadata includes timestamps and change instructions that enable automatic data updates, ensuring data currency is maintained without compromising management efficiency. The preliminary storage of update instructions allows the system to automatically refresh data at appropriate times.
Solution Approach 2:
The patent replaces the mechanical system of manual data updates with an automated metadata-driven mechanism. Instead of manually tracking and updating data, the system uses stored metadata with temporal conditions to automatically trigger updates. This substitution maintains simplicity by eliminating manual intervention while preventing data staleness through automated temporal-based updates.
Data Source
AI summary
A method, apparatus, and computer-readable medium are provided for storing data such that the data automatically changes to remain current over time. In one embodiment, a database server stores metadata in association with data that is stored in a database. The metadata specifies a time and a manner in which the data should change. On, near, or after the specified time, the database server reads the metadata to determine that the specified time is satisfied. In response to determining that the specified time has been satisfied, the database server changes the data stored in the database in the specified manner.