Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Question
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.

Expert Solution & Answer
Check Mark

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 NetworkWide Area Network
LAN is used in private areasWAN is used in public areas
The data transfer rate is higher for LAN than for a WANThe data transfer rate is slower for WAN
The throughput cannot be raised through replication and fragmentationThe 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 WANWAN has more congestion compared to LAN

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Knowledge Booster
Recommended textbooks for you
  • Database System Concepts
    Computer Science
    ISBN:9780078022159
    Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
    Publisher:McGraw-Hill Education
    Starting Out with Python (4th Edition)
    Computer Science
    ISBN:9780134444321
    Author:Tony Gaddis
    Publisher:PEARSON
    Digital Fundamentals (11th Edition)
    Computer Science
    ISBN:9780132737968
    Author:Thomas L. Floyd
    Publisher:PEARSON
  • C How to Program (8th Edition)
    Computer Science
    ISBN:9780133976892
    Author:Paul J. Deitel, Harvey Deitel
    Publisher:PEARSON
    Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781337627900
    Author:Carlos Coronel, Steven Morris
    Publisher:Cengage Learning
    Programmable Logic Controllers
    Computer Science
    ISBN:9780073373843
    Author:Frank D. Petruzella
    Publisher:McGraw-Hill Education
  • Database System Concepts
    Computer Science
    ISBN:9780078022159
    Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
    Publisher:McGraw-Hill Education
    Starting Out with Python (4th Edition)
    Computer Science
    ISBN:9780134444321
    Author:Tony Gaddis
    Publisher:PEARSON
    Digital Fundamentals (11th Edition)
    Computer Science
    ISBN:9780132737968
    Author:Thomas L. Floyd
    Publisher:PEARSON
    C How to Program (8th Edition)
    Computer Science
    ISBN:9780133976892
    Author:Paul J. Deitel, Harvey Deitel
    Publisher:PEARSON
    Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781337627900
    Author:Carlos Coronel, Steven Morris
    Publisher:Cengage Learning
    Programmable Logic Controllers
    Computer Science
    ISBN:9780073373843
    Author:Frank D. Petruzella
    Publisher:McGraw-Hill Education