US 2010/0077326 A1Published application

Layout aware calculations

AssigneeOracle International Corporation

InventorsHenry Verschell, Raghuram Venkatasubramanian, Steve Cave, Martin Roth

Life of this patent

Estimating the term…

Loading patent…

Abstract

A method for analyzing data from a database using an analytic database function includes receiving a selection of measured items from a user, receiving a placement item from the user, and determining a partitioning of the selection of measured items from the placement item. A placement item can be a column, a row, or an axis. A template associated with the analytic database function is adapted to define at least one partitioning relative to the placement item. The template is further adapted to define an ordering parameter for the analytic database function and optionally an aggregation level for the analytic database function. A database query is created with the partitioning. The database query can be an SQL statement.

Claims31

Dependent claims

A computer-implemented method for analyzing data using analytic database functions, the method comprising:

displaying a layout having a plurality of cells on a display device using a graphical user interface configured to enable users to manipulate arrangement of the plurality of cells within the graphical user interface, the layout specifying relationships between each cell in the plurality of cells and data in a database;
receiving first user input at a computer system, the first user input indicative of a selection made by a user on the layout via the graphical user interface of one or more measured items in cells associated with the layout;
receiving second user input at the computer system, the second user input indicative of a selection made by a user on the layout via the graphical user interface of a placement item in a cell associated with the layout;
determining with the computer system a partitioning associated with an analytic database function of the one or more measured items selected by the user on the layout based on the placement item selected by the user on the layout;
formatting with the computer system the analytic database function associated with a cell in the plurality of cells of the layout displayed on the display device based on the determined partitioning of the one or more measured items, the analytic database function formatted by the computer system to include the determined partitioning of the one or more measured items, one or more functions to be performed on the one or more measured items, and location of the cell within the layout to contain a resulting item for the one or more functions;
and
displaying the resulting item in the cell of the layout displayed on the display device.

4 more elements

A system for analyzing data, the system comprising:

a processor;
and
a memory coupled to the processor, the memory configured to store a set of instructions which when executed by the processor cause the processor to:
display a layout having a plurality of cells on a display device using a graphical user interface configured to enable users to manipulate arrangement of the plurality of cells within the graphical user interface, the layout specifying relationships between each cell in the plurality of cells and data in a database;
receive input indicative of a selection made by a user on the displayed layout via the graphical user interface of a set of measured items in cells associated with the layout;
receive input indicative of a selection made by a user on the displayed layout via the graphical user interface of a placement item in a cell associated with the layout;
determine a partitioning associated with an analytic database function of the set of measured items selected by the user on the layout based on the placement item selected by the user on the layout;
format the analytic database function associated with a cell in the plurality of cells of the layout based on the determined partitioning of the set of measured items, the analytic database function formatted by the processor to include the determined partitioning of the one or more measured items, one or more functions to be performed on the one or more measured items, and location of the cell within the layout to contain a resulting item for the one or more functions;
and
modify the display of the layout on the display device using the graphical user interface with the resulting item.

7 more elements

An information storage medium configured to store a plurality of instructions which when executed by a processor direct an information processing device to perform the steps of:

displaying a layout having a plurality of cells on a display device using a graphical user interface configured to enable users to manipulate arrangement of the plurality of cells within the graphical user interface, the layout specifying relationships between each cell in the plurality of cells and data in a database;
receiving a selection made by a user on the layout via the graphical user interface of one or more measured items in cells associated with the layout;
receiving a selection made by the user on the layout via the graphical user interface of a placement item in a cell associated with the layout;
determining a partitioning associated with an analytic database function of the one or more measured items selected by the user on the layout from the placement item selected by the user on the layout;
format the analytic database function associated with a cell in the plurality of cells of the layout based on the determined partitioning of the one or more measured items, the analytic database function formatted to include the determined partitioning of the one or more measured items, one or more functions to be performed on the one or more measured items, and location of the cell within the layout to contain a resulting item for the one or more functions;
and
display the resulting item in the cell of the layout displayed on the display device.

4 more elements

Dependencies are inferred from the claim text.

Facts

Application: 12/557,664Filed 11 Sep 2009
Priority: 11 Aug 2003
Published: 25 Mar 2010
Term ends: Not estimatedThe source records don’t support an estimate.

Classification8 codes

G06F 16/2455
Query processing: query execution
G06F 16/2453
Query processing: query optimisation
G06F 16/283
Databases characterised by their database models, e.g. relational or object models: multi-dimensional databases or data warehouses, e.g. MOLAP or…
G06F 16/9574
Browsing optimisation, e.g. caching or content distillation: of access to content, e.g. by caching

Family

Application10/639,291Continuation in part · filed 11 Aug 2003
Application10/641,393Continuation · filed 13 Aug 2003
Application12/557,664Continuation
Application10/641,393Continuation in part
US 2005/0038630 A1Published application
US 2005/0038767 A1Published application
US 7,590,613 B2Related patent
US 7,877,348 B2Related patent
US 2010/0077326 A1This patent

From the US filing history. Foreign family members aren’t listed.