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

公开(公告)号：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.