chapter09

chapter09 - Concepts of Database Concepts of Database...

Info iconThis preview shows pages 1–12. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Concepts of Database Concepts of Database Management, Fifth Edition Management, Fifth Edition Chapter 9: Chapter 9: Database Management Database Management Approaches Approaches 2 9 Objectives ◆ Describe distributed DBMSs ◆ Discuss client/server systems ◆ Define data warehouses and explain their structure and access ◆ Discuss the general concepts of object- oriented DBMSs 3 9 Objectives ◆ Summarize the impact of Web access to databases ◆ Provide a brief history of database management ◆ Describe the network and hierarchical data models 4 9 Distributed Databases ◆ Computers at various sites ◆ Connected with communications network ◆ Distributed database is single logical database physically divided among networked computers ◆ DDBMS supports and manipulates distributed databases 5 9 Figure 9.1: Communications Network 6 9 Characteristics of Distributed DBMSs ◆ Homogeneous ● Same local DBMS at each site ◆ Heterogeneous ● At least two sites with different DBMSs 7 9 Characteristics of Distributed DBMSs (con’t.) ◆ Location transparency ● User feels as though entire database is at their site ◆ Replication transparency ● User unaware of behind the scenes replication of the data ◆ Fragmentation transparency ● Logical object divided among various locations 8 9 Unfragmented Parts Table 9 9 Fragmented Parts Table 10 9 Advantages of Distributed Databases ◆ Local control of data ● Possible legal reasons for local control over data used in a particular geographic region ◆ Increased database capability ◆ Added system availability ● Though parts of a database may not be accessible, transactions can still occur, increasing overall availability of the database ◆ Added efficiency ● Smaller tables are faster to query 11 9 Disadvantages of Distributed Databases...
View Full Document

This note was uploaded on 04/17/2008 for the course IS 158 taught by Professor Moffitt during the Spring '08 term at CSU Fresno.

Page1 / 42

chapter09 - Concepts of Database Concepts of Database...

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online