Browse Prior Art Database

System and Method for Filtering/Sorting Data as It is Dragged to the Query Template

IP.com Disclosure Number: IPCOM000245289D
Publication Date: 2016-Feb-26
Document File: 2 page(s) / 64K

Publishing Venue

The IP.com Prior Art Database

Abstract

Disclosed is a system and method to pre-filter/sort the desired data items in the initial query-building stage and offer the ability to further refine compressed data in order to reduce the impact on the performance and processing engine.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 52% of the total text.

Page 01 of 2

System and Method for Filtering/Sorting Data as It is Dragged to the Query Template

One of the most complex aspects of data analysis is to manage, filter, and sort data that in most cases requires advanced scripting and knowledge of the data model. The user is required to create the reports/queries and then apply the filter that changes the report format and layout. There is no solution to instantly apply common types of filtering or sorting to a query as the user builds it.

Building a query with millions of records and then applying a filter is requires a lot of time and resources of the query engine , especially if the user wants to cache the query. Then, filtering and sorting requires more resources from the computing and reporting engine to apply a cross-referenced filter/sort when data is in a list or a crosstab format.

The solution is a method to reduce the server stress and performance by pre -filtering/sorting the desired data in the initial stage and offering the ability to further refine compressed data in order to reduce the impact on the performance and processing engine .

Users are presented with a visual metadata tree to explore, insert/drag data items, and then drop items into the query template to generate the query. With the proposed method, as the user drags the data item toward the grid/template, the user hovers the data item over a filter/sort bar. This action automatically activates and inserts filtered/sorted data into the grid. The filter bar is part of the built-in default in the front-end query tool. It is located between the metadata tree and the grid/dashboard. The user can optionally choose not to pass through the bar and bypass it, even though it is enabled. When enabled, it is added to the default menu bar/right click option for further modification and updates.

To implement the system and method for filtering/sorting data as it is dragged to the query template, the user must have access to a metadata tree and a user interface (UI) to generate a query/report. As the user moves a data item from metadata tree, the feature is automatically present.

Specification...