Aggregation of data stored in multiple data stores

• US 8,762,420 B2
• Filed: 06/20/2008
• Issued: 06/24/2014
• Est. Priority Date: 06/20/2008
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Brown, Kevin L., Avery, William R., Atay, Omer, Rashid, Mohammad, Abel, Todd J.
• Primary Examiner(s): Nguyen, Cindy
• Application Number:
  US12/142,836
• Publication Number:
  US 20090319548A1
• Time in Patent Office: 2,195 Days
• Field of Search: 707790-793, 707/802, 707/803
• US Class Current: 707/803
• 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 a first entry in a primary data store that contains information related to an entity;

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

identifying information in the secondary data store, wherein the identified information identifies the second entry in the secondary data store; and

associating the identified information of the second entry with the first entry in the primary data store by storing the identified information of the second entry in the primary data store, so that the first and second entries from the primary and secondary data store are viewable together without modifying the secondary data store, and without creating intermediate copies of the first and second entries in a merged 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 first entry in the primary data store and retrieving the information related to the first entry in the primary data store and the information related to the second entry in the secondary data store, wherein the information from the secondary data store is retrieved using the identified information stored in the primary data store.

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

7. The method of claim 1 further comprising associating third entry in an additional data store with the first 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 processor and memory configured to execute software instructions embodied within the following components;

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

a secondary data store configured to store additional information related to at least one of the one or more entities as second entries, wherein the primary data store includes one or more references to one or more of the second entries containing the additional information in the secondary data store; 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 using the references to one or more of the second entries stored in the primary 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 without creating intermediate copies of the first and second entries in a merged 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 tangible 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 a first entry of information related to the entity, wherein the primary data store also contains a reference to a second entry in 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 to the second entry retrieved from the primary data store, wherein the primary data store and secondary data store are accessed directly by a data consumer without creating intermediate copies of the first and second entries in a merged data store; and

displaying a user interface that contains the information from the first entry of the primary data store and the additional information from the second entry of the secondary data store, wherein the user interface does not identify from which one of the primary or secondary data store the information and the additional information is retrieved.

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

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

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

19. The tangible 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 of the multiple entities; and

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

20. The tangible 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 the 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 the multiple entities that contains the aggregated information.