Global query correlation attributes

• US 7,734,639 B2
• Filed: 08/03/2007
• Issued: 06/08/2010
• 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): LEROUX, ETIENNE PIERRE
• Application Number:
  US11/833,880
• Publication Number:
  US 20070271252A1
• Time in Patent Office: 1,040 Days
• Field of Search: 707/4, 707/102, 707/760, 715/200
• US Class Current: 707/760
• 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 to facilitate query composition, comprising:

specifying a respective correlation attribute in a plurality of logical field definitions defined in a data abstraction model that logically models physical data, each correlation attribute including a name and a reference to a corresponding correlation expression;

wherein at least two of the plurality of logical field definitions include a respective correlation attribute with the same name and a different correlation expression;

wherein an abstract query referencing one or more of the logical field definitions and one or more of the correlation attributes, configure a query processor to;

transform the abstract query into an executable query, wherein transforming comprises dynamically adding query logic to the executable query on the basis of the referenced correlation attributes and the corresponding logical fields for which the referenced correlation attributes are specified, the query logic comprising the correlation expressions corresponding to the referenced correlation attributes, whereby additional constraints are placed on the executable query on the basis of user-specified correlation attributes in the abstract query without requiring user composition of the corresponding added query logic defining the additional constraints.

2. The method of claim 1, wherein specifying a respective correlation attribute in a plurality of logical field definitions comprises specifying at least two different correlation attributes for at least one of the logical field definitions.

3. The method of claim 1, wherein the value may be one of an age value, a time value and a location 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 queries generated from abstract queries defined by one or more logical fields, the method comprising:

providing a data abstraction model that logically describes physical data and comprises a plurality of logical field definitions each having one or more correlation attributes;

each correlation attribute having a name and a reference to a corresponding correlation expression;

wherein at least two of the plurality of logical field definitions include a respective correlation attribute with the same name and reference to a different correlation expression; and

receiving an abstract query including (i) conditions referencing one or more of the logical field definitions and (ii) one or more of the correlation attributes;

generating an executable query from the abstract query, the generating comprising;

determining whether the referenced correlation attributes are associated with any of the referenced logical field definitions; and

if so,

applying, as part of the executable query, each correlation expression corresponding to the respective referenced correlation attribute associated with the referenced logical field definition.

6. The method of claim 5, wherein at least one condition of the abstract query relates to an event having a corresponding time value in the physical data and wherein at least one applied correlation condition imposes a constraint on the condition on the basis of the time value.

7. The method of claim 5, wherein at least one condition of the abstract query relates to an event having a corresponding value in the physical data and wherein at least one applied correlation expressions imposes a constraint on the condition on the basis of the value.

8. The method of claim 7, wherein the value is a location value.

9. The method of claim 5, wherein at least one applied correlation expression is a parameterized condition that receives passed in values during the step of applying.

10. A computer-implemented method of adding query logic to queries each having a plurality of conditions, the method comprising:

receiving a query referencing one or more predefined correlation attributes, each correlation attribute having a predefined relationship to a given field of a plurality of fields, wherein each correlation attribute has a definition comprising a name and a reference to a corresponding correlation expression, and wherein the respective correlation attribute for at least two of the plurality of fields have the same name and a reference to a different correlation expression;

for each correlation attribute referenced in the query;

(i) determining whether the query includes the given field for which the correlation attribute has the predefined relationship; and

if so,

(ii) generating query logic on the basis of the respective correlation expression of the given correlation attribute; and

applying the generated query logic to the query.

11. The method of claim 10, wherein the predicate imposes a time based constraint upon the given field.

12. The method of claim 10, wherein the respective correlation expression is a parameterized condition that receives passed in values during the generating query logic.

13. A computerized system, comprising:

a processor;

a memory containing a data structure containing a plurality of correlation attributes each having a predefined relationship to a given field of a plurality of fields, wherein each correlation attribute has a definition comprising a name and a reference to a corresponding correlation expression, and wherein the respective correlation attribute for at least two of the plurality of fields have the same name and a reference to a different correlation expression;

a searchable data source containing a plurality of fields of physical data, including those fields having predefined relationships with the predicates; and

a query processor that, when executed by the processor, is configured to;

receive a query referencing one or more of the plurality of fields and one or more correlation attributes defined in the data structure;

for each correlation attribute referenced in the query;

(i) determine whether the query includes the given field for which the correlation attribute has the predefined relationship; and

if so,

(ii) generate query logic on the basis of the predicate of the given correlation attribute; and

apply the generated query logic to the query;

receiving a query referencing one or more predefined correlation attributes, each correlation attribute having a predefined relationship to a given field

for each correlation attribute referenced in the query;

(i) determining whether the query includes the given field for which the correlation attribute has the predefined relationship; and

if so,

(ii) generating query logic on the basis of the respective correlation expression of the given correlation attribute; and

applying the generated query logic to the query.

14. The computerized system of claim 13, wherein the query processor is further configured to execute the generated query against the data source.

15. The computerized system of claim 13, further comprising a data abstraction model comprising a plurality of logical fields that logically describe respective ones of the plurality of fields in the data source, the data abstraction model having a plurality of mapping rules which map the plurality of logical fields to respective fields in the data source.

16. The computerized system of claim 13, wherein the predicate is a parameterized condition that receives passed in values during the generating query logic.

17. The computerized system of claim 13, wherein the predicate imposes a time based constraint upon the given field.