EBK DATABASE SYSTEM CONCEPTS
EBK DATABASE SYSTEM CONCEPTS
7th Edition
ISBN: 9781260049268
Author: SILBERSCHATZ
Publisher: MCG COURSE
Question
Book Icon
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!
Students have asked these similar questions
using r language for integration theta = integral 0 to infinity (x^4)*e^(-x^2)/2 dx (1) use the density function of standard normal distribution N(0,1) f(x) = 1/sqrt(2pi) * e^(-x^2)/2 -infinity <x<infinity as importance function and obtain an estimate theta 1 for theta set m=100 for the estimate whatt is the estimate theta 1? (2)use the density function of gamma (r=5 λ=1/2)distribution f(x)=λ^r/Γ(r) x^(r-1)e^(-λx) x>=0 as importance function and obtain an estimate theta 2 for theta set m=1000 fir the estimate what is the estimate theta2? (3) use simulation (repeat 1000 times) to estimate the variance of the estimates theta1 and theta 2 which one has smaller variance?
using r language A continuous random variable X has density function f(x)=1/56(3x^2+4x^3+5x^4).0<=x<=2 (1) secify the density g of the random variable Y you find for the acceptance rejection method. (2) what is the value of c you choose to use for the acceptance rejection method (3) use the acceptance rejection method to generate a random sample of size 1000 from the distribution of X .graph the density histogram of the sample and compare it with the density function f(x)
using r language a continuous random variable X has density function f(x)=1/4x^3e^-(pi/2)^4,x>=0  derive the probability inverse transformation F^(-1)x where F(x) is the cdf of the random variable X
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education