Database Systems: Design, Implementation, and Management Ninth Edition
-
Upload
sylvester-haynes -
Category
Documents
-
view
81 -
download
4
description
Transcript of Database Systems: Design, Implementation, and Management Ninth Edition
![Page 1: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/1.jpg)
Database Systems: Design, Implementation, and ManagementNinth Edition
Chapter 1Database Systems
![Page 2: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/2.jpg)
ObjectivesIn this chapter, you will learn:The difference between data and informationWhat a database is, the various types of
databases, and why they are valuable assets for decision making
The importance of database designHow modern databases evolved from file
systems
2
![Page 3: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/3.jpg)
Objectives (cont’d.)About flaws in file system data managementThe main components of the database systemThe main functions of a database
management system (DBMS)
3
![Page 4: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/4.jpg)
IntroductionGood decisions require good information
derived from raw factsData is managed most efficiently when stored
in a database Databases evolved from computer file
systemsUnderstanding file system characteristics is
important
Database Systems, 9th Edition 4
![Page 5: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/5.jpg)
Why Databases?Databases solve many of the problems
encountered in data managementUsed in almost all modern settings involving
data management: Business Research Administration
Important to understand how databases work and interact with other applications
Database Systems, 9th Edition 5
![Page 6: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/6.jpg)
Data vs. InformationData are raw factsInformation is the result of processing raw
data to reveal meaningInformation requires context to reveal
meaningRaw data must be formatted for storage,
processing, and presentationData are the foundation of information, which
is the bedrock of knowledge
Database Systems, 9th Edition 6
![Page 7: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/7.jpg)
Data vs. Information (cont’d.)Data: building blocks of informationInformation produced by processing dataInformation used to reveal meaning in dataAccurate, relevant, timely information is the
key to good decision makingGood decision making is the key to
organizational survival
Database Systems, 9th Edition 7
![Page 8: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/8.jpg)
Introducing the DatabaseDatabase: shared, integrated computer
structure that stores a collection of:End-user data: raw facts of interest to end userMetadata: data about data
Provides description of data characteristics and relationships in data
Complements and expands value of data
Database management system (DBMS): collection of programsManages structure and controls access to data
Database Systems, 9th Edition 8
![Page 9: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/9.jpg)
Role and Advantages of the DBMSDBMS is the intermediary between the user
and the databaseDatabase structure stored as file collectionCan only access files through the DBMS
DBMS enables data to be shared DBMS integrates many users’ views of the
data
Database Systems, 9th Edition 9
![Page 10: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/10.jpg)
Database Systems, 9th Edition 10
![Page 11: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/11.jpg)
Role and Advantages of the DBMS (cont’d.)Advantages of a DBMS:
Improved data sharingImproved data securityBetter data integrationMinimized data inconsistency Improved data accessImproved decision makingIncreased end-user productivity
Database Systems, 9th Edition 11
![Page 12: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/12.jpg)
Types of DatabasesCentralized database: data located at a
single siteDistributed database: data distributed
across several different sites Operational database: supports a
company’s day-to-day operationsTransactional or production database
Data warehouse: stores data used for tactical or strategic decisions
Database Systems, 9th Edition 12
![Page 13: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/13.jpg)
Database Systems, 9th Edition 13
![Page 14: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/14.jpg)
Why Database Design Is ImportantDatabase design focuses on design of
database structure used for end-user dataDesigner must identify database’s expected
useWell-designed database:
Facilitates data managementGenerates accurate and valuable information
Poorly designed database:Causes difficult-to-trace errors
Database Systems, 9th Edition 14
![Page 15: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/15.jpg)
Evolution of File System Data ProcessingReasons for studying file systems:
Complexity of database design is easier to understand
Understanding file system problems helps to avoid problems with DBMS systems
Knowledge of file system is useful for converting file system to database system
File systems typically composed of collection of file folders, each tagged and kept in cabinetOrganized by expected use
Database Systems, 9th Edition 15
![Page 16: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/16.jpg)
Evolution of File System Data Processing (cont'd.)Contents of each file folder are logically
relatedManual systems
Served as a data repository for small data collections
Cumbersome for large collectionsComputerized file systems
Data processing (DP) specialist converted computer file structure from manual system Wrote software that managed the data Designed the application programs
Database Systems, 9th Edition 16
![Page 17: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/17.jpg)
Evolution of File System Data Processing (cont'd.)Initially, computer file systems resembled
manual systemsAs number of files increased, file systems
evolvedEach file used its own application program to
store, retrieve, and modify dataEach file was owned by individual or
department that commissioned its creation
Database Systems, 9th Edition 17
![Page 18: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/18.jpg)
Database Systems, 9th Edition 18
![Page 19: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/19.jpg)
Database Systems, 9th Edition 19
![Page 20: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/20.jpg)
Database Systems, 9th Edition 20
![Page 21: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/21.jpg)
Problems with File System Data ProcessingSummary of file system limitations:
Requires extensive programmingCannot perform ad hoc queriesSystem administration is complex and difficultDifficult to make changes to existing structuresSecurity features are likely to be inadequate
Database Systems, 9th Edition 21
![Page 22: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/22.jpg)
Data RedundancyFile system structure makes it difficult to
combine data from multiple sourcesVulnerable to security breaches
Organizational structure promotes storage of same data in different locationsIslands of information
Data stored in different locations is unlikely to be updated consistently
Data redundancy: same data stored unnecessarily in different places
Database Systems, 9th Edition 22
![Page 23: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/23.jpg)
Data Redundancy (cont'd.)Data inconsistency: different and
conflicting versions of same data occur at different places
Data anomalies: abnormalities when all changes in redundant data are not made correctlyUpdate anomalies Insertion anomaliesDeletion anomalies
Database Systems, 9th Edition 23
![Page 24: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/24.jpg)
Lack of Design and Data-Modeling Skills
Most users lack the skill to properly design databases, despite multiple personal productivity tools being available
Data-modeling skills are vital in the data design process
Good data modeling facilitates communication between the designer, user, and the developer
Database Systems, 9th Edition 24
![Page 25: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/25.jpg)
Database SystemsDatabase system consists of logically related
data stored in a single logical data repositoryMay be physically distributed among multiple
storage facilitiesDBMS eliminates most of file system’s
problemsCurrent generation stores data structures,
relationships between structures, and access paths Also defines, stores, and manages all access paths
and components
Database Systems, 9th Edition 25
![Page 26: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/26.jpg)
Database Systems, 9th Edition 26
![Page 27: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/27.jpg)
The Database System EnvironmentDatabase system: defines and regulates the
collection, storage, management, use of dataFive major parts of a database system:
HardwareSoftwarePeopleProceduresData
Database Systems, 9th Edition 27
![Page 28: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/28.jpg)
Database Systems, 9th Edition 28
![Page 29: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/29.jpg)
DBMS FunctionsMost functions are transparent to end users
Can only be achieved through the DBMSData dictionary management
DBMS stores definitions of data elements and relationships (metadata) in a data dictionary
DBMS looks up required data component structures and relationships
Changes automatically recorded in the dictionary
DBMS provides data abstraction and removes structural and data dependency
Database Systems, 9th Edition 29
![Page 30: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/30.jpg)
DBMS Functions (cont'd.)Data storage management
DBMS creates and manages complex structures required for data storage
Also stores related data entry forms, screen definitions, report definitions, etc.
Performance tuning: activities that make the database perform more efficiently
DBMS stores the database in multiple physical data files
Database Systems, 9th Edition 30
![Page 31: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/31.jpg)
DBMS Functions (cont'd.)Data transformation and presentation
DBMS transforms data entered to conform to required data structures
DBMS transforms physically retrieved data to conform to user’s logical expectations
Security managementDBMS creates a security system that enforces
user security and data privacySecurity rules determine which users can
access the database, which items can be accessed, etc.
Database Systems, 9th Edition 31
![Page 32: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/32.jpg)
DBMS Functions (cont'd.)Multiuser access control
DBMS uses sophisticated algorithms to ensure concurrent access does not affect integrity
Backup and recovery managementDBMS provides backup and data recovery to
ensure data safety and integrityRecovery management deals with recovery of
database after a failure Critical to preserving database’s integrity
Database Systems, 9th Edition 32
![Page 33: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/33.jpg)
DBMS Functions (cont'd.)Data integrity management
DBMS promotes and enforces integrity rules Minimizes redundancy Maximizes consistency
Data relationships stored in data dictionary used to enforce data integrity
Integrity is especially important in transaction-oriented database systems
Database Systems, 9th Edition 33
![Page 34: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/34.jpg)
DBMS Functions (cont'd.)Database access languages and application
programming interfacesDBMS provides access through a query
languageQuery language is a nonprocedural languageStructured Query Language (SQL) is the de
facto query language Standard supported by majority of DBMS vendors
Database Systems, 9th Edition 34
![Page 35: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/35.jpg)
Managing the Database System: A Shift in Focus
Database system provides a framework in which strict procedures and standards enforcedRole of human changes from programming to
managing organization’s resourcesDatabase system enables more sophisticated
use of the data Data structures created within the database
and their relationships determine effectiveness
Database Systems, 9th Edition 35
![Page 36: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/36.jpg)
Managing the Database System: A Shift in Focus (cont'd.)Disadvantages of database systems:
Increased costsManagement complexityMaintaining currencyVendor dependenceFrequent upgrade/replacement cycles
Database Systems, 9th Edition 36
![Page 37: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/37.jpg)
SummaryData are raw factsInformation is the result of processing data to
reveal its meaningAccurate, relevant, and timely information is
the key to good decision makingData are usually stored in a databaseDBMS implements a database and manages
its contents
Database Systems, 9th Edition 37
![Page 38: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/38.jpg)
Summary (cont'd.)Metadata is data about dataDatabase design defines the database
structureWell-designed database facilitates data
management and generates valuable information
Poorly designed database leads to bad decision making and organizational failure
Databases evolved from manual and computerized file systems
Database Systems, 9th Edition 38
![Page 39: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/39.jpg)
Summary (cont'd.)In a file system, data stored in independent files
Each requires its own management programSome limitations of file system data
management:Requires extensive programmingSystem administration is complex and difficultChanging existing structures is difficultSecurity features are likely inadequateIndependent files tend to contain redundant data
Structural and data dependency problems
Database Systems, 9th Edition 39
![Page 40: Database Systems: Design, Implementation, and Management Ninth Edition](https://reader030.fdocument.pub/reader030/viewer/2022032604/56812b08550346895d8ee9a6/html5/thumbnails/40.jpg)
Summary (cont'd.)Database management systems were
developed to address file system’s inherent weaknesses
DBMS present database to end user as single repositoryPromotes data sharingEliminates islands of information
DBMS enforces data integrity, eliminates redundancy, and promotes security
Database Systems, 9th Edition 40