Custom Data Filtering System for Tabular Data Management
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 querying databases, and do not effectively reduce storage capacity by eliminating unneeded data, nor do they allow for customizable data displays.
Innovation Solution
A custom filtering computer system that includes a processor configured to receive filter criteria from a user, retrieve and filter data from a database, perform operations on the filtered data, and apply display criteria to generate a user-friendly data display, all without requiring technical expertise or knowledge of computer programming.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If SQL or spreadsheet systems are used to manage tabular data, then data can be stored and accessed, but the systems require computer coding knowledge and are laborious to operate
Solution Approach 1:
The patent introduces an intermediary layer between the user and the database system. This intermediary translates natural language queries into SQL commands automatically, eliminating the need for users to learn SQL or complex spreadsheet operations. The system acts as a mediator that handles the complexity of data management behind the scenes while providing a simple interface to users.
2Productivity
If all tabular data is stored in databases, then complete data is available, but storage capacity is wasted on unneeded data and retrieval is inefficient
Solution Approach 1:
The patent applies preliminary action by pre-filtering and organizing data based on anticipated user needs and access patterns. The system proactively identifies and retrieves only the relevant subsets of data required for specific queries, rather than retrieving entire tables or databases. This preliminary organization of data enables faster retrieval while reducing unnecessary storage utilization.
3Ease of operation
If data is displayed in traditional formats, then all information is visible, but the display is difficult for users to comprehend and interact with
Solution Approach 1:
The patent segments large datasets into smaller, more manageable units for display. Instead of presenting entire tables or databases at once, the system divides data into relevant subsets based on user queries and preferences. This segmentation makes data more comprehensible and easier to interact with, while still providing access to the complete underlying dataset when needed.
Data Source
AI summary
Described herein is a custom filtering computer system for enabling custom filtering and management of tabular data 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, the filtered data including tabular data that matches 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 on an output module of the user computer device.