Query Expression Validation via Entity Verification
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current computer applications that allow users to create and edit query expressions for database processing often perform only rudimentary syntactical validation, failing to detect invalid entity identifiers or access permissions, leading to potential errors or data breaches.
Innovation Solution
A method and system for validating query expression updates by determining syntactical validity and checking for entity identifiers, using a bidirectional communication channel to transmit updates to an application server, which verifies the existence of entities in a database and provides feedback to the user interface, preventing invalid expressions from being saved.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If only rudimentary syntactical validation is performed on query expressions, then the validation process is simple and fast, but invalid entity identifiers or access permissions are not detected, leading to potential errors or data breaches
Solution Approach 1:
The system performs preliminary validation actions by checking entity identifiers and access permissions against the database schema before the query expression is executed. This advance verification ensures that only valid expressions with proper access rights are allowed to proceed, preventing errors and data breaches while maintaining a manageable validation process through structured pre-checks
2Reliability
If comprehensive validation including entity identifier verification is performed, then validation accuracy improves, but the validation process becomes more complex and time-consuming
Solution Approach 1:
The system performs preliminary checks of entity identifiers and access permissions against the database schema before query execution. By verifying the validity of entity identifiers and checking access permissions in advance, the system ensures comprehensive validation without requiring extensive processing time during actual query execution, thus reducing the perceived validation time while maintaining high reliability
Solution Approach 2:
The system replaces manual or mechanical validation processes with automated computer-based verification against the database schema. This substitution allows for rapid, comprehensive validation of entity identifiers and access permissions without requiring human intervention or time-consuming manual checks, thereby reducing validation time while maintaining high accuracy
3Measurement precision
If entity identifiers are verified against the database, then detection precision of invalid entities improves, but the system complexity increases
Solution Approach 1:
The system introduces an intermediary validation layer that acts as a mediator between the query expression and the database execution. This intermediary component automatically verifies entity identifiers and access permissions against the database schema, providing high detection precision for invalid entities while keeping the overall system complexity manageable through modular, automated verification processes
Data Source
AI summary
Technologies are provided for validating expression updates. A change to an editable expression can be detected by a client computing device and an expression update describing the detected change can be transmitted to an application server over a bidirectional communication channel. The application server can analyze the expression update to determine whether the detected change resulted in a valid expression. Analyzing the expression update can comprise locating an entity identifier in the detected change and searching a database to determine whether the identified entity exists. The application server can also determine whether a given user has permission to access the identified entity. The application server can transmit expression update validation information back to the client computing device over the bidirectional communication channel. The client computing device can update a user interface displaying the expression based on the validation information.