Cross-Database Writes Using Metadata and Transaction Context
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database migration techniques do not allow producers to maintain control over database management and data access, leading to inefficiencies and increased complexity, especially in geographically distributed environments.
Innovation Solution
Implementing a system that enables writes from a consumer database to a producer database, maintaining control over access to metadata and transaction context, and using local user ID mappings to manage permissions, thus reducing complexity and resource usage.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If database migration techniques are used to enable access to producer database, then consumer database can access producer database data, but producer loses control over database management and data access
Solution Approach 1:
The patent introduces a datashare as an intermediary mechanism between consumer and producer databases. The datashare contains metadata that describes the producer database structure, enabling consumer database to access producer data without direct connectivity. This intermediary layer maintains producer control over data management while providing consumer access capability.
Solution Approach 2:
The patent creates a virtual copy of the producer database structure through metadata in the datashare. Instead of actual data migration or direct connection, the consumer database works with a metadata representation that mirrors the producer database schema. This copying approach enables access while preserving producer control over the actual data and management operations.
2Adaptability or versatility
If traditional database access methods are used, then data can be accessed between databases, but system complexity and resource usage increase
Solution Approach 1:
The patent extracts only the essential structural information (metadata) from the producer database and places it in the datashare. This extraction separates the access mechanism from the actual data storage and management, simplifying the system architecture. The consumer database accesses only the metadata needed for interaction, reducing complexity compared to full database connectivity approaches.
Solution Approach 2:
The patent segments the database access function into distinct components: the producer database (data storage), the datashare (metadata and access control), and the consumer database (query execution). This segmentation allows each component to be optimized independently and reduces overall system complexity by avoiding tight coupling between consumer and producer systems.
3Adaptability or versatility
If full database connectivity is established, then bidirectional access is enabled, but resource usage and maintenance cost increase
Solution Approach 1:
The patent applies partial action by providing only the necessary metadata and access permissions in the datashare, rather than establishing full database connectivity. The consumer database receives just enough information to perform read operations and receive changes, without needing complete database access rights. This partial action approach reduces resource usage while maintaining sufficient access flexibility for the intended use case.
Data Source
AI summary
A consumer database of a service provider network may perform writes to a producer database. To do so, the consumer database obtains metadata and a transaction context from the producer database and uses that information to perform a write from the consumer database to the producer database. A consumer database may access (read and/or write) a producer database that uses a different topology to manage data. To do so, the consumer database obtains topology metadata from the producer database and uses the topology metadata to perform a query (read or write) from the consumer database to the producer database. A consumer database may access a producer database based on a mapping of local user IDs to consumer databases at the producer database. The access may be granted to the consumer database based on permissions assigned to the local user IDs.