12
DATABASES
McGraw-Hill Technology Education
© 2006 by the McGraw-Hill Companies, Inc. All rights reserved.
Competencies (Page 1 of 2)
Distinguish between the
physical and logical
view of data
Describe how data is
organized: characters,
fields, records, files,
and databases
Describe databases,
database issues, and
database management
systems (DBMS)
Page 332
CE06_PP12-2
Competencies (Page 2 of 2)
Describe the five data
models: hierarchical,
network, relational,
multidimensional, and
object-oriented
Distinguish among
individual, company,
distributed,
proprietary, and Web
databases
Recognize strategic
database uses and
security concerns
Page 332
CE06_PP12-3
Data
Facts or observations
about people, places,
things, and events
Two ways to view
data
Physical view
Logical view
Page 334
CE06_PP12-4
Data Organization
Character
Field
Record
File
Database
Page 334
CE06_PP12-5
Key Field
Unique identifier also
known as primary field
Common examples
Social security number
Driver’s license
Credit card account
Page 336
CE06_PP12-6
Batch Versus
Real-time Processing (Page 1 of 2)
Batch processing -- later
Batch Processing
Page 336
CE06_PP12-7
Batch Versus
Real-Time Processing (Page 2 of 2)
Real-time processing -- now
Page 338
CE06_PP12-8
Need for Databases
Sharing – one department to another
Security – passwords to access
Less data redundancy
Data integrity
Access data entry form
Page 339
CE06_PP12-9
Subsystems of a Database
Management System
DBMS engine
Data definition
subsystem
Data manipulation
subsystem
Query-by-example
Structured query
language (SQL)
Application generation
subsystem
Data administration
subsystem
Page 339
CE06_PP12-10
DBMS Structure
Data models define
rules and standards for
data in a database – the
five data models are:
Hierarchical database
Network database
Relational database
Multidimensional
database
Object-oriented database
Page 340
CE06_PP12-11
Types of Databases
The five classifications of databases include:
Individual or microcomputer database
Company or shared
Operational
User
Distributed
Proprietary
Web database
Page 345
CE06_PP12-17
Database Uses and Issues
Strategic uses
Special type of database called data warehouse
Data mining used to search database
Security
Databases are valuable
Protection necessary
Electronic fingerprint pads
Page 348
CE06_PP12-18
A Look to the Future
Xperanto
Enhancement to searching
for data
Access to structured
(relational databases) and
unstructured data (word
processing and spreadsheet
files)
Page 350
CE06_PP12-19
Discussion Questions (Page 1 of 2)
Describe the five logical data groups or
categories.
What is the difference between batch
processing and real-time processing?
Identify and define the five part of DBMS
programs.
What are the five types of databases? Why does
more than one kind of database exist?
Page 359
CE06_PP12-20
Discussion Questions (Page 2 of 2)
What are some of the benefits and limitations
of databases? Why is security a concern?
Page 359
CE06_PP12-21
Descargar

Document