AGGREGATION OF DATA STORED IN MULTIPLE DATA STORES

• US 20090319548A1
• Filed: 06/20/2008
• Published: 12/24/2009
• Est. Priority Date: 06/20/2008
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Atay, Omer, Rashid, Mohammad, Brown, Kevin L., Abel, Todd J., Avery, William R.
• Granted Patent: US 8,762,420 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/256 in federated or virtual databases

Abstract

A data aggregation system is described herein for accessing and viewing information about an entity stored in multiple data stores. The data aggregation system identifies an entry in a primary data store that contains information about an entity. The system receives a request to associate an entry in a secondary data store with the identified entry in the primary data store. Then, the system identifies information in the secondary data store that identifies the entry in the secondary data store and associates the identified information with the entry in the primary data store. When a user requests to view the entry in the primary data store, the system retrieves the information about the entry in the primary data store and uses the stored entry identifier to also retrieve the information about the entry from the secondary data store. Thus, the information remains in the data store in which it originated, but the data aggregation system provides a unified view.

Claims

1. A computer-implemented method for associating information related to an entity stored in a secondary data store with information related to the entity stored in a primary data store, the method comprising:

identifying an entry in a primary data store that contains information related to an entity;

receiving a request to associate an entry in a secondary data store with the identified entry in the primary data store;

identifying information in the secondary data store that identifies the entry in the secondary data store; and

associating the identified information with the entry in the primary data store, so that the entries from the primary and secondary data store can be viewed together without modifying the secondary data store.

2. The method of claim 1 wherein the entity is a user contact and the primary data store contains contact information associated with the user contact.

3. The method of claim 1 wherein the primary data store is a data file associated with a personal information management application.

4. The method of claim 1 wherein the secondary data store is a database containing line of business data.

5. The method of claim 1 further comprising receiving a request to view the entry in the primary data store and retrieving the information related to the entry in the primary data store and the information related to the entry in the secondary data store, wherein the information from the secondary data store is retrieved using the associated identified information.

6. The method of claim 1 further comprising, when information in the secondary data store is updated, the primary data store does not need to be updated.

7. The method of claim 1 further comprising associating an entry in an additional secondary data store with the entry in the primary data store.

8. The method of claim 1 wherein the primary data store and secondary data store contain at least one field of duplicate information related to the entity.

9. The method of claim 1 wherein identified information comprises a packet of information including a list of fields, a list of values, and a version stamp.

10. A computer system for aggregating information stored in multiple data stores in a unified view, the system comprising:

a primary data store configured to store information related to one or more entities;

a secondary data store configured to store additional information related to at least one of the one or more entities; and

an aggregation component configured to provide a unified view of the information stored in the primary data store and the additional information stored in the secondary data store, wherein the unified view provides the appearance to a consumer of the unified view that the information is stored in a single data store.

11. The system of claim 10 further comprising a view component configured to display a unified entry containing information related to an entity, wherein some of the information is retrieved from the primary data store and some of the information is retrieved from the secondary data store.

12. The system of claim 10 further comprising an object model component configured to provide an application programming interface for accessing the unified view of information related to the one or more entities provided by the aggregation component.

13. The system of claim 10 further comprising a sorting component configured to sort entries in the unified view.

14. The system of claim 10 wherein the primary data store is a PIM application database and the secondary data store is a line of business database.

15. A computer-readable storage medium encoded with instructions for controlling a computer system to display information from multiple data stores in a unified view, by a method comprising:

receiving a request to display information related to an entity;

accessing a primary data store to retrieve first information related to the entity, wherein the first information contains a reference to a secondary data store that contains additional information related to the entity;

accessing the secondary data store to retrieve additional information related to the entity using the reference retrieved from the primary data store; and

displaying a user interface that contains the first information from the primary data store and the additional information from the secondary data store, wherein the user interface does not identify from which data store contents of the first information and additional information was retrieved.

16. The computer-readable medium of claim 15 further comprising receiving a request to edit the information, determining which data store the information was retrieved from, and updating the determined data store.

17. The computer-readable medium of claim 15 further comprising receiving a request to edit the information, determining that the edited information is stored in both data stores, and updating both the primary and secondary data stores.

18. The computer-readable medium of claim 15 wherein the user interface has a table format and the information from the primary and secondary data store is displayed in columns in the table.

19. The computer-readable medium of claim 15 further comprising:

receiving a request to sort information related to multiple entities based on the additional information retrieved from the secondary data store;

sorting the information related to each entity; and

sending a response to the request to sort information related to multiple entities that contains the sorted information.

20. The computer-readable medium of claim 15 further comprising:

receiving a request to sort information related to multiple entities based on the additional information retrieved from the secondary data store;

sending a request to the secondary data store to sort the additional information at the secondary data store;

receiving sorted information from the secondary data store;

aggregating the sorted information with the information retrieved from the primary data store; and

sending a response to the request to sort information related to multiple entities that contains the aggregated information.