DBMS > Sphinx vs. Splice Machine
System Properties Comparison Sphinx vs. Splice Machine
Please select another system to include it in the comparison.
Our visitors often compare Sphinx and Splice Machine with Solr, Elasticsearch and MongoDB.
|Editorial information provided by DB-Engines|
|Name||Sphinx Xexclude from comparison||Splice Machine Xexclude from comparison|
|Description||Open source search engine for searching in data from different sources, e.g. relational databases||Open-Source SQL RDBMS for Operational and Analytical use cases with native Machine Learning, powered by Hadoop and Spark|
|Primary database model||Search engine||Relational DBMS|
|Developer||Sphinx Technologies Inc.||Splice Machine|
|Current release||3.4.1, July 2021||3.1, March 2021|
|License Commercial or Open Source||Open Source GPL version 2, commercial licence available||Open Source AGPL 3.0, commercial license available|
|Cloud-based only Only available as a cloud service||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems||FreeBSD|
|Typing predefined data types such as float or date||no||yes|
|Secondary indexes||yes full-text index on all search fields||yes|
|SQL Support of SQL||SQL-like query language (SphinxQL)||yes|
|APIs and other access methods||Proprietary protocol||JDBC|
Native Spark Datasource
|Supported programming languages||C++ unofficial client library|
Perl unofficial client library
Ruby unofficial client library
|Server-side scripts Stored procedures||no||yes Java|
|Partitioning methods Methods for storing different data on different nodes||Sharding Partitioning is done manually, search queries against distributed index is supported||Shared Nothhing Auto-Sharding, Columnar Partitioning|
|Replication methods Methods for redundantly storing data on multiple nodes||none||Multi-source replication|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||Yes, via Full Spark Integration|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency|
|Foreign keys Referential integrity||no||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||no||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes, multi-version concurrency control (MVCC)|
|Durability Support for making data persistent||yes The original contents of fields are not stored in the Sphinx index.||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes|
|User concepts Access control||no||Access rights for users, groups and roles according to SQL-standard|
|More information provided by the system vendor|
How to Break Data Silos to Drive Enterprise-Wide AI
Point-in-Time Correctness in Machine Learning
The Compliance Nightmare Lurking in Your Data Science Team
Whose Job Is It Anyway?
How Optimizing MLOps Can Revolutionize Enterprise AI
We invite representatives of system vendors to contact us for updating and extending the system information,
Related products and services
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|
The DB-Engines ranking includes now search engines
|Recent citations in the news|
Mark Hill: The future looks dim: Silicon Valley and the race to make ...
6 Top & Best Open source Search Engine Software for Enterprises
The Pirate Bay was recently down for over a week due to a DDoS attack
Google Doodles celebrates Egypt's novelist Ihsan Abdel-Koddous ...
WowVisible Launches Professional SEO Service Complete Package
provided by Google News
Machine learning data pipeline outfit Splice Machine files for insolvency
Unified MLOps: Feature Stores and Model Deployment
Booming Data Volumes and Velocities Require Vectorized ...
Splice Machine Launches the Splice Machine Feature Store to ...
The Economic Impact of Transitioning to Hybrid Cloud for Analytics ...
provided by Google News
Hadoop Developer / Admin Jr
Share this page