02010_ch12

02010_ch12 - Database Systems Design Implementation and...

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

View Full Document Right Arrow Icon
Database Systems: Design, Implementation, and Management Eighth Edition Chapter 12 Distributed Database Management Systems
Background image of page 1

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

View Full DocumentRight Arrow Icon
th 2 Objectives In this chapter, you will learn: What a distributed database management system (DDBMS) is and what its components are How database implementation is affected by different levels of data and process distribution How transactions are managed in a distributed database environment How database design is affected by the distributed database environment
Background image of page 2
th 3 The Evolution of Distributed Database Management Systems Distributed database management system ( DDBMS ) Governs storage and processing of logically related data Interconnected computer systems Both data and processing functions are distributed among several sites Centralized database required that corporate data be stored in a single central site
Background image of page 3

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

View Full DocumentRight Arrow Icon
th 4
Background image of page 4
th 5 DDBMS Advantages and Disadvantages Advantages: Data are located near “greatest demand” site Faster data access Faster data processing Growth facilitation Improved communications Reduced operating costs User-friendly interface Less danger of a single-point failure Processor independence
Background image of page 5

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

View Full DocumentRight Arrow Icon
th 6 DDBMS Advantages and Disadvantages (continued) Disadvantages: Complexity of management and control Security Lack of standards Increased storage requirements Increased training cost
Background image of page 6
th 7
Background image of page 7

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

View Full DocumentRight Arrow Icon
th 8 Distributed Processing and Distributed Databases Distributed processing Database’s logical processing is shared among two or more physically independent sites Connected through a network Distributed database Stores logically related database over two or more physically independent sites Database composed of database fragments
Background image of page 8
th 9
Background image of page 9

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

View Full DocumentRight Arrow Icon
th 10
Background image of page 10
th 11 Characteristics of Distributed Management Systems Application interface Validation Transformation Query optimization Mapping I/O interface
Background image of page 11

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

View Full DocumentRight Arrow Icon
th 12 Characteristics of Distributed Management Systems (continued) Formatting Security Backup and recovery DB administration Concurrency control Transaction management
Background image of page 12
th 13 Characteristics of Distributed Management Systems (continued) Must perform all the functions of centralized DBMS Must handle all necessary functions imposed by distribution of data and processing Must perform these additional functions transparently to the end user
Background image of page 13

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

View Full DocumentRight Arrow Icon
th 14
Background image of page 14
th 15 DDBMS Components Must include (at least) the following components: Computer workstations Network hardware and software Communications media Transaction processor ( application processor , transaction manager ) Software component found in each computer that requests data
Background image of page 15

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

View Full DocumentRight Arrow Icon
th 16 DDBMS Components (continued) Must include (at least) the following components: (continued) Data processor or data manager Software component residing on each computer that stores and retrieves data located at the site May be a centralized DBMS
Background image of page 16
th 17
Background image of page 17

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

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

Page1 / 51

02010_ch12 - Database Systems Design Implementation and...

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

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