ch070 - Concepts of Database Management Sixth Edition...

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

View Full Document Right Arrow Icon
Concepts of Database Management Sixth Edition Chapter 7 DBMS Functions
Background image of page 1

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

View Full DocumentRight Arrow Icon
Concepts of Database Management 2 Objectives Introduce the functions, or services, provided by a DBMS Describe how a DBMS handles updating and retrieving data Examine the catalog feature of a DBMS Illustrate the concurrent update problem and describe how a DBMS handles this problem Explain the data recovery process in a database environment
Background image of page 2
Concepts of Database Management 3 Objectives (continued) Describe the security services provided by a DBMS Examine the data integrity features provided by a DBMS Discuss the extent to which a DBMS achieves data independence Define and describe data replication Present the utility services provided by a DBMS
Background image of page 3

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

View Full DocumentRight Arrow Icon
Concepts of Database Management 4 Introduction Functions of a DBMS Update and retrieve data Provide catalog services Support concurrent update Recover data Provide security services Provide data integrity features Support data independence Support data replication Provide utility services
Background image of page 4
Concepts of Database Management 5 Update and Retrieve Data Fundamental capability of a DBMS Users don’t need to know how data is stored or manipulated Users add, change, and delete records during updates
Background image of page 5

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

View Full DocumentRight Arrow Icon
Concepts of Database Management 6 Update and Retrieve Data (continued) FIGURE 7-1: Adding a new part to the Premiere Products database
Background image of page 6
Concepts of Database Management 7 Update and Retrieve Data (continued) FIGURE 7-2: Changing the price of a part in the Premiere Products database
Background image of page 7

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

View Full DocumentRight Arrow Icon
Concepts of Database Management 8 Update and Retrieve Data (continued) FIGURE 7-3: Retrieving a balance amount from the Premiere Products database
Background image of page 8
Concepts of Database Management 9 Provide Catalog Services Metadata : data about data Stores metadata and makes it accessible to users Enterprise DBMSs often have a data dictionary (a super catalog)
Background image of page 9

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

View Full DocumentRight Arrow Icon
Concepts of Database Management 10 Support Concurrent Update Ensures accuracy when several users update database at the same time Manages complex scenarios for updates Concurrent update : multiple users make updates to the same database at the same time
Background image of page 10
Concepts of Database Management 11 The Concurrent Update Problem FIGURE 7-4: Ryan updates the database
Background image of page 11

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

View Full DocumentRight Arrow Icon
Concepts of Database Management 12 The Concurrent Update Problem (continued) FIGURE 7-5: Elena updates the database
Background image of page 12
Concepts of Database Management 13 The Concurrent Update Problem (continued) FIGURE 7-6: Ryan’s and Elena’s updates to the database result in a lost update
Background image of page 13

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

View Full DocumentRight Arrow Icon
Concepts of Database Management 14 The Concurrent Update Problem (continued) FIGURE 7-6: Ryan’s and Elena’s updates to the database result in a lost update (continued)
Background image of page 14
Concepts of Database Management 15 Avoiding the Lost Update Problem Batch processing All updates done through a special program Problem: data becomes out of date Does not work in situations that require data to be current
Background image of page 15

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

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

This note was uploaded on 10/20/2008 for the course IST 331 taught by Professor Sikder during the Spring '08 term at Cleveland State.

Page1 / 54

ch070 - Concepts of Database Management Sixth Edition...

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

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