IM 101 Flashcards
evolved from computer file systems. Understanding file
system characteristics is important.
Databases
Used in almost all modern settings involving data management:
- Business
- Research
- Administration
The difference between data and information.
Data are raw facts. Information is processed data to reveal the meaning behind the facts.
a discipline that focuses on the proper generation, storage, and retrieval
of data.
Data Management
Data Hierarchy
Bit>Byte>Field>Record>File>Database
shared, integrated computer structure that stores a collection of end-user data and Metadata.
Database
raw facts of interest to end user
End-user data
data about data
* Provides description of data characteristics and relationships in data
* Complements and expands value of data
Metadata
Number of users
Single-user:
Desktop
Multi-user
Workgroup
Enterprise
Supports only one user at a time.
Single User
Single-user database running on a personal computer.
Desktop
Supports multiple users at the same time.
Multi-user
Multi-user database that supports a small group of users or a single
department.
Workgroup
Multi-user database that supports a large group of users or an entire
organization.
Enterprise
Database site location
Centralized
Distributed
Supports data located at a single site.
Centralized
Supports data distributed across several sites.
Distributed
Type of data
General Purpose
Discipline-Specific
Supports a company’s day-to-day
operations.
Transactional (production) database (OLTP)
Stores data used to generate information required
to make tactical or strategic decisions. Often used to store historical data structure is quite
different.
Data warehouse database (OLAP)