Databases and Database Users

A set of vocabulary flashcards covering key concepts in databases and database technology.

Database

A collection of related data.

Data

Known facts that can be recorded and have an implicit meaning.

Mini-world

Some part of the real world about which data is stored in a database.

Database Management System (DBMS)

A software package/system to facilitate the creation and maintenance of a computerized database.

Database System

The DBMS software together with the data itself.

Traditional Applications

Applications that utilize numeric and textual databases.

Real-time Databases

Databases that provide a response to inputs in real-time.

Data Abstraction

A data model used to hide storage details and present a conceptual view of the database.

Program-data Independence

The ability to change data structures and storage organization without changing the access programs.

Concurrency Control

A DBMS functionality that ensures transactions are executed correctly in a multi-user environment.

Database Administrator (DBA)

A user who authorizes access, monitors usage, manages resources, and ensures efficient database operations.

End User

A user who uses the database for queries, reports, and updates.

Big Data

Data that involves large volumes, speeds, and variety such that traditional data processing applications are inadequate.

NOSQL

A type of database designed for rapid search and retrieval from documents and handling unstructured data.

Data Redundancy

The unnecessary duplication of data within a database.

Data Integrity

The accuracy and consistency of stored data.

Meta-data

Data that describes other data, detailing data structures, types, and constraints.