Databases and Data Management

These flashcards cover key concepts, definitions, and terms related to databases and data management.

Database Management System (DBMS)

Program that creates, processes, and administers a database.

Data Redundancy

The existence of duplicate data in database tables.

Primary Key

A unique field in a table used to identify each record in that table.

Foreign Key

A primary key from one table used in another table to establish a relationship.

Data Integrity

The accuracy, consistency, and reliability of data stored in a database.

Normalization

The process of organizing data to minimize redundancy and improve data integrity.

Entity

A person, place, thing, or concept about which data is stored.

Attribute (Metadata)

A characteristic or quality describing an entity.

SQL (Structured Query Language)

Standard language used for managing and manipulating relational databases.

Data Warehouse

A centralized repository that stores current and historical data from multiple sources for analysis.

Data Mart

A subset of a data warehouse focused on a specific subject or business line.

Big Data

Massive sets of unstructured/semi-structured data that require specialized processing tools.

Analytical features of big data

Full data analysis, correlation instead of causation, and the ability to handle noisy data.

Cardinality

The measure of the number of links in a particular relationship between data entities.

Data Dictionary

A centralized repository of data definitions and specifications.

Relational Database

A database structured to recognize relations among stored items of information.

Hierarchical Data Structure

A data structure that organizes data in a tree-like format with parent-child relationships.