📄️ Entity-Relationship
entity relationship (ER)
📄️ Relational Model and ER Mapping
relational model and er mapping
📄️ Relational Algebra
relational algebra
📄️ SQL
sql
📄️ Buffer-Management
Internals of a DBSM
📄️ Indexing
An index is a data structure that improves the speed of data retrieval operations on a database at the cost of additional writes and storage space. They are used to quickly locate data without having to search every row in a database table.
📄️ Query Evaluation
The processing of an SQL query is delegated to 3 programs:
📄️ Query Optimization
Execution Tree:
📄️ Large-scale Data Processing
To improve database performance and capacity, two options are available:
📄️ Transactions
transactions
📄️ Graph Databases
graph databases