DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > HBase vs. Microsoft SQL Server vs. ScyllaDB

System Properties Comparison HBase vs. Microsoft SQL Server vs. ScyllaDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameHBase  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparisonScyllaDB  Xexclude from comparison
DescriptionWide-column store based on Apache Hadoop and on concepts of BigTableMicrosofts flagship relational DBMSCassandra and DynamoDB compatible wide column store
Primary database modelWide column storeRelational DBMSKey-value store
Wide column store
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score43.19
Rank#26  Overall
#2  Wide column stores
Score941.20
Rank#3  Overall
#3  Relational DBMS
Score3.75
Rank#90  Overall
#16  Key-value stores
#8  Wide column stores
Websitehbase.apache.orgwww.microsoft.com/­en-us/­sql-serverwww.scylladb.com
Technical documentationhbase.apache.orgdocs.microsoft.com/­en-US/­sql/­sql-serverdocs.scylladb.com
DeveloperApache Software Foundation infoApache top-level project, originally developed by PowersetMicrosoftScyllaDB
Initial release200819892015
Current release2.3.4, January 2021SQL Server 2019, November 2019Scylla Open Source 4.6, March 2022
License infoCommercial or Open SourceOpen Source infoApache version 2commercial inforestricted free version is availableOpen Source infoOpen Source (AGPL), commercial license available
Cloud-based only infoOnly available as a cloud servicenonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Cloudera Operational Database: Cloud-native autonomous Apache HBase for unparalleled scale, performance and reliability. Automate and simplify database management with capabilities like auto-scale, auto-heal, and auto-tune.Scylla Cloud: Create real-time applications that run at global scale with Scylla Cloud, the industry’s most powerful NoSQL DBaaS
Implementation languageJavaC++C++
Server operating systemsLinux
Unix
Windows infousing Cygwin
Linux
Windows
Linux
Data schemeschema-free, schema definition possibleyesschema-free
Typing infopredefined data types such as float or dateoptions to bring your own types, AVROyesyes
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.noyesno
Secondary indexesnoyesyes infocluster global secondary indices
SQL infoSupport of SQLnoyesSQL-like DML and DDL statements (CQL)
APIs and other access methodsJava API
RESTful HTTP API
Thrift
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
Proprietary protocol (CQL) infocompatible with CQL (Cassandra Query Language, an SQL-like language)
RESTful HTTP API (DynamoDB compatible)
Thrift
Supported programming languagesC
C#
C++
Groovy
Java
PHP
Python
Scala
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
For CQL interface: C#, C++, Clojure, Erlang, Go, Haskell, Java, JavaScript, Node.js, Perl, PHP, Python, Ruby, Rust, Scala
For DynamoDB interface: .Net, ColdFusion, Erlang, Groovy, Java, JavaScript, Perl, PHP, Python, Ruby
Server-side scripts infoStored proceduresyes infoCoprocessors in JavaTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Javayes, Lua
Triggersyesyesno
Partitioning methods infoMethods for storing different data on different nodesShardingtables can be distributed across several files (horizontal partitioning); sharding through federationSharding
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication
Source-replica replication
yes, but depending on the SQL-Server Editionselectable replication factor infoRepresentation of geographical distribution of servers is possible
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency or Eventual ConsistencyImmediate ConsistencyEventual Consistency
Tunable Consistency infocan be individually decided for each write operation
Foreign keys infoReferential integritynoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataSingle row ACID (across millions of columns)ACIDno infoAtomicity and isolation are supported for single operations
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyes infoin-memory tables
User concepts infoAccess controlAccess Control Lists (ACL) for RBAC, integration with Apache Ranger for RBAC & ABACfine grained access rights according to SQL-standardAccess rights for users can be defined per object
More information provided by the system vendor
HBaseMicrosoft SQL ServerScyllaDB
Specific characteristicsApache HBase is the leading NoSQL, distributed database management system, well suited...
» more
Scylla is a highly-available, highly-scalable, highly-performant NoSQL database....
» more
Competitive advantagesNo single point of failure ensures very high availability with multiple customers...
» more
Highly-performant (efficiently utilizes full resources of a node and network; millions...
» more
Typical application scenariosInternet of Things (IOT), fraud detection applications, recommendation engines, product...
» more
AdTech ( AdGear , AppMonet , Dstillery , FullContact , MediaMath , Numberly , SAS...
» more
Key customersApple, Salesforce, Cerner, Allegis Group, Bloomberg, Airtel, Thomson Reuters, Dish,...
» more
Comcast, Grab, OlaCabs, Yahoo! Japan, IMVU, Adgear, Xandr, Zenly, Natura, Snapfish,...
» more
Market metrics#1 largest NoSQL database by revenue
» more
Licensing and pricing modelsApache license P ricing for commercial distribution provided by Cloudera and available...
» more
Scylla Open Source - free open source software (AGPL) Scylla Enterprise - subscription-based...
» 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 partiesNavicat Monitor is a safe, simple and agentless remote server monitoring tool for SQL Server and many other database management systems.
» more

DbVisualizer is equipping database professionals with the tools they need to build, manage and maintain state-of-the-art database technologies. It has sky-high user satisfaction and is the preferred tool for database professionals around the world. Customers include Tesla, Apple, Facebook, Deutsche Bank, NASA, and 25,000 others in 145 countries.
» more

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

SQL Complete: An advanced IntelliSense-style code completion add-in for SSMS and Visual Studio. Write, beautify, refactor your SQL code and give your productivity a dramatic boost.
» 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

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

More resources
HBaseMicrosoft SQL ServerScyllaDB
DB-Engines blog posts

Cloudera's HBase PaaS offering now supports Complex Transactions
11 August 2021,  Krishna Maheshwari (sponsor) 

Why is Hadoop not listed in the DB-Engines Ranking?
13 May 2013, 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

SQL and Complex Queries Are Needed for Real-Time Analytics
18 April 2022, thenewstack.io

Review: HBase is massively scalable -- and hugely complex
31 March 2014, InfoWorld

The Apache Software Foundation Announces the 10th Anniversary of Apache® HBase
13 May 2020, GlobeNewswire

Unified MLOps: Feature Stores and Model Deployment
13 May 2022, InfoQ.com

HBase: The database big data left behind
6 May 2016, InfoWorld

provided by Google News

How to Set Up a Microsoft SQL Server Database in Docker on Linux - MUO
8 May 2022, MakeUseOf

Rockset Enables Real-Time Analytics for Microsoft SQL Server
4 May 2022, Database Trends and Applications

SQL Server Transformation Market Size, Outlook, Strategies, Manufacturers, Type and Application, Global Forecast To 2029 – SMU Daily Mustang
15 May 2022, SMU Daily Mustang

Google Cloud Launches New Postgres-Compatible Database, AlloyDB
11 May 2022, Datanami

8 proven ways African database administrators can make money online
15 May 2022, Business Insider Africa

provided by Google News

Cloud Database Demand Spurs 198% Growth for ScyllaDB
25 January 2022, GlobeNewswire

Monstrously fast + scalable NoSQL database, ScyllaDB, now available on AWS Marketplace
13 April 2022, GlobeNewswire

ScyllaDB Announces Scylla Enterprise 2021 NoSQL Database
20 May 2021, GlobeNewswire

ScyllaDB Announces NoSQL Database as a Service Now Available on Google Cloud
4 August 2021, GlobeNewswire

Top NoSQL Innovators Honored with ScyllaDB Awards
16 February 2022, GlobeNewswire

provided by Google News

Job opportunities

Data Scientist
Source Enterprises, New York, NY

Data Engineer - Healthcare, Amazon Care
Amazon.com Services LLC, Remote

AI researcher
Qikspace, Seattle, WA

Data Engineer - Amazon Distribution and Grocery Innovation
Amazon.com Services LLC, Remote

Data Analyst (+2 years Exp., Preferred location India/Pakistan)
Voltaware, Remote

SQL Server DBA
NEXGEN TECHNOLOGIES INC., Remote

Data Engineer - SQL Server
Bonterra, Washington, DC

SQL Server Architect
RealPage, Richardson, TX

SQL Server Developer
Convazant, Remote

SQL Server Developer
The Salvation Army Eastern Territory, West Nyack, NY

Software Engineer - Storage Infrastructure
Discord, San Francisco, CA

Senior Storage Engineer- Persistence Infrastructure
Discord, San Francisco, CA

Senior Software Engineer, Infrastructure
OneSignal, Remote

Systems Engineer / DevOps
Hive, Seattle, WA

Systems Engineer / DevOps
Hive, San Francisco, CA

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.

Vertica logo

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

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.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Redis logo

The world’s most loved real‑time data platform.
Try free

Present your product here