Annotation of query components

• US 7,849,074 B2
• Filed: 01/31/2008
• Issued: 12/07/2010
• Est. Priority Date: 08/21/2003
• Status: Active Grant

• Current Assignee: Wrp IP Management, LLC
• Original Assignee: International Business Machines Corporation
• Inventors: Dettinger, Richard D., Rath, Cale T., Stevens, Richard J.
• Primary Examiner(s): LEROUX, ETIENNE PIERRE
• Application Number:
  US12/023,829
• Publication Number:
  US 20080126327A1
• Time in Patent Office: 1,041 Days
• Field of Search: 707/4, 707/5, 707/101, 707/713, 704/270
• US Class Current: 707/713
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence

Abstract

Methods, systems, and articles of manufacture that may be used to create and share annotations for query components, such as query conditions, in an effort to share domain knowledge, are provided. The annotations may be created by users with particular domain knowledge and may contain information useful to other users when building queries including the annotated query components. An annotation may indicate a particular format or syntax for an associated query component. In some cases, a replacement to the associated query component is suggested.

Claims

1. A method of sharing information useful in the building of queries, comprising:

monitoring one or more query components specified for use in a query, wherein the query is being composed in a query composition tool, wherein the one or more query components are stored and are accessible to the query composition tool;

searching for annotations associated with the one or more query components; and

providing an indication of one or more annotations, if found, associated with the one or more query components, comprising;

displaying an annotation icon proximate an annotated query component, displaying a suggested substitution for the annotated query component, allowing the user to accept the suggested substitution; and

in response to the user accepting the suggested substitution, replacing, in the query, the annotated query component with the suggested substitution.

2. The method of claim 1, further comprising, in response to a user selecting an annotation icon, displaying an annotation associated with the annotated query component.

3. The method of claim 1, wherein searching for annotations associated with the one or more query components comprises:

selecting a query component; and

searching annotation records for a reference to the selected query component.

4. The method of claim 3, wherein searching annotation records for a reference to the selected query component comprises applying one or more logical rules.

5. The method of claim 3, wherein searching annotation records for a reference to the selected query component comprises searching for references to fields involved in the selected query component.

6. The method of claim 5, wherein searching for references to fields involved in the selected query component comprises searching for references with parameter markers.

7. The method of claim 3, wherein searching annotation records for a reference to the selected query component comprises searching for references to a specific instance value of data.

8. A computer-readable storage medium containing a program which, when executed, performs an operation for sharing information useful in the building of queries, comprising:

monitoring one or more query components specified for use in a query, wherein the query is being composed in a query composition tool, wherein the one or more query components are stored and are accessible to the query composition tool;

responsive to detecting the monitored one or more query components, searching for annotations associated with the one or more query components; and

providing an indication of one or more annotations, if found, associated with the one or more query components, comprising;

displaying an annotation icon proximate an annotated query component, displaying a suggested substitution for the annotated query component, allowing the user to accept the suggested substitution; and

in response to the user accepting, the suggested substitution, replacing, in the query, the annotated query component with the suggested substitution.

9. The computer-readable storage medium of claim 8, further comprising, in response to a user selecting an annotation icon, displaying an annotation associated with the annotated query component.

10. The computer-readable storage medium of claim 8, wherein searching for annotations associated with the one or more query components comprises:

selecting a query component; and

searching annotation records for a reference to the selected query component.

11. The computer-readable storage medium of claim 10, wherein searching annotation records for a reference to the selected query component comprises applying one or more logical rules.

12. The computer-readable storage medium of claim 10, wherein searching annotation records for a reference to the selected query component comprises searching for references to fields involved in the selected query component.

13. The computer-readable storage medium of claim 12, wherein searching for references to fields involved in the selected query component comprises searching for references with parameter markers.

14. The computer-readable storage medium of claim 10, wherein searching annotation records for a reference to the selected query component comprises searching for references to a specific instance value of data.