Re: GUID as primary key

Billy schrieb am 21.06.2005 in
<1119337733.392352.219550_at_g44g2000cwa.googlegroups.com>:

> Andreas Mosmann wrote:

>> way they work is, that everyone has his own database and 12 times a year
>> the snapshots are given to build a unique database. Besides you have to
>> put all the historical data (I do not know the exact english phrase) to
>> all small databases. Because of that never happens at the same time it
>> is a hard work to build this database (consistent).
>> There must be another solution.

> Replication. Materialised views. Oracle supports various type of
> replication designs - including having multiple masters. This is one
> option. There are many more, including RAC for HA.

Surely you are right. But we all in our team are developers and not DBAs, so we only heard about it. Nobody in our team knows enough to handle Replication etc. and so we decided to do so.

> It makes a lot more sense to me to buy HA off-the-shelf and use it,
> then to attempt to roll your own at client application side. HA is IMO
> too complex for the ordinary app developer to grok, never mind to do it
> right in his/her code.

Hope we solve it and you will not be right in that point ;)

Thank you

> --
> Billy

Andreas

-- 
wenn email, dann AndreasMosmann <bei> web <punkt> de