DBMS > Amazon SimpleDB vs. Manticore Search vs. ToroDB

System Properties Comparison Amazon SimpleDB vs. Manticore Search vs. ToroDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	Amazon SimpleDB  Xexclude from comparison	Manticore Search  Xexclude from comparison	ToroDB  Xexclude from comparison
Description	Hosted simple database service by Amazon, with the data stored in the Amazon Cloud. There is an unrelated product called SimpleDB developed by Edward Sciore	Multi-storage database for search, including full-text search.	A MongoDB-compatible JSON document store, built on top of PostgreSQL
Primary database model	Key-value store	Search engine	Document store
Secondary database models		Time Series DBMS using the Manticore Columnar Library
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 2.09 Rank #123   Overall #24   Key-value stores	Score 0.08 Rank #322   Overall #20   Search engines	Score 0.01 Rank #351   Overall #46   Document stores
Website	aws.amazon.com/­simpledb	manticoresearch.com	www.torodb.com
Technical documentation	docs.aws.amazon.com/­simpledb	manual.manticoresearch.com	www.torodb.com/­stampede/­docs
Developer	Amazon	Manticore Software	8Kdata
Initial release	2007	2017	2016
Current release		4.2, December 2021
License Commercial or Open Source	commercial	Open Source GPL version 2	Open Source AGPL-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++	Java
Server operating systems	hosted	FreeBSD Linux macOS Windows	All OS with a Java 7 VM
Data scheme	schema-free	Fixed schema	schema-free
Typing predefined data types such as float or date	no	Int, Bigint, Float, Timestamp, Bit, Int array, Bigint array, JSON, Boolean	yes string, integer, double, boolean, date, object_id
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.		Can index from XML	no
Secondary indexes	yes All columns are indexed automatically	yes full-text index on all search fields
SQL Support of SQL	no	SQL-like query language
APIs and other access methods	RESTful HTTP API	Binary API RESTful HTTP/JSON API RESTful HTTP/SQL API SQL over MySQL
Supported programming languages	.Net C C++ Erlang Java PHP Python Ruby Scala	Elixir Go Java JavaScript (Node.js) Perl PHP Python
Server-side scripts Stored procedures	no	user defined functions
Triggers	no	no	no
Partitioning methods Methods for storing different data on different nodes	none Sharding must be implemented in the application	Sharding Partitioning is done manually, search queries against distributed index is supported	Sharding
Replication methods Methods for redundantly storing data on multiple nodes	yes	Synchronous replication based on Galera library	Source-replica replication
MapReduce Offers an API for user-defined Map/Reduce methods	no	no
Consistency concepts Methods to ensure consistency in a distributed system	Eventual Consistency Immediate Consistency can be specified for read operations		Eventual Consistency Immediate Consistency
Foreign keys Referential integrity	no	no	no
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data	no Concurrent data updates can be detected by the application	yes isolated transactions for atomic changes and binary logging for safe writes	no
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 Manticore index.	yes
User concepts Access control	Access rights for users and roles can be defined via the AWS Identity and Access Management (IAM)	no	Access rights for users and roles
More information provided by the system vendor We invite representatives of system vendors to contact us for updating and extending the system information, and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.
Related products and services We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
More resources
	Amazon SimpleDB	Manticore Search	ToroDB
DB-Engines blog posts	The popularity of cloud-based DBMSs has increased tenfold in four years 7 February 2017, Matthias Gelbmann Amazon - the rising star in the DBMS market 3 August 2015, Matthias Gelbmann show all