Graph Database Query Script Generation via JSON Configuration
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Users without the ability to write query statements face difficulties in quickly querying graph analysis indicator information through graph databases, as they need to write various type-specific query statements.
Innovation Solution
A method and apparatus that acquire configuration information in JSON format, generate query paths and script files based on information nodes and their connections, and execute these scripts in a second database server to retrieve query results, eliminating the need for users to write query statements manually.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Measurement precision
If users write query statements manually to query graph analysis indicator information, then query accuracy and flexibility are improved, but user operation difficulty and time consumption increase
Solution Approach 1:
The patent introduces an intermediary system that includes a parser, query path generator, and script executor. This intermediary automatically converts user-friendly configuration information into executable query statements, eliminating the need for users to manually write complex query statements while maintaining query accuracy
Solution Approach 2:
The system performs self-service by automatically generating query paths and executing queries based on configuration information. The query path generation module autonomously creates execution plans, and the script executor automatically runs the queries, reducing manual user intervention to minimal configuration input
2Adaptability or versatility
If users write query statements to query graph analysis indicator information, then query flexibility is improved, but query time and system complexity increase
Solution Approach 1:
The system performs preliminary action by pre-generating query paths and storing them as executable scripts. When a query is needed, the system simply executes the pre-prepared script rather than generating and optimizing the query plan at runtime, significantly reducing query time while maintaining flexibility through configurable parameters
Solution Approach 2:
The query process is segmented into distinct modules: configuration parsing, query path generation, script creation, and execution. This segmentation allows each module to be optimized independently and enables parallel processing of multiple queries, improving overall system efficiency and reducing query time
Data Source
AI summary
Disclosed are a method of indicator information determination and an apparatus of indicator information determination. Firstly, configuration information in json format is obtained and a query path list is generated based on the configuration information. Secondly, a script file is generated according to a constraint condition of the information nodes corresponding to the query path and stored in a first database server. Then, according to a third identification information of the query request input by a terminal device, a target script file corresponding to a fourth identification information is searched in the first database server, then the target script file is executed in the second database server to obtain a query result.