Hub-and-Spoke Data Sharing via Proxy User Access
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing multi-tenant database systems face inefficiencies and high operational costs due to the need for data replication in peer-to-peer models for cross-organizational data sharing, which does not scale well with large volumes of data.
Innovation Solution
Implementing a hub-and-spoke architecture where shared data is stored in a central 'hub' and accessed by 'spokes' without replication, using a proxy user to manage access rights and facilitate data sharing, eliminating the need for multiple copies and synchronization.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If data is replicated across multiple locations for sharing, then data accessibility is improved, but storage efficiency deteriorates and operational costs increase
Solution Approach 1:
The patent introduces a virtual copy mechanism where data remains stored in a single location but is presented to multiple users through virtual representations. The system creates virtual copies that reference the original data without duplicating it, allowing multiple users to access and interact with data as if it were locally stored while maintaining centralized storage efficiency.
2Ease of operation
If data is replicated across multiple locations for sharing, then data accessibility is improved, but operational costs increase
Solution Approach 1:
The patent uses virtual copying instead of physical data replication. Virtual copies are lightweight references to the original data that can be created and distributed without duplicating the actual data bytes. This approach maintains data accessibility for multiple users while avoiding the storage costs and synchronization overhead associated with traditional replication.
3Adaptability or versatility
If peer-to-peer data sharing is implemented, then data sharing capability is improved, but system complexity increases due to synchronization requirements
Solution Approach 1:
The system introduces a centralized coordination layer that manages data sharing through virtual copies. Instead of requiring direct peer-to-peer synchronization between multiple data locations, the intermediary system coordinates access to the single original data source, eliminating the need for complex synchronization protocols while maintaining versatile data sharing capabilities.
4Quantity of substance
If data is stored in a single location without replication, then storage efficiency is improved, but data accessibility deteriorates
Solution Approach 1:
The patent creates virtual copies of data that can be distributed to multiple users without duplicating the actual data storage. These virtual copies provide local access points and interaction capabilities while the underlying data remains stored in a single efficient location, resolving the contradiction between storage efficiency and data accessibility.
Data Source
AI summary
In accordance with disclosed embodiments, there are provided methods, systems, and apparatuses for implementing cross organizational data sharing including, for example, means for storing customer organization data in a database of the host organization; allocating at least a sub-set of the customer organization data to be shared as shared data; configuring a hub to expose the shared data to a proxy user and configuring the proxy user at the hub with access rights to the shared data; configuring one or more spokes with access rights to the shared data of the hub via the proxy user; receiving a request from one of the hubs for access to the shared data of the customer organization via the proxy user at the hub; and returning a response to the hub having made the request. Other related embodiments are disclosed.