Record-Keyed Database Update Buffers for Type-Specific Processing
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing data processing systems, particularly in automated systems like mechatronics, face complexity when input values vary greatly or include new types, necessitating human intervention, which complicates their use and scalability.
Innovation Solution
A method for distributing and apportioning database updates based on record identifiers and operational markings, involving a distributor and dispatcher system to efficiently manage data insertion and updates by associating requests with database records and executing specific programs for each type of value.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If automated processing systems use machine learning to handle data requests, then processing efficiency is improved, but system complexity increases when input values vary greatly or include new types
Solution Approach 1:
The system segments data processing into distinct phases: a distribution phase that handles data insertion into buffers based on record identifiers, and a processing phase that executes specific programs for each data type. This segmentation allows the system to handle varied input values through standardized buffer management while executing type-specific programs, thereby maintaining efficiency without increasing overall system complexity.
Solution Approach 2:
The patent introduces buffers as intermediary structures between data insertion and processing. Buffers receive data from distribution requests and hold it until processing is needed, acting as a mediator that decouples the insertion mechanism from the processing logic. This intermediary layer simplifies the system by providing a standardized interface for data handling while allowing complex processing programs to be executed separately based on data types.
2Loss of time
If the system processes all data requests immediately, then response time is reduced, but load balancing becomes difficult and scalability is limited
Solution Approach 1:
The system performs preliminary distribution of data into buffers during the distribution phase, organizing data by record identifiers before the processing phase begins. This preliminary action allows the system to prepare data structures in advance while maintaining the ability to handle varying loads. The buffers are pre-configured to accommodate different data types, enabling the system to scale by simply adding more buffers or processing capacity without affecting the fundamental operation flow.
Solution Approach 2:
The system dynamically adjusts processing based on operational markings associated with different data types. The processing phase executes different programs depending on the data type identified through operational markings, allowing the system to adapt to varying workloads and data characteristics. This dynamic processing enables scalability by allowing the system to prioritize and handle different types of data requests according to their importance and complexity.
3Adaptability or versatility
If the system uses AI to process variable input values, then processing capability is enhanced, but the need for human intervention increases when new input types arise
Solution Approach 1:
The system handles parameter variations by changing the execution path based on operational markings rather than using AI. When data is inserted, the system records the operational marking (e.g., data type, priority level), and during processing, it selects the appropriate program based on these markings. This parameter-based approach allows the system to adapt to new input types by simply adding new operational markings and corresponding programs, eliminating the need for AI and human intervention while maintaining full processing capability.
Data Source
Figure 1~3
Figure 2
Figure 4
AI summary
The invention relates to a method for processing data insertion and/or modification requests, which method is implemented by an electronic processing device, comprising a communication interface intended to receive the requests from a communication network. According to the invention, such a method comprises a phase (P10) of distributing data, within a plurality of buffers, each buffer being associated with a record of a database, the association being made by means of a database record identifier present within the received insertion and/or modification requests, the data being inserted in the form of buffer records, comprising a value to be updated in and/or inserted into the database; and a phase (P20) of allocating data within the records of the database, from the buffers of the plurality of buffers, the allocation phase comprising, for the buffer records that comprise an operational marking, the execution, from a configuration file, of 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.