Remote storage and management of binary object data

• US 8,250,102 B2
• Filed: 03/14/2008
• Issued: 08/21/2012
• Est. Priority Date: 03/14/2008
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Madhavarapu, Pradeep Jnana, Kumar, Rohan, Farlee, Kevin G., Raman, Balan Sethu, Warmington, Michael J
• Primary Examiner(s): Ehichioya, Fred I
• Assistant Examiner(s): TRAN, ANHTAI V
• Application Number:
  US12/048,753
• Publication Number:
  US 20090234880A1
• Time in Patent Office: 1,621 Days
• Field of Search: None
• US Class Current: 707/792
• CPC Class Codes: G06F 16/13 File access structures, e.g. distributed indices arrangements of input from, or output to, record carriers G06F3/06
• CPC Class Codes: G06F 16/93 Document management systems

Abstract

Embodiments described herein are directed to the accessing remotely stored binary object data in a binary object store. In one embodiment, a computer system receives a request for a portion of binary object data, sends a query to a database server requesting access to the binary object data, and receives a binary object reference. The binary object reference includes binary object identification data and use characteristics specific to the binary object store. The computer system sends a binary object data access request based on the binary object reference to the binary object store using a binary object store interface, and receives the binary object data corresponding to the binary object data access request. The binary object data comprises a portion of data files. The computer system also sends the received binary object data to the user.

Claims

1. A method for reducing processing loads in order to increase data transfer rates of a database server, wherein the database server responds to requests for data from an application server, and wherein the database server maintains references to binary objects stored within a binary object store that is separate from the database server, the method comprising:

an application server receiving a request from a user for a portion of binary object data;

the application server sending a query to the database server requesting access to the binary object data, wherein the database server maintains a reference to the binary object which is remotely stored in a binary object store which is separate from the database server;

the application server receiving from the database server the binary object reference, the binary object reference including binary object identification data and use characteristics specific to the binary object store, wherein the use characteristics include a data storage format of the binary object store and data access protocols for accessing data at the binary object store such that the application server may access binary object data from a plurality of binary object stores each having distinct data storage formats and data access protocols;

rather than requiring the database server to retrieve the binary object data, the application server sending a binary object data access request based on the binary object reference and the use characteristics directly to the separate binary object store using a binary object store interface, wherein the binary object store interface interprets the use characteristics to communicate with a particular binary object store using a particular data storage format and data access protocol among the plurality of distinct data storage formats and data access protocols;

the application server receiving from the binary object store the binary object data corresponding to the binary object data access request, the binary object data comprising a portion of one or more data files and wherein the application server did not need to interpret the particular data storage format and data access protocol; and

the application server sending the received binary object data to the user.

2. The method of claim 1, further comprising storing binary object data in at least one of a plurality of binary object stores, each binary object store comprising at least one of a plurality of binary object store types, each binary object being immutable.

3. The method of claim 1 wherein the binary object identification data identifies which particular binary object store of a plurality of binary object stores the binary object is located in.

4. The method of claim 1, wherein binary object references are stored in application tables on the database server.

5. The method of claim 1, further comprising requesting a plurality of binary object references in the same request.

6. The method of claim 1, further comprising receiving binary object locator information, the binary object locator information comprising location information that allows an application server in a multi application server environment to access and receive binary object data directly from the binary object store.

7. The method of claim 1, further comprising:

an act of determining that a data file is to be stored on the database server, the data file including at least a portion of binary object data and a portion of associated metadata;

an act of separating the binary object data from the portion of associated metadata;

an act of storing the binary object data in the binary object store, the binary object data being linked to the associated metadata stored on the database server.

8. The method of claim 1, further comprising:

an act of receiving authentication credentials corresponding to the user; and

an act of integrating both the received the binary object reference and the authentication credentials into a software object for secure access to the binary object data from the binary object store.

9. A computer program product comprising one or more computer-readable hardware storage devices having encoded thereon computer-executable instructions which, when executed upon one or more computer processors, performs a method for an application server to access binary object data which is remotely stored in a binary object store, wherein a database server which maintains references to binary objects stored within the binary object store is separate from the binary object store thereby separating the burden of interpreting data requests and accessing data, the method comprising the method of claim 1.

10. The method of claim 3, further comprising:

an act of sending a second request to the database server for a binary object store-specific binary object ID;

an act of receiving a binary object store-specific binary object ID from the database server.

11. The method of claim 8, wherein the binary object data access request is based on the authentication credentials and identification data in the binary object reference.

12. The method of claim 8, wherein binary object store authentication is managed by at least one of an operating system, a software application and the data server.

13. The method of claim 11, wherein the binary object data is accessible by the database server using the authentication credentials and identification data.

14. A method for an application server to access binary large object (blob) data which is remotely stored in a blob store, wherein a database server which maintains references to blobs stored within the blob store is separate from the blob store thereby separating the burden of interpreting data requests and accessing data, the method being performed in a computer system in a computer networking environment including the application server, the database server, a client communication interface, a blob store interface and the blob store, the method comprising:

an application server receiving from a user a request for a portion of blob data

the application server sending a query to the database server requesting access to the blob data, wherein the database server maintains a reference to the blob data which is remotely stored in a blob store which is separate from the database server;

the application server receiving a blob reference from the database server, the blob reference including blob identification data and one or more use characteristics specific to the blob store, wherein the use characteristics include each of a data storage format of the blob store and a proprietary data access protocol for accessing data at the blob store such that the application server may access binary object data from a plurality of blob stores each having distinct data storage formats and data access protocols;

the application server passing the received blob reference to a client communication interface configured to communicate with a blob store interface;

passing the blob reference from the client communication interface to the blob store interface, the blob store interface being configured to interpret blob references and request blob data directly from the blob store according to the use characteristics of the blob store, wherein the blob store interface interprets the use characteristics to communicate with a particular blob store using a particular data storage format and data access protocol among the plurality of distinct data storage formats and data access protocols;

sending to the blob store a blob data access request based on the identification data in the blob reference using the blob store interface and using the proprietary data access protocol;

receiving from the blob store the blob data corresponding to the blob data access request at the blob store interface, the blob data comprising a portion of one or more data files;

passing the received blob data from the blob store interface to the client communication interface;

passing the received blob data to the application server; and

the application server sending the received blob data to the user.