Error Parser Tree Structures for Invalid SQL Handling

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing SQL parsing technologies fail to effectively handle invalid SQL statements due to syntax errors, incompleteness, or outdated parsers, leading to parsing failures and disruptions in processing.

Innovation Solution

A method and system that utilize an error parser to generate tree structures for invalid SQL statements, identifying and processing them by determining the beginning and end of the statement, and applying grammar rules to tokenize keywords, allowing for the generation of error outputs and code complete hints, while skipping or notifying users of invalid statements to maintain processing continuity.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If a traditional parser is used to process SQL statements, then valid SQL statements can be parsed correctly, but invalid SQL statements cause parsing failures and disruptions

Engineering Contradiction:

Improveparsing reliabilityVSAvoidprocessing continuity

Core Design Contradiction:

ReliabilityVSProductivity

Solution Approach 1:

The system segments the batch of SQL statements into individual statements and processes them separately. When an invalid statement is detected, the error parser isolates it and generates an error output, allowing the main parser to continue processing subsequent statements without disruption, thus maintaining processing continuity while improving parsing reliability

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

An error parser is introduced as an intermediary component between the input SQL statements and the main parsing system. This error parser intercepts invalid SQL statements, analyzes them separately, and generates error outputs, preventing them from disrupting the main parsing workflow and enabling continuous processing of valid statements

Inventive Principle:

Principle #24Intermediary (Mediator)

2Productivity

If the parser processes every SQL statement in a batch, then complete processing is achieved, but invalid statements cause failures that disrupt the entire batch

Engineering Contradiction:

Improvebatch processing efficiencyVSAvoidparsing success rate

Core Design Contradiction:

ProductivityVSReliability

Solution Approach 1:

When the error parser identifies an invalid SQL statement, it skips detailed parsing of that statement and quickly generates an error output. This allows the system to rush through problematic statements without letting them block the processing of subsequent valid statements, thereby maintaining batch processing efficiency while improving overall parsing success rate

Inventive Principle:

Principle #21Skipping (Rushing through)

Solution Approach 2:

The system performs preliminary validation by checking each SQL statement before full parsing. The error parser conducts a quick initial assessment to identify invalid statements, allowing the main parser to skip detailed processing of problematic statements and focus resources on valid statements, thus improving both productivity and reliability

Inventive Principle:

Principle #10Preliminary action

Data Source

PatentUS11615081B2Systems and methods for addressing errors in SQL statements

Publication Date: 2023.03.28 EMBARCADERO TECHNOLOGIES INC

AI summary

A method includes determining that a parser fails to parse an invalid structured query language (SQL) statement. In response to determining that the parser fails to parse the invalid SQL statement, the method generates, by an error parser, an output corresponding to the invalid SQL statement. The output includes a plurality of data structures arranged in a tree structure. Each of the plurality of data structures corresponds to a portion of the invalid SQL statement.