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.