Method and apparatus for preserving dependancies during data...

Details Method and apparatus for preserving dependancies during data... Method and apparatus for preserving dependancies during data...

2004-11-01

2010-10-05

Mofiz, Apu M (Department: 2161)

Data processing: database and file management or data structures

Database design

Database and data structure management

C707S752000, C707S809000

Reexamination Certificate

active

07809764

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.

REFERENCES:
patent: 5581753 (1996-12-01), Terry et al.
patent: 6154816 (2000-11-01), Steely et al.
patent: 6370681 (2002-04-01), Dellarocas et al.
patent: 7240054 (2007-07-01), Adiba et al.
patent: 7363633 (2008-04-01), Goldick et al.
patent: 7386752 (2008-06-01), Rakic et al.
patent: 2004/0268302 (2004-12-01), Srivastava et al.
patent: 2005/0193041 (2005-09-01), Bourbonnais et al.
patent: 2005/0262432 (2005-11-01), Wagner
Rolfe, Timothy; “Mar02: Algorithm Alley: Graph Traversals”; Mar. 1, 2002; Architecture & Design; pp. 1-6 http://www.ddj.com/architect/184404999?pgno=1.

Affiliated with

Also associated with

Rating

Method and apparatus for preserving dependancies during data... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and apparatus for preserving dependancies during data..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for preserving dependancies during data... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4158311