Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!oleane.net!oleane!newspump.monmouth.com!newspeer.monmouth.com!news-east.rr.com!news.rr.com!news-server.columbus.rr.com!tornado.ohiordc.rr.com.POSTED!53ab2750!not-for-mail From: Jay Dee User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.2) Gecko/20040803 X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.theory Subject: Re: trying to mirror a db References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 17 Message-ID: Date: Tue, 04 Apr 2006 02:10:50 GMT NNTP-Posting-Host: 24.123.195.58 X-Complaints-To: abuse@rr.com X-Trace: tornado.ohiordc.rr.com 1144116650 24.123.195.58 (Mon, 03 Apr 2006 22:10:50 EDT) NNTP-Posting-Date: Mon, 03 Apr 2006 22:10:50 EDT Organization: Road Runner High Speed Online http://www.rr.com Xref: dp-news.maxwell.syr.edu comp.databases.theory:37765 Ike wrote: > If I have two databases, A and B, each with only one table, and the tables > are supposed to miror each other (yet, B gets interacted with independent of > A, and vice versa) and the table in A has a field for the timestamp of last > activity for each record, as well as a field for the corresponing id of each > record in B that the record in A corresponds to. > > I am trying to discern an alogirthm for maintining these two tables to be > concurrent with each other. Does anyone have any ideas, given the > description above for an algorithm to do this? > > Thanks, Ike > > The answers you're looking for can be found by looking-up "distributed database" and "two-phase commit."