Viewing annotations across multiple applications

• US 9,026,901 B2
• Filed: 05/13/2004
• Issued: 05/05/2015
• Est. Priority Date: 06/20/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.
• Primary Examiner(s): Patel, Manglesh M
• Application Number:
  US10/845,387
• Publication Number:
  US 20050256825A1
• Time in Patent Office: 4,009 Days
• Field of Search: 715/512, 715/230, 715/200, 715234-237
• US Class Current: 715/230
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

Methods, systems, and articles of manufacture for viewing annotations created for data objects appearing in a data source using a second application configured to access and view the data source. Some embodiments present users viewing a data source with an indication of data objects in the data source that have been by other applications accessing the data source. An annotation system may use a mapping component to transform a set of parameters suitable for the first application to identify an annotated data object into a set of parameters suitable for the second application to view an annotated data object in a common data source.

Claims

1. A method for accessing, using a second application, annotations created by a first application, comprising:

receiving a request, from the second application, for an indication of annotated data objects described by the annotations, wherein the data objects appear in a data source being accessed by the second application, wherein the data source was created using the first application;

obtaining, from an index table, a first set of parameters used by the first application to identify the annotated data objects, wherein the index table stores a unique identifier for each annotated data object based on a set of identification (ID) parameters, wherein each parameter of the first set of parameters corresponds to a respective column in the index table, wherein each parameter of the first set of parameters is based on a first access type used by the first application to access the data source;

transforming the first set of parameters of the index table into a second set of parameters suitable for use by the second application to identify the annotated data objects, wherein the second set of parameters is based on a second access type used by the second application to access the data source; and

in response to the request, returning the second set of parameters to the second application as the indication of the annotated data objects described by the annotations.

2. The method of claim 1, wherein the request for an indication of annotated data objects includes an indication of the second application.

3. The method of claim 1, wherein obtaining a first set of parameters comprises querying an annotation store to identify annotations created for data objects appearing in the data source being accessed by the second application.

4. The method of claim 1, further comprising displaying an indication of annotated data objects in the second application based upon the second set of parameters.

5. The method of claim 1, wherein the request for an indication of annotated data objects includes an indication of an application type associated with the second application.

6. The method of claim 1, further comprising returning the annotations to the second application.

7. The method of claim 1, wherein transforming the first set of parameters to the second set of parameters comprises selecting and using an annotation point map associated with the first and second applications, wherein the annotation point map contains sufficient information to transform the first set of parameters usable by the first application into the second set of parameters usable by the second application.

8. An annotation system comprising one or more computer processors configured to allow a second application to access annotations created by a first application, wherein the first and second applications identify annotatable portions of a common data source with different identifying parameters, comprising:

an indexing component configured to;

receive, from the second application, a request for an indication of one or more annotated data objects contained in the common data source, wherein the annotated data objects are referenced by annotations created by the first application; and

maintain, in an index table, a unique identifier for each annotated data object based on a first set of identification (ID) parameters, wherein each parameter of the first set of parameters corresponds to a respective column in the index table; and

a mapping component configured to receive, from the indexing component, a first set of parameters usable by the first application to identify the annotated data objects, to transform the first set of parameters into a second set of parameters usable by the second application to identify the annotated data objects, and to return the second set of parameters to the second application;

wherein the mapping component transforms the first set of parameters into the second set of parameters by accessing at least one annotation point map from a set of annotation point maps, each annotation point map containing sufficient information to transform a set of parameters usable by one application into a set of parameters usable by another application, wherein each parameter of the first set of parameters is based on a first access type used by the first application to access the data source, wherein the second set of parameters is based on a second access type used by the second application to access the data source.

9. The annotation system of claim 8, wherein each annotation point map comprises an XML document.

10. The annotation system of claim 8, wherein:

the annotation system further comprises an annotation store; and

the annotation system returns the unique identifier for each annotation referencing the annotated data objects.

11. A non-transitory computer-readable storage medium containing a program for accessing, using a second application, annotations created by a first application which, when executed by a processor, performs operations comprising:

receiving a request, from the second application for an indication of annotated data objects described by the annotations, wherein the data objects appear in a data source being accessed by the second application, wherein the data source was created using the first application;

obtaining, from an index table, a first set of parameters used by the first application to identify the annotated data objects, wherein the index table stores a unique identifier for each annotated data object based on a set of identification (ID) parameters, wherein each parameter of the first set of parameters corresponds to a respective column in the index table, wherein each parameter of the first set of parameters is based on a first access type used by the first application to access the data source;

transforming the first set of parameters of the index table to a second set of parameters suitable for use by the second application to identify the annotated data objects, wherein the second set of parameters is based on a second access type used by the second application to access the data source; and

returning the second set of parameters to the second application.

12. The non-transitory computer-readable storage medium of claim 11, wherein obtaining the first set of parameters comprises querying the index table to identify annotations created for data objects appearing the data source being accessed by the second application.

13. The non-transitory computer-readable storage medium of claim 11, wherein the operations further comprise returning unique identifiers corresponding to identified annotations created for data objects appearing the data source being accessed by the second application.

14. A method of creating and retrieving annotations using a plurality of different type applications, comprising:

receiving, from a first application, a request to create an annotation for a data object appearing in a data source, the data source identified by a first set of parameters;

generating an index based on the first set of parameters, wherein the index includes a unique identifier for each data object based on a set of identification (ID) parameters, of the first set of parameters, wherein each parameter of the first set of parameters corresponds to a respective column in the index table, wherein each parameter of the first set of parameters is based on a first access type used by the first application to access the data source;

storing, in an annotation store, the annotation and index in an annotation record;

receiving, from a second application accessing the data source, a request to identify annotated data objects in the data source;

in response to the request, retrieving the index generated based on the first set of parameters identifying the data object, wherein the index is retrieved from the index table, and wherein retrieving the index comprises;

querying the index table for indexes corresponding to annotations describing data object contained in the data source;

converting the index into the first set of parameters;

transforming the first set of parameters of the index to a second set of parameters suitable for use by the second application, wherein the second set of parameters is based on a second access type used by the second application to access the data source, wherein transforming comprises;

selecting, from a plurality of map definitions, a map definition associated with the first and second application; and

transforming the first set of parameters to the second set of parameters based on information in the selected map definition; and

returning the second set of parameters to the second application.

15. The method of claim 14, wherein the first application is a word processing application and the second application is a viewer.

16. The method of claim 14, further comprising returning to the second application a unique identifier of the annotation record.