![[assets/ex_broadcast.png|256]] - **Description**: Broadcast operations distribute data from one node to all other nodes in a distributed database system. This is often used in join operations where a small table is sent to all nodes to join with a larger, distributed table. - **Performance**: Can be network-intensive, especially with large datasets. - **Factors**: Size of the dataset being broadcast, network bandwidth, number of nodes. - **Cost**: `network_transfer_cost * size_of_data * number_of_nodes` - ![[assets/ex_broadcast_motion.svg|200]] - **Operates on**: [[Structures/Result Set]] - **Workloads**: - [[Workloads/IPC]] - [[Workloads/Sub/MessageQueueSend]] - [[Workloads/Sub/MessageQueueReceive]] - [[Workloads/LWLock]] - [[Workloads/Sub/ParallelQueryDSA]]