Database Basics
NoSQL
Non-relational databases optimized for big data.
Data
Numeric, textual, visual, or audio information that describes real-world systems.
Database Administrator
Responsible for securing the database system and enforcing user access procedures.
Open Source
Software that can be inspected, copied, and modified with no licensing fee.
Database Application
Software that helps business users interact with database systems.
Database System
Software that reads and writes data in a database, ensuring data security, consistency, and availability.
SQL
Structured Query Language, a standard query language for relational databases.
File Systems
Text files or spreadsheets used to manage small databases.
Performance
The ability of a database system to maintain fast response times.
Scope
The amount of data produced and collected.
Access
The availability of data sources, whether private or publicly available.
Architecture
The internal components and relationships of a database system.
Authorization
The process of granting limited access to specific data for database users.
Recovery
The process of restoring the database to a consistent state after failures or system crashes.
Format
The way data is produced, such as numbers, text, image, audio, or video.
Storage Manager
Translates query processor instructions into low-level filesystem commands.
Database
A collection of data in a structured format.
Database User
A consumer of data in a database.
Relational Database
A database that stores data in tables, columns, and rows.
Catalog
A directory of tables, columns, indexes, and other database objects.
Log
A file containing a complete record of all database changes.
MySQL Workbench
A graphical user interface for interacting with MySQL Server and executing SQL commands.
Transaction
A group of queries that must be either completed or rejected as a whole.
Query
A request to retrieve or change data in a database.
Query Language
A specialized programming language designed for database systems.
MySQL Command-Line Client
A text interface for connecting to the MySQL Server, performing administrative functions, and executing SQL statements.
Metadata
Data about the database, such as column names and row counts.
Database Designer
Determines the format and structure of the database.
Database Programmer
Develops computer programs that utilize a database.
Transaction Manager
Ensures proper execution of transactions and prevents conflicts between concurrent transactions.
Rules
Ensuring data consistency with structural and business rules.
Security
Ensuring that authorized users only access permissible data and protecting against hackers.
Query Processor
Interprets queries, creates query plans, and returns query results.