DBMS > Brytlyt vs. Drizzle vs. Impala vs. JaguarDB

System Properties Comparison Brytlyt vs. Drizzle vs. Impala vs. JaguarDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	Brytlyt  Xexclude from comparison	Drizzle  Xexclude from comparison	Impala  Xexclude from comparison	JaguarDB  Xexclude from comparison
		Drizzle has published its last release in September 2012. The open-source project is discontinued and Drizzle is excluded from the DB-Engines ranking.
Description	Scalable GPU-accelerated RDBMS for very fast analytic and streaming workloads, leveraging PostgreSQL	MySQL fork with a pluggable micro-kernel and with an emphasis of performance over compatibility.	Analytic DBMS for Hadoop	Performant, highly scalable DBMS for AI and IoT applications
Primary database model	Relational DBMS	Relational DBMS	Relational DBMS	Key-value store
Secondary database models			Document store
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 0.31 Rank #271   Overall #125   Relational DBMS		Score 17.79 Rank #40   Overall #25   Relational DBMS	Score 0.00 Rank #363   Overall #57   Key-value stores
Website	www.brytlyt.com		www.cloudera.com/­products/­open-source/­apache-hadoop/­impala.html	www.datajaguar.com
Technical documentation			docs.cloudera.com/­documentation/­enterprise/­latest/­topics/­impala.html	www.datajaguar.com/­support.php
Developer	Brytlyt	Drizzle project, originally started by Brian Aker	Cloudera	DataJaguar, Inc.
Initial release	2016	2008	2013	2015
Current release	0.9, October 2016	7.2.4, September 2012	4.0.0, July 2021	2.9.4 September 2018
License Commercial or Open Source	commercial	Open Source GNU GPL	Open Source Apache Version 2	Open Source GPL V3.0
Cloud-based only Only available as a cloud service	no	no	no	no
DBaaS offerings (sponsored links) Database as a Service Providers of DBaaS offerings, please contact us to be listed.
Implementation language	C, C++ and CUDA	C++	C++	C++ the server part. Clients available in other languages
Server operating systems	Linux OS X Windows	FreeBSD Linux OS X	Linux	Linux
Data scheme	yes	yes	yes	yes
Typing predefined data types such as float or date	yes	yes	yes	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.	yes specific XML-type available, but no XML query functionality.		no	no
Secondary indexes	yes	yes	yes	yes
SQL Support of SQL	yes	yes with proprietary extensions	SQL-like DML and DDL statements	A subset of ANSI SQL is implemented but no views, foreign keys, triggers
APIs and other access methods	ADO.NET JDBC native C library ODBC streaming API for large objects	JDBC	JDBC ODBC	JDBC ODBC
Supported programming languages	.Net C C++ Delphi Java Perl Python Tcl	C C++ Java PHP	All languages supporting JDBC/ODBC	C C++ Go Java JavaScript (Node.js) PHP Python Ruby Scala
Server-side scripts Stored procedures	user defined functions in PL/pgSQL	no	yes user defined functions and integration of map-reduce	no
Triggers	yes	no hooks for callbacks inside the server can be used.	no	no
Partitioning methods Methods for storing different data on different nodes		Sharding	Sharding	Sharding
Replication methods Methods for redundantly storing data on multiple nodes	Source-replica replication	Multi-source replication Source-replica replication	selectable replication factor	Multi-source replication
MapReduce Offers an API for user-defined Map/Reduce methods	no	no	yes query execution via MapReduce	no
Consistency concepts Methods to ensure consistency in a distributed system	Immediate Consistency		Eventual Consistency	Eventual Consistency
Foreign keys Referential integrity	yes	yes	no	no
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data	ACID	ACID	no	no
Concurrency Support for concurrent manipulation of data	yes	yes	yes	yes
Durability Support for making data persistent	yes	yes	yes	yes
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.			no	no
User concepts Access control	fine grained access rights according to SQL-standard	Pluggable authentication mechanisms e.g. LDAP, HTTP	Access rights for users, groups and roles based on Apache Sentry and Kerberos	rights management via user accounts
More information provided by the system vendor 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
	Brytlyt	Drizzle	Impala	JaguarDB
DB-Engines blog posts