| |
GeekInterview.com > Tech FAQs > Data Warehousing
| Print | |
Question: Replicate vs Broadcast
Answer: What is the difference between replicate and broadcast ? |
| September 09, 2009 13:02:53 |
#1 |
| zann1 |
Member Since: September 2009 Total Comments: 2 |
RE: Replicate vs Broadcast
|
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. |
| |
Back To Question | |
