Database Access Without File-System Translation Overhead
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In storage-compute separated database systems, the inefficiency of database accessing storage nodes is due to the need for converting database semantic operation requests into file system or block device semantic operation requests, increasing load and reducing communication efficiency.
Innovation Solution
The computing apparatus directly transmits database operation requests to the storage apparatus, which processes them without conversion, using a storage device that stores functions and addresses corresponding to these requests, reducing the need for file system or block device interaction.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If database operation requests are converted into file system or block device semantic operation requests, then compatibility between computing apparatus and storage apparatus is achieved, but access efficiency is reduced
Solution Approach 1:
The patent introduces a translation layer as an intermediary component between the computing apparatus and storage apparatus. This translation layer converts database semantic operations into storage-agnostic operations, allowing the storage apparatus to process requests directly without requiring conversion to file system or block device operations, thereby eliminating the efficiency penalty while maintaining compatibility
Solution Approach 2:
The storage apparatus is designed with universal functionality to handle both database semantic operations and storage operations directly. By implementing a unified interface that accepts database-level requests and translates them internally, the storage apparatus eliminates the need for separate conversion processes, achieving both compatibility and high performance
2Ease of operation
If conversion of database semantic operation requests into file system or block device semantic operation requests is performed, then storage node access is enabled, but processing load increases
Solution Approach 1:
The storage apparatus performs self-service by internally translating and processing database semantic operations without requiring the computing apparatus to perform conversions. The storage node autonomously handles the translation from database semantics to storage operations, eliminating the conversion load from the computing apparatus while maintaining ease of access
Solution Approach 2:
The translation function is performed preliminarily within the storage apparatus before actual data operations occur. By pre-translating database semantic operations into storage-agnostic operations internally, the system avoids the computational overhead of conversion at the computing apparatus level while enabling smooth storage node access
Data Source
AI summary
A data access method, a database system, and a storage apparatus are provided. A computing device includes a database operation request in a transmission command sent to a storage device. The database operation request is used to request to perform an operation on a data object in a database. After receiving the transmission command, the storage device parses the transmission command to obtain the database operation request, and then performs, on the data object in the operation request, the operation that is requested by the operation request, without conversion performed by a file system or a block device. Therefore, efficiency of the database system accessing data is improved.