Two-way mirroring

[Terry Herrin <therrin@xxxxxxxxx>]

"Edward Koziol" <koziol@chaney.net> wrote:
>They can do it and so can DataMirror...

It would be interesting to know how these products handle multiple
updates to the same data.  For example, if system A updates a field in
a record with value "X", and system B updates that same field and
record with value "Y", what value are you going to use when you go to
resynch the databases later?  Are you going to compare the journal
entries from both systems to determine which update happened later,
and then use that value?  Or what if system A deletes a record that
was updated by system B?  Do we just delete that record and not bother
with why system B was doing an update to it?  Whatever choices are
made in the above examples, assumptions will be made according to a
set of rules.  How am I to know those rules are the way I want my data
to behave?  This sounds like it would be a great thing to have, but to
me it opens up a whole Pandora's box of issues.

Terry Herrin
Sr. Programmer/Analyst
New Hanover Regional Medical Center
Wilmington, NC
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---