[prev] 109 [next]

Rows vs Columns (cont)

Which is more efficient depends on mix of queries/updates
  • RDBMSs are, to some extent, write-optimized
    • effective for OLTP applications  (e.g. ATM, POS, ...)
  • when RDBMSs might be better ...
    • when query requires all attributes
    • might read more data, but less seek-time  (multiple files)
  • when CoDbs might be better ...
    • smaller intermediate "tuples"
    • less competition for access to pages  (locking)