Visual Data Filtering Interface for No-Code Tabular Queries
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current systems for managing and displaying tabular data lack user-friendly interfaces for creating and applying custom filters, require computer coding knowledge for data querying, waste local storage with unnecessary data, and do not adequately alter data displays based on user input.
Innovation Solution
A custom filtering computer system that includes a custom filtering device, a database, and a user computer device, enabling customizable filtering and data management through a user-friendly interface, allowing users to specify filters, operations, and display elements without coding knowledge, and optimizing storage by reducing unnecessary data.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If SQL or spreadsheet formats are used for data management, then data querying and management capabilities are achieved, but user operation complexity increases and coding knowledge is required
Solution Approach 1:
The patent introduces a visual filter builder interface as an intermediary between the user and the database query system. This mediator translates user-friendly drag-and-drop filter operations into SQL queries automatically, eliminating the need for users to write code while maintaining full data querying capabilities.
Solution Approach 2:
The patent replaces the mechanical system of manual SQL coding and spreadsheet manipulation with an automated visual interface system. The filter builder automatically generates and executes queries, substituting manual coding operations with automated visual operations that are easier to perform.
2Speed
If all tabular data is stored locally for easy access, then data access speed improves, but local storage space is wasted on unnecessary data
Solution Approach 1:
The patent extracts only the necessary data from the database based on user-defined filter criteria. Instead of storing all tabular data locally, the system queries the database and retrieves only the filtered results that match user specifications, reducing local storage requirements while maintaining fast access to relevant data.
Solution Approach 2:
The patent performs preliminary filtering actions on the server side before data transmission. The filter builder pre-processes queries to identify and retrieve only the needed data records, preventing unnecessary data from being transferred and stored locally in the first place.
3Ease of operation
If data is displayed in standard tabular format, then data completeness is maintained, but user comprehension and interaction difficulty increases
Solution Approach 1:
The patent applies different display qualities to different parts of the data based on user needs. The system can highlight specific columns, apply conditional formatting, or transform data into visual representations like charts for certain data elements while maintaining the detailed tabular format for others, enhancing comprehension without losing data completeness.
Data Source
AI summary
Described herein is a custom filtering computer system for enabling custom filtering and management of tabular data that does not require any computer language or similar training for the user. The custom filtering computer system includes a processor configured to: receive filter criteria from a user computer device; retrieve filtered data by querying one or more databases based on the filter criteria; receive operations criteria from the user computer device; generate processed data, the processed data comprising the filtered data and operation outputs, by performing the operations defined in the operations criteria and storing the operation outputs with the filtered data; receive display criteria from a user computer device; generate a data display by applying the display criteria to the processed data, wherein the data display includes the processed data and the at least one display element; and display the data display.