Examples, calculation parameters

These calculations use the following assumptions about the example replication system:

Tables T1 and T2 are in database DB1.
Table T3 is in database DB2.
All three tables are replicated to sites S1, S2, and S3.
The parameters are shown in the following tables (note that not all messages are replicated to all sites).

**Table A-1: Table parameters**
Database	Table	# Cols	Columns changed	Change rate (num/sec)	Row width (bytes)	Row width changed	# Sites
DB1	T1	10	5	20	200	100	3
DB1	T2	10	5	10	400	200	2
DB2	T3	120	100	2	1500	1000	2

**Table A-2: Site parameters—table replication selectivity**
Table	Percent of updates to S1	Percent of updates to S2	Percent of updates to S3
T1	10%	40%	40%
T2	40%	80%	0%
T3	20%	0%	20%

**Table A-3: Transaction rates**
Transaction rate	DB1	DB2	S1	S2	S3
Inbound	20/sec	20/sec	-	-	-
Outbound	-	-	5/sec	10/sec	8/sec