DB-EnginesExtremeDB for everyone with an RTOSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Amazon CloudSearch vs. Amazon SimpleDB vs. Apache Druid vs. Manticore Search vs. Teradata

System Properties Comparison Amazon CloudSearch vs. Amazon SimpleDB vs. Apache Druid vs. Manticore Search vs. Teradata

Editorial information provided by DB-Engines
NameAmazon CloudSearch  Xexclude from comparisonAmazon SimpleDB  Xexclude from comparisonApache Druid  Xexclude from comparisonManticore Search  Xexclude from comparisonTeradata  Xexclude from comparison
DescriptionA hosted search engine service by Amazon with the data stored in Amazons cloudHosted simple database service by Amazon, with the data stored in the Amazon Cloud. infoThere is an unrelated product called SimpleDB developed by Edward ScioreOpen-source analytics data store designed for sub-second OLAP queries on high dimensionality and high cardinality dataMulti-storage database for search, including full-text search.A hybrid cloud data analytics software platform (Teradata Vantage)
Primary database modelSearch engineKey-value storeRelational DBMS
Time Series DBMS
Search engineRelational DBMS
Secondary database modelsTime Series DBMS infousing the Manticore Columnar LibraryDocument store
Graph DBMS
Spatial DBMS
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.81
Rank#137  Overall
#12  Search engines
Score1.88
Rank#133  Overall
#23  Key-value stores
Score3.25
Rank#90  Overall
#47  Relational DBMS
#7  Time Series DBMS
Score0.29
Rank#302  Overall
#21  Search engines
Score44.87
Rank#22  Overall
#15  Relational DBMS
Websiteaws.amazon.com/­cloudsearchaws.amazon.com/­simpledbdruid.apache.orgmanticoresearch.comwww.teradata.com
Technical documentationdocs.aws.amazon.com/­cloudsearchdocs.aws.amazon.com/­simpledbdruid.apache.org/­docs/­latest/­designmanual.manticoresearch.comdocs.teradata.com
DeveloperAmazonAmazonApache Software Foundation and contributorsManticore SoftwareTeradata
Initial release20122007201220171984
Current release29.0.1, April 20246.0, February 2023Teradata Vantage 1.0 MU2, January 2019
License infoCommercial or Open SourcecommercialcommercialOpen Source infoApache license v2Open Source infoGPL version 2commercial
Cloud-based only infoOnly available as a cloud serviceyesyesnonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaC++
Server operating systemshostedhostedLinux
OS X
Unix
FreeBSD
Linux
macOS
Windows
hosted
Linux
Data schemeyesschema-freeyes infoschema-less columns are supportedFixed schemayes
Typing infopredefined data types such as float or dateyesnoyesInt, Bigint, Float, Timestamp, Bit, Int array, Bigint array, JSON, Booleanyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.noCan index from XMLyes
Secondary indexesyes infoall search fields are automatically indexedyes infoAll columns are indexed automaticallyyesyes infofull-text index on all search fieldsyes infoJoin-index to prejoin tables, aggregate index, sparse index, hash index
SQL infoSupport of SQLnonoSQL for queryingSQL-like query languageyes infoSQL 2016 + extensions
APIs and other access methodsHTTP APIRESTful HTTP APIJDBC
RESTful HTTP/JSON API
Binary API
RESTful HTTP/JSON API
RESTful HTTP/SQL API
SQL over MySQL
.NET Client API
HTTP REST
JDBC
JMS Adapter
ODBC
OLE DB
Supported programming languages.Net
C
C++
Erlang
Java
PHP
Python
Ruby
Scala
Clojure
JavaScript
PHP
Python
R
Ruby
Scala
Elixir
Go
Java
JavaScript (Node.js)
Perl
PHP
Python
C
C++
Cobol
Java (JDBC-ODBC)
Perl
PL/1
Python
R
Ruby
Server-side scripts infoStored proceduresnononouser defined functionsyes infoUDFs, stored procedures, table functions in parallel
Triggersnonononoyes
Partitioning methods infoMethods for storing different data on different nodesyes infoautomatic partitioning across Amazon Search Instance as requirednone infoSharding must be implemented in the applicationSharding infomanual/auto, time-basedSharding infoPartitioning is done manually, search queries against distributed index is supportedSharding infoHashing
Replication methods infoMethods for redundantly storing data on multiple nodesyes infomanaged transparently by AWSyesyes, via HDFS, S3 or other storage enginesSynchronous replication based on Galera libraryMulti-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency infocan be specified for read operations
Immediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonononoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanono infoConcurrent data updates can be detected by the applicationnoyes infoisolated transactions for atomic changes and binary logging for safe writesACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes infoThe original contents of fields are not stored in the Manticore index.yes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyes
User concepts infoAccess controlauthentication via encrypted signaturesAccess rights for users and roles can be defined via the AWS Identity and Access Management (IAM)RBAC using LDAP or Druid internals for users and groups for read/write by datasource and systemnofine grained access rights according to SQL-standard

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 CloudSearchAmazon SimpleDBApache DruidManticore SearchTeradata
DB-Engines blog posts

Amazon - the rising star in the DBMS market
3 August 2015, Matthias Gelbmann

The DB-Engines ranking includes now search engines
4 February 2013, Paul Andlinger

show all

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

Teradata is the most popular data warehouse DBMS
2 April 2013, Paul Andlinger

show all

Recent citations in the news

Amazon CloudSearch – Start Searching in One Hour for Less Than $100 / Month | Amazon Web Services
12 April 2012, AWS Blog

Searching CloudTrail Logs Easily with Amazon CloudSearch | AWS Startups Blog
21 October 2014, AWS Blog

AWS, Microsoft and Google should retire these cloud services
2 June 2020, TechTarget

CloudSearch Update – Price Reduction, Hebrew & Japanese Support, Partitioning, CloudTrail | Amazon Web Services
19 November 2014, AWS Blog

Serverless Reference Architectures with AWS Lambda
10 May 2016, All Things Distributed

provided by Google News

A Place for Everything – Amazon SimpleDB | AWS News Blog
14 December 2007, AWS Blog

Amazon DynamoDB Serves Trillions Of Requests Per Month While Counterpart SimpleDB Is No Longer A Listed ...
12 November 2013, TechCrunch

Amazon SimpleDB Management in Eclipse | AWS News Blog
22 July 2009, AWS Blog

Good Advice on Keeping Your Database Simple and Fast.
25 March 2009, All Things Distributed

Amazon Goes Back to the Future With 'NoSQL' Database
19 January 2012, WIRED

provided by Google News

Apache Druid Wins Best Big Data Product in the 2023 BigDATAwire Readers' Choice Awards
26 January 2024, Datanami

'Lucifer' Botnet Turns Up the Heat on Apache Hadoop Servers
21 February 2024, Dark Reading

New DDoS malware Attacking Apache big-data stack, Hadoop, & Druid Servers
26 February 2024, GBHackers

Apache Druid Takes Its Place In The Pantheon Of Databases
16 June 2022, The Next Platform

How to connect DataGrip to Apache Druid | by Zisis Flokas
18 October 2021, Towards Data Science

provided by Google News

Integrating Manticore Search with Apache Superset
8 August 2023, hackernoon.com

Clickhouse vs Elasticsearch vs Manticore Search Query Times With a 1.7B NYC Taxi Rides Benchmark
1 June 2022, hackernoon.com

Manticore is a Faster Alternative to Elasticsearch in C++
25 July 2022, hackernoon.com

8 Google Alternatives: How to Search Crypto, the Dark Web, More
1 February 2023, Gizmodo

Highlighting in Search Results
24 May 2020, hackernoon.com

provided by Google News

SHAREHOLDER ALERT: Pomerantz Law Firm Reminds Shareholders with Losses on their Investment in Teradata ...
15 June 2024, PR Newswire

TERADATA ALERT: Bragar Eagel & Squire, P.C. Announces that a Class Action Lawsuit Has Been Filed Against ...
15 June 2024, GlobeNewswire

Teradata Stock: Much More Enticing Now Than Last Year, But Uncertainty Lingers (NYSE:TDC)
14 June 2024, Seeking Alpha

Is There Now An Opportunity In Teradata Corporation (NYSE:TDC)?
11 June 2024, Simply Wall St

Teradata Stock Analysis: Don't Let the Amazon News Fool You Into Buying Now
10 June 2024, InvestorPlace

provided by Google News



Share this page

Featured Products

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Present your product here