Invention Grant
US07809764B2 Method and apparatus for preserving dependancies during data transfer and replication
有权
在数据传输和复制期间保留依赖关系的方法和装置
- Patent Title: Method and apparatus for preserving dependancies during data transfer and replication
- Patent Title (中): 在数据传输和复制期间保留依赖关系的方法和装置
-
Application No.: US10979855Application Date: 2004-11-01
-
Publication No.: US07809764B2Publication Date: 2010-10-05
- Inventor: Wing Chit Mak
- Applicant: Wing Chit Mak
- Applicant Address: US WA Redmond
- Assignee: Microsoft Corporation
- Current Assignee: Microsoft Corporation
- Current Assignee Address: US WA Redmond
- Agency: Woodcock Washburn LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
Database objects, having interdependent relationships, are transferred for replication from a publisher to a subscriber in the order of a topological sort using a depth first search algorithm. When the depth first search algorithm attempts to enumerate all outgoing edges (dependencies) of a given node (database object), a request is made to begin an atomic transaction and then a temporary copy (e.g., via a T-SQL command) of the node/database object is created under a different name. The temporary copy is used to store dependency information that could otherwise be impaired by the replication process. Dependencies amongst database objects are thus preserved during the replication process through use of the temporary copy, as well as by transferring the database objects according to the topological sort order.
Public/Granted literature
- US20060101452A1 Method and apparatus for preserving dependancies during data transfer and replication Public/Granted day:2006-05-11
Information query