Database Query Cancellation via Network Disconnection Detection
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database querying methods face challenges when dealing with large datasets spread across multiple tables, as they become complex and error-prone due to unclear relationships between tables, making it difficult to generate effective queries.
Innovation Solution
A method and system for querying databases using a model-based approach, where a starting node and selected leaves are used to generate database queries, allowing for aggregation and filtering of results, and enabling users to 'drill down' into detailed data sets, while also incorporating non-blocking socket technology to cancel queries if the network connection is lost.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Quantity of substance
If data is stored across multiple database tables, then data organization and storage efficiency are improved, but query complexity and error probability increase
Solution Approach 1:
The patent introduces an intermediary layer between the user and the database tables. This intermediary automatically generates and executes SQL queries based on user selections from dropdown menus, translating high-level user intentions into complex database operations without requiring users to understand table relationships or SQL syntax.
Solution Approach 2:
The patent segments the query generation process into distinct, manageable steps: selecting a starting table, choosing leaves (columns), and automatically generating the query. This segmentation breaks down the complex task of writing SQL queries into simple, guided choices that reduce errors and improve accessibility.
2Productivity
If complex queries are executed on large datasets, then data analysis capability is improved, but resource consumption and execution time increase
Solution Approach 1:
The patent performs preliminary actions by pre-defining the available tables and leaves in dropdown menus, and by automatically generating optimized SQL queries before execution. This preliminary preparation ensures that queries are efficiently constructed and executed, reducing unnecessary processing time.
Solution Approach 2:
The system provides feedback mechanisms through dropdown menus that show available tables and leaves, and through automatic query generation that adapts to user selections. This feedback loop helps users make informed choices and allows the system to optimize query construction based on actual data structures.
3Reliability
If network connection is lost during query execution, then system stability should be maintained, but resource wastage occurs without automatic cancellation
Solution Approach 1:
The patent implements a feedback mechanism that continuously monitors network connection status during query execution. When a connection loss is detected, the system receives feedback about the failed connection and automatically cancels the ongoing query, preventing further resource consumption.
Solution Approach 2:
The system prepares for potential network failures by implementing error handling and query cancellation mechanisms in advance. This beforehand cushioning ensures that when network issues occur, the system can gracefully handle the situation and stop resource-consuming operations without crashing or wasting excessive resources.
Data Source
AI summary
Systems and methods for cancelling a query are disclosed. A method includes establishing a connection over a network with a user computing device associated with a user, receiving, from the user computing device via the connection, a query request requesting query results from a database and, based on the query request, instructing, via the network, a server to begin executing a database query against the database. The method also includes determining that the connection is disconnected and, in response to determining that the connection is disconnected, instructing, via the network, the server to stop executing the database query.