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.