Columnstore9 min Read

This blog post was originally published in January 2014, and it has long been the first blog post on the SingleStore blog – and one of the …
Read Post
Columnstore4 min Read

SingleStore’s breakthrough new Universal Storage™ data management, enhanced system of record capabilities, time series enhancements, and more, are now available instantly and on demand with SingleStore Managed Service. You can try SingleStore DB 7.0 and Managed Service for free , instantly. SingleStore is proud to announce the general availability of SingleStore DB 7.0, available first on SingleStore Managed Service, the company’s elastic cloud database available on public cloud providers…
Read Post
Announcements11 min Read

SingleStore Universal Storage is a new vision for how databases can work – first blurring and then, for most use cases, erasing any apparent difference between today’s rowstore and columnstore tables. In SingleStore Universal Storage™ Phase 1, shipping as part of SingleStore DB 7.0 ( currently in beta ), rowstore tables get null compression, lowering TCO in many cases by 50%. Columnstore tables get seekable columnstores, which support fast seeks and updates, giving columnstore tables many of the…
Read Post
Analytics6 min Read

John Sherwood, a senior engineer at SingleStore on the query optimizer team, presented at SingleStore’s Engineering Open House in our Seattle offices last month. He gave a technical introduction to the SingleStore database, including its support for in-memory rowstore tables and disk-backed columnstore tables, its SQL support and MySQL wire protocol compatibility, and how aggregator and leaf nodes interact to store data and answer queries simultaneously, scalably, and with low latencies. He also…
Read Post