Browse Prior Art Database

Smart and Flexible User-Driven Data Exploration

IP.com Disclosure Number: IPCOM000238482D
Publication Date: 2014-Aug-28
Document File: 5 page(s) / 901K

Publishing Venue

The IP.com Prior Art Database

Abstract

Disclosed is an efficient and flexible method, that does not require any prior data modeling, for business users to navigate data.

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

Page 01 of 5

Smart and Flexible User-Driven Data Exploration

Business users need to explore data in many different ways, without the intervention of information technology (IT)/modelers. In addition, some of the paths users need cannot be predicted ahead of time .

Solutions exist to help solve this problem, but require that the navigation paths are defined ahead of time (e.g., model a hierarchy) and are selected prior to use (e.g., create a view that uses a specific hierarchy).

This novel contribution is a method for navigating data that is efficient and flexible , and does not require any prior data modeling. The method surfaces the most likely options based on data relationships along with what the system learned from previous users' actions. It allows users to navigate across all columns in context. Figure 1 shows the data that is used as an example throughout this disclosure.

Figure 1: Example of data

Following are the components and process used to implement the method in a preferred embodiment :


1. Detect relationships in the data. When data becomes available, the system inspects it to detect inherent relationships.

A. The system inspects the data, and based on the cardinalities of values, (e.g., ON, QC and BC relate to Canada) it identifies hierarchies
i. level-based
ii.parent-child

1


Page 02 of 5

With the data in Figure 1, the system recognizes the following hierarchies:

Region > Prov/State > City and names it 'Region - City'

Country > Prov/State > City and names it 'Country - City'

Year (Sold) > Month (Sold) > Day (Sold) and names it 'Time (Sold)'
Year (Ship) > Month (Ship) > Day (Ship) and names it 'Time (Ship)'

...