DB-EnginesExtremeDB: mitigate connectivity issues in a DBMSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > H2 vs. OpenSearch vs. Prometheus vs. SWC-DB vs. XTDB

System Properties Comparison H2 vs. OpenSearch vs. Prometheus vs. SWC-DB vs. XTDB

Editorial information provided by DB-Engines
NameH2  Xexclude from comparisonOpenSearch  Xexclude from comparisonPrometheus  Xexclude from comparisonSWC-DB infoSuper Wide Column Database  Xexclude from comparisonXTDB infoformerly named Crux  Xexclude from comparison
DescriptionFull-featured RDBMS with a small footprint, either embedded into a Java application or used as a database server.A distributed, RESTful search and analytics engine forked from Elasticsearch and based on Apache LuceneOpen-source Time Series DBMS and monitoring systemA high performance, scalable Wide Column DBMSA general purpose database with bitemporal SQL and Datalog and graph queries
Primary database modelRelational DBMSSearch engineTime Series DBMSWide column storeDocument store
Secondary database modelsSpatial DBMSVector DBMSTime Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score8.13
Rank#49  Overall
#31  Relational DBMS
Score16.36
Rank#37  Overall
#4  Search engines
Score8.42
Rank#47  Overall
#2  Time Series DBMS
Score0.01
Rank#376  Overall
#13  Wide column stores
Score0.11
Rank#343  Overall
#46  Document stores
Websitewww.h2database.comgithub.com/­opensearch-project
opensearch.org
prometheus.iogithub.com/­kashirin-alex/­swc-db
www.swcdb.org
github.com/­xtdb/­xtdb
www.xtdb.com
Technical documentationwww.h2database.com/­html/­main.htmlopensearch.org/­docs/­latestprometheus.io/­docswww.xtdb.com/­docs
DeveloperThomas MuellerAmazon Web ServicesAlex KashirinJuxt Ltd.
Initial release20052021201520202019
Current release2.2.220, July 20232.5.0, January 20230.5, April 20211.19, September 2021
License infoCommercial or Open SourceOpen Source infodual-licence (Mozilla public license, Eclipse public license)Open Source infoApache Version 2.0Open Source infoApache 2.0Open Source infoGPL V3Open Source infoMIT License
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
  • Aiven for OpenSearch: Fully managed open source search and analytics suite. Out-of-the-box integrations get you up and running in a couple of clicks.
  • 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 languageJavaJavaGoC++Clojure
Server operating systemsAll OS with a Java VMAll OS with a Java VMLinux
Windows
LinuxAll OS with a Java 8 (and higher) VM
Linux
Data schemeyesschema-free infoFlexible type definitions. Once a type is defined, it is persistentyesschema-freeschema-free
Typing infopredefined data types such as float or dateyesyesNumeric data onlyyes, extensible-data-notation format
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 of XML data possiblenono
Secondary indexesyesyes infoAll search fields are automatically indexednoyes
SQL infoSupport of SQLyesSQL-like query languagenoSQL-like query languagelimited SQL, making use of Apache Calcite
APIs and other access methodsJDBC
ODBC
Java API
RESTful HTTP/JSON API
RESTful HTTP/JSON APIProprietary protocol
Thrift
HTTP REST
JDBC
Supported programming languagesJavaGo
Java
JavaScript (Node.js)
PHP
Python
Ruby infoElasticsearch client
.Net
C++
Go
Haskell
Java
JavaScript (Node.js)
Python
Ruby
C++Clojure
Java
Server-side scripts infoStored proceduresJava Stored Procedures and User-Defined Functionsyesnonono
Triggersyesyes infoby using the 'percolation' featurenonono
Partitioning methods infoMethods for storing different data on different nodesnoneShardingShardingShardingnone
Replication methods infoMethods for redundantly storing data on multiple nodesWith clustering: 2 database servers on different computers operate on identical copies of a databaseyesyes infoby Federationyes, each node contains all data
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
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, allnoneImmediate Consistency
Foreign keys infoReferential integrityyesnonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnonoACID
Concurrency infoSupport for concurrent manipulation of datayes, multi-version concurrency control (MVCC)yesyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes, flexibel persistency by using storage technologies like Apache Kafka, RocksDB or LMDB
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnono
User concepts infoAccess controlfine grained access rights according to SQL-standardno
More information provided by the system vendor
H2OpenSearchPrometheusSWC-DB infoSuper Wide Column DatabaseXTDB infoformerly named Crux
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
3rd partiesAiven for OpenSearch: Fully managed open source search and analytics suite. Out-of-the-box integrations get you up and running in a couple of clicks.
» more

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
H2OpenSearchPrometheusSWC-DB infoSuper Wide Column DatabaseXTDB infoformerly named Crux
Recent citations in the news

Hybrid Search with Amazon OpenSearch Service
19 March 2024, AWS Blog

Amazon OpenSearch Ingestion is now available in 2 additional commercial regions
15 February 2024, AWS Blog

Amazon OpenSearch H2 2023 in review
15 March 2024, AWS Blog

Track Amazon OpenSearch Service configuration changes more easily with new visibility improvements | Amazon Web ...
6 February 2024, AWS Blog

Petabyte-scale log analytics with Amazon S3, Amazon OpenSearch Service, and Amazon OpenSearch Ingestion ...
7 March 2024, AWS Blog

provided by Google News

VTEX scales to 150 million metrics using Amazon Managed Service for Prometheus | Amazon Web Services
10 March 2024, AWS Blog

VictoriaMetrics Offers Prometheus Replacement for Time Series Monitoring
17 July 2023, The New Stack

Linux System Monitoring with Prometheus, Grafana, and collectd
1 February 2024, Linux Journal

Consider Grafana vs. Prometheus for your time-series tools
18 October 2021, TechTarget

How to reduce Istio sidecar metric cardinality with Amazon Managed Service for Prometheus | Amazon Web Services
10 October 2023, AWS Blog

provided by Google News

2022 All O-Zone Football Team
17 December 2022, Ozarks Sports Zone

provided by Google News



Share this page

Featured Products

SingleStore logo

The database to transact, analyze and contextualize your data in real time.
Try it today.

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB 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

Neo4j logo

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

Milvus logo

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

Present your product here