Random Link ¯\_(ツ)_/¯ | ||
May 28, 2023 | » | Relational Model Versus Document Model
8 min; updated May 29, 2023
A relational data model uses tables that consist of rows and columns. A row can be uniquely identified by a table + ID combination. A column entry can reference another row in another table through a shared key. One goal is to avoid duplicating data. However, to answer a real-world query, we end up paying th cost by joining results from multiple tables. That said, with proper indexing and prior research, combining results is pretty fast.... |