DB-EnginesExtremeDB: mitigate connectivity issues in a DBMSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > IRONdb vs. Memcached vs. Microsoft SQL Server vs. NSDb vs. Rockset

System Properties Comparison IRONdb vs. Memcached vs. Microsoft SQL Server vs. NSDb vs. Rockset

Editorial information provided by DB-Engines
NameIRONdb  Xexclude from comparisonMemcached  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparisonNSDb  Xexclude from comparisonRockset  Xexclude from comparison
IRONdb seems to be discontinued. Therefore it is excluded from the DB-Engines Ranking.
DescriptionA distributed Time Series DBMS with a focus on scalability, fault tolerance and operational simplicityIn-memory key-value store, originally intended for cachingMicrosofts flagship relational DBMSScalable, High-performance Time Series DBMS designed for Real-time Analytics on top of KubernetesA scalable, reliable search and analytics service in the cloud, built on RocksDB
Primary database modelTime Series DBMSKey-value storeRelational DBMSTime Series DBMSDocument store
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
Relational DBMS
Search engine
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score19.42
Rank#32  Overall
#4  Key-value stores
Score824.29
Rank#3  Overall
#3  Relational DBMS
Score0.00
Rank#383  Overall
#41  Time Series DBMS
Score0.79
Rank#211  Overall
#35  Document stores
Websitewww.circonus.com/solutions/time-series-database/www.memcached.orgwww.microsoft.com/­en-us/­sql-servernsdb.iorockset.com
Technical documentationdocs.circonus.com/irondb/category/getting-startedgithub.com/­memcached/­memcached/­wikilearn.microsoft.com/­en-US/­sql/­sql-servernsdb.io/­Architecturedocs.rockset.com
DeveloperCirconus LLC.Danga Interactive infooriginally developed by Brad Fitzpatrick for LiveJournalMicrosoftRockset
Initial release20172003198920172019
Current releaseV0.10.20, January 20181.6.25, March 2024SQL Server 2022, November 2022
License infoCommercial or Open SourcecommercialOpen Source infoBSD licensecommercial inforestricted free version is availableOpen Source infoApache Version 2.0commercial
Cloud-based only infoOnly available as a cloud servicenonononoyes
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 and C++CC++Java, ScalaC++
Server operating systemsLinuxFreeBSD
Linux
OS X
Unix
Windows
Linux
Windows
Linux
macOS
hosted
Data schemeschema-freeschema-freeyesschema-free
Typing infopredefined data types such as float or dateyes infotext, numeric, histogramsnoyesyes: int, bigint, decimal, stringdynamic typing
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.noyesnono infoingestion from XML files supported
Secondary indexesnonoyesall fields are automatically indexedall fields are automatically indexed
SQL infoSupport of SQLSQL-like query language (Circonus Analytics Query Language: CAQL)noyesSQL-like query languageRead-only SQL queries, including JOINs
APIs and other access methodsHTTP APIProprietary protocolADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
gRPC
HTTP REST
WebSocket
HTTP REST
Supported programming languages.Net
C
C++
Clojure
Erlang
Go
Haskell
Java
JavaScript
JavaScript (Node.js)
Lisp
Lua
Perl
PHP
Python
R
Ruby
Rust
Scala
.Net
C
C++
ColdFusion
Erlang
Java
Lisp
Lua
OCaml
Perl
PHP
Python
Ruby
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
Java
Scala
Go
Java
JavaScript (Node.js)
Python
Server-side scripts infoStored proceduresyes, in LuanoTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Javanono
Triggersnonoyesno
Partitioning methods infoMethods for storing different data on different nodesAutomatic, metric affinity per nodenonetables can be distributed across several files (horizontal partitioning); sharding through federationShardingAutomatic sharding
Replication methods infoMethods for redundantly storing data on multiple nodesconfigurable replication factor, datacenter awarenone infoRepcached, a Memcached patch, provides this functionallityyes, but depending on the SQL-Server Editionyes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate consistency per node, eventual consistency across nodesImmediate ConsistencyEventual ConsistencyEventual Consistency
Foreign keys infoReferential integritynonoyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanonoACIDnono
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesnoyesUsing Apache Luceneyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyes
User concepts infoAccess controlnoyes infousing SASL (Simple Authentication and Security Layer) protocolfine grained access rights according to SQL-standardAccess rights for users and organizations can be defined via Rockset console

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

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
IRONdbMemcachedMicrosoft SQL ServerNSDbRockset
DB-Engines blog posts

Redis extends the lead in the DB-Engines key-value store ranking
3 February 2014, Matthias Gelbmann

New DB-Engines Ranking shows the popularity of database management systems
3 October 2012, Matthias Gelbmann, 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

Application observability firm Apica buys telemetry data startup Circonus and adds more funding
21 February 2024, SiliconANGLE News

Apica Acquires Telemetry Data Management Pioneer Circonus And Lands New Funding
22 February 2024, Datanami

Apica gets $6 million in funding and buys Circonus -
21 February 2024, Enterprise Times

provided by Google News

Why DDoS Threat Actors Are Shifting Their Tactics
15 March 2024, Infosecurity Magazine

Redis Labs Boldly Joins AWS in Dropping Prices From 10 to 40 Percent
27 March 2024, Yahoo Lifestyle UK

What are memcached servers, and why are they being used to launch record-setting DDoS attacks?
6 March 2018, GeekWire

Why Redis beats Memcached for caching
14 September 2017, InfoWorld

Introducing mcrouter: A memcached protocol router for scaling memcached deployments
15 September 2014, Facebook Engineering

provided by Google News

Configure change data capture parameters on Amazon RDS for SQL Server | Amazon Web Services
14 May 2024, AWS Blog

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

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

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

Mallox Ransomware Deployed Via MS-SQL Honeypot Attack
13 May 2024, Infosecurity Magazine

provided by Google News

Rockset Announces Native Support for Hybrid Search to Power AI Apps
17 May 2024, Datanami

Rockset launches native support for hybrid vector and text search to power AI apps
16 May 2024, SiliconANGLE News

Data Management News for the Week of May 17; Updates from Anomalo, DataStax, Rockset & More
16 May 2024, Solutions Review

Rockset Hybrid Search Release Sets New Course for Vector Databases
16 May 2024, Datanami

Rockset targets cost control with latest database update
31 January 2024, TechTarget

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

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

SingleStore logo

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

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.

Present your product here