Interactive Graph Visualization Interface for Database Queries
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Organizations face challenges in effectively utilizing vast amounts of data due to its quantity, particularly when using visualization tools designed for relational database management systems with graph-based databases, which can be disadvantageous for managing and displaying data.
Innovation Solution
A graphical user interface (GUI) is developed with a graph panel and visualization panel that allows for interactive data visualization, including a model feature panel, result inspection panel, object detail panel, and filter panel, which generates and updates graph information based on user interactions and filters to execute queries and provide visualizations.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If visualization tools designed for relational database management systems are used with graph-based databases, then the existing tool compatibility is maintained, but the effectiveness and efficiency of data visualization deteriorates
Solution Approach 1:
The patent introduces a graph database management system as an intermediary layer between the relational database management system and the visualization tool. This mediator translates graph-based data models into formats compatible with relational visualization tools, enabling effective visualization without requiring complete tool redesign while maintaining compatibility with existing visualization infrastructure
2Quantity of substance
If vast amounts of data are collected and stored, then the data quantity available for analysis increases, but the difficulty of effectively utilizing and visualizing the data increases
Solution Approach 1:
The patent segments the data management system into distinct components: a graph database management system for efficient data storage and organization, and a separate visualization system for data presentation. This segmentation allows the system to handle vast amounts of data through specialized graph database structures while keeping the visualization complexity manageable through modular design
Solution Approach 2:
The graph database management system acts as an intermediary that manages the complexity of vast data quantities by providing standardized interfaces and translation mechanisms, allowing the visualization layer to work with simplified data representations without directly handling the raw complexity of large-scale graph data
3Ease of operation
If real-time updates and interactions are enabled in the visualization interface, then the user interactivity and information freshness improve, but the system complexity and processing requirements increase
Solution Approach 1:
The patent implements feedback mechanisms where the visualization interface continuously receives updates from the graph database management system based on user interactions. This feedback loop enables real-time updates without requiring the entire system to be redesigned, as the intermediary layer handles the complexity of real-time data processing and translation
Data Source
AI summary
Embodiments are directed to a display engine that provides a graphical user interface (GUI) that includes a graph panel and a visualization panel may be generated. The graph panel may receive graph related inputs or interactions. Graph information based on the graph related inputs or interactions and a data source may be generated. A graph model based on the graph information and the data source may be generated. Elements that correspond to objects in the graph model or relationships in the graph model may be displayed in the graph panel. The graph information and the graph model may be employed to execute a query that provides a data model based on results of the query. The data model may be employed to provide a visualization that is displayed in the display panel.