Guided data exploration

Patent metadata

Field	Value
Publication number	US-2016085851-A1
Application number	US-201514678218-A
Country	US
Kind code	A1
Filing date	Apr 3, 2015
Priority date	Sep 24, 2014
Publication date	Mar 24, 2016
Grant date	—

Abstract

A system for exploring data receives the data from a database and indexes the data in a server. The system displays one or more selectable datasets from the indexed data, where the selected dataset includes one or more attributes. The system then sorts the one or more attributes by level of interestingness and displays the sorted attributes.

First claim

What is claimed is:

1 . A method of exploring data, the method comprising:
receiving the data from a database; indexing the data in a server; displaying one or more selectable datasets from the indexed data, each of the datasets comprising one or more attributes; sorting the one or more attributes by level of interestingness; and displaying the sorted attributes.

2 . The method of claim 1 , wherein at least some of the data in the database is unstructured data.

3 . The method of claim 1 , wherein the sorting comprises using entropy for the attributes.

4 . The method of claim 1 , wherein the displaying the sorted attributes comprises displaying a tile for each sorted attribute, the tile comprising a visualization of the attribute.

5 . The method of claim 1 , further comprising:
receiving a selection of a refinement from the display of sorted attributes and, in response: applying the selected refinement to the data; and re-sorting the one or more attributes of the refined data.

6 . The method of claim 1 , further comprising performing metadata discovery on the data received from the database.

7 . The method of claim 1 , further comprising receiving a selection of one or more of the selectable datasets.

8 . The method of claim 1 , wherein each of the attributes consists of a database column.

9 . A computer readable medium having instructions stored thereon that, when executed by a processor, cause the processor to provided guided data exploration, the providing comprising:
receiving the data from a database; indexing the data in a server; displaying one or more selectable datasets from the indexed data, each of the datasets comprising one or more attributes; sorting the one or more attributes by level of interestingness; and displaying the sorted attributes.

10 . The computer readable medium of claim 9 , wherein at least some of the data in the database is unstructured data.

11 . The computer readable medium of claim 9 , wherein the sorting comprises using entropy for the attributes.

12 . The computer readable medium of claim 9 , wherein the displaying the sorted attributes comprises displaying a tile for each sorted attribute, the tile comprising a visualization of the attribute.

13 . The computer readable medium of claim 9 , the providing further comprising receiving a selection of a refinement from the display of sorted attributes and, in response:
applying the selected refinement to the data; and re-sorting the one or more attributes of the refined data.

14 . The computer readable medium of claim 9 , the providing further comprising performing metadata discovery on the data received from the database.

15 . The computer readable medium of claim 9 , the providing further comprising receiving a selection of one or more of the selectable datasets.

16 . The computer readable medium of claim 9 , wherein each of the attributes consists of a database column.

17 . A guided data exploration system comprising:
an indexing module that receives data from a database and indexes the data in a server; a display module that displays one or more selectable datasets from the indexed data, wherein each selectable dataset comprises one or more attributes; and a sorting module that sorts the one or more attributes by level of interestingness; wherein the display module further displays the sorted attributes.

18 . The system of claim 17 , wherein the sorting comprises using entropy for the attributes.

19 . The system of claim 17 , wherein the sorting module further receives a selection of a refinement from the display of sorted attributes and, in response:
applies the selected refinement to the data; and re-sorts the one or more attributes of the refined data.

20 . The method of claim 1 , wherein the sorting module further receives a selection of one or more of the selectable datasets.

Assignees

• Oracle Int Corp

Inventors

• Sheffer Uri
• Pocock Adam Craig
• Stevens Brook
• Ishaque Mashhood
• Zelevinsky Vladimir
• Spaulding Tristan R

Classifications

• G06F16/248

  Presentation of query results · CPC title

• G06F16/3331

  Query processing · CPC title

• G06F16/904

  Browsing; Visualisation therefor (for navigating the web G06F16/954; browsing optimisation for the web G06F16/957) · CPC title

• G06F16/901 Primary

  Indexing; Data structures therefor; Storage structures (for retrieval from the web G06F16/951) · CPC title

• G06F16/26 Primary

  Visual data mining; Browsing structured data · CPC title