zann1

 Profile Answers by zann1 

• Sep 7th, 2009

 

Replication moves data to a specified target, usually at a specified time, and usually is usually defined by the ETL team or DBA. Broadcast moves data to targets in the system as needed, and is usually done by the dbms itself. 

Broadcasting usually refers to partitioned databases copying data from one partition to another in order to service a join requested by a query.

e.g. You may set up replication to copy a small lookup table to all partitions in order to avoid the dbms broadcasting it to every partition as needed. This remove the overhead of moving the data needed for common joins from the query execution time.

chandana

• Sep 21st, 2011

 

replicate supports the component parallelism and broadcast supports data parallelism i.e fan-out,all-to-all.