SingleStore
A real-time analytical database developed by SingleStore Inc., formerly known as MemSQL. It supports HTAP (Hybrid Transactional/Analytical Processing) mixed workloads, featuring a memory-first storage engine and distributed SQL capabilities.
Timeline (last 90 days)
Representative HTAP implementations include TiDB, OceanBase and SingleStore, among others, and the core idea is to use the same storage with different execution engines to serve transactional and analytical queries respectively.
In SingleStore, if RANGE_SEARCH_OPTIONS is written before USE INDEX, range queries may ignore the ANN index or directly throw an error; the correct order is to filter first, then USE INDEX, and finally RANGE_SEARCH_OPTIONS.
Nikita Shamgunov is a co-founder of Neon and previously also founded MemSQL (later renamed SingleStore).
Representative products of HTAP include TiDB and SingleStore.
Traditional HTAP systems achieve parallel transactional and analytical processing by maintaining two data copies—row-store and column-store—within the same database engine; Oracle, TiDB, and SingleStore all adopt this approach.
All Facts (5)
Traditional HTAP systems achieve parallel transactional and analytical processing by maintaining two data copies—row-store and column-store—within the same database engine; Oracle, TiDB, and SingleStore all adopt this approach.
70%UnverifiedRepresentative HTAP implementations include TiDB, OceanBase and SingleStore, among others, and the core idea is to use the same storage with different execution engines to serve transactional and analytical queries respectively.
50%UnverifiedIn SingleStore, if RANGE_SEARCH_OPTIONS is written before USE INDEX, range queries may ignore the ANN index or directly throw an error; the correct order is to filter first, then USE INDEX, and finally RANGE_SEARCH_OPTIONS.
50%UnverifiedNikita Shamgunov is a co-founder of Neon and previously also founded MemSQL (later renamed SingleStore).
50%UnverifiedRepresentative products of HTAP include TiDB and SingleStore.
50%