2 ms·
Microsoft's column store implementation uses a large delta rowgroups and functions a little like a log structured merge tree. Incoming inserts go into deltas, a
by AaronFriel 7y ago
Microsoft's column store implementation uses a large delta rowgroups and functions a little like a log structured merge tree. Incoming inserts go into deltas, and are later aggregated into updates to columnar blocks.
This gives insert performance on par with row storage (it is using row storage!). This can be combined with their in memory database functionality as well.