Database Systems Lecture Review

These flashcards cover key concepts, definitions, and roles related to Database Systems.

Data

Raw input such as numbers, characters, and images that, when processed, becomes meaningful output known as information.

Information

Processed data that is significant and provides meaning.

File-Based System

A method of storing data in permanent files where each application program defines and manages its own data.

Database Management System (DBMS)

An intermediate layer that enables users to create, maintain, and control access to a database.

Data Redundancy

Duplication of data that can lead to inconsistency and wasted storage space.

Metadata

Data about data, which describes the structure and constraints of the stored data.

Self-describing Nature

A characteristic of a database system where both data and its definition are stored together.

Data Integrity

The accuracy and consistency of stored data within a database.

Concurrency Control

The management of simultaneous operations without conflicting interactions.

Advantages of Databases

Reduce redundancy, avoid inconsistency, enable data sharing, provide security, and enforce integrity constraints.

Disadvantages of Databases

Require expertise to manage, can be expensive, and may present compatibility issues with other systems.

DBMS Functions

Includes constructing, manipulating, and securing databases as well as providing backup and recovery.

Database Development Life Cycle

The process that includes requirements analysis, database designing, implementation, and testing.

Single User Database System

A system where only one user can access the database at any given time.

Multi-User Database System

A system that allows multiple users to access the database simultaneously.

Database Roles - Database Administrator (DBA)

Responsible for authorizing access, coordinating database use, and managing resources.

Application Programmers

Individuals who implement application programs that provide functionality for end users.

Sophisticated End-Users

Users familiar with DB structure and capable of using high-level query language like SQL.

Data Warehouse

A system that extracts and analyzes large volumes of data for business intelligence.