Linking graphical elements of data visualizations

• US 8,286,100 B2
• Filed: 07/05/2007
• Issued: 10/09/2012
• Est. Priority Date: 07/05/2007
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Helfman, Jonathan, Goldberg, Joseph
• Primary Examiner(s): Sax, Steven
• Application Number:
  US11/773,908
• Publication Number:
  US 20090013270A1
• Time in Patent Office: 1,923 Days
• Field of Search: 715764-765, 715771-773, 715/774, 715/962, 715/963, 715967-969, 715853-855, 715734-737
• US Class Current: 715/855
• CPC Class Codes: G06F 3/0481 based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance

Abstract

Systems and methods in accordance with various embodiments of the present invention provide for representing data values of a dataset as a plurality of graphical elements in a data visualization. A data table of the dataset may be linked with web-accessible information using a first content identifier. The first content identifier includes a first substring. The data visualization for the dataset is generated based on a first configuration. A selection of a graphical element of the plurality of graphical elements in the data visualization is received through a first user interface. The first substring is substituted with an identifier of the selected graphical element, generating a second content identifier. The requested web-accessible information based on the second content identifier is rendered.

Claims

1. A method for representing data values of a dataset as a plurality of graphical elements in a data visualization, the method comprising:

receiving, by a computer system, a selection of a generic content identifier for a data table of a dataset, the generic content identifier including a generic substring, the generic substring configured to be substituted with a unique string identifier, the unique string identifier identifying one or more data entries of the data table of the dataset;

associating, by the computer system, the data table of the dataset with web-accessible information related to the data table of the dataset using the generic content identifier;

generating, by the computer system, the data visualization for the dataset based on a first configuration;

receiving, by the computer system through a first user interface, a selection of a graphical element of the plurality of graphical elements in the data visualization, wherein the selected graphical element is a group element;

generating, by the computer system, a unique content identifier by substituting the generic substring in the generic content identifier with a unique string identifier of the selected graphical element;

linking, by the computer system, the selected graphical element with web-accessible information related to the selected graphical element using the unique content identifier; and

rendering, by the computer system, the web-accessible information related to the selected graphical element based on the unique content identifier substituting the generic substring with the unique string identifier of the selected graphical element such that the unique string identifier is comprised within the data table, wherein the data table represents a hierarchical depth level of a plurality of hierarchical depth levels, the data table including data entries of aggregate values of the hierarchical depth level.

2. The method of claim 1, further comprising:

after receiving the selection of the graphical element, providing a menu user interface to enable selection of an option to drill to the web-accessible information.

3. The method of claim 1, further comprising:

if the selected graphical element represents a leaf element, substituting the generic substring with the unique string identifier of the selected graphical element.

4. The method of claim 1, wherein the aggregate values are determined from at least one of a plurality of aggregate functions.

5. The method of claim 1, wherein the generic content identifier further comprises a second generic substring, the method further comprising:

substituting the second generic substring with a label of the selected graphical element to generate the unique content identifier.

6. The method of claim 1, further comprising:

before rendering, sending a request for the linked web-accessible information using the unique content identifier; and

receiving the requested web-accessible information.

7. The method of claim 1, wherein the generic content identifier is a first URL and the unique content identifier is a second URL.

8. The method of claim 1, wherein the unique content identifier is a parameter to an applet.

9. The method of claim 1, wherein each data table of the dataset is linked with web-accessible information using a URL.

18. The method of claim 1, wherein the unique string identifier is an index for a data entry in the data table of the dataset.

10. A non-transitory computer-readable medium having stored thereon program code for representing data values of a dataset as a plurality of graphical elements in a data visualization, the program code comprising:

code for receiving a selection of a generic content identifier for a data table of a dataset, the generic content identifier including a generic substring, the generic substring configured to be substituted with a unique string identifier, the unique string identifier identifying one or more data entries of the data table of the dataset;

code for associating the data table of the dataset with web-accessible information related to the data table of the dataset using the generic content identifier;

code for generating the data visualization for the dataset based on a generic configuration;

code for receiving through a first user interface, a selection of a graphical element of the plurality of graphical elements in the data visualization, wherein the selected graphical element is a group element;

code for generating a unique content identifier by substituting the generic substring in the generic content identifier with a unique string identifier of the selected graphical element;

code for linking the selected graphical element with web-accessible information related to the selected graphical element using the unique content identifier; and

code for rendering the web-accessible information related to the selected graphical element based on the unique content identifier code for substituting the generic substring with the unique string identifier of the selected graphical element such that the unique string identifier is comprised within the data table, wherein the data table represents a hierarchical depth level of a plurality of hierarchical depth levels, the data table including data entries of aggregate values of the hierarchical depth level.

11. The non-transitory computer-readable medium according to claim 10, further comprising:

after receiving the selection of the graphical element, code for providing a menu user interface to enable selection of an option to drill to the web-accessible information.

12. The non-transitory computer-readable medium according to claim 10, further comprising:

if the selected graphical element is a leaf element, code for substituting the generic substring with the unique string identifier of the selected graphical element.

13. The non-transitory computer-readable medium according to claim 10, wherein the aggregate values are determined from at least one of a plurality of aggregate functions.

14. A system for representing data values of a dataset as a plurality of graphical elements in a data visualization, the system comprising:

a processor; and

a memory coupled to the processor, the memory configured to store a plurality of code modules which when executed by the processor cause the processor to;

receive a selection of a generic content identifier for a data table of a dataset, the generic content identifier including a generic substring, the generic substring configured to be substituted with a unique string identifier, the unique string identifier identifying one or more data entries of the data table of the dataset;

associate the data table of the dataset with web-accessible information related to the data table of the dataset using the generic content identifier;

generate the data visualization for the dataset based on a first configuration;

receive through a first user interface, a selection of a graphical element of the plurality of graphical elements in the data visualization, wherein the selected graphical element is a group element;

generate a unique content identifier by substituting the generic substring in the generic content identifier with a unique string identifier of the selected graphical element;

link the selected graphical element with web-accessible information related to the selected graphical element using the unique content identifier; and

render the web-accessible information related to the selected graphical element based on the unique content identifier substituting the generic substring with the unique string identifier of the selected graphical element such that the unique string identifier is comprised within the data table, wherein the data table represents a hierarchical depth level of a plurality of hierarchical depth levels, the data table including data entries of aggregate values of the hierarchical depth level.

15. The system of claim 14, further comprising additional code modules which when executed by the processor cause the processor to:

after receiving the selection of the graphical element, provide a menu user interface to enable selection of an option to drill to the web-accessible information.

16. The system of claim 14, further comprising additional code modules which when executed by the processor cause the processor to:

if the selected graphical element is a leaf element, substitute the generic substring with the unique string identifier of the selected graphical element.

17. The system of claim 14, wherein the aggregate values are determined from at least one of a plurality of aggregate functions.