Re: Oracle vs Informix comparison

In <58dqco$pbo@cssun.mathcs.emory.edu> billy@west.co.za ("Billy Wheeler") writes: > >Hi Thomas, > >This was an interesting post. Do you mind if I ask for some >clarification? > >On 7 Dec 96 at 19:51, tkyte@us.oracle.com wrote: > >> At some point in time after the application commits, the system will pick up the >> changes.... >> propagated correctly. > >Do you have any control over the timing of this? Yes, you do. The propagation can be done on-demand (typically if your remote sites are not always connected , say a salesman on the road with his laptop>>) or can be at pre-defined intervals (from seconds/minutes to every monday to more complex combinations. > >> - the stored procedures/triggers, being system generated and managed, cause as >> many applicatoin level mess-ups as do primary keys, foreign keys, check >> constraints, etc. Just another constraint. > >This is *very* interesting - you as a developer don't have to code the >sp's/triggers? How do you specify what must get replicated and where >to? What happens if you add new servers which must also be updated? > You create a replication group where in you identify the objects to be replicated. These objects are the tables/views of your interest which need to be replicated. Once these objects are identified, you generate what Oracle calls as 'Replication Support' which creates the triggers, stored proceduers.. Raj