Subscription for integrating external data from external system

• US 9,971,827 B2
• Filed: 11/21/2014
• Issued: 05/15/2018
• Est. Priority Date: 06/22/2010
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Koronthaly, David, Jimenez-Salgado, Rolando, Paranthaman, Sundaravadivelan, Kapadia, Arshish Cyrus, Lo, Wei-Lun
• Primary Examiner(s): CHANNAVAJJALA, SRIRAMA T
• Application Number:
  US14/550,623
• Publication Number:
  US 20150081732A1
• Time in Patent Office: 1,271 Days
• CPC Class Codes: G06F 13/00 Interconnection of, or transfer of information or other signals between, memories, input/output devices or central processing units interface circuits for specific input/output devices G06F3/00 ; multiprogram control therefor G06F9/46; multiprocessor systems G06F15/16
• CPC Class Codes: G06F 16/148 File search processing
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/24539 using cached or materialised query results
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/24552 Database cache management
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/90335 Query processing
• CPC Class Codes: G06F 16/907 Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
• CPC Class Codes: G06F 16/909 using geographical or spatial information, e.g. location spatiotemporally dependent retrieval from the web G06F16/9537
• CPC Class Codes: H04L 67/1097 for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]

Abstract

Technologies are described herein for integrating external data from an external system into a client system. A subscription filed is selected. The subscription filed may include a read method and a query method. The read method may define fields of a client cache operating on the client system. The query method may be executed to retrieve, from the external system, field values corresponding to at least a subset of the fields. Upon executing the query method, the read method may also be executed to retrieve, from the external system, additional field values corresponding to a remaining subset of the fields that were not retrieved by executing the query method. The client cache is populated with the field values and the additional field values according to the fields.

Claims

1. A computer-implemented method, comprising:

selecting a subscription file defining fields to be stored in database within a client system;

retrieving, from an external system, field values corresponding to at least a subset of the fields defined in the subscription file;

populating the database with the field values;

determining whether a field value was retrieved from the external system and populated in the database for each of the fields defined in the subscription file;

in response to determining that a field value was not retrieved from the external system and populated in the database for one of the fields defined in the subscription file, setting a refresh rate of the one of the fields defined in the subscription file with a priority on refreshing higher than a priority on refreshing placed on one of the fields defined in the subscription file retrieved from the external system and populated in the database;

refreshing the database based on the refresh rate;

receiving an indication that a corresponding representation of at least one of the retrieved field values has been updated on the external system; and

in response to receiving the indication, refreshing at least one of the retrieved field values or additional field values in the database.

2. The computer-implemented method of claim 1, further comprising:

retrieving, from the external system, additional field values corresponding to a remaining subset of the fields that were not previously retrieved; and

populating the database with the additional field values.

3. The computer-implemented method of claim 2, further comprising retrieving second additional field values from related entities, wherein populating the database with the field values and the additional field values according to the fields comprises populating the database with the field values, the additional field values, and the second additional field values according to the fields.

4. The computer-implemented method of claim 2, wherein the subscription file further comprises an explicit identity, and wherein the method further comprises utilizing the explicit identity to retrieve third additional field values by specific identifier, wherein populating the database with the field values and the additional field values comprises populating the database with the field values, the additional field values, and the third additional field values.

5. The computer-implemented method of claim 2, further comprising:

retrieving, from the external system, second field values corresponding to at least a second subset of the fields;

retrieving, from the external system, second additional field values corresponding to a remaining subset of the fields that were not previously retrieved; and

populating the database with the second field values and the second additional field values according to the fields.

6. The computer-implemented method of claim 2, further comprising merging overlapping results in the retrieved field values and the additional field values.

7. The computer-implemented method of claim 2, further comprising:

receiving an indication that a corresponding representation of at least one of the retrieved field values or the additional field values has been deleted on the external system; and

in response to receiving the indication, deleting the at least one of the retrieved field values or additional field values from the database.

8. The computer-implemented method of claim 1, further comprising retrieving, from the external system, the defined field values corresponding to at least a subset of the fields according to a parameter associated with the subscription file.

9. The computer-implemented method of claim 1, wherein the database comprises a relational database embedded within the client system.

10. A computer system, comprising:

a processor; and

a memory communicatively coupled to the processor storing computer-executable instructions (i) that execute in the processor from the memory and (ii) which, when executed by the processor, cause the computer system to perform operations comprising;

retrieving, from an external system, field values corresponding to at least a subset of fields used in a client system;

retrieving, from the external system, additional field values corresponding to a remaining subset of the fields that were not retrieved from the external system;

populating a database with the field values and the additional field values;

determining a refresh rate specifying a frequency with which the external system updates the field values as stored in the external system;

refreshing the field values stored in the database according to the refresh rate;

receiving an indication that a corresponding representation of at least one of the retrieved field values has been updated on the external system; and

in response to receiving the indication, refreshing at least one of the retrieved field values or additional field values in the database.

11. The computer system of claim 10, wherein the operations further comprise:

retrieving second additional field values from related entities; and

populating the database with the second additional field values according to the fields and the second additional field values.

12. The computer system of claim 11, wherein the operations further comprise retrieving, from the external system, defined the field values corresponding to at least a subset of the fields.

13. The computer system of claim 11, wherein the operations further comprise integrating external data from the external system into the client system by refreshing the field values according to the refresh rate.

14. The computer system of claim 11, wherein the operations further comprise:

receiving an indication that a corresponding representation of at least one of the retrieved field values or the additional field values has been deleted on the external system; and

in response to receiving the indication, deleting the at least one of the retrieved field values or the additional field values from the database.

15. The computer system of claim 10, wherein the subscription file further comprises an explicit identity, wherein the program module further causes the computer system to integrate external data from the external system into the client system by utilizing the explicit identity to retrieve third additional field values by specific identifier, and wherein populating the database with the field values, the additional field values, and the second additional field values comprises populating the database with the field values, the additional field values, the second additional field values, and the third additional field values.

16. A computer-readable storage medium having computer-executable instructions stored thereon which, when executed by a computer, cause the computer to:

select a subscription file defining fields to be stored in a database within a client system;

retrieve, from an external system, field values corresponding to at least a subset of the fields;

retrieve, from the external system, additional field values corresponding to a remaining subset of the fields not previously retrieved;

retrieve second additional field values from related entities;

utilize an explicit identity to retrieve third additional field values by specific identifier;

populate the database with the field values, the additional field values, the second additional field values, and the third additional field values;

determine a change made to the external system;

associate a refresh rate with the field values stored in the database at least partly based on the change made in the external system;

refresh the field values according to the refresh rate; and

receive an indication that a corresponding representation of at least one of the retrieved field values has been updated on the external system; and

in response to receiving the indication, refreshing at least one of the retrieved field values or additional field values in the database.

17. The computer-readable storage medium of claim 16, wherein the computer-readable storage medium has further computer-executable instructions stored thereon to cause the computer to retrieve, from the external system, defined field values corresponding to at least a subset of the fields.