US7149731B2
Expired / Lapsed
US
⏱️ 0.0 years remaining
Methods, systems and articles of manufacture for abstract query building with selectability of aggregation operations and grouping
Assignee: International Business Machines Corp
•
Filing: 2003-11-26
•
Granted: 2006-12-12
•
Expires: 2023-11-26
Abstract
Abstract Methods, systems and articles of manufacture for query building with selectability of summary information. A user interface exposes a plurality of query composition elements for building abstract queries is defined by a data abstraction model. The user interface allows a user to select and apply aggregation operations to result fields of a given abstract query, and further allows a user to define result groups for the given query. The user interface further allows a user to selectively specify whether the given query will be executed as an aggregation query (by applying the aggregation operations), in which case summary information is returned according to the specified result group(s).
Inventors
- 👤 Richard D. Dettinger
- 👤 Daniel P. Kolz
- 👤 Richard J. Stevens
- 👤 Jeffrey W. Tenner
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-24 20:18
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/242; G06F16/2433; G06F16/244; G06F16/245; G06F16/2455; G06F16/24553; G06F16/24554; G06F16/24556; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932; Y10S707/99933
Claims Analysis
Total Claims: 8
Claim 1
Independent Claim
231 words
A graphical user interface residing in memory, comprising: a) a query conditions screen for specifying logical fields and operators to define abstract queries, the abstract queries being defined by a data abstraction model comprising metadata mapping the logical fields to physical data; b) an aggregation screen area, comprising: a result field window displaying a plurality of result fields of a given abstract query, wherein the plurality of result fields are logical fields defined by the data abstraction model; and a plurality of graphical selection elements for each of a plurality of selectable aggregation operations applicable to the result fields; and c) a grouping screen area displaying the plurality of result fields and wherein each selection of one of the plurality of result fields defines a result group for the given query; d) a first selection element for specifying whether the given query comprising user selections made from aggregation screen area and the grouping screen area will be executed as an aggregation query or a non-aggregation query, wherein the aggregation query returns summary information comprising each result group and values calculated by applying selected ones of the plurality of selectable aggregation operations to selected ones of the plurality of result fields; and e) a second selection element for initiating execution of the given query as the aggregation query or the non-aggregation query according to the selection made through the first selection element.
Claim 2
Dependent Claim
231 words
A graphical user interface residing in memory, comprising: a) a query conditions screen for specifying logical fields and operators to define abstract queries, the abstract queries being defined by a data abstraction model comprising metadata mapping the logical fields to physical data; b) an aggregation screen area, comprising: a result field window displaying a plurality of result fields of a given abstract query, wherein the plurality of result fields are logical fields defined by the data abstraction model; and a plurality of graphical selection elements for each of a plurality of selectable aggregation operations applicable to the result fields; and c) a grouping screen area displaying the plurality of result fields and wherein each selection of one of the plurality of result fields defines a result group for the given query; d) a first selection element for specifying whether the given query comprising user selections made from aggregation screen area and the grouping screen area will be executed as an aggregation query or a non-aggregation query, wherein the aggregation query returns summary information comprising each result group and values calculated by applying selected ones of the plurality of selectable aggregation operations to selected ones of the plurality of result fields; and e) a second selection element for initiating execution of the given query as the aggregation query or the non-aggregation query according to the selection made through the first selection element.
Claim 3
Dependent Claim
16 words
The graphical user interface of claim 1 , wherein the first selection element is a checkbox.
Claim 4
Dependent Claim
51 words
The graphical user interface of claim 1 , wherein the aggregation screen area comprises a selection window for displaying a query element comprising a selected result field and a selected aggregation operation applied to the selected result field by selection of a graphical selection element corresponding to the selected aggregation operation.
Claim 5
Independent Claim
231 words
A method of building queries, comprising: displaying logical fields and operators to define abstract queries in a query conditions screen, the abstract queries being defined by a data abstraction model comprising metadata mapping the logical fields to physical data; in an aggregation screen area: displaying a plurality of result fields of a given abstract query, wherein the plurality of result fields are logical fields defined by the data abstraction model; and displaying a plurality of selectable aggregation operations applicable to the result fields; and in a grouping screen area, displaying the plurality of result fields and wherein each selection of one of the plurality of result fields from the grouping screen area defines a result group for the given query; displaying a first selection element for specifying whether the given query comprising user selections made from the aggregation screen area and the grouping screen area will be executed as an aggregation query or a non-aggregation query, wherein the aggregation query returns summary information comprising each result group and values calculated by applying selected ones of the plurality of selectable aggregation operations from the aggregation screen area to selected ones of the plurality of result fields from the aggregation screen area; and displaying a second selection element for initiating execution of the given query as the aggregation query or the non-aggregation query according to the selection made through the first selection element.
Claim 6
Independent Claim
231 words
A method of building queries, comprising: displaying logical fields and operators to define abstract queries in a query conditions screen, the abstract queries being defined by a data abstraction model comprising metadata mapping the logical fields to physical data; in an aggregation screen area: displaying a plurality of result fields of a given abstract query, wherein the plurality of result fields are logical fields defined by the data abstraction model; and displaying a plurality of selectable aggregation operations applicable to the result fields; and in a grouping screen area, displaying the plurality of result fields and wherein each selection of one of the plurality of result fields from the grouping screen area defines a result group for the given query; displaying a first selection element for specifying whether the given query comprising user selections made from the aggregation screen area and the grouping screen area will be executed as an aggregation query or a non-aggregation query, wherein the aggregation query returns summary information comprising each result group and values calculated by applying selected ones of the plurality of selectable aggregation operations from the aggregation screen area to selected ones of the plurality of result fields from the aggregation screen area; and displaying a second selection element for initiating execution of the given query as the aggregation query or the non-aggregation query according to the selection made through the first selection element.
Claim 7
Dependent Claim
14 words
The method of claim 4 , wherein the first selection element is a checkbox.
Claim 8
Dependent Claim
49 words
The method of claim 4 , wherein the aggregation screen area comprises a selection window for displaying a query element comprising a selected result field and a selected aggregation operation applied to the selected result field by selection of a graphical selection element corresponding to the selected aggregation operation.
References Cited (Backward Citations)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2009-12-11 | 2010-06-12 | 2010-12-12 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2013-12-11 | 2014-06-12 | 2014-12-12 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2017-12-11 | 2018-06-12 | 2018-12-12 | $7700.00 | Window Closed / Lapsed |