Chapter 23, Problem 1PE

Program Plan Intro

Distributed database:

A distributed database is a database that comprises of two or more files situated in various destinations either on a similar system or on altogether various systems. This database can be stored on different storage devices and processing is distributed among multiple databases.

Local Area Network:

• Local area network is a network that covers a small geographical area such as homes, offices and groups of buildings.
• Local Area Network has higher bandwidth rates.
• It runs at a bandwidth speed of 100 Mbps, 1Gbps or 10 Gbps.
• The network speed which is the speed in which data packets are transported is faster for LAN than for a WAN.

Wide Area Network:

• Wide area network is a network that covers large geographical areas that can span the globe.
• Wide area network has lower bandwidth rates compared with local area network.
• Wide area networks run on bandwidth of 20 Mbps, 50 Mbps or 100 Mbps.
• The network speed which is the speed in which data packets are transported is slower for WAN.

Explanation of Solution

Key differences between a local-area network and a wide-area network, that affect the design of a distributed database:

Local Area Network	Wide Area Network
LAN is used in private areas	WAN is used in public areas
The data transfer rate is higher for LAN than for a WAN	The data transfer rate is slower for WAN
The throughput cannot be raised through replication and fragmentation	The throughput can be raised through replication and fragmentation
The maintenance cost for a LAN is lower as it covers only smaller areas.	The maintenance cost for a WAN is higher as it covers larger areas.
LAN has less congestion compared to WAN	WAN has more congestion compared to LAN