Tool for creating charts

• US 7,667,582 B1
• Filed: 10/14/2005
• Issued: 02/23/2010
• Est. Priority Date: 10/14/2004
• Status: Active Grant

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Sun Microsystems Incorporated (Oracle Corporation)
• Inventors: Waldorf, Jerry A.
• Primary Examiner(s): Amini; Javid A
• Application Number:
  US11/251,652
• Time in Patent Office: 1,593 Days
• Field of Search: 345/440, 345/581
• US Class Current: 340/440
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06T 11/206 Drawing of charts or graphs

Abstract

Techniques are described for defining, creating, and presenting a chart. When the chart is called, up-to-date information is used to create the chart. This allows the chart to reflect current key performance indicators for a business. A tool can also be provided for creating a chart definition, which is used to instantiate the chart. The tool provides graphical inputs for a user to select the inputs, operations and outputs into the chart. The tool enables users to create the chart definition with little or no programming.

Claims

1. A method of creating a dynamic chart definition, comprising:

receiving from a user a selection of a data definition, wherein the data definition includes one or more data sources with one or more data fields;

receiving from the user a selection of one or more operators wherein the user selects the one or more operators from a list of graphical representations of operators;

creating a dataset having one or more fields, wherein at least one of the fields of the dataset corresponds to a component of a chart;

receiving from the user input indicating a mapping between one or more of the data fields of the data definition and the one or more operators, and between the one or more operators and a particular field in the dataset, wherein the mapping specifies that the one or more operators perform one or more operations on information in the one or more data fields of the data definition to produce information for the particular field in the dataset, and wherein the mapping is specified graphically by the user using a graphical user interface (GUI) by placing the data definition, the dataset, and the one or more operators onto a canvas and graphically connecting the one or more data fields of the data definition and the one or more operators and graphically connecting the one or more operators and the particular field in the dataset,

wherein receiving from the user input indicating a mapping includes receiving user input forming one or more lines from the one or more data fields of the data definition to the one or more operators to the particular field in the dataset;

automatically translating the mapping into code that implements the mapping; and

storing the mapping, the code, the data definition, the operators and the dataset as a chart definition;

wherein the method is performed by a computer.

2. The method of claim 1, wherein receiving from the user a selection of one or more operators includes receiving from the user a selection of a GUI component, wherein the GUI component represents SQL code.

3. The method of claim 2, further comprising:

displaying a representation of the data definition, the one or more operators, the dataset and the mapping; and

displaying SQL code that corresponds to the mapping.

4. A computer program product for creating a dynamic chart definition, embodied on a machine-readable storage device, that includes executable instructions for causing a computer system to:

receive from a user a selection of a data definition, wherein the data definition includes one or more data sources with one or more data fields;

receive from the user a selection of one or more operators wherein the user selects the one or more operators from a list of graphical representations of operators;

creating a dataset having one or more fields, wherein at least one of the fields of the dataset corresponds to a component of a chart;

receive from the user input indicating a mapping between one or more of the data fields of the data definition and the one or more operators, and between the one or more operators and a particular field in the data set, wherein the mapping specifies that the one or more operators perform one or more operations on information in the one or more data fields of the data definition to produce information for the particular field in the dataset, and wherein the mapping is specified graphically by the user using a graphical user interface (GUI) by placing the data definition, the dataset, and the one or more operators onto a canvas and graphically connecting the one or more data fields of the data definition and the one or more operators

and graphically connecting the one or more operators and the particular field in the dataset,

wherein the instructions to cause a computer system to receive from the user input indicating a mapping include instructions to cause a computer system to receive user input forming one or more lines from the one or more data fields of the data definition to the one or more operators to the particular field in the dataset;

automatically translate the mapping into code that implements the mapping; and

store the mapping, the code, the data definition, the operators and the dataset as a chart definition.

5. The computer program product embodied on a machine-readable storage device of claim 4, wherein the instructions to receive from the user a selection of one or more operators include instructions to receive from the user a selection of a GUI component, wherein the GUI component represents SQL code.

6. The computer program product embodied on a machine-readable storage device of claim 5, further comprising instructions to cause a computer system to:

display a representation of the data definition, the one or more operators, the dataset and the mapping; and

display SQL code that corresponds to the mapping.