Chapter 1 of Database Design, Application Development and

Download Report

Transcript Chapter 1 of Database Design, Application Development and

Introduction to Database
Management
Outline




Database characteristics
DBMS features
Architectures
Organizational roles
1-2
Initial Vocabulary
 Data: raw facts about things and events
 Information: transformed data that has
value for decision making
 Essential to organize data for retrieval and
maintenance
1-3
Database Characteristics
 Persistent : stable storage
 Shared : multiple users and uses
 Interrelated : data stored as entities and
relationships
1-4
University Database
Registration
Grade
Recording
Entities:
students, faculty, courses,
offerings, enrollments
Relationships:
faculty teach offerings,
students enroll in
offerings, offerings made
of courses, ...
Faculty
Assignment
Course
Scheduling
University Database
1-5
Water Utility Database
Billing
Meter
Reading
Entities:
customers, meters, bills,
payments, meter readings
Relationships:
bills sent to customers,
customers make payments,
customers use meters, ...
Payment
Processing
Service Start/
Stop
1-6
Database Management
System (DBMS)
 Collection of components that support
data acquisition, dissemination, storage,
maintenance, retrieval, and formatting
 Enterprise DBMSs
 Desktop DBMSs
 Embedded DBMSs
 Major part of information technology
infrastructure
1-7
Database Definition
 Define database structure before using a
database
 Tables and relationships
 SQL CREATE TABLE statement
 Graphical tools
1-8
University Database
Relationships
Tables
s
1-9
University Database (ERD)
Student
Offering
Faculty
StdSSN
StdClass
StdMajor
StdGPA
OfferNo
OffLocation
OffTime
FacSSN
FacSalary
FacRank
FacHireDate
Teaches
Has
Supervises
Accepts
Course
Registers
Enrollment
EnrGrade
CourseNo
CrsDesc
CrsUnits
1-10
Nonprocedural Access
 Query: request for data to answer a
question
 Indicate what parts of database to retrieve
not the procedural details
 Improve productivity and improve
accessibility
 SQL SELECT statement and graphical
tools
1-11
Graphical Tool for
Nonprocedural Access
1-12
Application Development
 Form: formatted document for data entry
and display
 Report: formatted document for display
 Use nonprocedural access to specify data
requirements of forms and reports
1-13
Sample Data Entry Form
1-14
Sample Report
1-15
Procedural Language Interface
 Combine procedural language with
nonprocedural access
 Why
 Batch processing
 Customization and automation
 Performance improvement
1-16
Transaction Processing
 Transaction: unit of work that should be
reliably processed
 Control simultaneous users
 Recover from failures
1-17
Database Technology Evolution
Era
1960s
Generation
1st Generation
Orientation
File
1970s
2nd Generation
Network
Navigation
1980s
3rd Generation
Relational
1990s
4th Generation
Object
Major Features
File structures and
proprietary program
interfaces
Networks and hierarchies
of related records,
standard program
interfaces
Non-procedural
languages, optimization,
transaction processing
Multi-media, active,
distributed processing,
XML enabled
1-18
DBMS Marketplace
 Enterprise DBMS




Oracle: dominates in Unix; strong in Windows
SQL Server: strong in Windows
DB2: strong in mainframe environment
Significant open source DBMSs: MySQL,
Firebird, PostgreSQL
 Desktop DBMS
 Access: dominates
 FoxPro, Paradox, Approach, FileMaker Pro
1-19
Data Independence
 Software maintenance is a large part
(50%) of information system budgets
 Reduce impact of changes by separating
database description from applications
 Change database definition with minimal
effect on applications that use the
database
1-20
Three Schema Architecture
View 1
External to
Conceptual
Mappings
Conceptual
to Internal
Mappings
View 2
Conceptual
Schema
Internal
Schema
View n
External
Level
Conceptual
Level
Internal
Level
1-21
Differences among Levels
 External
 Forms
 Reports
 Conceptual
 Tables
 Internal
 Files needed to store the tables
 Extra files to improve performance
1-22
Client-Server Architecture
a) Client, server, and
database on the
same computer
b) Mulitple clients and 1 server
on different computers
Client
Client
Server
Server
Client
Client
Database
Database
c) Multiple servers and databases on different computers
Client
Server
Server
Client
Client
Client
Database
Database
1-23
Organizational Roles
Specialization
Functional User
Indirect
Parametric
Information Systems
Power
DBA
Technical
Analyst/Programmer
Management
Non Technical
1-24
Database Specialists
 Database administrator (DBA)
 More technical
 DBMS specific skills
 Data administrator
 Less technical
 Planning role
1-25
Summary
 Databases and database technology vital
to modern organizations
 Database technology supports daily
operations and decision making
 Nonprocedural access is a crucial feature
 Many opportunities to work with databases
1-26