GUIDED DATA EXPLORATION

• US 20160085851A1
• Filed: 04/03/2015
• Published: 03/24/2016
• Est. Priority Date: 09/24/2014
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: ZELEVINSKY, Vladimir, SHEFFER, Uri, POCOCK, Adam Craig, STEVENS, Brook, ISHAQUE, Mashhood, SPAULDING, Tristan R.
• Granted Patent: US 10,387,494 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data
• CPC Class Codes: G06F 16/3331 Query processing
• CPC Class Codes: G06F 16/901 Indexing; Data structures therefor; Storage structures for retrieval from the web G06F16/951
• CPC Class Codes: G06F 16/904 Browsing; Visualisation therefor for navigating the web G06F16/954; browsing optimisation for the web G06F16/957

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.

Claims

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.

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

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.