Simplifying Data Architectures with a Unifed Database
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
