Embedding and retrieving data in an application file format

• US 8,429,118 B2
• Filed: 10/23/2009
• Issued: 04/23/2013
• Est. Priority Date: 10/23/2009
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Battagin, Daniel C., Berry, Gabhan, Collie, Robert C., Iyer, Raman S., Prish, Shahar, Wu, Su-Piao Bill, Graber, Lee B.
• Primary Examiner(s): Nguyen, Cindy
• Application Number:
  US12/605,126
• Publication Number:
  US 20110099143A1
• Time in Patent Office: 1,278 Days
• Field of Search: 707/602, 707/726, 707/776, 709/227, 709/201, 709/202
• US Class Current: 707/602
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/84 Mapping; Conversion

Abstract

Third party data embedding may be provided. Data associated with a third party provider may be saved in a native application save file. If a save file opened by the application is determined to comprise third party data, the application may determine whether an appropriate data provider is available. The application may connect to the data provider and provide on-demand, asynchronous access to the third party data upon request from a user.

Claims

1. A method for embedding data in an application file, the method comprising:

establishing a connection between an application and a data provider, wherein establishing the connection comprises providing a generic data interface for the data provider to read and write data to the application;

receiving, through the generic data interface, a plurality of data from the data provider;

storing the plurality of data in a file, wherein the file comprises a format associated with the application;

modifying at least one element of the plurality of data within the application; and

saving the modified at least one element to the file, wherein saving the modified at least one element comprises;

providing the modified at least one element of the plurality of data to the data provider, and

receiving a modification to the file associated with the modified at least one element of the plurality of datafrom the data provider via the generic data interface.

2. The method of claim 1, wherein the application does not comprise native support for retrieving the plurality of data.

3. The method of claim 1, wherein the data provider collects the plurality of data from a plurality of sources.

4. The method of claim 1, wherein the file comprises a compressed archive of a plurality of files, wherein at least one of the plurality of files comprises a primary index file, and wherein the primary index file comprises an entry for each of the other files of the plurality of files.

5. The method of claim 4, wherein storing the plurality of data in the file comprises storing the plurality of data in at least one of the other files of the plurality of files, and wherein the primary index file entry associated with the at least one of the other files of the plurality of files comprises an identifier associated with the data provider.

6. A computer-readable storage device which stores a set of instructions which when executed performs a method for accessing third party data in an application file, the method executed by the set of instructions comprising:

opening a file associated with an application, wherein the file comprises a third party data segment;

determining whether a data provider associated with the third party data segment is available;

in response to determining that the data provider is available;

establishing a connection between the application and the data provider, wherein establishing the connection comprises providing a generic data interface for the data provider to read and write data to the application,

receiving, through the ,generic data interface, a plurality of data from the data provider,

receiving a modification to at least one element of the plurality of data from the application, and

saving the modified at least one element to the file, wherein saving the modified at least one element comprises;

providing the modified at least one element of the plurality of data to the data provider, and

receiving a modification to the file associated with the modified at least one element of the plurality of data from the data provider via the ,generic data interface.

7. The computer-readable storage device of claim 6, wherein the file comprise an Open XML file.

8. The non-transitory computer-readable of claim 6, wherein the third party data segment comprises binary data.

9. The computer-readable storage device of claim 6, wherein the file associated with the application comprises a location index for a sub-file, and wherein the third party data segment is stored in the sub-file.

10. The computer-readable storage device of claim 9, further comprising:

receiving a user request to access the third party data segment within the application;

providing the location index of the sub-file to the data provider; and

providing the user access to the third party data segment through the data provider.

11. The computer-readable storage device of claim 6, further comprising providing the generic data interface as a read-write access interface to the data provider from the application, wherein the write-access interface is operative to allow the data provider to read and write data to the file associated with the application.

12. The computer-readable storage device of claim 6, further comprising:

in response to determining that the data provider is not available, not loading the third party data segment into memory.

13. The computer-readable storage device of claim 6, wherein the third party data comprises a database table.

14. The computer-readable storage device of claim 13, wherein the data provider comprises a database engine.

15. The computer-readable storage device of claim 6, wherein the third party data comprises an OLAP cube.

16. The computer-readable storage device of claim 15, wherein the data provider comprises an OLEDB provider.

17. The computer-readable storage device of claim 6, wherein the data provider is operative to connect to a plurality of applications.

18. The computer-readable storage device of claim 6, wherein the connection between the application and the data provider comprises an asynchronous connection.

19. A system for providing access to third party data, the system comprising:

a memory storage; and

a processing unit coupled to the memory storage, wherein the processing unit is operative to;

open a file associated with an application,

determine whether the file comprises at least one third party data segment, wherein the at least one third party data segment comprises binary data,

in response to determining that the file comprises the at least one third party data segment, determine whether a data provider associated with the at least one third party data segment is available,

in response to determining that the data provider associated with the at least one third party data segment is available, establish a connection between the application and the data provider, wherein establishing the connection comprises providing a generic data interface for the data provider to read and write data to the application,

receive a request from a user to access the at least one third party data segment,

provide the generic data interface as a read-write interface between the file and the data provider,

display at least a portion of the at least one third party data segment as defined by the data provider,

receive a modification to the at least one third party data segment from the user,

provide the modification to the at least one third party data segment to the data provider, and

receive an update to the at least one third party data segment stored in the file from the data provider via the generic data interface, wherein the update comprises the modification received from the user.