Information Processing System for Parallel Query Execution
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In business systems utilizing multi-model databases, performance optimization and efficient use of external databases are challenging due to separate data management, leading to inefficient database usage.
Innovation Solution
An information processing system comprising a first device that determines query targets and connection information for external databases, and a second device that executes queries in parallel across multiple servers, offloading query execution and optimizing data access.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If external databases are managed separately in a multi-model database system, then data management flexibility is improved, but database usage efficiency deteriorates
Solution Approach 1:
The patent introduces an information processing device as an intermediary between the external database and the multi-model database system. This device includes a determination unit that identifies which external database contains the target record, a specification unit that determines the access method, and an execution unit that performs the actual data access. This intermediary structure enables flexible management of multiple external databases while optimizing access efficiency through intelligent routing and parallel processing.
2Device complexity
If query execution is centralized in a single database server, then system complexity is reduced, but query processing speed deteriorates
Solution Approach 1:
The patent segments the query execution process into multiple independent tasks that can be executed in parallel. The execution unit divides a single query into multiple query tasks and distributes them to different threads for concurrent execution. This segmentation approach maintains relatively simple system architecture while achieving high query processing speed through parallelization, effectively resolving the contradiction between system complexity and processing speed.
3Reliability
If all query processing is handled by the multi-model database server, then data access consistency is improved, but system resource utilization deteriorates
Solution Approach 1:
The patent implements a dynamic query execution mechanism where the system adaptively determines the optimal execution strategy based on the query characteristics and data distribution. The determination unit dynamically identifies whether to access external databases or internal tables, and the execution unit dynamically adjusts the degree of parallelization. This dynamic approach ensures data access consistency while optimizing system resource utilization by executing queries directly at the external database level when appropriate, reducing unnecessary data transfer and processing overhead.
Data Source
AI summary
An information processing system includes a first information processing device configured to accept an input of a query to be processed, and a second information processing device configured to execute the query for each of a plurality of tasks in parallel. The first information processing device determines whether or not an external database server contains records targeted by the query, and transmit the query and a connection information for accessing the external database server to the second information processing device. The second information processing device connects to the external database server based on the connection information received from the first information processing device, acquires information indicating a storage status of the records targeted by the query among records stored in the external database server, and determines a processing target range for each of the plurality of tasks relevant to the records targeted by the query, based on the acquired information.