DB-EnginesextremeDB - Data management wherever you need itEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > Kdb vs. OpenSearch vs. Snowflake vs. TerminusDB

System Properties Comparison Kdb vs. OpenSearch vs. Snowflake vs. TerminusDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameKdb  Xexclude from comparisonOpenSearch  Xexclude from comparisonSnowflake  Xexclude from comparisonTerminusDB infoformer name was DataChemist  Xexclude from comparison
DescriptionHigh performance Time Series DBMSA distributed, RESTful search and analytics engine forked from Elasticsearch and based on Apache LuceneCloud-based data warehousing service for structured and semi-structured dataScalable Graph Database platform making enterprise data available by exploiting inferred entities and relationships
Primary database modelTime Series DBMS
Vector DBMS
Search engineRelational DBMSGraph DBMS
Secondary database modelsRelational DBMSVector DBMSDocument store
RDF store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score7.73
Rank#45  Overall
#2  Time Series DBMS
#1  Vector DBMS
Score16.31
Rank#36  Overall
#4  Search engines
Score133.72
Rank#7  Overall
#5  Relational DBMS
Score0.19
Rank#311  Overall
#27  Graph DBMS
Websitekx.comgithub.com/­opensearch-project
opensearch.org
www.snowflake.comterminusdb.com
Technical documentationcode.kx.comopensearch.org/­docs/­latestdocs.snowflake.net/­manuals/­index.htmlterminusdb.github.io/­terminusdb/­#
DeveloperKx Systems, a division of First Derivatives plcAmazon Web ServicesSnowflake Computing Inc.DataChemist Ltd.
Initial release2000 infokdb was released 2000, kdb+ in 2003202120142018
Current release3.6, May 20182.5.0, January 202311.0.0, January 2023
License infoCommercial or Open Sourcecommercial infofree 32-bit versionOpen Source infoApache Version 2.0commercialOpen Source infoGPL V3
Cloud-based only infoOnly available as a cloud servicenonoyesno
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 languageqJavaProlog, Rust
Server operating systemsLinux
OS X
Solaris
Windows
All OS with a Java VMhostedLinux
Data schemeyesschema-free infoFlexible type definitions. Once a type is defined, it is persistentyes infosupport of semi-structured data formats (JSON, XML, Avro)yes
Typing infopredefined data types such as float or dateyesyesyesyes
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.yesyesno
Secondary indexesyes infotable attribute 'grouped'yes infoAll search fields are automatically indexed
SQL infoSupport of SQLSQL-like query language (q)SQL-like query languageyesSQL-like query language (WOQL)
APIs and other access methodsHTTP API
JDBC
Jupyter
Kafka
ODBC
WebSocket
Java API
RESTful HTTP/JSON API
CLI Client
JDBC
ODBC
OWL
RESTful HTTP API
WOQL (Web Object Query Language)
Supported programming languagesC
C#
C++
Go
J
Java
JavaScript
Lua
MatLab
Perl
PHP
Python
R
Scala
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby infoElasticsearch client
JavaScript (Node.js)
Python
JavaScript
Python
Server-side scripts infoStored proceduresuser defined functionsyesuser defined functionsyes
Triggersyes infowith viewsyes infoby using the 'percolation' featureno infosimilar concept for controling cloud resourcesyes
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioningShardingyesGraph Partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replicationyesyesJournaling Streams
MapReduce infoOffers an API for user-defined Map/Reduce methodsno infosimilar paradigm used for internal processingnono
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 Consistency
Foreign keys infoReferential integrityyesnoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanonoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes infoin-memory journaling
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesno
User concepts infoAccess controlrights management via user accountsUsers with fine-grained authorization concept, user roles and pluggable authenticationRole-based access control
More information provided by the system vendor
KdbOpenSearchSnowflakeTerminusDB infoformer name was DataChemist
Specific characteristicsIntegrated columnar database & programming system for streaming, real time and historical...
» more
OpenSearch is a highly scalable and extensible open-source software suite for search,...
» more
Competitive advantagesprovides seamless scalability; runs on industry standard server platforms; is top-ranked...
» more
Distributed as fully open source under Apache License, Version 2.0 (ALv2), OpenSearch...
» more
Typical application scenariostick database streaming sensor data massive intelligence applications oil and gas...
» more
The OpenSearch platform is used across a broad range of search , analytics, and observability...
» more
Key customersGoldman Sachs Morgan Stanley Merrill Lynch J.P. Morgan Deutsche Bank IEX Securities...
» more
Market metricskdb+ performance and reliability proven by our customers in critical infrastructure...
» more
Licensing and pricing modelsupon request
» more
The 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 partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more

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

More resources
KdbOpenSearchSnowflakeTerminusDB infoformer name was DataChemist
DB-Engines blog posts

Snowflake is the DBMS of the Year 2022, defending the title from last year
3 January 2023, Matthias Gelbmann, Paul Andlinger

Snowflake is the DBMS of the Year 2021
3 January 2022, Paul Andlinger, Matthias Gelbmann

show all

Recent citations in the news

Turbocharging the Engine: KX Unleashes AI-First Transformation with kdb+
28 February 2024, Business Wire

Introducing Amazon FinSpace with Managed kdb Insights, a fully managed analytics engine, commonly used by capital markets customers for analysis of real-time and historical time series data
18 May 2023, AWS Blog

McLaren Applied and KX partner to enhance ATLAS software analytics capabilities
9 August 2023, Professional Motorsport World

KX Brings the Power and Performance of kdb+ to Python Developers with PyKX
7 June 2023, Datanami

Time for the Kdb/Q specialists to quit finance?
18 May 2017, eFinancialCareers

provided by Google News

Achieve cross-Region resilience with Amazon OpenSearch Ingestion
24 September 2024, AWS Blog

AWS brings OpenSearch under the Linux Foundation umbrella
16 September 2024, TechCrunch

Amazon Donates OpenSearch To Linux Foundation
20 September 2024, iProgrammer

AWS hands OpenSearch to the Linux Foundation
16 September 2024, InfoWorld

Amazon OpenSearch Service now supports OpenSearch version 2.15
10 September 2024, AWS Blog

provided by Google News

Hacker behind Snowflake customer data breaches remains active
21 September 2024, CyberScoop

Snowflake expands its data cloud platform with capabilities tailored for travel
24 September 2024, PhocusWire

Snowflake’s AI Data Cloud for Travel and Hospitality Drives AI Innovation, Enhances Collaboration, and Transforms Customer Experiences
24 September 2024, Business Wire

Snowflake seeks to raise funds with $2B bond sale
24 September 2024, The Register

Snowflake launches AI data platform for travel and hospitality industry
24 September 2024, Yahoo Finance

provided by Google News

How TerminusDB is commercializing its open source graph database
16 March 2021, VentureBeat

[MCR2030-CAMS-ARISE-UNDRR Webinar] Preventing cascading failures of critical assets: Using the Open-Source Critical Asset Management System (CAMS) to help cities become disaster and climate resilient
12 April 2022, United Nations Office for Disaster Risk Reduction

Trinity College spinout TerminusDB secures €3.6m in investment
15 March 2021, The Irish Times

Bus Terminus Update – April 26th
26 April 2021, Around DB and Life on Lantau

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