DBMS > Sphinx vs. Splice Machine vs. Yanza
System Properties Comparison Sphinx vs. Splice Machine vs. Yanza
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Sphinx Xexclude from comparison||Splice Machine Xexclude from comparison||Yanza Xexclude from comparison|
|Yanza seems to be discontinued. Therefore it is excluded from the DB-Engines Ranking.|
|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||Time Series DBMS for IoT Applications|
|Primary database model||Search engine||Relational DBMS||Time Series DBMS|
|Developer||Sphinx Technologies Inc.||Splice Machine||Yanza|
|Current release||3.5.1, February 2023||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||commercial free version available|
|Cloud-based only Only available as a cloud service||no||no||no but mainly used as a service provided by Yanza|
|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||no|
|XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.||no|
|Secondary indexes||yes full-text index on all search fields||yes||no|
|SQL Support of SQL||SQL-like query language (SphinxQL)||yes||no|
|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
|any language that supports HTTP calls|
|Server-side scripts Stored procedures||no||yes Java||no|
|Triggers||no||yes||yes Timer and event based|
|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||none|
|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||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||no||yes||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||no||ACID||no|
|Concurrency Support for concurrent manipulation of data||yes||yes, multi-version concurrency control (MVCC)||yes|
|Durability Support for making data persistent||yes The original contents of fields are not stored in the Sphinx index.||yes||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||no|
More information provided by the system vendor
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|
The FAIR Cookbook - the essential resource for and by FAIR doers ...
7 Tips for Effective Communication with Chat AI Assistants
The draft genome sequence of the Japanese rhinoceros beetle ...
Hummingbird Moths, A Primer - - The Adirondack Almanack
AI Assistants for Strategic Foresight and Early Warning
provided by Google News
Machine learning data pipeline outfit Splice Machine files for insolvency
Splice Machine Launches the Splice Machine Feature Store to ...
Gartner: Top Machine Learning Trends for 2023
The Convergence of AI and Data Modernization
Splice Machine Launches Feature Store to Simplify Feature ...
provided by Google News
Hadoop Developer / Admin Jr
Share this page