What's the difference between MaterixOne and SingleStore? #2234

Sunt-ing · 2022-04-18T05:42:12Z

Sunt-ing
Apr 18, 2022

Hi, developers. I'm wondering what's the difference between MaterixOne and SingleStore?
Thanks!

Answered by yingfeng

Actually they have similar vision: single store, but different approaches as well as scopes:

SS chooses a typical delta-main approach to provide htap, the delta is based on an in-memory row store and the main is columnar store, additionally the main area does not provide capabilities for frequent updating. While MO TAE is a pure columnar store based solution although it has mem-table, it's not a delta-main architecture.
MO has the infrastructure to contain multiple storage engines, such as AOE(append only), TPE(kv engine), TAE(transactional analytical), although it might be reduced to fewer or even one in future. Such infrastructure provides the possibility to integrate heterogeneous eng…

yingfeng · 2022-04-18T10:03:54Z

Actually they have similar vision: single store, but different approaches as well as scopes:

SS chooses a typical delta-main approach to provide htap, the delta is based on an in-memory row store and the main is columnar store, additionally the main area does not provide capabilities for frequent updating. While MO TAE is a pure columnar store based solution although it has mem-table, it's not a delta-main architecture.
MO has the infrastructure to contain multiple storage engines, such as AOE(append only), TPE(kv engine), TAE(transactional analytical), although it might be reduced to fewer or even one in future. Such infrastructure provides the possibility to integrate heterogeneous engines into single one.
MO has the builtin streaming scope which has not been started yet which has not been contained by SS

1 reply

Thanks for your vivid and clear explanation!