Graph Database Query Interface for Intuitive User Interaction

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Graph databases present a challenge for traditional search interfaces due to their complex structure, making it difficult for users to form effective search queries without understanding the underlying database structure.

Innovation Solution

A method and computing device that provide a user-friendly interface for generating search queries in graph databases by exposing vertex properties and edge relationships, allowing users to select and filter properties, forming queries based on user inputs, and displaying report previews, enabling intuitive query formation without requiring knowledge of the database structure.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If a traditional search interface is used for graph databases, then the interface structure is simple and familiar to users, but users cannot effectively form search queries without understanding the complex underlying database structure

Engineering Contradiction:
Improveease of query formationVSAvoidloss of database structure understanding
Core Design Contradiction:
Ease of operationVSLoss of information

Solution Approach 1:

The patent introduces an intermediary layer between the user and the graph database structure. This intermediary automatically generates and manages the complex query formation logic, allowing users to perform searches without needing to understand the underlying database structure. The system mediates between simple user input and the complex graph database query requirements.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Reliability

If the underlying database structure is exposed to users, then users can understand and form effective queries, but the interface complexity increases significantly

Engineering Contradiction:
Improvequery effectivenessVSAvoidinterface complexity
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The patent extracts the complex database structure understanding requirement from the user interface. By separating the query formation logic from the user interaction layer, the system allows users to perform effective searches without being exposed to or needing to understand the complex underlying graph database structure.

Inventive Principle:
Principle #2Taking out (Extraction)

3Ease of operation

If a simplified interface is provided for graph database searches, then ease of use is improved, but the ability to perform complex queries is reduced

Engineering Contradiction:
Improveuser friendlinessVSAvoidquery capability
Core Design Contradiction:
Ease of operationVSAdaptability or versatility

Solution Approach 1:

The system provides self-service functionality by automatically generating and optimizing queries based on user input. The interface handles the complexity of graph database query formation autonomously, allowing users to perform both simple and complex queries through a unified simplified interface without needing to manually construct complex query syntax.

Inventive Principle:
Principle #25Self-service

Data Source

PatentUS11586617B2Method and computing device for generating a search query for a graph database
Publication Date: 2023.02.21 WORKIVA INC
  • US11586617B2 patent drawing
  • US11586617B2 patent drawing
  • US11586617B2 patent drawing

AI summary

In an embodiment, a method for generating a search query for a graph database includes displaying a list of vertex properties on a user interface; receiving, via the user interface, a selection of one or more of the displayed vertex properties; forming a graph database query based on selection; and displaying a report containing a result of the query.