Rockset Architecture vs SingleStore
Separation of compute and storage
Yes - Singlestore Cloud uses cloud object storage for separation of compute and storage
Isolation of ingest and query
Yes - separate compute clusters (Virtual Instances) for ingest and query
No - databases share ingest and queries
Isolation for multiple applications
Yes - separate compute cluster (Virtual Instance) for each application
Use of storage hierarchy
• SSDs store shared hot data, accessible from any Virtual Instance cluster
• Cloud storage for durability
• Memory - for data requiring the highest performance
• High-performance block storage for persistent cache - the working dataset should fit within the persistent cache
• Cloud object storage for long-term retention
SaaS - infrastructure, software and cluster ops managed by service provider
Self managed and SaaS deployment options
Rockset is built to be a cloud-only database and does not have a self-managed option. It disaggregates compute from both hot storage and cloud storage, allowing multiple isolated compute clusters to run on the same shared data.
SingleStore is a proprietary distributed relational database that handles both transactional and analytical workloads. It relies on memory and a persistent cache to deliver low latency queries. For longer term data retention, SingleStore Cloud separates compute from cloud object storage. SingleStore Cloud pricing is based on compute and storage usage.
Rockset Ingestion vs SingleStore
Managed data connectors to:
• Events streams (e.g. Kafka, Kinesis)
• Database CDC (e.g. MongoDB, DynamoDB, MySQL, PostgreSQL)
• Data lakes (e.g. S3, Google Cloud Storage)
Integrations to: Amazon S3, Apache Beam, GCS, HDFS, Kafka, Spark, Qlik Replicate, HVR
Semi structured data
• Ingests JSON and XML without a predefined schema
• Ingests nested data
Ingests JSON as a JSON column type
Transformations and rollups
Yes - using SQL ingest transformations
SingleStore pipelines do common data shaping including normalizing and denormalizing data, adding computed columns, filtering data, mapping data, splitting records into multiple destination tables
Rockset has built-in connectors that manage streaming ingestion from common data sources. It has native support for semi-structured data, so that nested JSON and XML can be ingested and queried as is.
SingleStore has integrations to common data lakes and streams. With SingleStore pipelines, users can perform common data transformations during the ingestion process. SingleStore provides limited support for semi-structured data with its JSON column type. Many users structure data prior to ingestion for optimal query performance.
See Rockset in action
Get a product tour with a Rockset engineer.
Rockset Queries vs SingleStore
SQL - with extensions for nested data
• Data APIs - saved SQL queries executed via REST endpoint
• Python, Java, Node.js and Go SDKs
• API for querying data via POST command
• JDBC driver, Python client
• Compatibility with MySQL and MariaDB to support additional drivers
Integrations with Tableau, Looker, Grafana, Superset, Power BI, Retoolwhic
Integrations with Cognos Analytics, Dremio, Looker, Microstrategy, Power BI, Sisense, Tableau and Tibco Spotfire
Rockset supports SQL as its native query language and can perform SQL joins. Users can create data APIs by storing SQL queries in Rockset that are executed from dedicated REST endpoints. Rockset integrates with some common visualization tools, but BI is not Rockset’s primary use case.
SingleStore supports SQL as its native query language and can perform SQL joins. It is designed for querying structured data with static schemas. Users can create data APIs to execute SQL statements against the database over an HTTP connection. Common SingleStore use cases include business intelligence and analytics, and the database offers a number of integrations to visualization tools.
Rockset Performance vs SingleStore
• Ingests on a per-record basis
• Data latency is typically 1-2 seconds
• Columnnar store/universal storage ingests on a batch basis
• Data latency is typically seconds by relying on memory
Documents are mutable and can be updated at the field level
SingleStore columnar store/universal storage is immutable. Updates are fast when the data still resides in memory
Converged Index, comprising a rowstore, columnstore and inverted index
Two table formats-either use the rowstore or columnstore/universal storage
• Converged Index (row, columnar and inverted index) built on all data by default
• All queries are resolved through the index
Indexes can be manually configured: Skiplist index, hash index, full-text index, geospatial index
50-1000ms queries on 100s of TB
50-1000ms queries when the working set is contained in memory
Rockset is designed to make streaming data queryable as quickly as possible by avoiding the need to batch data. It also updates documents efficiently by only reindexing fields that are part of an update request. Rockset indexes all data by default, which results in storage amplification but also enables low-latency queries that require less compute.
SingleStore has two storage formats: a rowstore and a columnar store referred to as universal storage. The columnar store is used for analytical workloads, loading data in batch and relying on memory to achieve seconds of data latency. The columnar store can also execute queries in seconds when the working set is contained in memory. SingleStore provides the ability to configure and manage additional indexes on the data for faster performance.
Rockset Scalability vs SingleStore
Resize compute clusters (Virtual Instances) via API or in the console
• Cloud offering: Resize compute workspaces in the UI or using the Management API
• Self-managed offering: Change cluster configuration by updating command-line arguments or to the cluster directly.
• Add or remove compute clusters (Virtual Instances) via API or in the console
• Scale out compute clusters for higher concurrency
• Use separate compute clusters to isolate ingest from query or for multiple isolated applications
• No rebalancing required
Self-managed offering: Increase or decrease the number of nodes in the cluster. Rebalancing required
Rockset Virtual Instances are distributed compute clusters that can be scaled up for faster queries or scaled out for practically unlimited concurrency or if compute isolation is needed. Rockset has shared storage that scales automatically and independently, so no rebalancing is required.
SingleStore Cloud can be sized up or down using the UI or the Management API. There is no ability to scale out by increasing or decreasing the leaf and aggregator nodes in the cloud offering. In the self-managed offering, horizontal and vertical scaling can occur by updating command-line arguments or the cluster directly. Horizontal scaling does require rebalancing