Systems and methods for a large object infrastructure in a database system

• US 7,437,346 B2
• Filed: 02/10/2004
• Issued: 10/14/2008
• Est. Priority Date: 02/10/2004
• Status: Expired due to Fees

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Stefani, Stefano, Ashwin, Shrinivas, Surna, Aleksandras, Kleinerman, Christian, Fang, Jun, Kalhan, Ajay, Blakeley, Jose A., Zhang, Honggang, Carlin, Peter
• Primary Examiner(s): Lee; Wilson
• Assistant Examiner(s): HO, BINH VAN
• Application Number:
  US10/776,664
• Publication Number:
  US 20050187893A1
• Time in Patent Office: 1,708 Days
• Field of Search: 707/103, 707/6, 707/102, 707/1
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24562 Pointer or reference processing operations
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99936 Pattern matching access
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

Various embodiments of the present invention are direct to the utilization of Blob Handles (BHs) which are an internal representation of a large value. BHs are immutable and stateless references to a large data object. The structure of a BH contains enough information to return an ILockBytes interface in order to provide access to the corresponding large data block, and a BH can also return information regarding its own lifetime description. A BH can be completely described using (a) a pointer to the beginning of BH data and (b) the byte-length of the BH.

Claims

1. A method for handling a large data object in a database system implemented in a computer system, said method comprising:

creating a handling structure comprising;

a reference to locate the large data object stored in the database system, the reference being configured to point to a small value data object within the handling structure itself provided that the small value data object is stored entirely within the handling structure;

information to return an interface to provide access to the large data object in the database system; and

a field having a value indicative of a length of time during which the handling structure is valid,

wherein partial update of the large data object referenced by the handling structure is processed by replacing only a portion of the large data object without updating the large data object in its entirety to avoid substantial negative impact on overall performance of the database system.

2. The method of claim 1 wherein a data object having a type from a group of types consisting of text, ntext, and image data types is converted into a large data object with a corresponding handling structure.

3. The method of claim 1 wherein a data object having a type from a first group of types consisting of text, ntext, and image data type is converted into a data object having a type from a second group of types consisting of varchar(MAX), nvarchar(MAX), and varbinary(MAX) data types respectively, the varchar(MAX), nvarehar(MAX), and varbinary(MAX) data types each comprising a handling structure and a MAX corresponding to a predetermined maximum size value.

4. The method of claim 1 wherein said handling structure is created by a handling structure factory in response to a need for a handling structure.

5. A system for handling a large data object in a database system implemented in a computer system, said system comprising:

a subsystem comprising a server computer for creating a handling structure Comprising;

a reference to locate the large data object stored in the database system, the reference being configured to point to a small value data object within the handling structure itself provided that the small value data object is stored entirely within the handling structure;

information to return an interface to provide access to the large data object in the database system; and

a field having a value indicative of a length of time during which the handling structure is valid;

wherein partial update of the large data object referenced by the handling structure is processed by replacing only a portion of the large data object without updating the large data object in its entirety to avoid substantial negative impact on overall performance of the database system.

6. The system of claim 5 wherein a data object having a type from a group of types consisting of text, ntext, and image data types is converted into a large data object with a corresponding handling structure.

7. The system of claim 5 wherein a data object having a type from a first group of types consisting of text, ntext, and image data type is converted into a data object having a type from a second group of types consisting of varchar(MAX), nvarchar(MAX), and varbinary(MAX) data types respectively, the varchar(MAX), nvarchar(MAX), and varbinary(MAX) data types each comprising a handling structure and a MAX corresponding to a predetermined maximum size value.

8. The system of claim 5 wherein said handling structure is created by a handling structure factory in response to a need for a handling structure.

9. A computer-readable storage medium comprising computer-readable instructions for handling a large data object in a database system implemented in a computer system, said computer-readable instructions causing the computer system to perform a method comprising:

creating a handling structure comprising;

a reference to locate the large data object stored in the database system, the reference being configured to point to a small value data object within the handling structure itself provided that the small value data object is stored entirely within the handling structure;

information to return an interface to provide access to the large data object in the database system; and

a field having a value indicative of a length of time during which the handling structure is valid;

wherein partial update of the large data object referenced by the handling structure is processed by replacing only a portion of the large data object without updating the large data object in its entirety to avoid substantial negative impact on overall performance of the database system.

10. The computer-readable storage medium of claim 9, wherein the method further comprises:

converting into a large data object with a corresponding handling structure, a data object having a type from a group of types consisting of text, ntext, and image data types.

11. The computer-readable storage medium instructions of claim 9, wherein the method further comprises converting a data object into a large data object, wherein:

in an event that the data object is of a type, text, the data object is converted into a large data object of a type varchar(MAX);

in an event that the data object is of a type, ntext, the data object is converted into a large data object of a type nvarchar(MAX); and

in an event that the data object is of a type, image, the data object is converted into a large data object of a type varbinary(MAX), wherein the varchar(MAX), nvarchar(MAX), and varbinary(MAX) data types each comprise a handling structure type and a MAX value corresponding to a predetermined maximum size value.

12. The computer-readable storage medium of claim 9, wherein said handling structure is created by a handling structure factory in response to a need for a handling structure.