Job Queue Processing for Database Update Latency
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Initial database updates often initiate lengthy and time-consuming further updates, leading to performance lag and decreased efficiency in database servers due to the execution of triggered updates.
Innovation Solution
A job processing server detects job initiation data, retrieves new job parameters, and creates job records in a queue, processing jobs based on predefined triggers to execute updates independently of the initial updates, thereby separating and expediting the completion of triggered updates.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If initial database updates are executed, then the database is updated with new data, but the triggered further updates cause the overall process to become lengthy and time-consuming
Solution Approach 1:
The patent segments the database update process into two independent parts: (1) initial update execution that completes quickly, and (2) triggered further updates that are queued and executed separately. This segmentation allows the initial update to complete without being blocked by time-consuming triggered updates, thereby reducing overall update time while ensuring all necessary updates are eventually executed.
Solution Approach 2:
The patent implements preliminary action by queuing the triggered further updates during the initial update process, rather than executing them immediately. This allows the system to prepare and organize all necessary update operations in advance, then execute them efficiently in a controlled manner, reducing the time impact on the initial update completion.
2Reliability
If triggered updates are executed immediately, then data consistency is maintained, but database server performance decreases due to the lengthy execution time
Solution Approach 1:
The patent introduces a job queue as an intermediary between the initial update process and the triggered further updates. This intermediary component receives, stores, and manages the triggered updates, allowing them to be executed separately without blocking the initial update. This maintains data consistency while preserving database server performance by preventing performance degradation during the initial update execution.
3Manufacturing precision
If multiple triggered updates are processed sequentially, then each update is executed correctly, but the overall update process becomes lengthy
Solution Approach 1:
The patent implements continuous useful action by processing multiple triggered updates in a continuous queued manner rather than with idle gaps between sequential executions. The job queue enables the database server to maintain continuous productive work on update operations, executing multiple triggered updates efficiently in sequence without unnecessary delays, thereby reducing total update duration while ensuring each update is executed correctly.
Data Source
AI summary
A method in job processing server of processing database updates includes: storing, at a job processing server, a job queue including a plurality of job records, each job record having corresponding job parameters; detecting job initiation data at a data source; responsive to detecting the job initiation data, retrieving new job parameters from the data source based on the job initiation data; creating a new job record including the new job parameters in the job queue; and responsive to a predefined trigger, for each job in the job queue, processing the job based on corresponding job parameters, wherein processing the job includes sending instructions for execution by a second server, the instructions for performing an update at the second server.