Database Onboarding via Single-Connection Control Plane
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database management systems face inefficiencies in resource consumption, security, and tenant isolation, with multiple connections and disparate code sets leading to increased resource usage and potential data leakage.
Innovation Solution
A control plane architecture utilizing a single connection with each database server, a messaging cluster for secure communication, global tenant management for shared assets, and automated database registration to enhance efficiency and security.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If multiple connections are used between control plane and database servers, then communication flexibility is improved, but resource consumption increases
Solution Approach 1:
The patent merges multiple communication connections into a single connection between the control plane and each database server. The single connection incorporates multiple data streams (command stream, event stream, metric stream) that were previously handled by separate connections, thereby reducing resource consumption while maintaining communication flexibility through stream multiplexing.
2Adaptability or versatility
If disparate code sets are used for different tenants, then tenant customization is improved, but security and data isolation are worsened
Solution Approach 1:
The patent implements a universal code base that serves all tenants through multi-tenancy architecture. The system uses a single code set with configurable parameters and streams that can be customized per tenant, eliminating the need for disparate code sets while maintaining data isolation through stream-based segmentation and tenant-specific stream subscriptions.
3Manufacturing precision
If manual database registration is used, then registration accuracy is improved, but onboarding time increases
Solution Approach 1:
The patent implements automated database registration that performs preliminary actions to register databases without manual intervention. The system automatically discovers databases, registers them with the control plane, and configures appropriate streams and connections, thereby reducing onboarding time while maintaining registration accuracy through automated validation and configuration protocols.
4Reliability
If multiple separate connections are maintained for different database operations, then operation reliability is improved, but device complexity increases
Solution Approach 1:
The patent segments communication into distinct streams (command stream, event stream, metric stream) within a single connection. Each stream handles specific operations independently, maintaining operational reliability through stream isolation while reducing connection management complexity by consolidating multiple connections into one multiplexed connection.
Data Source
AI summary
A system may include a memory having computer-readable instructions stored thereon, and a processor of a control plane that executes the computer-readable instructions to receive from a database server, over a first connection, a request for credentials, in response to the request for credentials, generate credentials for the database server, transmit the credentials to the database server over a second connection specific to the database server, receive, over the second connection, from the database server, a request for registering the database server, the request for registering the database server comprising the credentials, in response to the request for registering the database server, register the database server with a database management system associated with the control plane.