IoT Multi-Tenant Account Creation Without Service Restarts
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing Internet of Things multi-tenant systems face service restart issues due to tenant-related information being stored in static files, leading to inefficiencies in data configuration and increased operational costs.
Innovation Solution
An account creation method that dynamically creates a target tenant database based on existing database instances, establishes data source mappings, and adjusts connection pool parameters in real-time to optimize resource allocation and reduce service disruptions.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of manufacture
If tenant-related information is stored in static files in a multi-tenant database, then data configuration is simplified, but service restart is required when configuration information is added
Solution Approach 1:
The patent transforms the static file storage approach into a dynamic database instance creation approach. Instead of storing tenant information in static files that require service restart upon modification, the system dynamically creates database instances for each tenant. This allows configuration changes to take effect immediately without service restart, as the database structure adapts dynamically to new tenants and configurations.
Solution Approach 2:
The patent changes the fundamental parameter of data storage from static files to dynamic database instances. By altering the storage medium and its characteristics, the system enables configuration updates without service interruption. The database instance parameters (such as schema, tables, and configurations) can be modified and added dynamically without requiring the entire service to restart.
2Device complexity
If tenant information is stored in static files, then system complexity is reduced, but operational costs increase due to service restart requirements
Solution Approach 1:
The system adopts dynamic database instance creation which, while increasing initial system complexity, eliminates the need for repeated service restarts. The one-time setup of dynamic database structures replaces ongoing operational overhead of service restarts, thereby reducing long-term operational costs and energy consumption.
Solution Approach 2:
The patent performs preliminary database instance creation and configuration setup during tenant onboarding. By pre-configuring the database structure, tables, and schemas when a tenant is first added, the system avoids the need for future service restarts when configuration changes are needed. This preliminary action shifts the complexity burden to the initialization phase rather than ongoing operations.
3Productivity
If dynamic database instances are created for each tenant, then account creation efficiency is improved, but system resource consumption increases
Solution Approach 1:
The patent segments the database system into multiple independent database instances, each dedicated to a specific tenant. This segmentation enables parallel account creation operations for different tenants without interfering with each other, thereby improving overall account creation efficiency. Each tenant's database instance can be created and configured independently, allowing concurrent processing and faster onboarding.
Solution Approach 2:
The patent creates a universal database instance template that can be reused across multiple tenants. Instead of designing entirely separate database structures for each tenant, the system uses a standardized template that can be instantiated repeatedly. This universal approach reduces resource consumption by avoiding redundant schema definitions while still enabling efficient account creation through automated template instantiation.
Data Source
AI summary
An account creation method, an Internet of Things multi-tenant system, a device, a program, and a medium provided by the present invention relate to the technical field of Internet of Things, and are applied to an Internet of Things multi-tenant platform. The method comprises: receiving an account creation request that at least comprises: an account identifier and a database instance identifier; creating, in a database server according to a database instance corresponding to the database instance identifier, a target tenant database corresponding to the account identifier, wherein the database instance is a database instance corresponding to existing tenant databases in the database server; and after the completion of the creation of the target tenant database, inputting an account creation success notification corresponding to the account identifier.