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 > Ehcache vs. Microsoft SQL Server

System Properties Comparison Ehcache vs. Microsoft SQL Server

Please select another system to include it in the comparison.

Our visitors often compare Ehcache and Microsoft SQL Server with Redis, Memcached and Amazon DynamoDB.

Editorial information provided by DB-Engines
NameEhcache  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparison
DescriptionA widely adopted Java cache with tiered storage optionsMicrosofts flagship relational DBMS
Primary database modelKey-value storeRelational DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score6.45
Rank#64  Overall
#8  Key-value stores
Score902.22
Rank#3  Overall
#3  Relational DBMS
Websitewww.ehcache.orgwww.microsoft.com/­en-us/­sql-server
Technical documentationwww.ehcache.org/­documentationlearn.microsoft.com/­en-US/­sql/­sql-server
DeveloperTerracotta Inc, owned by Software AGMicrosoft
Initial release20091989
Current release3.10.0, March 2022SQL Server 2022, November 2022
License infoCommercial or Open SourceOpen Source infoApache Version 2; commercial licenses availablecommercial inforestricted free version is available
Cloud-based only infoOnly available as a cloud servicenono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaC++
Server operating systemsAll OS with a Java VMLinux
Windows
Data schemeschema-freeyes
Typing infopredefined data types such as float or dateyesyes
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.noyes
Secondary indexesnoyes
SQL infoSupport of SQLnoyes
APIs and other access methodsJCacheADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
Supported programming languagesJavaC#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
Server-side scripts infoStored proceduresnoTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Java
Triggersyes infoCache Event Listenersyes
Partitioning methods infoMethods for storing different data on different nodesSharding infoby using Terracotta Servertables can be distributed across several files (horizontal partitioning); sharding through federation
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoby using Terracotta Serveryes, but depending on the SQL-Server Edition
MapReduce infoOffers an API for user-defined Map/Reduce methodsnono
Consistency concepts infoMethods to ensure consistency in a distributed systemTunable Consistency (Strong, Eventual, Weak)Immediate Consistency
Foreign keys infoReferential integritynoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayes infosupports JTA and can work as an XA resourceACID
Concurrency infoSupport for concurrent manipulation of datayesyes
Durability infoSupport for making data persistentyes infousing a tiered cache-storage approachyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes
User concepts infoAccess controlnofine 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 partiesNavicat Monitor is a safe, simple and agentless remote server monitoring tool for SQL Server and many other database management systems.
» more

DBHawk: Secure access to SQL, NoSQL and Cloud databases with an all-in-one solution.
» 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
EhcacheMicrosoft SQL Server
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

Security Bulletin 20 Sep 2023
20 September 2023, Cyber Security Agency of Singapore

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

API Monitoring: Why It's Important and How to Do It Right
18 September 2023, Analytics Insight

Critical Jira Flaw in Atlassian Could Lead to RCE
22 July 2021, Threatpost

MyBatis之缓存_枫叶梨花的博客
2 September 2023, CSDN

provided by Google News

5 Questions to Ask About Upgrading Microsoft SQL Server
8 September 2023, StateTech Magazine

CodingSight Revolutionizes SQL Server Knowledge Sharing ...
26 September 2023, Digital Journal

Expect SQL Server failures as Microsoft disables old TLS in Windows
5 September 2023, CSO Online

How To Filter SQL Server Data in Windows PowerShell
15 September 2023, ITPro Today

Fix Unable to Install SQL Server on Windows 11
19 September 2023, TheWindowsClub

provided by Google News

Job opportunities

Sr. Microservices Developer
Photon, New Jersey

Software Analyst/Developer
Verudix, Oak Brook, IL

SENIOR SPECIALIST, Full-Stack Developer
The Bank of New York Mellon Corporation, Jersey City, NJ

Sr. Software Developer(Applications)
Verudix, Oak Brook, IL

Tech Lead Microservices Developer
Photon, New Jersey

SQL Server DBA
ANB Sourcing LLC, Remote

SQL Server DBA
Proits Hub LLC, Remote

MS SQL Server Developer
Global Information Technology, Southfield, MI

Entry Level Developer
TSL Companies, Remote

Junior SQL Developer
PCS Global Tech, Remote

jobs by Indeed



Share this page

Featured Products

Redis logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

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

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

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Present your product here