Glossary#

Cloud-Based Database#

They are hosted on cloud computing platforms like AWS, Azure, or Google Cloud.

Data#

Raw facts stored in structured or unstructured formats.

Database#

An organized collection of digital data or information stored electronically in a computer system.

Database Access Language#

Used to interact with the database.

Database Languages#

Specialized sets of commands and instructions used to define, manipulate and control data within a database.

Data Control Language#

Commands manage access permissions, ensuring data security, by controlling who can perform certain actions on the database.

Data Definition Language#

Deals with database schemas and descriptions, of how the data should reside in the database.

Data Manipulation Language#

Focuses on manipulating the data stored in the database, enabling users to retrieve, add, update and delete data.

Data Query Language#

A subset of SQL to retrieve data from a database without modifying it.

Database Management System#

A software system that manages, stores, and retrieves data efficiently in a structured format.

Hardware#

Physical devices like servers, disks, input-output devices.

Hierarchical Database#

Organizes data in a tree-like structure, where a record (node) has a single parent and have multiple children.

Network Database#

It uses a graph-like model to allow more complex relationships between entities.

NoSQL DBMS#

They are designed to handle large-scale data and provide high performance for scenarios where relational models might be restrictive.

Object-Oriented DBMS#

OODBMS integrates object-oriented programming concepts into the database environment allowing data to be stored as objects.

People#

Users interacting with DBMS at different levels.

Procedures#

Instructions and rules for using DBMS effectively.

Relational Database Management System#

Organizes data into tables (relations) composed of rows and columns.

Software#

Actual DBMS software like MySQL, Oracle, PostgreSQL.

Structured Query Language#

A standardized domain-specific programming language used to manage, manipulate, and retrieve data stored in relational database management systems (RDBMS).

Transaction Control Language#

Commands oversee transactional data to maintain consistency, reliability, and atomicity.