DB-EnginesExtremeDB: is hard real time possible with a dbms?English
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Drizzle vs. Google BigQuery vs. Impala vs. KairosDB vs. Microsoft SQL Server

System Properties Comparison Drizzle vs. Google BigQuery vs. Impala vs. KairosDB vs. Microsoft SQL Server

Editorial information provided by DB-Engines
NameDrizzle  Xexclude from comparisonGoogle BigQuery  Xexclude from comparisonImpala  Xexclude from comparisonKairosDB  Xexclude from comparisonMicrosoft SQL Server  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.
DescriptionMySQL fork with a pluggable micro-kernel and with an emphasis of performance over compatibility.Large scale data warehouse service with append-only tablesAnalytic DBMS for HadoopDistributed Time Series DBMS based on Cassandra or H2Microsofts flagship relational DBMS
Primary database modelRelational DBMSRelational DBMSRelational DBMSTime Series DBMSRelational DBMS
Secondary database modelsDocument storeDocument store
Graph DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score45.62
Rank#24  Overall
#16  Relational DBMS
Score18.46
Rank#39  Overall
#24  Relational DBMS
Score0.68
Rank#210  Overall
#15  Time Series DBMS
Score944.81
Rank#3  Overall
#3  Relational DBMS
Websitecloud.google.com/­bigquerywww.cloudera.com/­products/­open-source/­apache-hadoop/­impala.htmlgithub.com/­kairosdb/­kairosdbwww.microsoft.com/­en-us/­sql-server
Technical documentationcloud.google.com/­bigquery/­docsdocs.cloudera.com/­documentation/­enterprise/­latest/­topics/­impala.htmlkairosdb.github.iodocs.microsoft.com/­en-US/­sql/­sql-server
DeveloperDrizzle project, originally started by Brian AkerGoogleClouderaMicrosoft
Initial release20082010201320131989
Current release7.2.4, September 20124.0.0, July 20211.2.2, November 2018SQL Server 2019, November 2019
License infoCommercial or Open SourceOpen Source infoGNU GPLcommercialOpen Source infoApache Version 2Open Source infoApache 2.0commercial inforestricted free version is available
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.
Implementation languageC++C++JavaC++
Server operating systemsFreeBSD
Linux
OS X
hostedLinuxLinux
OS X
Windows
Linux
Windows
Data schemeyesyesyesschema-freeyes
Typing infopredefined data types such as float or dateyesyesyesyesyes
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.nononoyes
Secondary indexesyesnoyesnoyes
SQL infoSupport of SQLyes infowith proprietary extensionsyesSQL-like DML and DDL statementsnoyes
APIs and other access methodsJDBCRESTful HTTP/JSON APIJDBC
ODBC
Graphite protocol
HTTP REST
Telnet API
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
Supported programming languagesC
C++
Java
PHP
.Net
Java
JavaScript
Objective-C
PHP
Python
Ruby
All languages supporting JDBC/ODBCJava
JavaScript infoNode.js
PHP
Python
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
Server-side scripts infoStored proceduresnouser defined functions infoin JavaScriptyes infouser defined functions and integration of map-reducenoTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Java
Triggersno infohooks for callbacks inside the server can be used.nononoyes
Partitioning methods infoMethods for storing different data on different nodesShardingnoneShardingSharding infobased on Cassandratables can be distributed across several files (horizontal partitioning); sharding through federation
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication
Source-replica replication
selectable replication factorselectable replication factor infobased on Cassandrayes, but depending on the SQL-Server Edition
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyes infoquery execution via MapReducenono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual ConsistencyEventual Consistency infobased on Cassandra
Immediate Consistency infobased on Cassandra
Immediate Consistency
Foreign keys infoReferential integrityyesnononoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDno infoSince BigQuery is designed for querying datanonoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nononoyes
User concepts infoAccess controlPluggable authentication mechanisms infoe.g. LDAP, HTTPAccess privileges (owner, writer, reader) on dataset, table or view level infoGoogle Cloud Identity & Access Management (IAM)Access rights for users, groups and roles infobased on Apache Sentry and Kerberossimple password-based access controlfine 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,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services
3rd partiesSQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

CData: Connect to Big Data & NoSQL through standard Drivers.
» more
Navicat Monitor is a safe, simple and agentless remote server monitoring tool for SQL Server and many other database management systems.
» more

Fivetran: Quickly and easily centralize your on-premise and cloud databases.
» more

SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

Navicat for SQL Server gives you a fully graphical approach to database management and development.
» more

DBHawk: Secure access to SQL, NoSQL and Cloud databases with an all-in-one solution.
» more

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

More resources
DrizzleGoogle BigQueryImpalaKairosDBMicrosoft SQL Server
DB-Engines blog posts

MySQL won the April ranking; did its forks follow?
1 April 2015, Paul Andlinger

Has MySQL finally lost its mojo?
1 July 2013, Matthias Gelbmann

show all

Cloud-based DBMS's popularity grows at high rates
12 December 2019, Paul Andlinger

The popularity of cloud-based DBMSs has increased tenfold in four years
7 February 2017, Matthias Gelbmann

Increased popularity for consuming DBMS services out of the cloud
2 October 2015, Paul Andlinger

show all

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

Microsoft SQL Server is the DBMS of the Year
4 January 2017, Matthias Gelbmann, Paul Andlinger

show all

Recent citations in the news

Winning the 2020 Google Cloud Technology Partner of the Year – Infrastructure Modernization Award
20 July 2021, CIO

Google’s Logica language addresses SQL’s flaws
15 April 2021, InfoWorld

provided by Google News

Cloudera Boosts Hadoop App Development On Impala
10 November 2014, InformationWeek

Cloudera’s Impala brings Hadoop to SQL and BI
25 October 2012, ZDNet

Harnessing Data In Motion - insideHPC
10 January 2022, insideHPC

Unravel Data Adds Native Support for Impala and Kafka
29 June 2017, insideBIGDATA

Cloudera aims to bring real-time queries to Hadoop, big data
24 October 2012, ZDNet

provided by Google News

The Rise of Time Series Databases
3 March 2020, Automation.com

provided by Google News

Best Data Modeling Tools and Software for 2022 | eWEEK
27 January 2022, eWeek

Understanding Dirty Reads: What NOLOCK Does to Your Queries
21 January 2022, Redmondmag.com

Global SQL Server Performance Monitoring Tools and Software Market 2021 Key Companies Growth by 2027 – Solarwinds, Idera, Lepide, Heroix Longitude, SQL Power Tools – The Oxford Spokesman
24 January 2022, The Oxford Spokesman

Global SQL Server Transformation Market 2021 Comprehensive Analysis, Business Growing Strategies, Industry Segmentation and Forecast 2027 – The Oxford Spokesman
26 January 2022, The Oxford Spokesman

i IT POSITIONS: Fairfield, NJ and various unanticipated locations throughout
27 January 2022, New Jersey Hills

provided by Google News

Job opportunities

Presales Engineer - Voltage Data Privacy & Protection
Micro Focus, Sunnyvale, CA

Tableau Developer
Capgemini, Chicago, IL

Tableau Administrator
MAXIMUS, Remote

Data Architect
Telnet Inc, Texas

Federal - ETL Developer Engineer Specialist
Accenture, St. Louis, MO

Cloud Security/DevOps Engineer
SYNTASA, Herndon, VA

SQL Server Developer
WorkCog, Remote

Sr. SQL Server DBA
XTIVIA, Inc., Remote

SQL Server Developer
Spruce, New York, NY

SQL Server DBA
Volto Consulting, Remote

Azure SQL Server DBA
Mid America Mortgage, Remote

jobs by Indeed



Share this page

Featured Products

Neo4j logo

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

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

Present your product here