Method and system for providing aggregate data access

• US 8,341,172 B2
• Filed: 07/22/2004
• Issued: 12/25/2012
• Est. Priority Date: 07/22/2004
• Status: Active Grant

• Current Assignee: Daedalus Blue LLC
• Original Assignee: International Business Machines Corporation
• Inventors: Dettinger, Richard D., Stevens, Richard J., Tenner, Jeffrey W.
• Primary Examiner(s): Alam, Hosain
• Assistant Examiner(s): Tang, Jieying
• Application Number:
  US10/897,333
• Publication Number:
  US 20060020580A1
• Time in Patent Office: 3,078 Days
• Field of Search: 707/3, 707/10, 707/100, 707/102, 707/103.R, 707/104.1, 707/999.002, 707/999.003, 707/760, 707/769, 717/136
• US Class Current: 707/760
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

A method and apparatus for defining and processing aggregate data is disclosed. Using database abstraction techniques, a set of logical fields may be used to compose queries of a set of underlying physical data sources. In one embodiment, a logical field may represent an aggregate data value calculated from the elements appearing in a column of a relational table in an underlying physical data source. The elements may be divided into to subsets to calculate multiple aggregate values. An abstract derived entity is a data object present in a database abstraction model that may be accessed as though it were a relational table contained in an underlying physical data source. In one embodiment, columns of the table defined by the abstract derived entity may be populated with aggregate data values joined to other data as specified by a composition rule included in the definition of the abstract derived entity.

Claims

1. A system for generating aggregate data values from data stored in a data source, comprising:

a processor;

a database service available in a network environment, the database service comprising (a) a data source, (b) an abstract data layer, wherein the abstract data layer comprises a plurality of logical fields used to compose an abstract query to query the data source, and for each logical field, providing an access method specifying at least a method for accessing the data, wherein at least one logical field specifies an aggregate access method, wherein the aggregate access method specifies a set of input data and an expression for determining an aggregate data value from the set of input data; and

(c) a runtime component configured to process an abstract query that includes the at least one logical field by (i) retrieving a definition for the aggregate access method, (ii) determining aggregate data values according to the definition, (iii) merging the aggregate data values with query results obtained for logical fields, other than the at least one logical field, included in the abstract query, and (iv) returning the results to the requesting entity.

2. The system of claim 1, wherein the aggregate access method further specifies a grouping condition used to divide the set of input of data into multiple subsets, wherein each subset is used to determine an aggregate data value according to the expression specified by the aggregate access method.

3. The system of claim 1, wherein the data source comprises a relational database and the set of input data comprises a column from a relational table stored in the database.

4. The system of claim 1, wherein the data source for at least one access method comprises an abstract derived entity that defines a derived relational table.

5. The system of claim 4, wherein the derived relational table is composed from sets of data elements selected from at least one of:

(i) data defined by other abstract derived entities;

(ii) data stored in the multiple data sources; and

(iii) data accessed using logical fields appearing in the data abstraction layer.

6. The system of claim 4, wherein at least one set of data included in the relational table comprises the aggregate data values generated from the at least at least one logical field that specifies an aggregate access method.

7. A computer-readable storage medium, that when executed by a processor performs operations comprising:

providing, for a requesting entity, an abstract data layer comprising a plurality of logical fields for composing an abstract query, and for each logical field;

defining an access method that specifies at least a method for accessing the data corresponding to the logical field, wherein at least one logical field specifies an aggregate access method for accessing the data corresponding to the at least one logical field, wherein the aggregate access method specifies a set of input data and an expression for determining an aggregate data value from the set of input data;

receiving, from the requesting entity, an abstract query that includes the at least one logical field specifying an aggregate access method;

retrieving a set of input data defined by the aggregate access method;

determining at least an aggregate data value from the set of input data;

transforming each logical field, other than the at least one logical field, included in the abstract query into a query contribution that is consistent with the data source specified by the access method for each logical field;

accessing the data source corresponding to each of the above logical fields using the query contribution and retrieving a set of query results data; and

returning, to the requesting entity, the at least one aggregate data value and the set of query results data.