DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Amazon CloudSearch vs. HEAVY.AI vs. IBM Db2 warehouse vs. Sphinx

System Properties Comparison Amazon CloudSearch vs. HEAVY.AI vs. IBM Db2 warehouse vs. Sphinx

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAmazon CloudSearch  Xexclude from comparisonHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022  Xexclude from comparisonIBM Db2 warehouse infoformerly named IBM dashDB  Xexclude from comparisonSphinx  Xexclude from comparison
DescriptionA hosted search engine service by Amazon with the data stored in Amazons cloudA high performance, column-oriented RDBMS, specifically developed to harness the massive parallelism of modern CPU and GPU hardwareCloud-based data warehousing serviceOpen source search engine for searching in data from different sources, e.g. relational databases
Primary database modelSearch engineRelational DBMSRelational DBMSSearch engine
Secondary database modelsSpatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.47
Rank#120  Overall
#11  Search engines
Score2.26
Rank#126  Overall
#62  Relational DBMS
Score2.16
Rank#130  Overall
#65  Relational DBMS
Score6.74
Rank#61  Overall
#8  Search engines
Websiteaws.amazon.com/­cloudsearchgithub.com/­heavyai/­heavydb
www.heavy.ai
www.ibm.com/­products/­db2-warehousesphinxsearch.com
Technical documentationdocs.aws.amazon.com/­cloudsearchdocs.heavy.aisphinxsearch.com/­docs
DeveloperAmazonHEAVY.AI, Inc.IBMSphinx Technologies Inc.
Initial release2012201620142001
Current release5.10, January 20223.4.1, July 2021
License infoCommercial or Open SourcecommercialOpen Source infoApache Version 2; enterprise edition availablecommercialOpen Source infoGPL version 2, commercial licence available
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++ and CUDAC++
Server operating systemshostedLinuxhostedFreeBSD
Linux
NetBSD
OS X
Solaris
Windows
Data schemeyesyesyesyes
Typing infopredefined data types such as float or dateyesyesyesno
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.nono infoImport/export of XML data possible
Secondary indexesyes infoall search fields are automatically indexednoyesyes infofull-text index on all search fields
SQL infoSupport of SQLnoyesyesSQL-like query language (SphinxQL)
APIs and other access methodsHTTP APIJDBC
ODBC
Thrift
Vega
.NET Client API
JDBC
ODBC
OLE DB
Proprietary protocol
Supported programming languagesAll languages supporting JDBC/ODBC/Thrift
Python
Java
JavaScript (Node.js)
Perl
PHP
Python
R
Ruby
C++ infounofficial client library
Java
Perl infounofficial client library
PHP
Python
Ruby infounofficial client library
Server-side scripts infoStored proceduresnonoPL/SQL, SQL PLno
Triggersnonoyesno
Partitioning methods infoMethods for storing different data on different nodesyes infoautomatic partitioning across Amazon Search Instance as requiredSharding infoRound robinShardingSharding infoPartitioning is done manually, search queries against distributed index is supported
Replication methods infoMethods for redundantly storing data on multiple nodesyes infomanaged transparently by AWSMulti-source replicationyesnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanonoACIDno
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes infoThe original contents of fields are not stored in the Sphinx index.
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes
User concepts infoAccess controlauthentication via encrypted signaturesfine grained access rights according to SQL-standardfine 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 CloudSearchHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022IBM Db2 warehouse infoformerly named IBM dashDBSphinx
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 DB-Engines ranking includes now search engines
4 February 2013, Paul Andlinger

show all

Recent citations in the news

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

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

Using AWS Cloud Search
11 December 2012, InfoQ.com

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

Amazon Takes On Google And Microsoft With CloudSearch
16 April 2012, Forbes

provided by Google News

GPU Database Global Market Report 2022: Increasing Preference of Enterprises Toward AI and Machine Learning Facilitated Workloads Presents Opportunities - ResearchAndMarkets.com
9 November 2022, Business Wire

HEAVY.AI Launches Industry's First Digital Twin for Telco Network Planning, Building and Operations
20 September 2022, Datanami

The Mobile Network » Accelerated analytics for telco? It's in the hardware
28 September 2022, The Mobile Network

The insideBIGDATA IMPACT 50 List for Q4 2022
12 October 2022, insideBIGDATA

Geospatial data a key means of combating climate change
18 August 2022, TechTarget

provided by Google News

Top Data Warehousing Tools in 2022
26 October 2022, MarkTechPost

The 10 Best Cloud Data Warehouse Solutions to Consider in 2022
22 December 2021, Solutions Review

Top 15 Data Warehouse Tools & Software 2022
1 February 2022, Datamation

Databricks claims warehouse supremacy with benchmark test - others say not so fast
2 November 2021, SiliconANGLE News

Best cloud databases of 2022
4 October 2022, IT PRO

provided by Google News

Job opportunities

Senior Data Engineer, Evernorth (work from home)
Cigna, Hartford, CT

Senior Software Engineer
GivePulse, Austin, TX

AEM Developer
Infinity Quest, Austin, TX

Backend Golang Software Engineer
Digital Turbine, Austin, TX

Software Development Engineer
Amazon.com Services LLC, Berkeley, CA

Senior Data Scientist
Design Interactive Inc, Remote

MIDDLEWARE ADMINISTRATOR
Snap IT Solutions, Houston, TX

Sr Software Engineer (IBM RPG)
Nintendo of America Inc., North Bend, WA

Sr. Enterprise Data Architect
Truist Financial, Raleigh, NC

Engineer Architect
ManTech International Corporation, Colorado Springs, CO

Engineer Architect, SME
ManTech International Corporation, Annapolis Junction, MD

jobs by Indeed



Share this page

Featured Products

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Redis logo

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

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

Neo4j logo

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

Present your product here