I had a discussion with a friend about row vs column oriented RDBMS.
From my understanding, these things are closely linked with the fact that there’s a concrete drive head reading and writing the data. This head moves and reading/writing data is faster if the head moves are limited.
Still from my understanding, SSD drives drops those mechanical artifacts and accessing the data is now taking the same amount time regardless of where they are physically stored on the chip / device (don’t know the right term).
Considering these two points, will the SSD drives (when they’ll have reached their full potential) make the distinction between row oriented and column oriented either obsolete or pointless?
2
The only time I’ve ever seen rotational latency mentioned in the same breath as a DBMS is with SQLite. SQLite recommends that, if you have a lot of consecutive inserts, you should wrap them into a transaction, because if you don’t, the database engine does a read after write to verify each record. That takes about 1/60th of a second for each insert on a 7200 RPM drive, which is a lifetime in computer terms.
In any case, there’s always a workaround in databases for this rotational latency; usually it’s some sort of caching. The only thing that changes when you switch to a solid state drive is that this caching becomes less important. You still need the things like queries, joins and sets that databases provide; you’ll just get them with a performance boost.
1