Global query correlation attributes

• US 7,096,217 B2
• Filed: 10/31/2002
• Issued: 08/22/2006
• Est. Priority Date: 10/31/2002
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Dettinger, Richard D., Stevens, Richard J.
• Primary Examiner(s): Corrielus, Jean M.
• Assistant Examiner(s): Ly, Anh
• Application Number:
  US10/285,228
• Publication Number:
  US 20040088292A1
• Time in Patent Office: 1,391 Days
• Field of Search: 707 1- 10, 707100-1041, 707/200
• US Class Current: 1/1
• CPC Class Codes: G06F 16/242 Query formulation
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A system, method and article of manufacture for accessing data are disclosed. In general, data access is facilitated by a query configured with a correlation criterion or criteria. The presence of the correlation criteria facilitates the introduction of additional correlation logic to be applied to conditions of the query. In general, correlation criteria are contemplated which support correlation of entities based on time, physical location and age, for example.

Claims

1. A computer-implemented method of providing query attributes comprising:

specifying which of a plurality of correlation attributes are supported for a particular logical field of one or more logical fields;

for each particular field, specifying a correlation attribute definition for computing a value of the correlation attributes supported for the particular logical field, wherein the correlation attributes are configured to add query logic to a query generated from an abstract query defined by one or more logical fields;

determining that a span correlation criterion applies to logical fields of two conditions of the abstract query; and

building an expression to compute a difference between each value calculated by the correlation attribute definitions defined for the logical fields of the two conditions and corresponding to the span correlation criterion.

2. The method of claim 1, wherein specifying which of the plurality of correlation attributes are supported comprises specifying two or more correlation attributes for the particular logical field.

3. The method of claim 1, wherein the value is a time value.

4. The method of claim 1, wherein the value may be one of a color value, a weight value, a volume value, a length value and a width value.

5. A computer-implemented method of providing attributes configured to add query logic to a query generated from an abstract query defined by one or more logical fields, the method comprising:

for each of a plurality of logical fields, specifying which of a plurality of correlation attributes are supported for a particular logical field;

for each of a plurality of logical fields, specifying a correlation attribute definition for computing a value of the correlation attributes supported for the particular logical field;

wherein at least two of the correlation attribute definitions for computing a value of a particular correlation attribute, specified for two different logical fields, are different;

determining that a span correlation criterion applies to logical fields of two conditions of the abstract query; and

building an expression to compute a difference between each value calculated by the correlation attribute definitions defined for the logical fields and corresponding to the span correlation criterion.

6. The method of claim 5, wherein specifying which of the plurality of correlation attributes are supported comprises specifying two or more correlation attributes for the particular logical field.

7. The method of claim 5, wherein the value is a time value.

8. A computer-implemented method of adding query logic to a query generated from an abstract query defined by one or more logical fields, the method comprising:

for each condition of the abstract query;

building an executable query contribution, wherein building the executable query contribution comprises building a query predicate according to an access method defined for a logical field of the condition and specifying a method of accessing physical data; and

determining whether the abstract query includes at least one of a plurality of correlation criterions which applies to the logical field of the condition, wherein each of the plurality of correlation criterion have a corresponding correlation attribute definition for calculating a value, and wherein at least two different corresponding correlation attribute definitions are defined for a given correlation criterion.

9. The method of claim 8, further comprising, if the abstract query includes at least one of the plurality of correlation criterions which applies to the logical field of the condition, building a query predicate from the correlation criterion and the correlation attribute definition.

10. The method of claim 8, wherein the value may be one of an age value, a time value and a location value.

11. The method of claim 8, further comprising:

determining that a span correlation criterion applies to logical fields of two conditions of the abstract query; and

building an expression to compute a difference between each value calculated by the correlation attribute definitions defined for the logical fields and corresponding to the span correlation criterion.

12. A tangible computer readable medium containing a program which, when executed, performs an operation of adding query logic to a query generated from an abstract query defined by one or more logical fields, the operation comprising:

for each condition of the abstract query;

building an executable query contribution, wherein building the executable query contribution comorises building a query predicate according to an access method defined for a logical field of the condition and specifying a method of accessing physical data; and

determining whether the abstract query includes at least one of a plurality of correlation criterions which applies to the logical field of the condition, wherein each of the plurality of correlation criterion have a corresponding correlation attribute definition for calculating a value, and wherein at least two different corresponding correlation attribute definitions are defined for a given correlation criterion.

13. The computer readable medium of claim 12, further comprising, if the abstract query includes at least one of the plurality of correlation criterions which applies to the logical field of the condition, building a query predicate from the correlation criterion and the correlation attribute definition.

14. The computer readable medium of claim 12, wherein the value may be one of an age value, a time value and a location value.

15. The computer readable medium of claim 12, further comprising:

determining that a span correlation criterion applies to logical fields of two conditions of the abstract query; and

building an expression to compute a difference between each value calculated by the correlation attribute definitions defined for the logical fields and corresponding to the span correlation criterion.

16. A computer system, comprising:

a query specification comprising a plurality of logical fields for defining abstract queries;

at least one correlation attribute definition specified for at least two of the plurality of logical fields, wherein each resoective correlation attribute definition comprises a name and a definition for calculating a value of the correlation attribute correlation attribute definition; and

a runtime component executable to perform an operation in response to receiving an abstract query issued against the data, wherein the abstract query is defined according to the query specification and is configured with the at least two logical fields for which the respective at least one correlation attribute definition is specified, the operation comprising;

determining that a span correlation criterion applies to logical fields of two conditions of the abstract query, the logical fields comprising the at least two logical fields;

building an exoression to compute a difference between each value calculated by the correlation attribute definitions defined for the logical fields and corresponding to the span correlation criterion; and

calculating the correlation attribute value for the at least two logical fields.

17. The system of claim 16, further comprising a plurality of mapping rules which map the plurality of logical fields to physical entities of data.

18. The system of claim 16, wherein the value is a time value.

19. A tangible computer-readable medium, comprising information stored thereon, the information comprising:

a query specification comprising a plurality of logical fields for defining abstract queries;

a plurality of correlation attribute definitions specified for at least two of the plurality of logical fields, wherein each correlation attribute definition comprises a name and a definition for calculating a value of the correlation attribute correlation attribute definition; and

a runtime component executable to perform an operation in response to receiving an abstract query issued against the data, wherein the abstract query is defined according to the query specification and is configured with the at least two logical fields for which respective ones of the correlation attribute definitions are specified, the operation comprising;

determining that a span correlation criterion applies to logical fields of two conditions of the abstract query, the logical fields comprising the at least two logical fields;

building an expression to compute a difference between each value calculated by the correlation attribute definitions defined for the logical fields and corresponding to the span correlation criterion; and

calculating the correlation attribute value for the logical fields.

20. The computer-readable medium of claim 19, wherein the value is a time value.

21. The computer-readable medium of claim 19, further comprising a plurality of mapping rules which map the plurality of logical fields to physical entities of data.

22. A computer-implemented method of translating an abstract query into a query executable by a database management system, the method comprising:

receiving an abstract query, the abstract query comprising at least two conditions and at least one correlation criterion, the correlation criterion being a span criterion applying to logical fields of the two conditions, wherein the at least one correlation criterion is referenced in a definition of the logical field and has a corresponding correlation attribute definition for calculating a correlation attribute value to be applied to the respective logical field of the respective condition, wherein the definitions of the logical fields are defined in a data abstraction repository layer and each comprises an access method specifying a method of accessing physical data;

building an expression to compute a difference between each value calculated by the correlation attribute definitions defined for the logical fields and corresponding to the span correlation criterion;

translating the abstract query into a query executable by a database management system;

issuing the executable query against the database management system; and

receiving the result from the database management system.