Database visualization and searching

• US 20060190442A1
• Filed: 02/09/2006
• Published: 08/24/2006
• Est. Priority Date: 02/10/2005
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Limberger, Tobias
• Granted Patent: US 7,565,374 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/904 Browsing; Visualisation therefor for navigating the web G06F16/954; browsing optimisation for the web G06F16/957
• CPC Class Codes: G06F 16/907 Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

In providing visualization of entries of a database for browsing meta data types may be provided, and meta data of each type may be associated with each database entry. The meta data types may describe different properties of the respective database entries. Three meta data types may be selected and mapped to a different one of three axes spanning a three dimensional space. Database entries may be displayed in the three dimensional space at coordinates given by the respective meta data of the three selected meta data types, thereby grouping related database entries generally in proximity to each other and unrelated database entries generally spaced apart.

Claims

1. A method for providing visualization of entries of a database for browsing, comprising:

providing meta data types and associating meta data of each type with each database entry, the meta data types describing different properties of the respective database entries;

selecting three meta data types and mapping each of the selected meta data types onto a different one of three axes spanning a three dimensional space; and

displaying database entries in the three dimensional space at coordinates given by the respective meta data of the three selected meta data types, thereby grouping related database entries generally in proximity to each other and unrelated database entries generally spaced apart, the related database entries each forming at least one entity of database entries that is displayed as a graphical entity within the three dimensional space.

2. The method of claim 1, wherein displaying database entries in the three dimensional space comprises displaying the database entries in the three dimensional space by a scatter plot at coordinates given by the respective meta data of the three selected meta data types.

3. The method of claim 2, wherein the graphical entity displayed within the three dimensional space includes a scatter plot grouping.

4. The method of claim 1, wherein the database entries are graphically marked by one or more of a color, shape or interconnecting lines.

5. The method claim 1, wherein database entries adjacent in time are interconnected by lines to form a time-ordered interconnected string of database entries.

6. The method claim 1, wherein a fourth meta data type is selected and the database entries are graphically represented in the three dimensional space with a graphical property that varies as a function of the respective meta data of the fourth meta data type, the graphical property including one or more of a color, shape, size, or transparency.

7. The method of claim 1, comprising:

monitoring a browsing of the database entries; and

deleting database entries that are infrequently browsed.

8. The method of claim 1, wherein the meta data type includes one or more of time, place, topic or confidentiality.

9. A computer program product comprising a processor and a storage medium, the storage medium storing a computer code that upon execution on the processor causes the processor to:

select three types of meta data, each type describing a different property associated with a plurality of database entries, where the database entries are stored within a database in association with meta data of different types;

display the database entries in a three dimensional space at coordinates corresponding to meta data of the three selected meta data types, thereby grouping related database entries generally in proximity to each other and unrelated database entries generally spaced apart, the related database entries each forming at least one entity of database entries that is displayed as a graphical entity within the three dimensional space; and

receive a selection of a further database entry from within a selected graphical entity.

10. The computer program product of claim 9, wherein the execution of the computer code causes the processor to:

provide the related database entries within the graphical entity with based on one or more of a distance or direction within the three dimensional space; and

receive the selection of the further database entry based on the provided distance or direction.

11. The computer program product of claim 9, wherein database entries associated to the selected graphical entity are displayed as a time-ordered line-interconnected string.

12. The computer program product of claim 9, wherein the execution of the computer code causes the processor to:

provide the related database entries within the graphical entity; and

receive the selection of the further database entry based on its position in a string of the graphical entity.

13. A system comprising:

a browsable database with database entries and meta data types, wherein meta data of each type is associated with each database entry, the meta data types describing different properties of the respective database entries;

selection logic operable to select three meta data types and further operable to map each of the selected meta data types onto a different one of three axes spanning a three dimensional space; and

display logic operable to display database entries in the three dimensional space at coordinates given by the respective meta data of the three selected meta data types, thereby grouping related database entries generally in proximity to each other and unrelated database entries generally spaced apart, the related database entries each forming at least one entity of database entries that is displayed as a graphical entity within the three dimensional space.

14. The system of claim 13, wherein the database entries are displayed in the three dimensional space by a scatter plot at coordinates given by the respective meta data of the three selected meta data types.

15. The system of claim 13, wherein the graphical entity has associated database entries graphically marked as being included in the graphical entity.

16. The system of claim 15, wherein the database entries are graphically marked using one or more of a color, shape, and/or interconnecting lines.

17. The system of claim 13, wherein the selection logic is operable to select a fourth meta data type and the display logic is operable to graphically represent at least one of the database entries in the three dimensional space with a graphical property that varies as a function of the at least one database entry'"'"'s respective meta data of the fourth meta data type.

18. The system of claim 17, wherein the graphical property includes one or more of a color, shape, size and/or transparency.

19. The system of claim 13, comprising monitor logic operable to:

monitor which database entries are browsed by a user;

assess the frequency of browsing; and

delete database entries that are browsed infrequently.

20. The system of claim 13, wherein the database is operable to provide the meta data type as including one or more of time, place, topic and confidentiality.