INSY 3304 Chapter 1

Data warehouse

stores data used for tactical or strategic decisions

Operational database

supports a company's day-to-day operations

Multi-user database

supports multiple users at the same time (workgroup and enterprise databases)

Single-user database

supports only one user at a time

Centralized database

A database located at a single site.

Database Management System (DBMS)

The collection of programs that manages the database structure and controls access to the data stored in the database.

Databases

can be classified according to: -number of users -database location(s) -expected type and extent of use -the degree to which data is stuctured

Metadata

data about data; describes data characteristics and relationships in data.

Distributed database

data distributed across different sites

Unstructured data

exist in their original state

Data

raw facts that describe the characteristics of an event or object