DBMS > Amazon Aurora vs. Sphinx vs. TerminusDB
System Properties Comparison Amazon Aurora vs. Sphinx vs. TerminusDB
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Amazon Aurora Xexclude from comparison||Sphinx Xexclude from comparison||TerminusDB former name was DataChemist Xexclude from comparison|
|Description||MySQL and PostgreSQL compatible cloud service by Amazon||Open source search engine for searching in data from different sources, e.g. relational databases||Scalable Graph Database platform making enterprise data available by exploiting inferred entities and relationships|
|Primary database model||Relational DBMS||Search engine||Graph DBMS|
|Secondary database models||Document store||Document store|
|Developer||Amazon||Sphinx Technologies Inc.||DataChemist Ltd.|
|Current release||3.5.1, February 2023||11.0.0, January 2023|
|License Commercial or Open Source||commercial||Open Source GPL version 2, commercial licence available||Open Source GPL V3|
|Cloud-based only Only available as a cloud service||yes||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Implementation language||C++||Prolog, Rust|
|Server operating systems||hosted||FreeBSD|
|Typing predefined data types such as float or date||yes||no||yes|
|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.||yes||no|
|Secondary indexes||yes||yes full-text index on all search fields|
|SQL Support of SQL||yes||SQL-like query language (SphinxQL)||SQL-like query language (WOQL)|
|APIs and other access methods||ADO.NET|
RESTful HTTP API
WOQL (Web Object Query Language)
|Supported programming languages||Ada|
|C++ unofficial client library|
Perl unofficial client library
Ruby unofficial client library
|Server-side scripts Stored procedures||yes||no||yes|
|Partitioning methods Methods for storing different data on different nodes||horizontal partitioning||Sharding Partitioning is done manually, search queries against distributed index is supported||Graph Partitioning|
|Replication methods Methods for redundantly storing data on multiple nodes||Source-replica replication||none||Journaling Streams|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency|
|Foreign keys Referential integrity||yes||no||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||no||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes The original contents of fields are not stored in the Sphinx index.||yes in-memory journaling|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes|
|User concepts Access control||fine grained access rights according to SQL-standard||no||Role-based access control|
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.
|Amazon Aurora||Sphinx||TerminusDB former name was DataChemist|
|DB-Engines blog posts|
Cloud-based DBMS's popularity grows at high rates The popularity of cloud-based DBMSs has increased tenfold in four years
The popularity of cloud-based DBMSs has increased tenfold in four years
The DB-Engines ranking includes now search engines
|Recent citations in the news|
Amazon enhances its serverless data platforms to kick off re:Invent ...
AWS adds more zero-ETL integrations to Amazon RedShift
AWS re:Invent 2023 recap: Some of the top announcements
It's a wrap: Key findings from AWS re:Invent 2023
provided by Google News
Tesla Cybertruck Price, Arrival Dates May Drive Musk's Company ...
The FAIR Cookbook - the essential resource for and by FAIR doers ...
7 Tips for Effective Communication with Chat AI Assistants
Pirate Bay Downtime 'Caused by Malicious Attack, Proxies May be ...
Hummingbird Moths, A Primer - - The Adirondack Almanack
provided by Google News
From knowledge graph discussion group to think tank ...
Dublin-based data collaboration tool TerminusDB raises €3.6 million ...
Testing 17 Theories on the Development of Complex Civilizations
Exploring Data Monetization: Strategies, Challenges, and ...
From Birth to Death: Data Product Management's Cycle
provided by Google News
Systems Analyst - Application Developer
Database Migration Specialist
Sr. Account Manager, DoD COCOMs
Data Science Analyst
Share this page