> For the complete documentation index, see [llms.txt](https://til.notdu.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://til.notdu.com/database/intro-to-database-systems/database-storage-ii/n-ary-storage-model-nsm.md).

# N-ARY STORAGE MODEL (NSM)

aka row storage

The DBMS store all attributes for a single tuple continuously in a page

Ideal for OLTP workloads where queries tend to operate only on an individual entity and insert-heavy workloads 

#### Advantages

* Fast inserts, updates, and deletes
* Good for queries that need the entire tuple

#### Disadvantages

* Not good for scanning large portion of the table and/or a subset of the attributes.

![](https://2548495579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTsnKOX7xLvOtvOXY9MlI%2Fuploads%2FGywH1Vi9Uk8zs5sTDHjz%2Fimage.png?alt=media\&token=0b13abc9-01b5-4538-a526-b5520a9bb8aa)