Multi-tenant Database Group Membership Segmentation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database systems become inefficient when updating applications with complex data structures and handling a large number of concurrent user accesses, leading to slow query processing and access management challenges.
Innovation Solution
The implementation of techniques for processing group membership data in a multi-tenant database system, which involves receiving requests for access to database content, identifying relevant groups, and granting access based on requester identification data, using virtual portals and associational data registry to manage user permissions and access control efficiently.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If conventional database systems process queries with complex data structures and multiple concurrent users, then access control and data retrieval functionality is provided, but processing speed decreases and system efficiency deteriorates
Solution Approach 1:
The patent segments group membership data into hierarchical levels (parent groups and child groups) and separates access control checks into distinct processing stages. This segmentation allows the system to handle complex multi-tenant data structures by breaking them down into manageable units that can be processed efficiently, directly addressing the contradiction between handling complex data structures and maintaining query processing speed.
2Productivity
If conventional database systems manage access control for multiple users, then permission verification is performed, but processing cycles increase and operational efficiency decreases
Solution Approach 1:
The patent performs preliminary actions by pre-computing and caching group membership relationships and access permissions before they are needed for query processing. The system pre-establishes the hierarchical group structures and membership data, so that when concurrent user queries arrive, the access control checks can be performed rapidly using the pre-prepared data structures, thereby reducing processing cycles and improving operational efficiency.
3Speed
If conventional database systems handle large numbers of concurrent user accesses, then multi-user access control is maintained, but query processing speed slows down
Solution Approach 1:
The patent segments the access control processing by creating separate data structures for parent groups and child groups, allowing concurrent user queries to be processed in parallel with dedicated group membership data for each user. This segmentation enables the system to maintain high query processing speeds even when handling large numbers of concurrent users, as each user's access control checks can be performed independently using their specific group hierarchy.
Data Source
AI summary
In accordance with embodiments, there are provided techniques for processing group membership data in a multi-tenant database system. These techniques for processing group membership data in a multi-tenant database system may enable embodiments to provide great flexibility to a tenant of the architecture to select the content that may be perceived by the tenant users while allowing the owner of the architecture control over the content.