Database Overview
Terminology
flowchart TB
subgraph a[Relational: Table with Foreign ID]
direction LR
subgraph a1[Language]
direction TB
A11[Structured Query Language SQL]
end
subgraph a2["Relational Database Management System (RDBMS)"]
direction TB
A21[phpMyAdmin] --> A22[mySQL];
A21 --> A23[mariaDB];
A23 -->|fork| A22;
A24[pgAdmin] --> A25[postgreSQL];
subgraph a21[Database Engine]
direction LR
A22;A23;A25
end
subgraph a22[UI Client]
direction LR
A21;A24;A26[dBeaver]
end
A26 -->|any| a21;
end
end
subgraph b[Non-relational: JSON,Graph,Hash]
direction TB
subgraph b1[Non-RDBMS]
direction LR
subgraph b11[Engine]
direction LR
B11[mongoDB];
B12[noSQL];
end
end
end
subgraph c[Cloud service: AWS]
direction TB
subgraph c1[Relational]
direction LR
C1["Relational Database Service (RDS)"]
end
subgraph c2[Non-relational]
direction LR
C2[S3]
C21[mongoDB];
C22[dynamoDB];
end
end
A[Database] --> a;
A --> b;
a --> c1;
b --> c2;
- Database Management System (DBM) is a database program. It is a software system that uses a standard method of cataloging, retrieving, and running queries on data.
- The PostgreSQL is a database engine implementing SQL standards. It usually listen as a server on a network tcp port to provide its abilities. The pgAdmin is a sort of client. You are able to manipulate schema and data on an instance or multiple instances of PostgreSQL engines. The MS Windows instalation package consists of both PostgreSQL server and PgAdmin client. So far right after the instalation you are able to manage your databases.
- Queries are requests made to the database management system for specific information.
- CRUD: Create, read, update and delete.
- Foreign key is a field in the table that is primary key in another table.
- Primary key uniquely identify a record in the table.
- Data structure diagram (DSD) is a diagram of the conceptual data model which documents the entities and their relationships, as well as the constraints that connect to them.
- phpMyAdmin+MySQL \(\approx\) pgAdmin+PostgreSQL
- SQL a hybrid language: Data Query Language, Data Definition Language, Data Control Language, Data Manipulation Language.
References
- About Mermaid
- Markdown Monster Documentation -- Rendering Mermaid Charts
graph LR
A --- B
B-->C[fa:fa-ban forbidden]
B-->D(fa:fa-spinner);
- Mermaid Demo
- TechTerms: DBMS
- Difference between pgAdmin and PostgreSQL
- YouTube: SQL Tutorial - Full Database Course for Beginners
- Difference between Primary Key and Foreign Key
- Wikipedia: Data structure diagram
- Connecting to a DB instance running the MySQL database engine
- Connecting to a DB instance running the PostgreSQL database engine
- Python Database Tutorials
- How To Install and Secure phpMyAdmin on Ubuntu 18.04
- MariaDB Graphical and Enhanced Clients
- How To Install MySQL on Ubuntu 18.04
- DBeaver Community Universal Database Tool