Fundamentals of Database Systems

Vocabulary flashcards from the lecture notes on Database Systems.

Database

A collection of related data.

DBMS (Database Management System)

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

Mini-world

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

Data

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

Meta-data

A description of a particular database, including data structures, types, and constraints.

Concurrency control

A DBMS capability that guarantees each transaction is correctly executed or aborted.

OLTP (Online Transaction Processing)

A major part of database applications that allows hundreds of concurrent transactions to execute per second.

SQL (Structured Query Language)

The de facto standard language for relational DBMSs.

NoSQL

Not Only SQL; a type of database designed for rapid search and retrieval from documents and processing of unstructured data.

Data Abstraction

A process in a database that hides storage details and presents users with a conceptual view of the database.

Actors on the Scene

Users who actually use and control the database content, including database administrators and designers.

Actors Behind the Scene

Those who design, develop, and maintain database applications and software.

Redundancy Control

The management of duplication in data storage to reduce costs and improve data integrity.

Cloud Storage

Storing data on hardware in a remote physical location, which can be accessed via the internet.

Big Data

Data that is too large, fast, or complex for traditional data-processing software to handle.

Data Warehouse

A centralized repository for storing, managing, and analyzing large amounts of data.