dbTalk Databases Forums  

Enterprise Replication

comp.databases.informix comp.databases.informix


Discuss Enterprise Replication in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tom Lehr
 
Posts: n/a

Default Enterprise Replication - 11-16-2011 , 08:54 AM






Hello All

Fairly new to the ER world and when i peruse the catalog for ER
training it mentions this:

-Database Design Issues

- Correct database design issues that can negatively impact
replication: Serial keys, Cascading deletes, Triggers, Accumulators


What are Accumulators?


Thanks

Reply With Quote
  #2  
Old   
Superboer
 
Posts: n/a

Default Re: Enterprise Replication - 11-22-2011 , 02:14 PM






Hello Tom,

afaikr an example

update account set balance=balance-100
where customer_num = 123

This can be hazardous in ER with update anywhere.

one could translate it into an insert into withdrawal values (123,
-100, .....);

Superboer.



On 16 nov, 15:54, Tom Lehr <tomc... (AT) gmail (DOT) com> wrote:
Quote:
Hello All

Fairly new to the ER world and when i peruse the catalog for ER
training it mentions this:

*-Database Design Issues

* * - Correct database design issues that can negatively impact
replication: Serial keys, Cascading deletes, Triggers, Accumulators

What are Accumulators?

Thanks

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.