In distributed data processing, explain two scenarios where vertical partitioning and horizontal partitioning are used.

Distributed Data Processing

The distributed data processing is an arrangement of networked computers in which data processing capabilities are spread across the network. In Distributed data processing several client computers shares the same server. The following are some of the features of Distributed Data Processing

 1. In Distributed Data Processing computers installed at different sites .

2. Each computer in Distributed Data Processing performs independent data processing 

3. Each computer in Distributed Data Processing is specialized to perform wide range of activities.

Horizontal Partitioning

In Horizontal Partitioning, Different applications run on different Systems. The one application replicated on different systems. For Example: Office Automation is used to store office information, raw data storage, electronic transfer, and the management of electronic business information comprises the basic activities of an office. Office automation helps in optimizing or automating existing office procedures. The backbone of office automation is a LAN, which allows users to transmit data, mail and even voice across the network.

Vertical Partitioning:

In vertical partitioning one application is distributed among different systems. For example: Retail chain where some of the restaurants have the chain system etc.