Database Management Systems II - Prof. Holowczak

Zicklin School of Business - Baruch College
City University of New York

Database Management Systems II


Distributed DBMS

What You'll Learn This Week

Distributed Database Architecture

Distributed Database Architecture

Elmasri/Navathe (3rd ed.) Connolly and Begg (3rd ed.) McFadden (6th ed.)
Chapter 24 Chapters 22 and 23 Chapter 13

Classifying DDBMS

Data Distribution - Data Fragmentation and Replication

Customer Table
Customer IDNameAddressCityStateZip
1001 Mr. Smith 123 Lexington Smithville KY 91232
1002 Mrs. Jones 12 Davis Ave. Smithville KY 91232
1003 Mr. Axe 443 Grinder Ln.Broadville GA 81992
1004 Mr. Builder 661 Parker Rd.Streetville GA 81990

Horizontal Partitioning:
Partition 1
Customer ID  Name        Address          City        State  Zip
1001         Mr. Smith   123 Lexington    Smithville  KY     91232
1002         Mrs. Jones  12 Davis Ave.    Smithville  KY     91232
Partition 2
Customer ID  Name        Address          City        State  Zip
1003         Mr. Axe     443 Grinder Ln.  Broadville  GA     81992 
1004         Mr. Builder 661 Parker Rd.   Streetville GA     81990

Vertical Partitioning:
Partition 1
CustID  Name             
1001    Mr. Smith
1002    Mrs. Jones
1003    Mr. Axe
1004    Mr. Builder
Partition 2
CustID  Address          City        State  Zip
1001    123 Lexington    Smithville  KY     91232
1002    12 Davis Ave.    Smithville  KY     91232
1003    443 Grinder Ln.  Broadville  GA     81992 
1004    661 Parker Rd.   Streetville GA     81990

Degree of heterogeneity/homogeneity

Degree of Autonomy

Degree of Distribution Transparency

DDBMS Query Processing and Optimization

DDBMS Concurrency Control

DDBMS Transaction Processing


File: ddb_index.html Date: Mon Dec 2 10:18:41 EST 2002
All materials Copyright, 1997-2002 Richard Holowczak