DBMS > Apache Kylin vs. CouchDB vs. Derby
System Properties Comparison Apache Kylin vs. CouchDB vs. Derby
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Apache Kylin Xexclude from comparison||CouchDB stands for "Cluster Of Unreliable Commodity Hardware" Xexclude from comparison||Derby often called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDB Xexclude from comparison|
|Description||A distributed analytics engine for big data, providing a SQL interface and multi-dimensional analysis (OLAP) and leveraging the Hadoop stack||A native JSON - document store inspired by Lotus Notes, scalable from globally distributed server-clusters down to mobile phones.||Full-featured RDBMS with a small footprint, either embedded into a Java application or used as a database server.|
|Primary database model||Relational DBMS||Document store||Relational DBMS|
|Secondary database models||Spatial DBMS using the Geocouch extension|
|Developer||Apache Software Foundation, originally contributed from eBay Inc||Apache Software Foundation Apache top-level project, originally developed by Damien Katz, a former Lotus Notes developer||Apache Software Foundation|
|Current release||3.1.0, July 2020||3.3.2, April 2023||10.16.1.1, May 2022|
|License Commercial or Open Source||Open Source Apache Version 2.0||Open Source Apache version 2||Open Source Apache version 2|
|Cloud-based only Only available as a cloud service||no||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems||Linux||Android|
|All OS with a Java VM|
|Typing predefined data types such as float or date||yes||no||yes|
|XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.||no||no||yes|
|Secondary indexes||yes||yes via views||yes|
|SQL Support of SQL||ANSI SQL for queries (using Apache Calcite)||no||yes|
|APIs and other access methods||JDBC|
RESTful HTTP API
|RESTful HTTP/JSON API||JDBC|
|Supported programming languages||C|
|Partitioning methods Methods for storing different data on different nodes||Sharding improved architecture with release 2.0||none|
|Replication methods Methods for redundantly storing data on multiple nodes||Multi-source replication|
|MapReduce Offers an API for user-defined Map/Reduce methods||yes||yes||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Eventual Consistency||Immediate Consistency|
|Foreign keys Referential integrity||no||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||no atomic operations within a single document possible||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes strategy: optimistic locking||yes|
|Durability Support for making data persistent||yes||yes||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no||no||yes|
|User concepts Access control||Access rights for users can be defined per database||fine grained access rights according to SQL-standard|
More information provided by the system vendor
We invite representatives of system vendors to contact us for updating and extending the system information,
Related products and services
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|Apache Kylin||CouchDB stands for "Cluster Of Unreliable Commodity Hardware"||Derby often called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDB|
|DB-Engines blog posts|
Couchbase climbs up the DB-Engines Ranking, increasing its popularity by 10% every month
|Recent citations in the news|
Overhauling Apache Kylin for the cloud
Introducing Kyligence Copilot: The AI Copilot for Data to Excel Your ...
Apache Druid, TiDB, ClickHouse, or Apache Doris? A Comparison ...
Apache Kylin Adds Real-time OLAP
provided by Google News
NoSQL Databases Software Market Business Overview 2023, and ...
Global NoSQL Databases Software Market Report | Global Forecast From 2023 -2031
NoSQL Software Market Navigating Growth Opportunities and ...
Data Science Careers: In-Demand Skills and Job Prospects
provided by Google News
IBM Acquires StepZen to Help Enterprises Get More Business Value ...
Pentesting mit Legion, sqlmap, ZAP, OpenSCAP, Karkinos und ...
Six free databases with commercial-quality features
Top Tools for ERP Enterprise Resource Planning
Why you should use SQLite
provided by Google News
Senior Marketing Manager
CouchDB Database Administrator (DBA)
Java Backend Developer
Senior Java Developer
Software Development Manager
Datahub Solutions Consultant
DEV OPS ENGINEER
ArchivesSpace Technical Lead
Share this page