Retrieval Sentence Visualization via Directed Graph
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Users with low syntax proficiency or inexperience struggle to create accurate retrieval sentences in SQL, as they find it difficult to recognize the meaning and temporal order of elements in retrieval sentences, leading to errors and inefficiencies in data retrieval.
Innovation Solution
A retrieval sentence utilization device and method that divides retrieval sentences into subtrees representing events and generates a directed graph, where nodes and edges represent the source and object of events, with subtrees placed according to their occurrence order, enabling users to visualize the temporal order and meaning of retrieval sentences.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If users create retrieval sentences using domain specific language syntax, then data retrieval functionality is achieved, but users with low syntax proficiency experience difficulty in creating accurate retrieval sentences and recognizing temporal order
Solution Approach 1:
The retrieval sentence is divided into multiple retrieval contents, each representing a distinct event with source, object, and temporal information. This segmentation allows users to understand and create retrieval sentences by focusing on individual events rather than complex overall syntax structures.
Solution Approach 2:
A directed graph is introduced as an intermediary visualization tool that represents retrieval contents and their temporal relationships. The graph serves as a mediator between the formal retrieval sentence syntax and user understanding, making temporal order and event relationships visually apparent without requiring syntax expertise.
2Loss of information
If retrieval sentences are displayed in traditional text format, then syntax information is preserved, but temporal order and causal relationships between elements are not visible
Solution Approach 1:
The retrieval sentence information is transformed from a one-dimensional text format to a two-dimensional directed graph structure. This dimensional change enables the visualization of temporal order and causal relationships through spatial arrangement and directional edges, making implicit temporal information explicitly visible.
Solution Approach 2:
The directed graph acts as an intermediary representation that preserves all syntax information from the original retrieval sentence while adding visual dimensionality. The graph structure mediates between the formal syntax and human perception, revealing temporal relationships without losing the underlying data structure.
3Reliability
If users manually correct errors in retrieval sentences, then accuracy can be improved, but significant time is required to identify and correct errors
Solution Approach 1:
The directed graph provides immediate visual feedback about the structure and temporal relationships of retrieval contents. Users can quickly identify errors by examining the graph structure, such as incorrect event sequences or missing connections, without having to manually parse and test the retrieval sentence syntax.
Solution Approach 2:
The directed graph serves as an intermediary checking mechanism that reveals structural errors in retrieval sentences before execution. By visualizing the parsed retrieval contents and their relationships, the graph enables users to identify and correct errors efficiently without time-consuming manual debugging.
Data Source
AI summary
To enable a user to easily recognize temporal order of elements included in a retrieval sentence, a retrieval sentence utilization device 10 includes: a retrieval sentence division unit 11 for dividing a retrieval sentence into a plurality of retrieval contents each of which includes an event; and a directed graph generation unit 12 for generating, from each of the retrieval contents, a subtree in which the event is an edge and a source of the event and an object of the event are nodes, and integrating a plurality of subtrees generated from the retrieval contents to generate a directed graph, wherein the directed graph generation unit 12 places the plurality of subtrees in the directed graph according to occurrence order of events corresponding to the plurality of subtrees.