Annotation of query components

• US 7,844,607 B2
• Filed: 01/31/2008
• Issued: 11/30/2010
• Est. Priority Date: 08/21/2003
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• 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,845
• Publication Number:
  US 20080120331A1
• Time in Patent Office: 1,034 Days
• Field of Search: 707/4, 707/5, 707/736, 715/210
• US Class Current: 707/736
• 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 system for sharing information useful in building queries, comprising:

an annotation database for storing annotations;

a query building interface allowing users to build queries by specifying query components, wherein the query components are stored and are accessible to the query building interface; and

an annotation system allowing users to create and display annotations associated with query components used in building queries, wherein the annotation system provides an annotation creating interface allowing a user to create an annotation for a query component selected from the query building interface, wherein the indication is an annotation icon; and

wherein the annotation system is configured to;

display an annotation associated with a query component, in response to a user selecting the annotation icon,

display, to the user, a suggested substitution for the query component associated with the annotation, and

replace the query component associated with the annotation with the suggested substitution, in response to the user accepting the suggested substitution.

2. The system of claim 1, wherein the annotation system provides an annotation creating interface allowing a user to create an annotation for a query component selected from the query building interface.

3. The system of claim 2, wherein the annotation creating interface is accessible from the query building interface.

4. The system of claim 2, wherein the annotation creating interface allows users to create suggested substitutions for query components associated with annotations.

5. The system of claim 2, wherein the annotation system is configured to:

monitor query components specified, via the query building interface, for use in a query;

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

provide an indication in the query building interface of one or more annotations, if found, associated with the one or more query components.

6. The system of claim 1, wherein the query components comprise conditional query logic.