Database
Concepts
- Choosing a database for workload
- Schema = shape of the data
- Types
- NoSQL, or document based database
- Relational
- Graph Database
- Key-value store
- Search engines
- Wide Column
- Message brokers
- Multi model
- Vector - high-dimensional data, good for similarity search
- ACID = atomicity, consistency, isolation, durability
- Transactions, e.g. 5 queries packed as a transaction, either all happens or none
- Indexes, so that don’t have to linear search every time we do a query. A tree structure is created.