Database Record Update via Time-Range Filtering and Parallel Threads
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing methods for updating software database records lack efficiency in estimating and transmitting the optimal amount of data, leading to potential overloads and time-outs in communication between databases.
Innovation Solution
A method that selects database records for download based on date-time stamp values within a specified time range, allowing for the use of multiple threads to concurrently download records, thereby reducing the likelihood of overloads and optimizing data transfer by adjusting the time period based on update counts.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Quantity of substance
If all database records are downloaded without time range filtering, then data completeness is improved, but communication overload and time-outs increase
Solution Approach 1:
The patent segments the database records into two categories: those requiring immediate attention (within the time range) and those that can be handled later (outside the time range). This segmentation allows the system to download only the necessary records for current operations, preventing communication overload while maintaining data completeness for immediate needs.
Solution Approach 2:
The system performs preliminary filtering of records based on time range before initiating the download process. By pre-determining which records fall within the specified time range and selecting only those for download, the system avoids unnecessary data transmission and reduces communication burden, thereby improving reliability.
2Quantity of substance
If a large time range is specified for record download, then data completeness is improved, but transmission time and system resources increase
Solution Approach 1:
The patent implements dynamic adjustment of the time range parameter based on actual system needs and conditions. The time range is not fixed but adapts to the current operational context, allowing the system to optimize between data completeness and transmission time by selecting the minimum necessary range that satisfies current requirements.
Solution Approach 2:
The system changes the time range parameter dynamically during the record selection process. By adjusting this parameter based on factors such as data volume, system load, and operational urgency, the patent optimizes the balance between retrieving sufficient data and minimizing transmission time and resource consumption.
3Productivity
If multiple threads are used for concurrent downloads, then download speed is improved, but system complexity increases
Solution Approach 1:
The patent segments the record download task into multiple independent threads, each responsible for downloading records from specific time ranges or database sections. This segmentation enables concurrent operations that improve download speed while keeping each thread's scope manageable and independent, reducing overall system complexity.
Solution Approach 2:
The system introduces a new dimension of organization by grouping thread responsibilities according to time ranges or record categories. This dimensional organization allows multiple threads to operate in parallel without creating a tangled mess of dependencies, as each thread works on a distinct slice of the data space, simplifying thread management.
Data Source
AI summary
A system and method enable the selection of a time range of database records for download from a source database source and for transfer to a recipient database. A specifically bounded time period is selected to limit the number of data records selected for download in a particular action to those records that are individually associated with date time stamp values falling within the specified time period. This limitation of records selected for inclusion in a download process to data records having associations with date time stamps falling within a limited time range reduces a likelihood of overload in transferring data and thereby reduces the incidence of time-outs in the communication of a source database, any intermediary server or software action, and the recipient database in an updating of the recipient database to reflect a current state of the source database. A plurality of threads may be employed to contemporaneously download records associated with date time stamps having values within a requested time range whereby data records may be downloaded in parallel.