DB-EnginesExtremeDB for everyone with an RTOSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > HBase vs. Interbase vs. Microsoft SQL Server vs. TerarkDB vs. YugabyteDB

System Properties Comparison HBase vs. Interbase vs. Microsoft SQL Server vs. TerarkDB vs. YugabyteDB

Editorial information provided by DB-Engines
NameHBase  Xexclude from comparisonInterbase  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparisonTerarkDB  Xexclude from comparisonYugabyteDB  Xexclude from comparison
DescriptionWide-column store based on Apache Hadoop and on concepts of BigTableLight-weight proven RDBMS infooriginally from BorlandMicrosofts flagship relational DBMSA key-value store forked from RocksDB with advanced compression algorithms. It can be used standalone or as a storage engine for MySQL and MongoDBHigh-performance distributed SQL database for global, internet-scale applications. Wire and feature compatible with PostgreSQL.
Primary database modelWide column storeRelational DBMSRelational DBMSKey-value storeRelational DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
Document store
Wide column store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score30.50
Rank#26  Overall
#2  Wide column stores
Score4.61
Rank#72  Overall
#39  Relational DBMS
Score824.29
Rank#3  Overall
#3  Relational DBMS
Score0.00
Rank#383  Overall
#60  Key-value stores
Score2.91
Rank#102  Overall
#51  Relational DBMS
Websitehbase.apache.orgwww.embarcadero.com/­products/­interbasewww.microsoft.com/­en-us/­sql-servergithub.com/­bytedance/­terarkdbwww.yugabyte.com
Technical documentationhbase.apache.org/­book.htmldocs.embarcadero.com/­products/­interbaselearn.microsoft.com/­en-US/­sql/­sql-serverbytedance.larkoffice.com/­docs/­doccnZmYFqHBm06BbvYgjsHHcKcdocs.yugabyte.com
github.com/­yugabyte/­yugabyte-db
DeveloperApache Software Foundation infoApache top-level project, originally developed by PowersetEmbarcaderoMicrosoftByteDance, originally TerarkYugabyte Inc.
Initial release20081984198920162017
Current release2.3.4, January 2021InterBase 2020, December 2019SQL Server 2022, November 20222.19, September 2023
License infoCommercial or Open SourceOpen Source infoApache version 2commercialcommercial inforestricted free version is availablecommercial inforestricted open source version availableOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
YugabyteDB Managed is the fully managed database-as-a-service offering of YugabyteDB. Get started quickly, and effortlessly ensure continuous availability and limitless scale of your cloud native applications.
Implementation languageJavaCC++C++C and C++
Server operating systemsLinux
Unix
Windows infousing Cygwin
Android
iOS
Linux
OS X
Windows
Linux
Windows
Linux
OS X
Data schemeschema-free, schema definition possibleyesyesschema-freedepending on used data model
Typing infopredefined data types such as float or dateoptions to bring your own types, AVROyesyesnoyes
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.nono infoexport as XML data possibleyesnono
Secondary indexesnoyesyesnoyes
SQL infoSupport of SQLnoyesyesnoyes, PostgreSQL compatible
APIs and other access methodsJava API
RESTful HTTP API
Thrift
ADO.NET
JDBC
ODBC
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
C++ API
Java API
JDBC
YCQL, an SQL-based flexible-schema API with its roots in Cassandra Query Language
YSQL - a fully relational SQL API that is wire compatible with the SQL language in PostgreSQL
Supported programming languagesC
C#
C++
Groovy
Java
PHP
Python
Scala
.Net
C
C++
Delphi
Java
Object Pascal
PHP
Ruby
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
C++
Java
C
C#
C++
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Rust
Scala
Server-side scripts infoStored proceduresyes infoCoprocessors in Javayes infoInterbase procedure and trigger languageTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Javanoyes infosql, plpgsql, C
Triggersyesyesyesnoyes
Partitioning methods infoMethods for storing different data on different nodesShardingnonetables can be distributed across several files (horizontal partitioning); sharding through federationnoneHash and Range Sharding, row-level geo-partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication
Source-replica replication
Interbase Change Viewsyes, but depending on the SQL-Server EditionnoneBased on Raft distributed consensus protocol, minimum 3 replicas for continuous availability
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency or Eventual ConsistencyImmediate ConsistencyImmediate ConsistencyStrong consistency on writes and tunable consistency on reads
Foreign keys infoReferential integritynoyesyesnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataSingle row ACID (across millions of columns)ACIDACIDnoDistributed ACID with Serializable & Snapshot Isolation. Inspired by Google Spanner architecture.
Concurrency infoSupport for concurrent manipulation of datayesyes infoMultiversion concurreny controlyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes infobased on RocksDB
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyesyesno
User concepts infoAccess controlAccess Control Lists (ACL) for RBAC, integration with Apache Ranger for RBAC & ABACfine grained access rights according to SQL-standardfine grained access rights according to SQL-standardnoyes
More information provided by the system vendor
HBaseInterbaseMicrosoft SQL ServerTerarkDBYugabyteDB
Specific characteristicsYugabyteDB is an open source distributed SQL database for cloud native transactional...
» more
Competitive advantagesPostgreSQL compatible: Get instantly productive with a PostgreSQL compatible RDBMS....
» more
Typical application scenariosSystems of record and engagement for cloud native applications that require resilience,...
» more
Market metrics2 Million+ lifetime clusters deployed, 6.5K+ GitHub stars, 7K YugabyteDB Community...
» more
Licensing and pricing modelsApache 2.0 license for the database
» 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

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

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

More resources
HBaseInterbaseMicrosoft SQL ServerTerarkDBYugabyteDB
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

MapR Technologies' Executives to Speak About Big Data, HBase and Hadoop at Upcoming April Conferences
10 May 2024, Yahoo Movies UK

Best Practices from Rackspace for Modernizing a Legacy HBase/Solr Architecture Using AWS Services | Amazon Web ...
9 October 2023, AWS Blog

Less Components, Higher Performance: Apache Doris instead of ClickHouse, MySQL, Presto, and HBase
20 October 2023, hackernoon.com

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

HBase Tutorial
24 February 2023, Simplilearn

provided by Google News

Borland InterBase backdoor detected | ZDNET
11 January 2001, ZDNet

Johnson Sakaja Donates KSh 200k to Support Cash Strapped Football Teams From Kibera - Tuko.co.ke
21 February 2024, Tuko.co.ke

An independent soccer league transforming lives in a slum in Kenya
15 November 2022, FanSided

Malaysian e-commerce firm Lelong.my acquires local digital marketing agency Mataris Agency
29 January 2018, Yahoo Singapore News

AHQ (Unit) Islamabad wins interbase shooting c’ship
11 February 2020, Pakistan Observer

provided by Google News

Data Virtualization in SQL Server 2022
7 May 2024, Visual Studio Magazine

Why migrate Windows Server and SQL Server to Azure: ROI, innovation, and free offers
25 April 2024, Microsoft

May 2024 Patch Tuesday forecast: A reminder of recent threats and impact
10 May 2024, Help Net Security

Monitor query performance with Performance Insights on Amazon RDS for SQL Server | Amazon Web Services
24 April 2024, AWS Blog

How to Know When It's Time for a Microsoft SQL Server Upgrade
31 October 2023, BizTech Magazine

provided by Google News

A Chinese company is making the cloud 200x faster · TechNode
3 July 2017, TechNode

provided by Google News

Yugabyte Achieves PCI DSS Level 1 Compliance, Validating Secure and Scalable Distributed PostgreSQL for ...
14 March 2024, businesswire.com

YugabyteDB Becomes First Distributed SQL Database Vendor to Complete CIS Benchmark
1 February 2024, Datanami

Yugabyte announced details and theme for Distributed SQL Summit Asia
18 April 2024, Martechcube

The surprising link between Formula One and enterprise PostgreSQL optimisation
28 March 2024, The Stack

Yugabyte adds multiregion Kubernetes support to YugabyteDB 2.18
24 May 2023, InfoWorld

provided by Google News



Share this page

Featured Products

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.

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

SingleStore logo

Database for your real-time AI and Analytics Apps.
Try it today.

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

Present your product here