Local Temporary Database Descriptors for Concurrent Session Management
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database management systems face limitations due to a two-byte unique ID field, which restricts the number of temporary objects that can be managed, especially in scenarios with multiple concurrently running applications requiring a large number of temporary objects.
Innovation Solution
Implementing a system with local temporary database descriptors for each database session, allowing unique object identifiers within each session while maintaining global scope for shared resources, thereby supporting a higher number of transactions without altering the global database descriptor's unique ID size.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Quantity of substance
If a global temporary object database descriptor with a two-byte unique ID field is used, then the database management system can maintain a simple structure and fast access speed, but the number of unique IDs is limited to approximately 32,000, which restricts the number of temporary objects that can be managed
Solution Approach 1:
The patent divides the single global temporary object database descriptor into multiple session-specific temporary object database descriptors. Each descriptor maintains a two-byte unique ID field, preserving simplicity and fast access speed. The system creates one descriptor per database session, allowing each session to independently manage its temporary objects without interfering with other sessions. This segmentation enables the database to support many more temporary objects across multiple sessions while maintaining the original simple structure at the descriptor level.
2Quantity of substance
If the unique ID field size is increased to support more temporary objects, then the number of manageable temporary objects increases, but the database management system architecture requires significant changes that are time-consuming and costly
Solution Approach 1:
The patent applies local quality by allowing each session-specific temporary object database descriptor to have its own independent two-byte unique ID space. Instead of requiring a single global descriptor with a larger unique ID field, each local descriptor maintains the simple two-byte structure appropriate for its specific session context. This enables the system to support a much larger total number of unique IDs across all sessions while keeping each individual descriptor simple and inexpensive to implement.
3Adaptability or versatility
If a single global temporary object database descriptor is used to manage temporary objects for all concurrent users, then the system structure remains simple, but the number of concurrent applications requiring temporary objects is limited by the unique ID capacity
Solution Approach 1:
The patent segments the global temporary object management functionality into multiple session-specific descriptors, where each descriptor serves a single database session. This segmentation allows each session to independently create and manage its own temporary objects with unique IDs, enabling many concurrent applications to run simultaneously without competing for a limited global unique ID pool. The segmentation directly increases system adaptability to handle multiple concurrent applications while supporting a larger total number of temporary objects.
Solution Approach 2:
The session-specific temporary object database descriptors are designed to be universal in structure, each capable of managing temporary objects for any database session. The same two-byte unique ID mechanism and descriptor format are used across all sessions, making the system multi-functional and adaptable to different concurrent applications while maintaining consistency and simplicity in implementation.
Data Source
AI summary
A computer system and a relational database management system (RDMS) computer program product are described for interfacing a number of concurrently running database sessions with a large database in which a plurality of local temporary object database descriptors are used in lieu of a single global temporary object database descriptor where the global and each of the local temporary object database descriptors include identifiers for temporary objects, each of the local temporary object database descriptors is associated with a single database session and each of the global database descriptors is shared among multiple database sessions.