Distributed Databases
https://www.tutorialspoint.com/distributed_dbms/distributed_dbms_database_environments.htm
© 2005 by Prentice Hall 1
, Objectives
Definition of terms
Explain business conditions driving distributed
databases
Describe salient characteristics of distributed
database environments
Explain advantages and risks of distributed databases
Explain strategies and options for distributed
database design
Discuss synchronous and asynchronous data
replication and partitioning
Discuss optimized query processing in distributed
databases
Explain salient features of several distributed
database management systems
Chapter 13 © 2005 by Prentice Hall 2
,Distributed database system
A distributed database is a collection of multiple, logically interrelated
databases distributed over a computer network.
A distributed database management system (DDBMS) is a software
system that permits the management of the distributed databases
and makes the distribution transparent to the users.
Chapter 13 © 2005 by Prentice Hall
, Definitions
Distributed Database: A single
logical database that is spread
physically across computers in multiple
locations that are connected by a data
communications link
Decentralized Database: A collection
of independent databases on non-
networked computers
They are NOT the same thing!
Chapter 13 © 2005 by Prentice Hall 4
https://www.tutorialspoint.com/distributed_dbms/distributed_dbms_database_environments.htm
© 2005 by Prentice Hall 1
, Objectives
Definition of terms
Explain business conditions driving distributed
databases
Describe salient characteristics of distributed
database environments
Explain advantages and risks of distributed databases
Explain strategies and options for distributed
database design
Discuss synchronous and asynchronous data
replication and partitioning
Discuss optimized query processing in distributed
databases
Explain salient features of several distributed
database management systems
Chapter 13 © 2005 by Prentice Hall 2
,Distributed database system
A distributed database is a collection of multiple, logically interrelated
databases distributed over a computer network.
A distributed database management system (DDBMS) is a software
system that permits the management of the distributed databases
and makes the distribution transparent to the users.
Chapter 13 © 2005 by Prentice Hall
, Definitions
Distributed Database: A single
logical database that is spread
physically across computers in multiple
locations that are connected by a data
communications link
Decentralized Database: A collection
of independent databases on non-
networked computers
They are NOT the same thing!
Chapter 13 © 2005 by Prentice Hall 4