公开(公告)号：WO2007024376A2

公开(公告)日：2007-03-01

申请号：PCT/US2006/028346

申请日：2006-07-20

Applicant: MICROSOFT CORPORATION

Inventor： GERBER, Robert H. ,  RAMAN, Balan S. ,  HAMILTON, James R. ,  LUDEMAN, John F. ,  KRISHNA, Murali M. ,  SMITH, Samuel H. ,  ASHWIN, Shrinivas

IPC: G06F7/00

CPC classification number: G06F17/30362 ,  G06F11/2094 ,  G06F11/2097 ,  G06F2201/80

Abstract: Mechanisms and techniques for database fragment cloning and management are provided. A database object, such as a table or index, is divided into fragments. Each fragment is cloned to create cloned fragments, which operationally are identical to one another. One or more of the cloned fragments may be designated as a primary cloned fragment for performing database operations or as a secondary cloned fragment for serving as backup. Updates to each fragment are implemented on the primary cloned fragment and then propagated from the primary cloned fragment to the corresponding secondary cloned fragments. A cloned fragment can go offline; unavailable to be updated. When the cloned fragment returns online, it is refreshed with data included in the primary cloned fragment. While being refreshed, the cloned fragment may be updated. The cloned fragment is eligible to be designated as a primary cloned fragment when the refreshing process has been completed.

Abstract translation: 提供了数据库片段克隆和管理的机制和技术。 数据库对象（如表或索引）被划分为片段。 克隆每个片段以产生克隆的片段，其在操作上彼此相同。 一个或多个克隆的片段可以被指定为用于执行数据库操作的主要克隆片段或作为备份的辅助克隆片段。 对每个片段的更新在主要克隆片段上实现，然后从主要克隆片段扩增到相应的次级克隆片段。 克隆片段可以脱机; 无法更新。 当克隆的片段返回在线时，它将使用包含在主要克隆片段中的数据进行刷新。 刷新时，可以更新克隆的片段。 当刷新过程完成时，克隆片段有资格被指定为主要的克隆片段。

公开(公告)号：WO2005083594A1

公开(公告)日：2005-09-09

申请号：PCT/US2004/024461

申请日：2004-07-29

Applicant: MICROSOFT CORPORATION ,  ASHWIN, Shrinivas ,  BLAKELY, Jose, A. ,  CARLIN, Peter ,  FANG, Jun ,  KALHAN, Ajay ,  KLEINERMAN, Christian ,  STEFANI, Stefano ,  SURNA, Aleksandras ,  ZHANG, Honggang

Inventor： ASHWIN, Shrinivas ,  BLAKELY, Jose, A. ,  CARLIN, Peter ,  FANG, Jun ,  KALHAN, Ajay ,  KLEINERMAN, Christian ,  STEFANI, Stefano ,  SURNA, Aleksandras ,  ZHANG, Honggang

IPC: G06F17/30

CPC classification number: G06F17/30504 ,  Y10S707/99931 ,  Y10S707/99936 ,  Y10S707/99943

Abstract: Various embodiments of the present invention are direct to the utilization of Blob Handles (BHs) (item 300) 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 (item 300) 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.

Abstract translation: 本发明的各种实施例直接利用作为大值的内部表示的Blob句柄（BH）（项目300）。 BH是不可变的和无状态的。对大数据对象的引用。 BH（项目300）的结构包含足够的信息以返回ILockBytes接口，以便提供对相应的大数据块的访问，并且BH还可以返回关于其自身寿命描述的信息。 可以使用（a）指向BH数据的开始的指针和（b）BH的字节长度来完全描述BH。

公开(公告)号：EP1915668A2

公开(公告)日：2008-04-30

申请号：EP06800192.4

申请日：2006-07-20

Applicant: Microsoft Corporation

Inventor： GERBER, Robert H. ,  RAMAN, Balan S. ,  HAMILTON, James R. ,  LUDEMAN, John F. ,  KRISHNA, Murali M. ,  SMITH, Samuel H. ,  ASHWIN, Shrinivas

IPC: G06F7/00

CPC classification number: G06F17/30362 ,  G06F11/2094 ,  G06F11/2097 ,  G06F2201/80

Abstract: Mechanisms and techniques for database fragment cloning and management are provided. A database object, such as a table, rowset or index, is divided into fragments. Each fragment is cloned to create cloned fragments, which operationally are substantially identical to one another. One or more of the cloned fragments may be designated as a primary cloned fragment for performing database operations or as a secondary cloned fragment for serving as backup. Updates to each fragment are implemented on the primary cloned fragment and are then propagated from the primary cloned fragment to the corresponding secondary cloned fragments. A cloned fragment can go offline, becoming unavailable to be updated. When the cloned fragment returns online, the cloned fragment is refreshed with data included in the primary cloned fragment. While being refreshed, the cloned fragment may continue to be updated. The cloned fragment is eligible to be designated as a primary cloned fragment when the refreshing process has been completed.