Company
Date Published
Author
Adam Prout
Word count
1575
Language
English
Hacker News points
None

Summary

The ACM SIGMOD conference has seen a renewed interest in Hybrid Transactional Analytical Processing (HTAP) this year, with four HTAP papers presented at the conference and an HTAP workshop. SingleStoreDB, one of the widely deployed distributed HTAP SQL databases, was featured in a paper titled "Cloud-Native Transactions and Analytics in SingleStore" which describes its key design decisions enabling it to run a breadth of workloads. HTAP databases like SingleStoreDB are reversing the trend of specialized database systems designed for single use cases, offering benefits such as reduced training requirements for developers, lower data movement and transformation costs, and improved storage efficiency. The paper also highlights SingleStoreDB's unified table storage and separation of storage and compute design, which enable fast scan performance and high availability. A CH-benCHmark benchmark test showed that SingleStoreDB can run both transactional and analytical workloads with strong performance, sharing resources almost equally without impacting each other. This demonstrates the potential of HTAP databases like SingleStoreDB to handle a wide range of applications and use cases.