Tenant-Specific Database Segmentation for Multi-Tenant Cloud Systems
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional multi-client server systems face challenges in scalability, database maintenance, content deployment, and data backup/recovery efficiency, while single-client systems require significant client involvement and resources for maintenance.
Innovation Solution
Implementing a system where a provider hosts multiple tenants with a shared data structure for common data and tenant-specific data structures, allowing each tenant to access shared and unique data independently, enabling flexible and efficient management without impacting other tenants.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If a multi-client system shares a common database for all clients, then resource utilization is improved, but database maintenance complexity and downtime increase
Solution Approach 1:
The patent segments the database into multiple separate physical databases, one for each client. This allows independent maintenance, backup, and recovery operations on each client's database without affecting other clients. The segmentation resolves the contradiction by maintaining resource efficiency through centralized management while eliminating the complexity and downtime issues of shared databases.
2Quantity of substance
If a multi-client system uses a common database, then infrastructure cost is reduced, but backup and recovery time increases significantly
Solution Approach 1:
By segmenting the database into separate physical databases for each client, the system enables independent backup and recovery operations. Each client's data can be backed up or recovered without waiting for other clients' operations, dramatically reducing the total time required compared to restoring an entire shared database environment.
3Productivity
If a single-client system provides separate databases for each client, then backup and recovery efficiency is improved, but client involvement in maintenance increases
Solution Approach 1:
The patent introduces a provider as an intermediary that manages all database operations including backup, recovery, and maintenance for segmented client databases. This resolves the contradiction by maintaining the efficiency benefits of separate databases while eliminating the need for client involvement in maintenance through centralized provider management.
4Productivity
If content is distributed throughout a common database, then resource sharing is optimized, but content deployment time and effort increase
Solution Approach 1:
The patent segments the database so that each client has their own physical database. This allows content to be deployed directly to a specific client's database without needing to search through or sort content from other clients' data, significantly reducing deployment time and manual effort while maintaining resource sharing through the application layer.
Data Source
AI summary
The present invention discloses methods and systems for tenants to execute application software hosted by a provider in a computer-based environment in which a provider may store a shared data structure associated with the application software, such that each of the plurality of tenants has access to the shared data structure. The provider may also distribute, to each of the plurality of tenants, respective tenant-specific data structures for storing data unique to each respective tenant for storage at each respective tenant, and send, based upon a data request generated by the application software, data of the shared data structure a first tenant of the plurality of tenants.