Storage System Query Generation for Direct Database Access
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional storage systems face inefficiencies in accessing target locations due to limitations in their architecture, leading to low query efficiency and poor user experience, particularly when handling GET class requests that require microservices for PostgreSQL and SQLite databases, resulting in excessive workload and limited query flexibility.
Innovation Solution
A method and device that allow direct access to storage systems by generating query statements based on query types, enabling direct database access without microservices, and supporting multiple database interfaces like PostgREST, JDBC, and Jooq, thereby enhancing query efficiency and flexibility.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If microservices are used for PostgreSQL and SQLite database access, then the storage system can handle GET class requests, but the workload becomes excessive and query efficiency decreases
Solution Approach 1:
The patent extracts the microservice layer from the database access path. Instead of routing all GET class requests through microservices, the system directly exposes database interfaces (PostgreSQL, SQLite, JDBC) for queries, removing the unnecessary intermediary layer and improving query efficiency while maintaining support for multiple database types
Solution Approach 2:
The patent introduces a new intermediary component - a query interface layer that sits between the client and database. This layer provides standardized query access to multiple database types without requiring full microservice architecture, thus maintaining versatility while improving efficiency by eliminating excessive workload processing
2Productivity
If direct database access is implemented, then query efficiency improves, but the system architecture becomes more complex
Solution Approach 1:
The patent implements a universal query interface that can access multiple database types (PostgreSQL, SQLite, JDBC) through a common protocol. This multi-functional interface simplifies the architecture by providing a single access point for diverse database systems, reducing the need for separate access mechanisms for each database type
3Adaptability or versatility
If multiple database interfaces are supported, then adaptability improves, but the device complexity increases
Solution Approach 1:
The patent segments the database interface support into modular components, where each database type (PostgreSQL, SQLite, JDBC) has its own dedicated interface implementation. This segmentation allows the system to support multiple interfaces independently, making it easier to manage, maintain, and scale without increasing overall system complexity
Data Source
AI summary
Techniques for querying a storage system involve receiving a query request for querying a resource in the storage system, determining a query type of the query request according to configuration information, generating a corresponding query statement according to the query type, and querying the resource from the storage system through the query statement. Accordingly, a query result can be obtained by generating a query statement (or referred to as “query expression”) corresponding to a query request to query the corresponding database directly, thereby improving the query efficiency in making queries to the storage system and enhancing the user experience. Such techniques can be easily integrated into any product having query needs (e.g. a storage system product), thus improving the product development efficiency and the ease of use and maintainability of the product.