Database Model

Database models are different approaches to structuring and managing data in DatabaseDatabase
Databases are computer systems designed for storing data.

This note serves as a link to connect database-related notes.


[[ACID]]
[[Optimistic Locking]]/[[Pessimistic Locking]]
[[Database I...s.

It’s not possible to say in general which data model leads to simpler application code; it depends on the kinds of relationships that exist between data items:

  • If the data in your application has a document-like structure (i.e., a tree of one-to-many relationships, where typically the entire tree is loaded at once), then it’s probably a good idea to use a Document Database ModelDocument Database Model
    Document [[Database Model]] is an approach to structuring and managing data in [[Database]]s.

    Data is stored as documents (usually JSON or BSON) inside collections. Documents can be self-contained...    .
  • If your application does use many-to-many relationships, the document model becomes less appealing and Relational Database ModelRelational Database Model
    Relational [[Database Model]] is an approach to structuring and managing data in [[Database]]s.

    Data is stored in tables (also called relations) with predefined schemas (columns with specific data...     might be a better fit.
  • For highly interconnected data, the document model is awkward, the relational model is acceptable, and Graph Database ModelGraph Database Model
    Many-to-many relationships are what gives advantage to [[Relational Database Model]] over [[Document Database Model]], but in cases when we have a lot of complex many-to-many relationships, it is g...    s are the most natural.
  • There are also use-cases like genome sequencing where special implementations are needed (e.g. GenBank)

See also:

  • Hierarchical Database ModelHierarchical Database Model
    The hierarchical [[Database Model]] organizes data in a tree-like structure, where each record (parent) has one or more child records, but each child has only one parent (in contrast to [[Network D...
  • Network Database ModelNetwork Database Model
    The network [[Database Model]] is like an improved [[Hierarchical Database Model]], that allows many-to-many relationships by allowing each node to have multiple parents.



    Status: #📥

    References:...

Status: #📥

References: