Database Server Message Pipe for Remote Storage Access
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Distributed database systems face inefficiencies in data transfer due to disparate methods for accessing local and remote data, leading to programmatic complexity and limitations in direct communication between storage subsystems across geographically diverse locations.
Innovation Solution
An efficient network data transfer service is provided using a message pipe between database servers, allowing remote access to locally attached storage subsystems through a set of access primitives, enabling data block-level access and unified I/O models, independent of external kernel processes or operating system dependencies.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If file transfer protocols are used to provide logical access to remote data, then data accessibility is improved, but transfer efficiency deteriorates
Solution Approach 1:
The patent introduces a storage subsystem interface as an intermediary component that enables direct communication between the remote database server and the local storage subsystem. This interface acts as a mediator that translates remote access requests into local storage operations, allowing efficient direct access without requiring file transfer protocols. The interface includes a communication interface coupled to the message pipe and a storage interface coupled to the storage subsystem, creating a direct pathway that bypasses inefficient file transfer mechanisms.
2Adaptability or versatility
If disparate methods are used to access local and remote data, then system autonomy is maintained, but programmatic complexity increases
Solution Approach 1:
The patent implements a universal message pipe interface that can handle both local and remote data access through a single, unified protocol. The communication interface is designed to receive messages from remote database servers and translate them into local storage operations, providing a universal access method that works for both local and remote scenarios. This eliminates the need for disparate access methods while maintaining system autonomy, as each database server can independently use the same interface protocol.
3Speed
If direct links are established between storage subsystems across geographically diverse locations, then data access efficiency is improved, but network infrastructure requirements increase
Solution Approach 1:
The patent uses a message pipe as an intermediary communication channel that abstracts the underlying network infrastructure complexity. The message pipe provides a standardized interface for communication between database servers across geographically diverse locations, handling protocol translation and data formatting. This allows efficient direct access to storage subsystems while shielding users from the complexity of long-distance network communication requirements.
Data Source
AI summary
An approach for providing efficient network data transfer service is provided. In one embodiment, a first database server receives, from a second database server, a first request to access a first storage subsystem. Here, the second database server cannot access first data in the first storage subsystem without another database server transmitting the first data to the second database server. In response, the first database server provides the second database server a first set of access primitives. Using the first set of access primitives, the second database server may access data stored in the first storage subsystem that may be otherwise not accessible. As a result, the first database server receives, from the second database server, a first data access request to access first data stored in the first storage subsystem.