DB-EnginesEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > Cachelot.io vs. Microsoft SQL Server vs. RavenDB vs. TempoIQ

System Properties Comparison Cachelot.io vs. Microsoft SQL Server vs. RavenDB vs. TempoIQ

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameCachelot.io  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparisonRavenDB  Xexclude from comparisonTempoIQ infoformerly TempoDB  Xexclude from comparison
TempoIQ seems to be decommissioned. It will be removed from the DB-Engines ranking.
DescriptionIn-memory caching systemMicrosofts flagship relational DBMSOpen Source Operational and Transactional Enterprise NoSQL Document DatabaseScalable analytics DBMS for sensor data, provided as a service (SaaS)
Primary database modelKey-value storeRelational DBMSDocument storeTime Series DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
Graph DBMS
Spatial DBMS
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.00
Rank#388  Overall
#62  Key-value stores
Score802.09
Rank#3  Overall
#3  Relational DBMS
Score2.70
Rank#100  Overall
#19  Document stores
Websitecachelot.iowww.microsoft.com/­en-us/­sql-serverravendb.nettempoiq.com (offline)
Technical documentationlearn.microsoft.com/­en-US/­sql/­sql-serverravendb.net/­docs
DeveloperMicrosoftHibernating RhinosTempoIQ
Initial release2015198920102012
Current releaseSQL Server 2022, November 20225.4, July 2022
License infoCommercial or Open SourceOpen Source infoSimplified BSD Licensecommercial inforestricted free version is availableOpen Source infoAGPL version 3, commercial license availablecommercial
Cloud-based only infoOnly available as a cloud servicenononoyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
SQLServer Flex @ STACKIT offers a managed version of SQL Server with adjustable CPU, RAM, storage amount and speed, in enterprise grade to perfectly match all application requirements. All services are 100% GDPR-compliant.
Implementation languageC++C++C#
Server operating systemsFreeBSD
Linux
OS X
Linux
Windows
Linux
macOS
Raspberry Pi
Windows
Data schemeschema-freeyesschema-freeschema-free
Typing infopredefined data types such as float or datenoyesnoyes
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
SQL infoSupport of SQLnoyesSQL-like query language (RQL)no
APIs and other access methodsMemcached protocolADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
.NET Client API
F# Client API
Go Client API
Java Client API
NodeJS Client API
PHP Client API
Python Client API
RESTful HTTP API
HTTP API
Supported programming languages.Net
C
C++
ColdFusion
Erlang
Java
Lisp
Lua
OCaml
OCaml
Perl
PHP
Python
Ruby
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
.Net
C#
F#
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
C#
Java
JavaScript infoNode.js
Python
Ruby
Server-side scripts infoStored proceduresnoTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Javayesno
Triggersnoyesyesyes infoRealtime Alerts
Partitioning methods infoMethods for storing different data on different nodesnonetables can be distributed across several files (horizontal partitioning); sharding through federationSharding
Replication methods infoMethods for redundantly storing data on multiple nodesnoneyes, but depending on the SQL-Server EditionMulti-source replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyesno
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneImmediate ConsistencyDefault ACID transactions on the local node (eventually consistent across the cluster). Atomic operations with cluster-wide ACID transactions. Eventual consistency for indexes and full-text search indexes.
Foreign keys infoReferential integritynoyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDACID, Cluster-wide transaction availableno
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentnoyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesno
User concepts infoAccess controlnofine grained access rights according to SQL-standardAuthorization levels configured per client per databasesimple authentication-based access control

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

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

More resources
Cachelot.ioMicrosoft SQL ServerRavenDBTempoIQ infoformerly TempoDB
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

Conferences, events and webinars

PASS Data Community Summit
Seattle, Washington, 4-8 November 2024

Recent citations in the news

Embed textual data in Amazon RDS for SQL Server using Amazon Bedrock
30 October 2024, AWS Blog

How to check your SQL Server version
21 August 2024, ITPro

SQL Server vNext: When and What Is Coming
15 May 2024, redmondmag.com

Mastering the SQL Server command-line interface
30 May 2024, SitePoint

SQL Server 2014 end of support: Keep your customers secure
28 March 2024, Microsoft

provided by Google News

RavenDB Welcomes David Baruc as Chief Revenue Officer: Seasoned Tech Leader to Drive Global Sales and Accelerate Growth
13 June 2023, PR Newswire

The Forrester Wave™: Big Data NoSQL, Q1 2019
13 March 2019, Forrester

provided by Google News



Share this page

Featured Products

SingleStore logo

The data platform to build your intelligent applications.
Try it 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

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB 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