Tenant Schema Generation via Database Template Copying

Solution Overview

Problem

In multi-tenant database environments, creating a new tenant schema is inefficient due to the need for database migration managed by third-party software, which generates more files and consumes increasing system resources with each migration.

Innovation Solution

The system uses a template tenant schema to optimize resource usage by copying the template schema within the database system to create new tenant schemas, reducing processing time and system overhead.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If third-party software is used for database migration to create tenant schemas, then schema creation can be achieved, but system resources increase and processing time increases with each migration

Engineering Contradiction:

Improveschema creation efficiencyVSAvoidsystem resource consumption

Core Design Contradiction:

ProductivityVSUse of energy by moving object

Solution Approach 1:

The patent applies the copying principle by creating a master schema that serves as a template, which is then copied to generate tenant schemas. This eliminates the need for repeated third-party software migrations for each tenant, as the schema structure is replicated efficiently from the master template, reducing both processing time and system resource consumption.

Inventive Principle:

Principle #26Copying

Solution Approach 2:

The patent implements preliminary action by pre-defining the master schema with all necessary table structures, relationships, and configurations before tenant creation. This upfront preparation allows subsequent tenant schemas to be generated through simple copying operations rather than requiring full migration processes for each tenant.

Inventive Principle:

Principle #10Preliminary action

2Productivity

If third-party software is used for database migration to create tenant schemas, then schema creation can be achieved, but processing time increases with each migration

Engineering Contradiction:

Improveschema creation speedVSAvoidmigration processing time

Core Design Contradiction:

ProductivityVSLoss of time

Solution Approach 1:

The patent applies the copying principle by creating a master schema that serves as a template, which is then copied to generate tenant schemas. This eliminates the need for repeated third-party software migrations for each tenant, as the schema structure is replicated efficiently from the master template, reducing both processing time and system resource consumption.

Inventive Principle:

Principle #26Copying

Solution Approach 2:

The patent implements preliminary action by pre-defining the master schema with all necessary table structures, relationships, and configurations before tenant creation. This upfront preparation allows subsequent tenant schemas to be generated through simple copying operations rather than requiring full migration processes for each tenant.

Inventive Principle:

Principle #10Preliminary action

Data Source

PatentUS11709807B2Optimized tenant schema generation

Publication Date: 2023.07.25 RED HAT LLC

AI summary

A system includes a memory and a processor, where the processor is in communication with the memory. The processor is configured to receive a request to create a tenant schema within a database, where the database includes one or more tenant schemas associated with one or more tenants. The tenant schema associated with a tenant of the one or more tenants is created, where the tenant schema is empty. It is determined whether the database includes a template schema. Upon determining the template schema exists, command is sent to the database to copy the template schema to the tenant schema associated with the tenant.