This whitepaper describes the need for unified databases and one product in particular SingleStore. The following features are described that make the product suitable for concurrent transactional and analytical workloads:
- A table storage structure called universal storage designed to support transactional and analytical workloads concurrently
- Strong consistency that ensures a consistent state of data for all the users
- Pipelined and parallel data loading for massive data ingestion
- Columns with JSON data types to store complex-structured data
- A distributed, shared-nothing architecture that provides near-linear scalability
- Compilation of queries to improve query performance
- Support for fast, complex analytical queries