Database Update Buffers for Variable Data Requests
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing automated data processing systems face challenges in efficiently handling data insertion and update requests, especially when input values vary widely or include non-existent types, requiring human intervention and complicating the use of artificial intelligence.
Innovation Solution
A method and device for processing data insertion and modification requests through a data distribution phase into buffers associated with database records, using operational markings and configuration files to optimize data updates, allowing for efficient and scalable data management without the need for extensive human intervention.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If automated data processing systems are used to handle data insertion and update requests, then processing efficiency is improved, but the system becomes more complex when input values vary widely or include non-existent types
Solution Approach 1:
The patent segments the data processing system into distinct modules: a data distribution phase that handles request routing and buffer allocation, and a dispatching phase that handles actual data updates. This segmentation allows each module to specialize in specific tasks, reducing overall system complexity while maintaining high processing efficiency for diverse data types
Solution Approach 2:
The patent introduces buffers as intermediary structures between the data distribution phase and the dispatching phase. These buffers act as mediators that temporarily store data updates, allowing the system to handle varied input values without directly increasing the complexity of the core processing logic. The buffers absorb the variability of input data types and values
2Reliability
If human intervention is required for handling varied input values, then data processing accuracy is improved, but the automation level decreases and implementation becomes more complex
Solution Approach 1:
The patent implements self-service mechanisms where the system automatically handles data updates based on predefined operational markings and configuration files. The dispatching phase automatically selects and executes appropriate update operations without requiring human intervention, even when input values vary widely. This maintains high automation levels while ensuring accurate processing through systematic rules
3Speed
If data updates are processed without buffering, then processing speed is improved, but system scalability decreases
Solution Approach 1:
The patent performs preliminary actions during the data distribution phase by pre-allocating buffers and preparing update operations before the actual data writing occurs. This preliminary buffering and preparation allows the system to scale efficiently by pre-organizing processing tasks, while the actual update execution remains fast through the optimized dispatching phase
Data Source
AI summary
A method for processing data insertion and/or modification requests, which is implemented by an electronic processing device including a communication interface to receive the requests from a communication network. The method includes distributing data, within a plurality of buffers. Each buffer is associated with a record of a database. The association is made via a database record identifier present within the received insertion and/or modification requests. The data is inserted in the form of buffer records, including a value to be updated in and/or inserted into the database. The method also includes allocating data within the records of the database, from the buffers of the plurality of buffers. The allocation phase includes, for the buffer records that include an operational marking, executing, from a configuration file, a computer program specifically dedicated to the record and/or specifically dedicated to the data type of the value to be updated and/or inserted.