database-design.md

Bookmarks tagged [database-design]

^{www.codever.land/bookmarks/t/database-design}

UUID or GUID as Primary Keys? Be Careful!

^{https://tomharrisonjr.com/uuid-or-guid-as-primary-keys-be-careful-7b2aa3dcb439}

• Reasons UUIDs are Good
• Reasons UUIDs May Not be Good
• 📆 published on: 2017-02-13
• tags: sql, database, database-design, primary-key

---

ORM: avoid using many to many relationships - DEV

^{https://dev.to/apium_hub/orm-avoid-using-many-to-many-relationships-52in}

The usage of ORMs (data mappers) comes with a great power but also with a great responsibility. ORMs... Tagged with architecture, objectrelationalmapp, orm.

• 📆 published on: 2020-12-07
• tags: orm, database, database-design

---

Two-phase commit protocol - Wikipedia

^{https://en.wikipedia.org/wiki/Two-phase_commit_protocol}

In transaction processing, databases, and computer networking, the two-phase commit protocol (2PC) is a type of atomic commitment protocol (ACP). It is a distributed algorithm that coordinates all the...

• tags: transactions, database, database-design

---

Modeling Data for NoSQL Document Databases - YouTube [31min]

^{https://www.youtube.com/watch?v=IUxT7ZRHlZ4}

To embed or to reference? Well, it depends on relationship type, data volatility, bounding type etc.... Great video

• 📆 published on: 2016-05-06
• tags: nosql, data-modeling, database-design

---

33rd Degree 2014 - MongoDB Schema Design - Tugdual Grall - YouTube [47']

^{https://www.youtube.com/watch?v=csKBT8zkRf0}

MongoDB's basic unit of storage is a document. Documents can represent rich, schema-free data structures, meaning that we have several viable alternatives to the normalized, relational model. In this ...

• 📆 published on: 2014-09-29
• tags: mongodb, database-design, data-modeling

---