Database Record Transfer Resumption via Ordered Identifier Sets
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In client/server computing environments, transferring large amounts of data without interruption is challenging, as existing methods fail to track and resume data transfer effectively after interruptions or breaks.
Innovation Solution
Assigning unique identifiers to records based on the time of addition allows the server to sort and transfer data in ordered sets, enabling seamless continuation of data transfer by tracking the last retrieved record's identifier for subsequent requests, even across interruptions.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Quantity of substance
If large amounts of data are transferred from database over network in client/server computing environment, then data transfer completeness is improved, but interruption and break occur during transfer
Solution Approach 1:
The patent divides the large data set into multiple smaller pages or records, transferring them in sequential batches rather than as a single large transfer. Each page contains a subset of records, allowing the transfer to be broken into manageable segments that can be sent one at a time, reducing the impact of interruptions while maintaining overall transfer completeness.
2Adaptability or versatility
If data transfer is divided into portions with starting points tracked, then transfer resumption capability is improved, but system complexity increases
Solution Approach 1:
The patent pre-establishes a tracking mechanism that records the starting point (first record identifier) and ending point (last record identifier) of each transferred page before the transfer completes. This preliminary tracking allows the system to resume from the exact position where it left off without requiring complex real-time monitoring or state management during interruption.
Solution Approach 2:
The patent implements a feedback loop where the server returns information about the transferred records (including the last record identifier) to the client. This feedback allows the client to track progress and resume from the correct position, providing simple and effective tracking without requiring complex distributed state management.
3Reliability
If records are transferred in sequential pages, then transfer reliability is improved, but transfer time increases
Solution Approach 1:
The patent makes the page size dynamic rather than fixed, allowing the system to adjust the number of records per page based on transfer conditions, network bandwidth, and data set characteristics. This dynamic adjustment optimizes the balance between transfer reliability (smaller pages mean fewer records to lose on interruption) and transfer speed (larger pages mean fewer total transfers), adapting to changing conditions throughout the transfer process.
Data Source
AI summary
Each record added to a database is assigned an identifier, for example, based on or at the time the record is added to the database. A database server receives a request for a first group of records that satisfy a condition, and searches and sorts on the basis of the identifier field all records in the database that satisfy the condition, to create an ordered set of records. The server sends the first group of records from the ordered set, in response to the request, and also sends a starting point in the ordered set from which to begin to send a second group of records from the ordered set that satisfy the condition.