Database Access Control via Communication Time Measurement
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In constructing a business system that utilizes multiple databases, existing technologies fail to optimize access to external databases due to varying communication costs and deployment positions, leading to inefficient query execution plans.
Innovation Solution
An information processing method that specifies the relation between communication times for accessing external databases, calculates processing loads, and controls access based on these calculations to determine optimal execution plans for query execution.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of time
If access to external databases is performed without optimization, then system complexity is reduced, but communication time and processing load increase
Solution Approach 1:
The system performs preliminary measurement of communication times between the information processing apparatus and multiple external databases before actual query execution. These measurement results are stored and reused to determine optimal execution plans, avoiding the need to measure communication times repeatedly while minimizing communication time overhead.
Solution Approach 2:
The system calculates and stores execution plans in advance based on measurement results of communication times. When a query is received, the system selects from pre-calculated execution plans rather than optimizing in real-time, thus reducing communication time while avoiding the complexity of dynamic optimization during query execution.
2Productivity
If execution plans are optimized based on communication time measurements, then query execution efficiency improves, but measurement and calculation overhead increases
Solution Approach 1:
The system measures communication times and calculates optimal execution plans in advance, before actual query execution. These execution plans are stored and directly applied when queries are received, improving query execution efficiency while avoiding the complexity of real-time measurement and calculation during query processing.
Solution Approach 2:
The system creates execution plans based on measurement results and stores them as reusable templates. When similar queries are received, the system uses these pre-created execution plans rather than重新 measuring and calculating, thus improving productivity while minimizing the overhead of measurement and calculation activities.
3Measurement precision
If communication time measurements are performed frequently, then execution plan accuracy improves, but system resource consumption increases
Solution Approach 1:
The system performs communication time measurements periodically or at predetermined intervals rather than continuously or for every query. This periodic measurement approach maintains adequate execution plan accuracy while significantly reducing system resource consumption compared to frequent or real-time measurements.
Solution Approach 2:
The system performs communication time measurements in advance and stores the results for later use. By measuring communication times beforehand and reusing these measurements for multiple execution plan determinations, the system achieves sufficient measurement precision while minimizing resource consumption from repeated measurements.
Data Source
AI summary
Disclosed system specifies, based on measurement results of communication times taken for accessing a plurality of external databases, relation between the communication times taken for accessing the plurality of external databases, calculates, when accepting an instruction to execute processing using at least one of the plurality of external databases, a processing load when accessing the at least one of the external databases, based on the relation between the communication times, and controls an access to data included in the at least one of the external databases according to the calculated processing load.