Database Tenant Creation Using Template Metadata Snapshots
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Traditional database systems require time-consuming and resource-intensive processes to create new tenants, as each record must be added individually, leading to inefficiencies in computational and hardware resource utilization.
Innovation Solution
The method involves using template tenant metadata to create new tenants by associating them with a snapshot of the template tenant data, eliminating the need for row-by-row data copying and reducing resource usage, by storing tenant data in an immutable storage system with a unique identifier.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If traditional database systems create new tenants by adding records row-by-row, then data integrity and completeness are ensured, but the creation process becomes time-consuming and resource-intensive
Solution Approach 1:
The patent uses template tenant metadata as a reusable copy that can be instantiated multiple times to create new tenants. Instead of creating records row-by-row for each new tenant, the system copies the template metadata structure and populates it with tenant-specific data, dramatically reducing creation time while maintaining data integrity
Solution Approach 2:
The patent performs preliminary actions by pre-defining template tenant metadata that contains the structure and schema for future tenants. This template is prepared in advance and can be quickly instantiated when new tenants need to be created, eliminating the need to define the entire structure from scratch each time
2Productivity
If traditional database systems insert each record individually when creating a tenant, then data consistency is maintained, but computational and hardware resources are heavily utilized
Solution Approach 1:
The patent merges multiple record insertion operations into a single template instantiation operation. By combining the structure definition, data population, and tenant creation into one unified process using template metadata, the system reduces the number of individual database operations and associated resource consumption
Solution Approach 2:
The template tenant metadata serves multiple functions: it defines the data structure, validates data consistency, and enables rapid tenant creation. This universal template can be reused across multiple tenant creations, reducing redundant computational work and improving resource efficiency
Data Source
Figure 1
Figure 2
Figure 3
AI summary
System and methods are provided for creating a tenant of a database system, the tenant to have tenant data stored in an immutable storage of the database system associated with a tenant identifier. A request may be received at the database system to create a new tenant. A template tenant metadata of a template tenant may be selected at the database system to create the new tenant based on the received request. A new tenant identifier may be created at the database system based on the selected template tenant metadata. The new tenant may be created by associating the new tenant identifier with a snapshot of at least a portion of the template tenant metadata at a point in time when the template tenant metadata is made accessible to the new tenant. Systems and methods are also provided for removing a tenant of a database system by removing references to a tenant identifier.