Database Data Transfer with State Indicator
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
High traffic volumes in database servers can lead to delays and instability, causing end-user frustration, especially in applications like computer gaming where immediate data access is critical.
Innovation Solution
A method and system for transferring data between database locations using a location reference with an indicator that changes states to manage data collection transfers, allowing selective updating of location values and handling of data copies and deletions based on these states, supporting different importance levels of lookup requests and utilizing a hierarchical database structure with shards and caches.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If data is transferred between database locations during high traffic, then data access continuity is maintained, but database stability deteriorates due to concurrent access conflicts
Solution Approach 1:
The system sets a transfer indicator before actually transferring the data collection. This preliminary action marks the data collection as being in transfer state, so that subsequent lookup requests can detect this state and handle accordingly (either wait or access from source location), preventing access conflicts while maintaining continuity
Solution Approach 2:
The transfer indicator acts as an intermediary mechanism between the data transfer process and lookup requests. It mediates by providing a visible state that allows lookup operations to make informed decisions without directly interfering with the transfer process, thus maintaining database stability
2Ease of operation
If location values are updated during data transfer, then data is accessible from new location, but data loss occurs if transfer is interrupted
Solution Approach 1:
The transfer indicator is set before the actual data transfer begins. This allows the system to track whether a transfer was initiated, and if the indicator remains set after a lookup request, it indicates the transfer was interrupted and the new location value should not be used, preventing data loss
Solution Approach 2:
The transfer indicator provides feedback about the transfer state to lookup requests. If the indicator is still set when a lookup occurs, it feedbacks that the transfer was interrupted, triggering the system to revert to the source location or abort the transfer, thus preventing data loss
3Reliability
If data collections are copied during transfer, then data availability is maintained, but system resources are consumed
Solution Approach 1:
The system performs a partial copy of the data collection during transfer rather than a complete copy. This partial action provides sufficient data availability for lookup requests while consuming fewer system resources compared to a full copy operation
Data Source
AI summary
A method of transferring data between database locations comprising: providing a location reference comprising location values of one or more data collections stored in a database; providing an indicator in association with at least one data collection of the one or more data collections, the indicator being provided in response to initiation of a transfer process of the at least one data collection from a first location of the database to a second location of the database; wherein the indicator is changeable between a first state and a second state, the first state being indicative of the initiation of the transfer process; and as part of the transfer process of the at least one data collection, selectively updating a location value of the at least one data collection in the location reference, in dependence on a determination of whether the indicator is in the first state or the second state.