Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Microsoft SQL Server ColumnStore and SAP HANA both support indexes, point updates, etc...

You can convert a table in SQL Server to "Clustered ColumnStore" storage, it'll become compressed, but everything will mostly work the same.

The implementation in SQL Server uses a row "delta store" to keep recent changes. Once a certain threshold is reached, the delta store is converted to columnar format and merged with the underlying table.



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: