chapter07

chapter07 - Concepts of Database Management, Fifth Edition...

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

View Full Document Right Arrow Icon
Concepts of Database  Concepts of Database  Management, Fifth Edition Management, Fifth Edition Chapter 7: Chapter 7: DBMS Functions 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
2 7 Objectives Introduce the functions, or services, provided by a DBMS Describe how a DBMS handles updating and retrieving data Examine the catalog features 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
3 7 Objectives 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
4 7 Nine 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
5 7 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 Users view and manipulate data during retrieval
Background image of page 5

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

View Full DocumentRight Arrow Icon
6 7 Figure 7.1: Adding Record
Background image of page 6
7 7 Figure 7.2: Updating Record
Background image of page 7

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

View Full DocumentRight Arrow Icon
8 7 Figure 7.3: Retrieving Data
Background image of page 8
9 7 Provide Catalog Services Stores data about data Contains descriptions of database components Often hidden from users Used by database administrators and programmers Data dictionary in larger DBMSs
Background image of page 9

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

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

Page1 / 36

chapter07 - Concepts of Database Management, Fifth Edition...

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

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