Database Access Control via Pre-Execution Table Joining
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database access methods are inefficient due to repeated queries across multiple tables, especially in batch processing, where the range of data to be accessed cannot be identified beforehand, leading to performance degradation and increased communication time over external networks.
Innovation Solution
A system and method that includes an acquiring section for access programs, a detecting section to identify multiple tables, a join control section to execute a join instruction combining tables before access, and an access control section to manage access to a result table, reducing the frequency of database queries and improving efficiency.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If separate queries are issued to multiple tables sequentially, then data access flexibility is maintained, but processing time increases and performance deteriorates
Solution Approach 1:
The patent combines multiple separate database access instructions that access different tables into a single database access instruction. The system detects multiple tables accessed by access instructions and generates a unified query that retrieves data from all detected tables in one operation, thereby reducing the number of queries and improving processing efficiency without sacrificing data access flexibility
Solution Approach 2:
The system performs preliminary detection of multiple tables that will be accessed before executing the actual data retrieval. By analyzing access instructions in advance and identifying all tables that need to be queried, the system can prepare a consolidated query plan that optimizes data retrieval efficiency before the actual processing begins
2Productivity
If data is cached beforehand at each checkpoint operation, then processing efficiency improves, but memory usage increases and complexity increases
Solution Approach 1:
The patent merges multiple database access operations into a single consolidated query, eliminating the need for separate caching operations at each checkpoint. By retrieving all required data in one operation, the system avoids the complexity of managing multiple cache operations while maintaining improved processing efficiency
3Reliability
If multiple queries are sent over external network, then data retrieval completeness is ensured, but communication time increases and network load increases
Solution Approach 1:
The patent consolidates multiple separate database queries that would otherwise be sent over the network into a single unified query. This approach ensures that all required data is retrieved in one network communication event, maintaining data retrieval completeness while significantly reducing communication time and network load
Data Source
AI summary
A system to controls access to a database, including: an acquiring section which acquires an access program including a plurality of database access instructions; a detecting section which detects a plurality of different tables in the database that are accessed by the plurality of access instructions; a join control section which executes a join instruction prior to the execution of the access instructions, the join instruction obtaining a result table from the database by combining the plurality of different tables detected; and a conversion control section which executes a conversion instruction prior to the execution of the plurality of access instructions, the conversion instruction extracting records from the result table for the access instructions and converting the records into the form of a structure accessible for the plurality of access instructions.