Universal Storage
On this page
Universal storage allows you to support large-scale Online Transaction Processing (OLTP) and Hybrid Transactional and Analytical Processing (HTAP) at a lower total cost of ownership (TCO).
Although rowstores are well-suited for transaction processing, it can be costly to store large datasets in rowstores, as they store all data in RAM.
Current Features in Universal Storage
Currently, universal storage has five features that allow columnstores to process transactional workloads more efficiently:
-
Hash indexes on columnstores which may optionally require uniqueness.
-
Subsegment access, which speeds up access to a row in a columnstore.
For more details, see item 6 in Creating Efficient Columnstore Queries. -
Joins on columnstores, where one of the tables in the join uses a highly selective filter.
-
Upserts on columnstores.
Additionally, sparse compression for rowstores enables wide tables with a large percentage of NULL
values to be stored in as little as half of the RAM.
Related Content
See SingleStore's Patented Universal Storage - Part 4 for a general discussion of all the capabilities of Universal Storage.
Last modified: January 14, 2022