Active-Active Data Center Affinity for Consistent Database Routing
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing systems face challenges in managing simultaneous access and operations by multiple users from different databases within an institution system, leading to inconsistencies and potential data discrepancies due to users accessing different databases at the same time.
Innovation Solution
A device agnostic active/active data center system that groups users with similar profiles to ensure they access and operate on the same database, using a content delivery network (CDN) to manage load balancing and middleware to convert user credentials to member identifiers for consistent database assignment.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If multiple users access different databases simultaneously based on load balance, then system load distribution is improved, but data consistency and user profile synchronization deteriorate
Solution Approach 1:
The patent introduces a CDN provider as an intermediary layer between users and databases. The CDN provider receives user requests, determines the appropriate database based on user profile information, and forwards requests to the designated database. This mediator ensures that all users within the same profile access the same database while the system maintains load balancing across multiple databases through intelligent request routing.
2Productivity
If users are assigned to different databases based on load balance, then system capacity utilization is improved, but user experience and operational consistency deteriorate
Solution Approach 1:
The patent applies local quality by making database assignment dependent on the specific user profile characteristics. Each user profile is associated with a specific database, creating a localized access path. The CDN provider examines user profile information and routes each user to their designated database, ensuring consistent experience for users within the same profile while allowing different profiles to access different databases for load distribution.
3Productivity
If load balancing is implemented across multiple databases, then system throughput is improved, but complexity of database assignment and user routing deteriorates
Solution Approach 1:
The patent implements preliminary action by pre-establishing associations between user profiles and specific databases. The CDN provider maintains a mapping or routing table that links user profile identifiers to their designated databases. When a user request arrives, the CDN provider performs a simple lookup in this pre-computed mapping rather than performing complex real-time load balancing calculations, thereby reducing assignment complexity while maintaining throughput.
Data Source
AI summary
Systems, methods, and computer-readable and executable instructions are provided for providing a device agnostic active/active data center. Providing a device agnostic active/active data center can include receiving user communication assigned from a content delivery network (CDN) provider. In addition, providing a device agnostic active/active data center can include determining a designated database for the user communication. Furthermore, providing a device agnostic active/active data center can include assigning a destination address to the designated database for the user communication.