News for hackers. Stuff that matters.

A comment on Ask HN: How do I improve our data infrastructure?. Parent comment

Re:Ask HN: How do I improve our data infrastructure? by usgroup on Saturday April 20, 2019 @10:56AM (#19706828)
... also remembering that a traditional dB will typically not store data raw. Row compression is normal and disk compression is normal . The typical column store advantage is block compression, predicate pushdown and column order storage.
[ Parent | on HN ]
Re:Ask HN: How do I improve our data infrastructure? by sixdimensional on Saturday April 20, 2019 @12:58PM (#19707558)
Regular databases such as SQL Server and Oracle have had columnar compression built in as an option along with the row stores for years now. I use it in SQL Server a lot and it works great.
[ Parent | on HN ]