Graphical Flowchart Interface for Database Query Construction
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing data extraction applications require users to create complex logical expressions using Boolean operations, which is difficult for non-technical users and prone to errors due to the need for understanding order of operations and manual overrides.
Innovation Solution
A software-based user interface that allows users to define complex logic rules graphically using a flowchart, where each step represents a logical expression connected by 'pass' and 'fail' connections, automatically converting the graphical flowchart into a database query statement, such as SQL, without requiring knowledge of Boolean operations or order of operations.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If users directly create logical expressions using Boolean operations, then data extraction functionality is achieved, but the complexity and difficulty of operation increase significantly for non-technical users
Solution Approach 1:
The patent segments the complex logical expression creation process into discrete, manageable steps represented as flowchart nodes. Each node handles a specific logical operation or data source, allowing users to build complex queries by connecting simple, intuitive steps rather than writing entire Boolean expressions at once. This segmentation reduces the cognitive load and complexity perceived by users.
Solution Approach 2:
The patent transitions from a one-dimensional linear text-based Boolean expression interface to a two-dimensional graphical flowchart interface. This dimensional change allows users to visualize the logical structure spatially, with nodes arranged in a hierarchical or sequential layout that naturally represents the flow of logic, making it easier to understand and construct complex queries without dealing with nested parentheses and operator precedence.
2Adaptability or versatility
If users manually override order of operations in Boolean expressions, then complex query logic can be achieved, but the potential for errors and difficulty increase
Solution Approach 1:
The patent pre-establishes the correct order of operations through the inherent structure of the flowchart itself. The graphical representation naturally enforces a top-to-bottom, left-to-right evaluation sequence, eliminating the need for users to manually manage operator precedence or add parentheses. The system automatically processes nodes in the correct sequence based on their positional arrangement, ensuring reliable logic execution without user intervention.
Solution Approach 2:
The flowchart structure acts as an intermediary between the user's intuitive logical thinking and the underlying Boolean expression execution. Instead of directly manipulating error-prone text-based expressions, users interact with visual nodes and connections that automatically translate into the correct logical operations and precedence, reducing errors while maintaining full logical flexibility.
3Adaptability or versatility
If data extraction applications require technical knowledge, then complex queries can be created, but accessibility and functionality are reduced for non-technical users
Solution Approach 1:
The patent enables non-technical users to independently create and execute complex data extraction queries through the intuitive flowchart interface, without requiring assistance from technical staff or data specialists. The system provides all necessary tools, templates, and guidance within the interface, allowing users to self-serve their data needs while maintaining full query capability equivalent to traditional methods.
Solution Approach 2:
The patent replaces the mechanical system of text-based Boolean expression writing with a graphical flowchart manipulation system. This substitution eliminates the need for users to learn and remember Boolean syntax, operator precedence rules, and expression formatting, while preserving the full power of logical query construction through visual node-based assembly.
4Measurement precision
If users write complete logical expressions, then precise data retrieval is achieved, but the development time and training requirements increase
Solution Approach 1:
The patent pre-configures common data sources, logical operators, and retrieval parameters as reusable flowchart nodes and templates. Users can quickly assemble precise queries by selecting and connecting pre-built components rather than constructing expressions from scratch, significantly reducing development time while maintaining retrieval precision through the systematic structure of the flowchart approach.
Data Source
AI summary
Methods and systems for providing a user interface for building a graphical flowchart that represents a database query. One method includes presenting a plurality of flowchart step types, wherein each of the flowchart step types is associated with a different logical expression format. The method also includes receiving a selection of one of the plurality of flowchart step types, presenting at least one expression option for the logical expression format of the selected flowchart step type, and receiving at least one input for the expression option. The method further includes generating a graphical flowchart step associated with a logical expression, wherein the logical expression is based on the at least one input and the logical expression format of the selected flowchart step type. The method also includes displaying the graphical flowchart step and automatically generating a database query corresponding to the logical expression associated with the displayed graphical flowchart step.