DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Amazon CloudSearch vs. BigObject vs. Microsoft Azure SQL Database vs. OpenTSDB

System Properties Comparison Amazon CloudSearch vs. BigObject vs. Microsoft Azure SQL Database vs. OpenTSDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAmazon CloudSearch  Xexclude from comparisonBigObject  Xexclude from comparisonMicrosoft Azure SQL Database infoformerly SQL Azure  Xexclude from comparisonOpenTSDB  Xexclude from comparison
DescriptionA hosted search engine service by Amazon with the data stored in Amazons cloudAnalytic DBMS for real-time computations and queriesDatabase as a Service offering with high compatibility to Microsoft SQL ServerScalable Time Series DBMS based on HBase
Primary database modelSearch engineRelational DBMS infoa hierachical model (tree) can be imposedRelational DBMSTime Series DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.45
Rank#126  Overall
#11  Search engines
Score0.19
Rank#356  Overall
#151  Relational DBMS
Score78.75
Rank#16  Overall
#10  Relational DBMS
Score2.44
Rank#128  Overall
#9  Time Series DBMS
Websiteaws.amazon.com/­cloudsearchbigobject.ioazure.microsoft.com/­en-us/­services/­sql-databaseopentsdb.net
Technical documentationdocs.aws.amazon.com/­cloudsearchdocs.bigobject.iodocs.microsoft.com/­en-us/­azure/­azure-sqlopentsdb.net/­docs/­build/­html/­index.html
DeveloperAmazonBigObject, Inc.Microsoftcurrently maintained by Yahoo and other contributors
Initial release2012201520102011
Current releaseV12
License infoCommercial or Open Sourcecommercialcommercial infofree community edition availablecommercialOpen Source infoLGPL
Cloud-based only infoOnly available as a cloud serviceyesnoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++Java
Server operating systemshostedLinux infodistributed as a docker-image
OS X infodistributed as a docker-image (boot2docker)
Windows infodistributed as a docker-image (boot2docker)
hostedLinux
Windows
Data schemeyesyesyesschema-free
Typing infopredefined data types such as float or dateyesyesyesnumeric data for metrics, strings for tags
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.noyesno
Secondary indexesyes infoall search fields are automatically indexedyesyesno
SQL infoSupport of SQLnoSQL-like DML and DDL statementsyesno
APIs and other access methodsHTTP APIfluentd
ODBC
RESTful HTTP API
ADO.NET
JDBC
ODBC
HTTP API
Telnet API
Supported programming languages.Net
C#
Java
JavaScript (Node.js)
PHP
Python
Ruby
Erlang
Go
Java
Python
R
Ruby
Server-side scripts infoStored proceduresnoLuaTransact SQLno
Triggersnonoyesno
Partitioning methods infoMethods for storing different data on different nodesyes infoautomatic partitioning across Amazon Search Instance as requirednoneSharding infobased on HBase
Replication methods infoMethods for redundantly storing data on multiple nodesyes infomanaged transparently by AWSnoneyes, with always 3 replicas availableselectable replication factor infobased on HBase
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneImmediate ConsistencyImmediate Consistency infobased on HBase
Foreign keys infoReferential integritynoyes infoautomatically between fact table and dimension tablesyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanonoACIDno
Concurrency infoSupport for concurrent manipulation of datayesyes infoRead/write lock on objects (tables, trees)yesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesno
User concepts infoAccess controlauthentication via encrypted signaturesnofine grained access rights according to SQL-standardno

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 CloudSearchBigObjectMicrosoft Azure SQL Database infoformerly SQL AzureOpenTSDB
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

PostgreSQL is the DBMS of the Year 2020
4 January 2021, Paul Andlinger, Matthias Gelbmann

Cloud-based DBMS's popularity grows at high rates
12 December 2019, Paul Andlinger

The popularity of cloud-based DBMSs has increased tenfold in four years
7 February 2017, Matthias Gelbmann

show all

Time Series DBMS are the database category with the fastest increase in popularity
4 July 2016, Matthias Gelbmann

show all

Recent citations in the news

Enterprise Search Software Market Industry by Size and Trends ...
31 January 2023, Digital Journal

PLG Will Eliminate the Subscription-Based Software Model
25 January 2023, The New Stack

Is Amazon CloudSearch superior to do-it-yourself search tools?
24 January 2014, TechTarget

How your company can adopt a usage-based business model like ...
11 July 2022, TechCrunch

Searching for search: UK Gov wants to dump GOV.UK Elasticsearch
17 November 2022, The Stack

provided by Google News

How to Stay Sane With Modern C++
7 February 2017, dzone.com

provided by Google News

Azure Now Supports Database as a Service Couchbase Capella
4 February 2023, InfoQ.com

Azure Migration Strategy: Tools, Costs and Best Practices
3 February 2023, DevOps.com

Learn To Build A Full Stack Application with Azure SQL And Prisma
13 January 2023, iProgrammer

The Dangers of Default Cloud Configurations
16 January 2023, Dark Reading

Microsoft Azure Load Testing is now generally available
1 February 2023, azure.microsoft.com

provided by Google News

Automate Anomaly Detection for Time Series Data
2 August 2022, The New Stack

MapR to help admins peer into dense Hadoop clusters
28 June 2016, SiliconANGLE News

Security Bulletin 28 Dec 2022
28 December 2022, Cyber Security Agency of Singapore

Victoriametrics' Opensource Monitoring Reigns Supreme As User ...
10 May 2022, ResponseSource

Why We Need Time Series Databases for Site Reliability Engineering
30 August 2022, Open Source For You

provided by Google News

Job opportunities

Senior Data Engineer, Evernorth (work from home)
Cigna, Texas

Software Engineer
Transcat, Inc., Rochester, NY

Sr. Golang Software Engineer
Digital Turbine, Austin, TX

Senior DevOps Engineer
Sirius XM, Irving, TX

Senior Server Software Engineer
Canvis, San Francisco, CA

SQL Server Database Admin
Spruce, Brooklyn, NY

Senior Azure Cloud Database Administrator
Building Service 32BJ Benefit Funds, New York, NY

SQL Azure Consultant
Hercules Consulting, Princeton, NJ

SQL Server Database Administrator
Margin5 Solutions Inc, Jersey City, NJ

Senior SQL Database Administrator
EXARCA INC, New York, NY

Developer
Wipro Limited, Austin, TX

Infrastructure SRE - Application Services - USDS
TikTok, Mountain View, CA

DevOps Engineer
Sapient Industries, Philadelphia, PA

Hadoop Admin
Sage IT, Inc., Austin, TX

Hadoop Admin
IT-SCIENT, Austin, TX

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

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

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

Redis logo

The world’s most loved real‑time data platform.
Try free

Present your product here