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 ApsaraDB for PolarDB vs. Ehcache vs. HEAVY.AI vs. Microsoft SQL Server vs. Tibero

System Properties Comparison Alibaba Cloud ApsaraDB for PolarDB vs. Ehcache vs. HEAVY.AI vs. Microsoft SQL Server vs. Tibero

Editorial information provided by DB-Engines
NameAlibaba Cloud ApsaraDB for PolarDB  Xexclude from comparisonEhcache  Xexclude from comparisonHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparisonTibero  Xexclude from comparison
DescriptionA cloud-native relational database compatible with MySQL, PostgreSQL, and Oracle. Designed for business critical applications.A widely adopted Java cache with tiered storage optionsA high performance, column-oriented RDBMS, specifically developed to harness the massive parallelism of modern CPU and GPU hardwareMicrosofts flagship relational DBMSA secure RDBMS, designed for easy portability from Oracle
Primary database modelRelational DBMSKey-value storeRelational DBMSRelational DBMSRelational DBMS
Secondary database modelsSpatial DBMSDocument store
Graph DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.52
Rank#237  Overall
#113  Relational DBMS
Score6.47
Rank#66  Overall
#9  Key-value stores
Score1.29
Rank#153  Overall
#73  Relational DBMS
Score941.20
Rank#3  Overall
#3  Relational DBMS
Score1.95
Rank#126  Overall
#62  Relational DBMS
Websitewww.alibabacloud.com/­product/­polardbwww.ehcache.orggithub.com/­heavyai/­heavydb
www.heavy.ai
www.microsoft.com/­en-us/­sql-serverwww.tmaxsoft.com/­products/­tibero
Technical documentationwww.alibabacloud.com/­help/­doc-detail/­58764.htmwww.ehcache.org/­documentationdocs.heavy.aidocs.microsoft.com/­en-US/­sql/­sql-servertechnet.tmaxsoft.com/­upload/­download/­online/­tibero/­pver-20150504-000002/­index.html
DeveloperAlibabaTerracotta Inc, owned by Software AGHEAVY.AI, Inc.MicrosoftTmaxSoft
Initial release2009201619892003
Current release3.9.6, September 20215.10, January 2022SQL Server 2019, November 20196, April 2015
License infoCommercial or Open SourcecommercialOpen Source infoApache Version 2; commercial licenses availableOpen Source infoApache Version 2; enterprise edition availablecommercial inforestricted free version is availablecommercial
Cloud-based only infoOnly available as a cloud serviceyesnononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaC++ and CUDAC++C and Assembler
Server operating systemshostedAll OS with a Java VMLinuxLinux
Windows
AIX
HP-UX
Linux
Solaris
Windows
Data schemeyesschema-freeyesyesyes
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.yesnonoyesyes
Secondary indexesyesnonoyesyes
SQL infoSupport of SQLyesnoyesyesyes
APIs and other access methodsJDBC
ODBC
JCacheJDBC
ODBC
Thrift
Vega
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
JDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
Tibero CLI
Supported programming languagesJava
Python
JavaAll languages supporting JDBC/ODBC/Thrift
Python
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
C
C#
C++
Cobol
Java
Objective-C
Perl
PHP
Python
Ruby
Visual Basic
Server-side scripts infoStored proceduresyesnonoTransact SQL, .NET languages, R, Python and (with SQL Server 2019) JavaPersistent Stored Procedure (PSM)
Triggersyesyes infoCache Event Listenersnoyesyes
Partitioning methods infoMethods for storing different data on different nodesSharding infoImplicit feature of the cloud serviceSharding infoby using Terracotta ServerSharding infoRound robintables can be distributed across several files (horizontal partitioning); sharding through federationhorizontal partitioning infoby range, hash, list or composite
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoImplicit feature of the cloud serviceyes infoby using Terracotta ServerMulti-source replicationyes, but depending on the SQL-Server EditionMulti-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyTunable Consistency (Strong, Eventual, Weak)Immediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesnonoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDyes infosupports JTA and can work as an XA resourcenoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyes infousing a tiered cache-storage approachyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyesyesno infoplanned for next version
User concepts infoAccess controlfine grained access rights according to SQL-standardnofine grained access rights according to SQL-standardfine grained access rights according to SQL-standardfine grained access rights according to SQL-standard (SQL 92, SQL 99)
More information provided by the system vendor
Alibaba Cloud ApsaraDB for PolarDBEhcacheHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022Microsoft SQL ServerTibero
Specific characteristicsApsaraDB for PolarDB is a cloud-native relational database 100% compatible with MySQL...
» more
Optimizes memory and compute layers to deliver unprecedented performance. Natively...
» more
Competitive advantagesWebinar: Top Scientists Live: Tech Secrets to Double 11's Success Revealed. White...
» more
Only HEAVY.AI allows users to visually and interactively discover high-value patterns,...
» more
Typical application scenariosCreating a Robust Cloud-Based Database for Fintech, E-Commerce and Gaming. Learn...
» more
Advanced analytics, geospatial and time-series analytics, accelerated data science,...
» more
Licensing and pricing modelsSpecification and pricing. You can use either of the following billing methods to...
» more
HEAVY.AI Free (Free Forever), Foundations ($2k/month), and Enterprise Licensure (Inquire...
» 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 partiesSQL 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

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

Navicat Monitor is a safe, simple and agentless remote server monitoring tool for SQL Server and many other database management systems.
» 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
Alibaba Cloud ApsaraDB for PolarDBEhcacheHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022Microsoft SQL ServerTibero
DB-Engines blog posts

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

Alibaba Cloud vs AWS | Cloud Provider Comparison | ITBE
6 October 2021, IT Business Edge

Alibaba Cloud reports 50% revenue year-over-year growth and named a Leader in CDM by Gartner
19 January 2022, DataCenterNews Asia

An introduction to Alibaba cloud offerings
28 September 2020, TechTarget

provided by Google News

Jira Data Center user? Here's a critical Ehcache vulnerability to spoil your day
22 July 2021, The Register

Ehcache 3.0 Released with Revamped API and Off-Heap Storage
2 May 2016, InfoQ.com

Memcached surpasses EhCache and Coherence in Java Job Demand
13 September 2011, InfoQ.com

Terabyte-sized Java apps now possible
22 July 2010, InfoWorld

How to Create a Spring Boot App With Caching Enabled
1 February 2017, DZone

provided by Google News

The insideBIGDATA IMPACT 50 List for Q2 2022
27 April 2022, insideBIGDATA

OmniSci Gets HEAVY New Name and New CEO
1 March 2022, Datanami

HEAVY.AI launches HEAVY.AI v6.0 with new HeavyConnect feature -
28 March 2022, Enterprise Times

Nvidia unveils a new GPU architecture designed for AI data centers
22 March 2022, Network World

The insideBIGDATA IMPACT 50 List for Q1 2022
10 January 2022, insideBIGDATA

provided by Google News

Google Needs Another Database To Attack Oracle, DB2, And SQL Server Directly
16 May 2022, The Next Platform

Microsoft warns of brute-force attacks targeting MSSQL servers
18 May 2022, BleepingComputer

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

Spektra Systems Has Earned the Windows Server and SQL Server Migration to Microsoft Azure Advanced Specialization
19 May 2022, EIN News

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

provided by Google News

Open-source DBMS becoming battleground of public cloud
17 May 2022, Etnews

TmaxSoft is using clear licensing to woo Oracle database users
15 August 2016, PCWorld

Manage Your Database with TIBERO
24 October 2011, Korea IT Times

SkyDrive and Suzuki to Partner for Flying Two-Seater Electric Flying Cars
27 March 2022, AUTO Connected Car News

Hyundai and Kia Say Good-bye to Oracle and Choose Tmax as DBMS Vendor
13 June 2019, BusinessKorea

provided by Google News

Job opportunities

Jr. Backend Engineer
Viant, Irvine, CA

Lead Software Engineer
Disney Streaming, Seattle, WA

Java Software Development Engineer
JPMorgan Chase Bank, N.A., Jersey City, NJ

Core Java Software Developer
Tiger IT Solutions, Greenwich, CT

Java Fullstack Developer-DQL
HCL, Orlando, FL

Senior DevOps Engineer
NVIDIA, Santa Clara, CA

Product Designer 2
Microsoft, Redmond, WA

Accountant
HEAVY.AI, Inc., San Francisco Bay Area, CA

SQL Server DBA
NEXGEN TECHNOLOGIES INC., Remote

SQL Server Developer
Convazant, Remote

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

Data Engineer - SQL Server
Bonterra, Washington, DC

Product Support Specialist (Time)
UKG (Ultimate Kronos Group), Remote

Senior Software Engineer
GLOVIS America, Montgomery, AL

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Vertica logo

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

Neo4j logo

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

Redis logo

The world’s most loved real‑time data platform.
Try 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.

Present your product here