System and method for object persistence in a database store

• US 7,356,546 B2
• Filed: 01/04/2005
• Issued: 04/08/2008
• Est. Priority Date: 10/23/2003
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Sezgin, Beysim, Venkatesh, Ramachandran, Blakeley, Jose A., Altudov, Denis Y.
• Primary Examiner(s): Le; Debbie
• Assistant Examiner(s): Hotelling; Harold A
• Application Number:
  US11/028,783
• Publication Number:
  US 20050120048A1
• Time in Patent Office: 1,190 Days
• Field of Search: None
• US Class Current: 707/812
• CPC Class Codes: G06F 16/24557 Efficient disk access during query execution
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: G06F 9/4493 Object persistence
• CPC Class Codes: Y10S 707/955 Object-oriented
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99936 Pattern matching access
• CPC Class Codes: Y10S 707/99937 Sorting
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

A new persistence format for storing objects of a user defined type in a database store enables information about the structure of the type to be communicated to the store. This information enables a number of store optimizations, including direct structural access to members of the type. Specifically, metadata is exchanged between the type implementer and the data store. The store uses the metadata to determine the storage layout for instances of the type. With this information, the store is able to detect access patterns that can be optimized to directly operate over the storage representation without hydration (deserialization) the object.

Claims

1. A computer-implemented method for persisting an object in a database store, comprising:

creating a definition of a user-defined type of an object that is persisted in the database store, wherein the definition of the user-defined type comprises fields and methods, each field of the definition of the type user-defined comprising one or more storage facets;

annotating at least one field of the definition of the user-defined type with a first attribute that controls said one or more storage facets of the field;

annotating at least one method with a second attribute that denotes an equivalent structural access path; and

wherein the database store uses the annotations in the definition of the user-defined type to control the storage layout of instances of the user-defined type in the database store.

2. The computer-implemented method recited in claim 1, wherein said one or more storage facets of the field that are controlled by the first attribute comprise at least one of the maximum size of the field, whether the field length is fixed or variable the field is fixed length, the precision of the field, the scale of the field, and when values of the field are null.

3. The computer-implemented method recited in claim 1, wherein the second attribute specifies the name of a field of the user-defined type that is the subject of the method.

4. The computer-implemented method of claim 1, wherein the definition of the user-defined type is created as a class in managed code.