DB-EnginesEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > BigchainDB vs. IBM Db2 warehouse vs. OpenSearch vs. SAP SQL Anywhere vs. Teradata Aster

System Properties Comparison BigchainDB vs. IBM Db2 warehouse vs. OpenSearch vs. SAP SQL Anywhere vs. Teradata Aster

Editorial information provided by DB-Engines
NameBigchainDB  Xexclude from comparisonIBM Db2 warehouse infoformerly named IBM dashDB  Xexclude from comparisonOpenSearch  Xexclude from comparisonSAP SQL Anywhere infoformerly called Adaptive Server Anywhere  Xexclude from comparisonTeradata Aster  Xexclude from comparison
Teradata Aster has been integrated into other Teradata systems and therefore will be removed from the DB-Engines ranking.
DescriptionBigchainDB is scalable blockchain database offering decentralization, immutability and native assetsCloud-based data warehousing serviceA distributed, RESTful search and analytics engine forked from Elasticsearch and based on Apache LuceneRDBMS database and synchronization technologies for server, desktop, remote office, and mobile environmentsPlatform for big data analytics on multistructured data sources and types
Primary database modelDocument storeRelational DBMSSearch engineRelational DBMSRelational DBMS
Secondary database modelsVector DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.76
Rank#215  Overall
#36  Document stores
Score1.26
Rank#161  Overall
#73  Relational DBMS
Score17.31
Rank#33  Overall
#4  Search engines
Score3.64
Rank#79  Overall
#43  Relational DBMS
Websitewww.bigchaindb.comwww.ibm.com/­products/­db2/­warehousegithub.com/­opensearch-project
opensearch.org
www.sap.com/­products/­technology-platform/­sql-anywhere.html
Technical documentationbigchaindb.readthedocs.io/­en/­latestopensearch.org/­docs/­latesthelp.sap.com/­docs/­SAP_SQL_Anywhere
DeveloperIBMAmazon Web ServicesSAP infoformerly SybaseTeradata
Initial release20162014202119922005
Current release2.5.0, January 202317, July 2015
License infoCommercial or Open SourceOpen Source infoAGPL v3commercialOpen Source infoApache Version 2.0commercialcommercial
Cloud-based only infoOnly available as a cloud servicenoyesnonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
STACKIT OpenSearch offers OpenSearch in a managed version in enterprise grade, 100% GDPR-compliant, for a wide range of applications like analytics, website search, offering scalability and fast data access.
Implementation languagePythonJava
Server operating systemsLinuxhostedAll OS with a Java VMAIX
HP-UX
Linux
OS X
Solaris
Windows
Linux
Data schemeschema-freeyesschema-free infoFlexible type definitions. Once a type is defined, it is persistentyesFlexible Schema (defined schema, partial schema, schema free) infodefined schema within the relational store; partial schema or schema free in the Aster File Store
Typing infopredefined data types such as float or datenoyesyesyesyes
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 possibleyesyes infoin Aster File Store
Secondary indexesyesyes infoAll search fields are automatically indexedyesyes
SQL infoSupport of SQLnoyesSQL-like query languageyesyes
APIs and other access methodsCLI Client
RESTful HTTP API
.NET Client API
JDBC
ODBC
OLE DB
Java API
RESTful HTTP/JSON API
ADO.NET
HTTP API
JDBC
ODBC
ADO.NET
JDBC
ODBC
OLE DB
Supported programming languagesGo
Haskell
Java
JavaScript
Python
Ruby
Java
JavaScript (Node.js)
Perl
PHP
Python
R
Ruby
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby infoElasticsearch client
C
C#
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
C
C#
C++
Java
Python
R
Server-side scripts infoStored proceduresPL/SQL, SQL PLyesyes, in C/C++, Java, .Net or PerlR packages
Triggersyesyes infoby using the 'percolation' featureyesno
Partitioning methods infoMethods for storing different data on different nodesShardingShardingShardingnoneSharding
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factoryesyesSource-replica replication infoDatabase mirroringyes infoDimension tables are replicated across all nodes in the cluster. The number of replicas for the file store can be configured.
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononoyes infoSQL Map-Reduce Framework
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency infoSynchronous doc based replication. Get by ID may show delays up to 1 sec. Configurable write consistency: one, quorum, allImmediate ConsistencyImmediate Consistency or Eventual Consistency depending on configuration
Foreign keys infoReferential integritynoyesnoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyes,with MongoDB ord RethinkDByesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesno
User concepts infoAccess controlyesfine grained access rights according to SQL-standardfine grained access rights according to SQL-standardfine grained access rights according to SQL-standard
More information provided by the system vendor
BigchainDBIBM Db2 warehouse infoformerly named IBM dashDBOpenSearchSAP SQL Anywhere infoformerly called Adaptive Server AnywhereTeradata Aster
Specific characteristicsOpenSearch is a highly scalable and extensible open-source software suite for search,...
» more
Competitive advantagesDistributed as fully open source under Apache License, Version 2.0 (ALv2), OpenSearch...
» more
Typical application scenariosThe OpenSearch platform is used across a broad range of search , analytics, and observability...
» more
Licensing and pricing modelsThe OpenSearch Project offers open source software licensed under Apache License...
» more

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
BigchainDBIBM Db2 warehouse infoformerly named IBM dashDBOpenSearchSAP SQL Anywhere infoformerly called Adaptive Server AnywhereTeradata Aster
Recent citations in the news

Blockchain in Automotive Market Rewriting Long Term Growth Story | VeChain, Ripple Labs, Ethereum, BigchainDB
1 October 2024, EIN News

Top 10 startups in Digital Twin in Germany in Oct, 2024
9 October 2024, Tracxn

Blockchain Database Startup BigchainDB Raises €3 Million
27 September 2016, CoinDesk

7 blockchain firms join Bosch led GAIA-X consortium for vehicle identity
13 September 2022, Ledger Insights

Data Science News Daily Roundup – 22nd March 2018
22 March 2018, Packt Hub

provided by Google News

Tackling AI’s data challenges with IBM databases on AWS
14 March 2024, IBM

Data Mining in Db2 Warehouse: the basics
23 June 2020, Towards Data Science

Db2 Warehouse delivers 4x faster query performance than previously, while cutting storage costs by 34x
11 July 2023, IBM

Top 7 Cloud Data Warehouse Companies
31 May 2023, Datamation

The 10 Best Cloud Data Warehouse Solutions to Consider in 2024
22 October 2023, Solutions Review

provided by Google News

Improve OpenSearch Service cluster resiliency and performance with dedicated coordinator nodes
29 October 2024, AWS Blog

Amazon OpenSearch Service now supports dedicated coordinator nodes
29 October 2024, AWS Blog

Why AWS Gave OpenSearch To The Linux Foundation
29 September 2024, Forbes

Manage Amazon OpenSearch Service Visualizations, Alerts, and More with GitHub and Jenkins
24 October 2024, AWS Blog

Amazon OpenSearch Service: Managed and community driven
16 September 2024, AWS Blog

provided by Google News

Rimini Street expands support beyond SAP and Oracle
11 June 2022, InsideSAP

SAP Products & Services Data Portfolio
2 July 2021, Datamation

Securing SAP with AWS Network Firewall: Part 2 – Managed Rules
17 July 2023, AWS Blog

SAP vulnerabilities Let Attacker Inject OS Commands—Patch Now!
11 July 2023, CybersecurityNews

MindsDB is now the leading and fastest growing applied ML platform in the world
3 November 2022, PR Newswire

provided by Google News

Northwestern Analytics Partners with Teradata Aster to Host Hackathon
23 May 2014, Northwestern Engineering

Teradata gears up for Internet of Things analytics
19 October 2015, CIO

Teradata's Aster shows how the flowers of fraud bloom
23 April 2015, The Register

Teradata Unveils Powerful Analytics Platform
23 October 2017, PR Newswire

Breakthrough Teradata Software Pushes the Analytic Edge with Internet of Things Data
19 October 2015, IoT Business News

provided by Google News



Share this page

Featured Products

SingleStore logo

The data platform to build your intelligent applications.
Try it 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

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Milvus logo

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

Neo4j logo

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

Present your product here