Database Systems Design, Implementation, and Management

These flashcards cover essential vocabulary related to database systems, design, and management, aiding in the understanding of key concepts.

Data

Raw facts that are the building blocks of information.

Information

Data that has been processed to reveal meaning.

Database Management System (DBMS)

A collection of programs that manage the database structure and control data access.

Metadata

Data about data, describing data characteristics and relationships.

Data Redundancy

The unnecessary storage of the same data in different places.

Update Anomaly

An inconsistency that occurs during data updating when changes are made in one location but not others.

Data Independence

The ability to change data storage characteristics without affecting the application’s ability to access the data.

Distributed Database

A database that is distributed across different sites.

Centralized Database

A database located at a single site.

Analytical Database

A database designed to store historical data and business metrics for decision making.

Operational Database

A database designed to support a company’s day-to-day operations.

Structured Query Language (SQL)

A standard programming language used to manage and manipulate databases.

Extensible Markup Language (XML)

A markup language that represents data elements in a textual format.

Database Design

The process of planning the structure used to store and manage end-user data.

File System

A method of storing data in files on a storage medium.

Ecosystem of Database Systems

Includes hardware, software, data, procedures, and people involved in the database environment.

Ad hoc queries

Queries that are created spontaneously for specific data retrieval needs.