Winter 2022 Release: SingleStoreDB Universal Storage, Part 5

The SingleStore Universal Storage is a single table type that supports both analytical and transactional workloads. It uses a columnstore format, enhanced for seekability. The new release of SingleStoreDB (8.0) introduces significant improvements in seeking into JSON and string data, with orders-of-magnitude performance gains. Fast seeks enable faster updates by avoiding the need to scan entire segments of data. Universal Storage tables are organized differently in 8.0 to enable fast row lookups for JSON data, using a new SingleStore-encoded Parquet (S2EP) data format. This simplifies designs and reduces hardware requirements, while maintaining excellent performance across both operational and analytical workloads. The improvements also include faster update and delete performance for changes affecting small percentages of rows, with significant speedups in TPC-C results illustrating these gains.

No tracked trend matches for this post yet.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.