2010_Fall_Lecture02 - Database Systems, 8th Edition 1...

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

View Full Document Right Arrow Icon
Chapter 1: Database systems Database Systems, 8 th Edition 1
Background image of page 1

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

View Full DocumentRight Arrow Icon
Introduction Good decisions require good information derived from raw facts Data managed most efficiently when stored in a database Databases evolved from computer file systems Understanding file system characteristics is important Database Systems, 8 th Edition 2
Background image of page 2
Data vs. Information Data are raw facts Information is the result of processing raw data to reveal meaning Information requires context to reveal meaning Raw data must be formatted for storage, processing, and presentation Data are the foundation of information, which is the bedrock of knowledge Database Systems, 8 th Edition 3
Background image of page 3

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

View Full DocumentRight Arrow Icon
Data vs. Information (continued) Data: building blocks of information Information produced by processing data Information used to reveal meaning in data Accurate, relevant, timely information is the key to good decision making Good decision making is the key to organizational survival Database Systems, 8 th Edition 4
Background image of page 4
Introducing the Database and the DBMS Database: shared, integrated computer structure that stores a collection of data End-user data: raw facts of interest to the end user Metadata : data about data Metadata provides description of data characteristics and relationships in data Complements and expands value of data Database management system (DBMS) : collection of programs Manage structure and control access to data Database Systems, 8 th Edition 5
Background image of page 5

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

View Full DocumentRight Arrow Icon
Role and Advantages of the DBMS DBMS is the intermediary between the user and the database Database structure stored as file collection Access database through the DBMS DBMS enables data to be shared DBMS integrates many users’ views of the data Database Systems, 8 th Edition 6
Background image of page 6
Database Systems, 8 th Edition 7
Background image of page 7

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

View Full DocumentRight Arrow Icon
Role and Advantages of the DBMS (continued) Advantages of a DBMS: Improved data sharing Improved data security Better data integration Minimized data inconsistency Improved data access Improved decision making Increased end-user productivity Database Systems, 8 th Edition 8
Background image of page 8
Types of Databases Databases can be classified according to: Number of users Database location(s) Expected type and extent of use Single-user database supports only one user at a time Desktop database – single-user, runs on PC Multiuser database supports multiple users at the same time Workgroup database supports a small number Enterprise database supports a large number Database Systems, 8 th Edition 9
Background image of page 9

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

View Full DocumentRight Arrow Icon
Types of Databases (continued) Centralized database : data located at a single site Distributed database : data distributed across several different sites Operational database : supports a company’s day-to-day operations Transactional or production database Data warehouse : stores data used for tactical or strategic decisions Database Systems, 8 th Edition 10
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/28/2010 for the course LIS 102LSG22 taught by Professor Jungeunkyung during the Fall '10 term at Ewha Womans University.

Page1 / 44

2010_Fall_Lecture02 - Database Systems, 8th Edition 1...

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

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