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)
|