Data Starter Set

Flashcards covering key concepts and terminology related to databases, including models, operations, and administrative responsibilities.

Database

A collection of records.

Flat-File Database

Stores data in a plain text file, where each line holds one record.

Relational Database

Contains database tables that can be joined together, with each record having a unique identifier called a primary key.

Hierarchical Database

Data is organized in a tree structure, like an organizational chart.

DBMS

Database Management System.

Structured Query Language (SQL)

Code used to identify what data should be retrieved or how it should be manipulated.

Selection Operation

Takes rows from one table and creates a new table.

UNION Operation

Combines data from different tables that have the same data types.

JOIN Operation

Combines two tables, but records are only appended when a matching criterion is met.

NoSQL Database

Stands for Not Only SQL; more dynamic than traditional relational databases, accommodating various data models.

Cloud Database

Optimized to work in a cloud environment, allowing for increased resources and high availability.

Data Lake

A system for storing data in a raw format, including both structured and unstructured data.

Distributed Database

Consists of data residing on different machines, linked via a network.

Database Security

Ensures only authorized users can access the database.

Database Tuning

Optimizing database performance.

High Availability

Maintaining replicas/copies of data for unretrieved access during outages.

Backup & Recovery

Planning and executing backup procedures to recover data.

Database Administrator Responsibilities

Includes database security, tuning, high availability, and backup/recovery planning.