| Editorial information provided by DB-Tools |
| System |
| Name |
ElasticSearch |
IBM DB2 |
| Version |
Version 6.4.1 (released in September 2018)
|
Last Stable Release 11.1 , released in april 2016 |
| Drawbacks |
Elasticsearch AMI not available |
high license costs. Applicable for transaction systems in large enterprises |
| Advantages |
Large number of drivers present for integration |
ACID compliant. |
| Languages Supported |
.Net
Groovy
Java
JavaScript
Perl
PHP
Python
Ruby |
C
C#
C++
Cobol
Delphi
Fortran
Java
JCL
Perl
PHP
Python
Ruby
Visual Basic |
| Website |
www.elastic.co/products/elasticsearch |
www.ibm.com/analytics/us/en/db2 |
| XML Support |
no |
yes |
| JSON Support |
yes |
yes |
| Brief description |
Elasticsearch is a search engine based on Lucene. It provides a distributed, multitenant-capable full-text search engine with an HTTP web interface and schema-free JSON documents. |
IBM Db2 was the name introduced by IBM in 1983. The names DB2(tm) and Db2(tm) refer to database-server products developed by IBM.
IBM Researchers invented Relational model and SQL Format. |
| Database Model |
Key Value NoSQL Model |
Primarily a relational database |
| Technical Documentation |
www.elastic.co/guide/en/elasticsearch/reference/current/index.html |
www.ibm.com/support/knowledgecenter/SSEPGG |
| License |
Open Source. Commercial version with HA available with redislabs.com |
Commercial |
| Cloud-based / SaaS |
ElasticSearch Cloud Cluster available from ElasticSearch |
Available in AWS, Azure Clouds. Available as a SaaS option in IBM Cloud |
| Implementation Language |
C,C++ |
C,C++ |
| Operating System Supported |
Linux
OS X
Solaris
Windows
|
Linux
Windows
|
| Options for Integration / Access API |
Proprietary protocol using JSON |
JSON Query,
Xquery,
JDBC,
ODBC |
| Consistency |
Highly Consistent |
Highly Consistent |
| Foreign Keys |
No |
Yes |
| Streaming Support |
Yes |
No |
| Analytics Support |
NA |
Need to buy Netezza |
| Data Storage Schema |
Inverted Index |
Relational Database |
| Notable Users |
-- |
Most of the Fortune 500 Companies |
| Key Differentiator |
No known Enterprise Competitor apart from Amazaon Cloud Search |
Go To Database for IBM Mainframe Systems |
| Concurrency |
Yes |
Yes |
| Partitioning |
Yes |
No |
| Replication |
Yes |
Yes |
| Secondary Indexes |
Yes |
Yes |
| SchemaLess |
Yes |
No |
| SQL Query |
No |
Yes |
