Dynamic Database Schema Allocation System

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Conventional techniques for providing database schemas are time-consuming, resource-intensive, and prone to human errors, leading to collisions and inefficient resource allocation due to manual intervention and the need for separate database instances for each client.

Innovation Solution

A dynamic schema allocation system that automatically allocates and manages temporary database schemas across multiple database instances from different vendors, using load balancing and automated processes to optimize resource utilization and minimize conflicts.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Quantity of substance

If a centralized database is used with manual schema provisioning, then resource utilization is improved, but human errors and collisions increase

Engineering Contradiction:

Improveresource utilizationVSAvoiderror rate

Core Design Contradiction:

Quantity of substanceVSReliability

Solution Approach 1:

The system enables automatic schema provisioning where the database management system autonomously creates, allocates, and manages temporary schemas without human intervention. The system self-services by automatically detecting schema needs, generating unique schema identifiers, and provisioning schemas on-demand based on workload requirements.

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The patent replaces manual mechanical operations (human administrators physically creating and managing schemas) with automated computational processes. The system uses software-based automatic schema generation and management, substituting human manual work with algorithmic processes that eliminate human errors while improving resource utilization.

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

2Reliability

If separate database instances are created for each client, then collisions are minimized, but resource intensity increases

Engineering Contradiction:

Improvecollision rateVSAvoidresource intensity

Core Design Contradiction:

ReliabilityVSUse of energy by moving object

Solution Approach 1:

The system segments the database environment by creating isolated temporary schemas within shared database instances. Each client receives a dedicated schema namespace with unique identifiers, providing collision-free environments without requiring separate database instances. This segmentation approach maintains isolation benefits while reducing overall resource consumption.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The patent makes database instances universal by enabling them to serve multiple clients simultaneously through automatic schema allocation. A single database instance can provision and manage multiple temporary schemas for different clients, making the instance multi-functional and reducing the need for dedicated instances per client.

Inventive Principle:

Principle #6Universality (Multi-functionality)

3Ease of operation

If manual schema creation is performed, then schema allocation is controlled, but time consumption increases

Engineering Contradiction:

Improvecontrol levelVSAvoidprovisioning time

Core Design Contradiction:

Ease of operationVSLoss of time

Solution Approach 1:

The system performs preliminary actions by pre-configuring template schemas and establishing automatic provisioning rules beforehand. When a client needs a schema, the system rapidly instantiates pre-defined templates with unique identifiers, eliminating the time-consuming manual creation process while maintaining controlled allocation through pre-established policies.

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The patent replaces manual schema creation operations with automated computational processes. The system uses software-based schema generation that executes instantly, substituting the time-consuming manual administrative work with algorithmic processes that maintain control while dramatically reducing provisioning time.

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

4Productivity

If automated schema allocation is implemented, then productivity is improved, but system complexity increases

Engineering Contradiction:

Improveschema allocation efficiencyVSAvoidsystem complexity

Core Design Contradiction:

ProductivityVSDevice complexity

Solution Approach 1:

The system introduces an intermediary schema allocation service that sits between clients and database instances. This intermediary automatically manages schema provisioning, unique identifier generation, and resource coordination, simplifying the overall system by centralizing complexity in a dedicated management layer while maintaining high productivity.

Inventive Principle:

Principle #24Intermediary (Mediator)

Data Source

PatentUS10956379B2Dynamic lifecycle management of temporary storage schemas

Publication Date: 2021.03.23 ORACLE INT CORP

AI summary

Techniques are described that enable the dynamic and automatic life cycle management of database schemas. Temporary database schemas are dynamically and automatically allocated in response to database schema requests. Allocated schemas are also automatically reclaimed upon expiration. A dynamic schema allocation system is provided that is configured to receive database schema requests from one or more clients and dynamically and automatically, substantially free of any manual intervention, serve database schemas in response to the requests. The database schemas may be allocated from multiple database instances available to the dynamic schema allocation system. Attributes specified in a database schema request may be used to find a matching database instance and a schema is allocated for the request from the matching database instance.