SingleStore Features
Database Features (7)
Storage
Availability
Stability
Scalability
Security
Data Manipulation
Query Language
Support (4)
Text Search
Provides support for international character sets and full text search.
Data Types
Supports multiple data types like primitive, structured, document etc.
Languages
Supports multiple procedural programming languages like PL/PGSQL, Perl, Python etc.
Operating Systems
Available on multiple operating systems like Linux, Windows, MacOS etc.
Security (4)
Database Locking
Prevents other users and applications from accessing data while it is being updated to avoid data loss or update.
Access Control
Allows permissions to be granted or revoked in the database, schema or table levels.
Encryption
Built-in native encryption with enterprise key management.
Authentication
Provides multi-factor authentication with certificates.
Performance (5)
Disaster Recovery
Provides data recovery functionality to protect and restore data in a database.
Data Concurrency
Allows multi-version concurrency control.
Workload Management
Handles workloads, from single machines to data warehouses or web services with many concurrent users.
Advanced Indexing
Allows users to quickly retrieve data through various types of indexing like B-tree, hash table etc.
Query Optimizer
Helps interpret SQL queries and determine the fastest method of execution.
Management (4)
Data Schema
Data is organized as a set of tables with columns and rows like a table structure.
Query Language
Allows users to create, update and retrieve data in a database.
ACID - Complaint
Adheres to ACID (atomicity, consistency, isolation, durability), a set of database transaction properties.
Data Replication
Provides log-based or/and trigger-based replication.
Data Indexing (2)
Semantic Search
Allows semantic search service by organizing data.
Indexing Data
Allows indexing of data for search and retrieval.
Filters (2)
Accurate Search
The feature aids in filtering queries by metadata thus achieving accurate search.
Single Stage Filtering - Vector Database
This feature integrates vectors and metadata indexes into a single index.
Query latency (2)
Lower query latency
Aids in faster processing of query to obtain results.
Continuous queries
Enables faster queries and search engine-like workloads.
Data latency (2)
Lower data latency
Enables the user to track the time taken for data to be generated and available for processing
Data pipeline performance
Aids in monitoring and reporting data pipeline performance.
Connectors (2)
Faster ingestion
Manages in building pipelines between two protocols.
Built-in connectors
Allows continuous data ingestion directly from the data source.
Scale (2)
Linearly scalable database
Aids the database in scaling horizontally and vertically in petabytes.
Storage management
Helps store the data in fixed size segments called vectors for better management.
Architecture (2)
Data security
Enables ingesting data efficiently and securely.
Lockless architecture
Allows concurrent access to data without the use of any table locks.
