Types of DB: SQL, NoSQL, Vector
| SQL | NoSQL | |
|---|---|---|
| Types | Columnar DB, Graph DB(Cypher, GraphDB) | |
| Example |
PostgreSQL: Install, Commands(Create/Connect/List/Delete database, tables. Insert data) Stored procedures, Function, Extensions (pg_trgm), pgmq(Postgres Inbuilt MessageQueue), PgBouncer(Connection Pooler) CockroachDB, MariaDB, MySQL, Amazon RDS, Amazon Aurora |
Couchbase(Introduction, N1QL) |
| Issues | SQL Database Issues |
-
DB Scaling: Replication, Federation,
Sharding
DB Schema
Terms:
ACID(Atomicity, Consistency, Isolation, Durability)
Indexing(Forward, Reverse)
Isolation(Read Committed, Snapshot Isolation)
JOIN(Left, Right, Inner, Full, Cross)
Transaction(Dirty Read, Dirty Write, Read Skew, Write Skew, 2PC(Two Phase Commit))