Temporary Database Tables for Resource Optimization
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Relational databases face performance bottlenecks due to inefficient data access and complex coding, leading to high resource consumption and reduced portability, making it costly and labor-intensive to create and manage functional databases.
Innovation Solution
The creation and management of temporary database tables, which can be created at runtime, store intermediate data, and are deleted upon application exit, allowing for shifting database calculations to the database software layer, reducing the need for persistent memory and enhancing system resource utilization.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If data is stored in persistent memory for intermediate results, then data availability is improved, but system resource consumption and storage costs increase
Solution Approach 1:
The patent implements temporary tables that are automatically created and deleted without requiring persistent storage. These temporary structures hold intermediate data only for the duration of the database operation, then are automatically discarded. This eliminates the need for expensive persistent storage of transient intermediate results while maintaining data availability during the operation.
Solution Approach 2:
The patent introduces temporary tables as intermediary structures between source and target tables during data operations. These temporary tables serve as transient holding areas that facilitate complex operations without requiring permanent storage, acting as a mediator that exists only momentarily during the operation.
2Adaptability or versatility
If complex coding is used to query relational databases, then data access capability is improved, but development time and labor resources increase
Solution Approach 1:
The patent implements self-service temporary tables that automatically manage their own creation, population, and deletion. The database system itself handles the overhead of managing these temporary structures without requiring additional complex coding from developers, allowing versatile data access operations while reducing development effort.
Solution Approach 2:
The patent creates universal temporary table structures that can be used across multiple different database operations and applications. These temporary tables provide a standardized interface for intermediate data storage that works consistently across various query types and operations, reducing the need for application-specific complex coding.
3Productivity
If database structures are designed for infrequent data access to reduce resource consumption, then system performance is improved, but data accessibility and responsiveness worsen
Solution Approach 1:
The patent implements dynamic temporary tables that are created on-demand during database operations and automatically deleted when no longer needed. This dynamic approach allows the system to maintain optimal performance by only allocating resources for temporary data storage when actually required, rather than maintaining static structures that would consume resources continuously.
Solution Approach 2:
The patent performs preliminary creation of temporary tables before complex operations to ensure data access pathways are prepared in advance. This preliminary action allows the system to optimize subsequent data access operations by having the temporary structures already in place, improving access speed during the actual operation without compromising overall system performance.
Data Source
AI summary
Systems and methods for creating and populating temporary database tables with intermediate data that can be preserved once a database application session ends and used outside of the instant database operation without storing this data in persistent memory are provided. A local temporary database table may be used only in the local instance of a database application, and a global temporary table makes intermediate data available across multiple applications and multiple application instances.