database

Topics: Database management system, Database, Data management Pages: 50 (1930 words) Published: September 30, 2014
1

Chapter 1

Database Systems
Database Systems:
Design, Implementation, and Management,
Seventh Edition, Rob and Coronel
1

1

In this chapter, you will learn:
• The difference between data and information
• What a database is, what the different types
of databases are, and why they are valuable
assets for decision making
• The importance of database design
• How modern databases evolved from file
systems
Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

2

1

In this chapter, you will learn (continued):
• About flaws in file system data management
• What the database system’s main
components are and how a database system
differs from a file system
• The main functions of a database
management system (DBMS)

Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

3

1

Data vs. Information
• Data:
– Raw facts; building blocks of information
– Unprocessed information

• Information:
– Data processed to reveal meaning

• Accurate, relevant, and timely information is key to
good decision making
• Good decision making is the key to survival in a
global environment
Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

4

1

Transforming Raw Data into Information

Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

5

1

Transforming Raw Data into Information
(continued)

Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

6

1

Transforming Raw Data into Information
(continued)

Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

7

1

Transforming Raw Data into Information
(continued)

Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

8

1

Introducing the Database
and the DBMS
• Database—shared, integrated computer
structure that stores:
– End user data (raw facts)
– Metadata (data about data)

Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

9

1

Introducing the Database and the DBMS
(continued)
• DBMS (database management system):
– Collection of programs that manages
database structure and controls access to
data
– Possible to share data among multiple
applications or users
– Makes data management more efficient and
effective

Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

10

1

Role and Advantages of the DBMS
(continued)
• End users have better access to more and
better-managed data
– Promotes integrated view of organization’s
operations
– Probability of data inconsistency is greatly
reduced
– Possible to produce quick answers to ad hoc
queries

Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

11

1

Role and Advantages of the DBMS
(continued)

Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

12

1

Types of Databases
• Single-user:
– Supports only one user at a time

• Desktop:
– Single-user database running on a personal
computer

• Multi-user:
– Supports multiple users at the same time

Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

13

1

Types of Databases (continued)
• Workgroup:
– Multi-user database that supports a small
group of users or a single department

• Enterprise:
– Multi-user database that supports a large
group of users or an entire organization

Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

14

1

Types of Databases (continued)
Can be classified by location:
• Centralized:
– Supports data located at a single site

• Distributed:
– Supports data distributed across several sites

Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

15

1...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Week 8 Case Study: Database Development Research Paper
  • database management systems Essay
  • Database Management Essay
  • Database Essay
  • Oracle Database 11 G Essay
  • Database Environment Paper
  • Database Management Review Essay
  • Determining Databases Essay

Become a StudyMode Member

Sign Up - It's Free