4 ms·
Columnar is just a specialisation, like graph or document. It's not a general-purpose improvement on relational.
by robertlagrant 6y ago
Columnar is just a specialisation, like graph or document. It's not a general-purpose improvement on relational.
- PaulHoule 6y agoFrom the viewpoint of relational it is an execution strategy. Many columnar databases return row wise results via odbc or some similar interface and they look like relational databases. The difficulties of doing columnar style queries for document and graph databases led at least one person I know to tell a certain three letter agency that they couldn't have the panopticon machine they wanted. For online transaction processing rows are good, but for OLAP it is not even competitive.