DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Alibaba Cloud AnalyticDB for MySQL vs. Apache Drill vs. Apache Impala vs. Datastax Enterprise

System Properties Comparison Alibaba Cloud AnalyticDB for MySQL vs. Apache Drill vs. Apache Impala vs. Datastax Enterprise

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAlibaba Cloud AnalyticDB for MySQL  Xexclude from comparisonApache Drill  Xexclude from comparisonApache Impala  Xexclude from comparisonDatastax Enterprise  Xexclude from comparison
DescriptionA real-time data warehousing service that can process petabytes of data with high concurrency and low latency. It is fully compatible with the MySQL protocol.Schema-free SQL Query Engine for Hadoop, NoSQL and Cloud StorageAnalytic DBMS for HadoopDataStax Enterprise (DSE) is the always-on, scalable data platform built on Apache Cassandra and designed for hybrid Cloud. DSE integrates graph, search, analytics, administration, developer tooling, and monitoring into a unified platform.
Primary database modelRelational DBMSDocument store
Relational DBMS
Relational DBMSWide column store
Secondary database modelsDocument storeDocument storeDocument store
Graph DBMS
Spatial DBMS
Search engine
Vector DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.91
Rank#201  Overall
#94  Relational DBMS
Score2.02
Rank#124  Overall
#22  Document stores
#59  Relational DBMS
Score12.45
Rank#40  Overall
#24  Relational DBMS
Score5.93
Rank#56  Overall
#4  Wide column stores
Websitewww.alibabacloud.com/­product/­analyticdb-for-mysqldrill.apache.orgimpala.apache.orgwww.datastax.com/­products/­datastax-enterprise
Technical documentationwww.alibabacloud.com/­help/­doc-detail/­93776.htmdrill.apache.org/­docsimpala.apache.org/­impala-docs.htmldocs.datastax.com
DeveloperAlibabaApache Software FoundationApache Software Foundation infoApache top-level project, originally developed by ClouderaDataStax
Initial release201220132011
Current release1.20.3, January 20234.1.0, June 20226.8, April 2020
License infoCommercial or Open SourcecommercialOpen Source infoApache Version 2Open Source infoApache Version 2commercial
Cloud-based only infoOnly available as a cloud serviceyesnonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Datastax Astra DB: Astra DB simplifies cloud-native Cassandra application development for your apps, microservices and functions. Deploy in minutes on AWS, Google Cloud, Azure, and have it managed for you by the experts, with serverless, pay-as-you-go pricing.
Implementation languageC++Java
Server operating systemshostedLinux
OS X
Windows
LinuxLinux
OS X
Data schemeyesschema-freeyesschema-free
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.yesnonono
Secondary indexesyesnoyesyes
SQL infoSupport of SQLyesSQL SELECT statement is SQL:2003 compliantSQL-like DML and DDL statementsSQL-like DML and DDL statements (CQL); Spark SQL
APIs and other access methodsJDBC
ODBC
JDBC
ODBC
RESTful HTTP API
JDBC
ODBC
Proprietary protocol infoCQL (Cassandra Query Language)
TinkerPop Gremlin infowith DSE Graph
Supported programming languagesC#
Java
PHP
Python
C++All languages supporting JDBC/ODBCC
C#
C++
Java
JavaScript (Node.js)
PHP
Python
Ruby
Server-side scripts infoStored proceduresyesuser defined functionsyes infouser defined functions and integration of map-reduceno
Triggersyesnonoyes
Partitioning methods infoMethods for storing different data on different nodesSharding infoImplicit feature of the cloud serviceShardingShardingSharding infono "single point of failure"
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoImplicit feature of the cloud serviceselectable replication factorconfigurable replication factor, datacenter aware, advanced replication for edge computing
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesyes infoquery execution via MapReduceyes
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencynoneEventual ConsistencyImmediate Consistency
Tunable Consistency infoconsistency level can be individually decided with each write operation
Foreign keys infoReferential integrityyesnonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnonono infoAtomicity and isolation are supported for single operations
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesDepending on the underlying data sourceyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesDepending on the underlying data sourcenoyes
User concepts infoAccess controlfine grained access rights according to SQL-standardDepending on the underlying data sourceAccess rights for users, groups and roles infobased on Apache Sentry and KerberosAccess rights for users can be defined per object
More information provided by the system vendor
Alibaba Cloud AnalyticDB for MySQLApache DrillApache ImpalaDatastax Enterprise
Specific characteristicsA real-time data warehousing service that can process PB data with high concurrency...
» more
DataStax Enterprise is scale-out data infrastructure for enterprises that need to...
» more
Competitive advantagesTPC Benchmark: The world leading result in TPC-DS benchmark . TPC-H benchmark for...
» more
Supporting the following application requirements: Zero downtime - Built on Apache...
» more
Typical application scenariosApplications that must be massively and linearly scalable with 100% uptime and able...
» more
Key customersCapital One, Cisco, Comcast, eBay, McDonald's, Microsoft, Safeway, Sony, UBS, and...
» more
Market metricsAmong the Forbes 100 Most Innovative Companies, DataStax is trusted by 5 of the top...
» more
Licensing and pricing modelsAvailable regions: America US Virginia US Silicon Valley Asia China Hong Kong India...
» more
Annual subscription
» 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

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

More resources
Alibaba Cloud AnalyticDB for MySQLApache DrillApache ImpalaDatastax Enterprise
Recent citations in the news

Alibaba Cloud launches new cloud database solutions following market growth
1 October 2020, DataCenterNews Asia

How Data Analytics Capabilities of Alibaba Group Evolve Its Ecosystem to the Cloud
20 February 2021, DataDrivenInvestor

Gartner’s Magic Quadrant for Cloud Database Management Systems
9 December 2020, CRN

Alibaba Cloud Named a Leader in Gartner(R) Magic Quadrant(TM) for Cloud Database Management Systems
8 February 2024, ryt9.com

AWS, IBM, Microsoft, Google emerge Cloud DBMS leaders
22 December 2022, Daily Host News

provided by Google News

Apache Drill vs. Apache Spark — Which SQL query engine is better for you?
23 September 2019, Towards Data Science

Apache Drill case study: A tutorial on processing CSV files
9 June 2016, TheServerSide.com

Apache Drill Poised to Crack Tough Data Challenges
19 May 2015, Datanami

Apache Drill Eliminates ETL, Data Transformation for MapR Database
11 April 2016, The New Stack

Drill Mines Diverse Data Sets, Google Style
20 May 2015, The Next Platform

provided by Google News

Apache Impala becomes Top-Level Project
28 November 2017, SDTimes.com

Cloudera Bringing Impala to AWS Cloud
28 November 2017, Datanami

Apache Doris just 'graduated': Why care about this SQL data warehouse
24 June 2022, InfoWorld

Hudi: Uber Engineering’s Incremental Processing Framework on Apache Hadoop
12 March 2017, Uber

Updates & Upserts in Hadoop Ecosystem with Apache Kudu
27 October 2017, KDnuggets

provided by Google News

DataStax previews new Hyper Converged Data Platform for enterprise AI
15 May 2024, VentureBeat

DataStax Launches New Hyper-Converged Data Platform Giving Enterprises the Complete Modern Data Center Suite ...
15 May 2024, Business Wire

DataStax and LlamaIndex Partner to Make Building RAG Applications Easier than Ever for GenAI Developers
20 February 2024, insideBIGDATA

DataStax Introduces Enhanced RAG Capabilities Through Astra DB and NVIDIA Tech
19 March 2024, Datanami

DataStax goes vector searching with Astra DB
20 July 2023, Blocks and Files

provided by Google News



Share this page

Featured Products

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

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