SingleStore is a database that supports in-memory rowstore tables and disk-backed columnstore tables, with features such as SQL support and MySQL wire protocol compatibility. The database's primary feature is the in-memory rowstore, which allows it to circumvent issues with disk-based databases. SingleStore also has columnstore tables with unique features, and its architecture is designed for scalability and low latency. The database is designed for companies with large datasets and fast query requirements, such as those with shifting data or historical data sets. Its cluster consists of two types of nodes: leaves that store data and aggregators that coordinate data manipulation language (DML). The master aggregator coordinates DDL and is responsible for handling failures and implementing a two-phase commit mechanism. SingleStore's interface is MySQL compatible, and it uses code generation to optimize queries and reduce runtime costs. The database also collects metadata on various columns and tables, which allows it to make efficient decisions at runtime.