Versioned Database Timestamp Valuation for Global Transactions
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional snapshot processing methods for end-of-day valuations in international enterprises face delays due to copying transactions, leading to out-of-sync data, and locking mechanisms are not suitable for global operations with 24-hour transactions.
Innovation Solution
A method where initial and subsequent versions of documents are stored in a versioned database with timestamp data, allowing for precise valuation calculations by accessing the most recent version records at a specified time, enabling continuous business operations without disrupting valuation processes.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Measurement precision
If conventional snapshot processing copies transactions for valuation, then valuation can be performed, but data becomes out of sync due to time delays
Solution Approach 1:
The patent creates a copy of the transaction log at the valuation timestamp, rather than copying individual transactions during processing. This allows the valuation system to work with a static snapshot of the log while the original continues to receive updates, eliminating synchronization delays while maintaining accurate valuation data.
Solution Approach 2:
The system prepares the valuation by identifying and copying only the necessary transaction log data at the precise valuation timestamp before processing begins. This preliminary action ensures that the valuation uses accurate data without requiring ongoing synchronization during the valuation process.
2Reliability
If locking mechanism is used to prevent transaction updates during valuation, then data consistency is maintained, but global 24-hour operations are disrupted
Solution Approach 1:
Instead of locking transactions, the system creates a copy of the transaction log at the valuation timestamp. This copy is then processed for valuation while the original transaction log remains unlocked and continues to accept updates, maintaining both data consistency for valuation and operational continuity.
Solution Approach 2:
The patent introduces an intermediary mechanism where the transaction log is copied to a separate valuation workspace. This intermediary copy allows valuation processing to proceed with consistent data while the original system continues operations without interruption, acting as a mediator between valuation needs and operational continuity.
3Loss of time
If batch process begins before 5 pm for 5 pm valuation, then timely valuation is achieved, but updates occurring during processing are not reflected
Solution Approach 1:
The system performs a preliminary action by copying the transaction log at the precise valuation timestamp (5 pm) before valuation processing begins. This ensures that all updates through 5 pm are captured in the copy, allowing timely valuation with accurate data that reflects all transactions up to the valuation point.
Solution Approach 2:
The patent replaces the mechanical approach of sequential transaction copying with a systematic log-based approach. By copying the entire transaction log at the valuation timestamp and processing it systematically, the system achieves both timely valuation and complete accuracy without the race conditions inherent in sequential copying.
Data Source
AI summary
A computer system may create version records in a versioned database that stores data from transaction documents. Each version record may include a timestamp that represents a time from which the data stored in the version record is valid. The timestamp may represent the time of creation of particular version of the transaction document. The version records may be accessed to perform a valuation for a specified time.