US6748394B2
Expired / Lapsed
US
⏱️ 0.0 years remaining
Graphical user interface for relational database
Assignee: Oracle International Corp
•
Filing: 2001-04-27
•
Granted: 2004-06-08
•
Expires: 2021-04-27
Abstract
Abstract Disclosed is a system, method, and apparatus for calculating metrics by using hierarchical level metadata to describe the various structures within the database. The hierarchical level metadata permit calculation of complex metrics by an analytical server which would otherwise be difficult or impossible. As a result of the way that the analytical server calculates the metrics, slicing and drilling are supported. Additionally, dimension and fact level security are also supported.
Inventors
- 👤 Arun Shah
- 👤 Robert F. Novy
- 👤 Robert A. Ertl
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-24 20:20
CPC Classifications
G; G06; G06F; G06F21/00; G06F21/60; G06F21/62; G06F21/6218; G06F21/6227; G06F16/00; G06F16/20; G06F16/24; G06F16/242; G06F16/2428; G06F16/28; G06F16/283; Y; Y10; Y10S; Y10S707/00; Y10S707/953; Y10S707/956; Y10S707/99941; Y10S707/99943; Y10S707/99944; Y10S707/99945
Claims Analysis
Total Claims: 21
Claim 1
Independent Claim
74 words
A graphical user interface for displaying metrics, said graphical user interface comprising: a hierarchical listing of a plurality of dimensions for selection of one or more constraints for the plurality of dimensions; and a metric selector for selection of a metric; wherein after the selection of the one or more constraints and the metric, the graphical user interface submits a query requesting calculations of the metric based on the one or more selected constraints.
Claim 2
Dependent Claim
74 words
A graphical user interface for displaying metrics, said graphical user interface comprising: a hierarchical listing of a plurality of dimensions for selection of one or more constraints for the plurality of dimensions; and a metric selector for selection of a metric; wherein after the selection of the one or more constraints and the metric, the graphical user interface submits a query requesting calculations of the metric based on the one or more selected constraints.
Claim 3
Dependent Claim
20 words
The graphical user interface of claim 1 , further comprising a results page for graphically displaying calculations of the metric.
Claim 4
Dependent Claim
31 words
The graphical user interface of claim 2 , wherein the results page further comprises a plurality of columns, wherein each of the plurality of columns is associated with a particular metric.
Claim 5
Dependent Claim
44 words
The graphical user interface of claim 3 , wherein the results page further comprises a plurality of rows, wherein each of the plurality of rows is associated with values associated with one or more slices of one or more of the plurality of dimensions.
Claim 6
Dependent Claim
35 words
The graphical user interface of claim 4 , wherein each of the plurality of columns comprises a graph displaying the calculated metric for the one or more constraint and a corresponding one of the values.
Claim 7
Dependent Claim
39 words
The graphical user interface of claim 5 , wherein the results page further comprises one or more graphic bars corresponding to one or more metrics, a height of the one or more graphic bars corresponding to the calculated metrics.
Claim 8
Dependent Claim
25 words
The graphical user interface of claim 6 , wherein the metrics are selected from the group consisting of profits, costs, sales made, and sales forecast.
Claim 9
Dependent Claim
17 words
The graphical user interface of claim 1 and further comprising a user-selectable button for transmitting the query.
Claim 10
Dependent Claim
24 words
The graphical user interface of claim 1 and further comprising at least a second metric selector for selection of at least a second metric.
Claim 11
Dependent Claim
90 words
A computer system for providing metrics, said computer system comprising: an application programming interface for generating a graphical user interface for displaying metrics, said graphical user interface comprising: a hierarchical listing of a plurality of dimensions for selection of one or more constraints for the plurality of dimensions; and a metric selector for selection of a metric; wherein after the selection of the one or more constraints and the metric, the graphical user interface submits a query requesting calculations of the metric based on the one or more selected constraints.
Claim 12
Dependent Claim
90 words
A computer system for providing metrics, said computer system comprising: an application programming interface for generating a graphical user interface for displaying metrics, said graphical user interface comprising: a hierarchical listing of a plurality of dimensions for selection of one or more constraints for the plurality of dimensions; and a metric selector for selection of a metric; wherein after the selection of the one or more constraints and the metric, the graphical user interface submits a query requesting calculations of the metric based on the one or more selected constraints.
Claim 13
Dependent Claim
18 words
The computer system of claim 10 , further comprising a client computer for displaying the graphical user interface.
Claim 14
Dependent Claim
16 words
The computer system of claim 10 , further comprising an analytical server for calculating the metric.
Claim 15
Dependent Claim
17 words
The computer system of claim 10 , and further comprising a user-selectable button for transmitting the query.
Claim 16
Dependent Claim
24 words
The computer system of claim 10 , and further comprising at least a second metric selector for selection of at least a second metric.
Claim 17
Dependent Claim
22 words
The computer system of claims wherein the graphical user interface further comprises a results page for graphically displaying calculations of the metric.
Claim 18
Dependent Claim
43 words
The computer system of claim 15 , wherein the results page further comprises a plurality of rows, wherein each of the plurality of rows is associated with values associated with one or more slices of one or more of the plurality of dimensions.
Claim 19
Dependent Claim
50 words
The computer system of claim 16 , wherein the graphical user interface further comprises a plurality of columns associated with one or more metrics, each of the plurality of columns comprising a graph displaying the calculated metric for the one or more constraints and a corresponding one of the values.
Claim 20
Dependent Claim
38 words
The computer system of claim 17 , wherein the results page further comprises one or more graphic bars corresponding to one or more metrics, a height of the one or more graphic bars corresponding to the calculated metrics.
Claim 21
Dependent Claim
24 words
The computer system of claim 18 , wherein the metrics are selected from the group consisting of profits, costs, sales made, and sales forecast.
References Cited (Backward Citations)
US5864857A
Cited
US6032144A
Cited
US5884299A
Cited
US5899992A
Cited
US6385201B1
Cited
US6205469B1
Cited
US5983227A
Cited
US5926818A
Cited
US6377993B1
Cited
US5991756A
Cited
US6078926A
Cited
US6480836B1
Cited
US6199063B1
Cited
US6493699B2
Cited
WO1999057658A1
Cited
US6212524B1
Cited
US6161103A
Cited
US6327574B1
Cited
US6366922B1
Cited
WO2000020982A1
Cited
US6212515B1
Cited
US6163774A
Cited
US6282544B1
Cited
US6505205B1
Cited
US6446063B1
Cited
US6385604B1
Cited
US6542895B1
Cited
US6484179B1
Cited
US6556983B1
Cited
US20020029207A1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2007-06-08 | 2007-12-08 | 2008-06-08 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2011-06-08 | 2011-12-08 | 2012-06-08 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2015-06-08 | 2015-12-08 | 2016-06-08 | $7700.00 | Window Closed / Lapsed |