DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > InterSystems IRIS vs. Microsoft SQL Server vs. Solr vs. YugabyteDB

System Properties Comparison InterSystems IRIS vs. Microsoft SQL Server vs. Solr vs. YugabyteDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameInterSystems IRIS  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparisonSolr  Xexclude from comparisonYugabyteDB  Xexclude from comparison
DescriptionA containerised multi-model DBMS, interoperability and analytics data platform with wide capabilities for vertical and horizontal scalabilityMicrosofts flagship relational DBMSA widely used distributed, scalable search engine based on Apache LuceneHigh-performance distributed SQL database for global, internet-scale applications. Wire and feature compatible with PostgreSQL.
Primary database modelDocument store
Key-value store
Object oriented DBMS
Relational DBMS
Relational DBMSSearch engineRelational DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
Spatial DBMSDocument store
Wide column store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.59
Rank#116  Overall
#23  Document stores
#21  Key-value stores
#2  Object oriented DBMS
#58  Relational DBMS
Score924.35
Rank#3  Overall
#3  Relational DBMS
Score48.26
Rank#24  Overall
#3  Search engines
Score4.47
Rank#86  Overall
#44  Relational DBMS
Websitewww.intersystems.com/­products/­intersystems-iriswww.microsoft.com/­en-us/­sql-serverlucene.apache.org/­solrwww.yugabyte.com
Technical documentationdocs.intersystems.com/­irislatest/­csp/­docbook/­DocBook.UI.Page.clsdocs.microsoft.com/­en-US/­sql/­sql-serverlucene.apache.org/­solr/­resources.htmldocs.yugabyte.com
github.com/­yugabyte/­yugabyte-db
DeveloperInterSystemsMicrosoftApache Software FoundationYugabyte Inc.
Initial release2018198920062017
Current release2021.1, June 2021SQL Server 2019, November 20199.0.0, May 20222.14, July 2022
License infoCommercial or Open Sourcecommercialcommercial inforestricted free version is availableOpen Source infoApache Version 2Open Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Yugabyte Cloud 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 languageC++JavaC and C++
Server operating systemsAIX
Linux
macOS
Windows
Linux
Windows
All OS with a Java VM inforuns as a servlet in servlet container (e.g. Tomcat, Jetty is included)Linux
OS X
Data schemedepending on used data modelyesyes infoDynamic Fields enables on-the-fly addition of new fieldsdepending on used data model
Typing infopredefined data types such as float or dateyesyesyes infosupports customizable data types and automatic typingyes
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.yesyesyesno
Secondary indexesyesyesyes infoAll search fields are automatically indexedyes
SQL infoSupport of SQLyesyesSolr Parallel SQL Interfaceyes, PostgreSQL compatible
APIs and other access methodsJDBC
ODBC
RESTful HTTP API
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
Java API
RESTful HTTP/JSON 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 languages.Net
C++
Java
JavaScript (Node.js)
Python
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
.Net
Erlang
Java
JavaScript
any language that supports sockets and either XML or JSON
Perl
PHP
Python
Ruby
Scala
C
C#
C++
Go
Java
JavaScript (Node.js)
Python
Ruby
Server-side scripts infoStored proceduresyesTransact SQL, .NET languages, R, Python and (with SQL Server 2019) JavaJava pluginsyes infosql, plpgsql, C
Triggersyesyesyes infoUser configurable commands triggered on index changesyes
Partitioning methods infoMethods for storing different data on different nodesShardingtables can be distributed across several files (horizontal partitioning); sharding through federationShardingHash and Range Sharding, row-level geo-partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replicationyes, but depending on the SQL-Server EditionyesBased on Raft distributed consensus protocol, minimum 3 replicas for continuous availability
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonospark-solr: github.com/­lucidworks/­spark-solr and streaming expressions to reduceno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyEventual ConsistencyStrong consistency on writes and tunable consistency on reads
Foreign keys infoReferential integrityyesyesnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDoptimistic lockingDistributed ACID with Serializable & Snapshot Isolation. Inspired by Google Spanner architecture.
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes infobased on RocksDB
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyesno
User concepts infoAccess controlyesfine grained access rights according to SQL-standardyesyes
More information provided by the system vendor
InterSystems IRISMicrosoft SQL ServerSolrYugabyteDB
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 metrics900,000+ lifetime clusters deployed 5.5K+ GitHub stars 4.3K+ 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 partiesSQLFlow: 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

SQL 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

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

More resources
InterSystems IRISMicrosoft SQL ServerSolrYugabyteDB
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

Elasticsearch replaced Solr as the most popular search engine
12 January 2016, Paul Andlinger

Enterprise Search Engines almost double their popularity in the last 12 months
2 July 2014, Paul Andlinger

The DB-Engines ranking includes now search engines
4 February 2013, Paul Andlinger

show all

Recent citations in the news

InterSystems recognized as a leader by independent research firm in translytical data platforms evaluation
9 December 2022, ZAWYA

Forrester's translytical neologism and rankings – with Oracle on top – Blocks and Files
5 December 2022, Blocks and Files

Unlock Ultimate Control for Manufacturing with InterSystems and M&M Software
30 November 2022, Automation.com

InterSystems partners with PainChek on pain assessment
10 November 2022, Med-Tech Innovation

InterSystems releases updates to its IRIS data platform
19 August 2022, DataCenterNews Asia

provided by Google News

Microsoft’s SQL Server 2022 is all about Azure
16 November 2022, TechCrunch

New Windows 11 bug may prevent users from connecting to databases using SQL Server
6 December 2022, XDA Developers

Non-relational SQL Market Size, Current Insights and Development Trends | Top Key Players, Production Capacity Estimates, Competitive Strategy Analysis | 2023-2027
7 December 2022, Digital Journal

DH2i Adds Container Sidecar Option to SQL Server HA Platform
22 November 2022, Container Journal

10 Best SQL Editor Tools in the Market
18 November 2022, Built In

provided by Google News

SOLR Dividend Announcement $0.3700/Share 12/1/2022
1 December 2022, Dividend Investor

Tag page
5 December 2022, European Research Council

Distressed energy supply companies: further guidance for officeholders and stakeholders
22 November 2022, JD Supra

Energy Companies Seek Clarification on Insolvency ESC Issues
15 November 2022, The National Law Review

SOLR PR, MultiChoice Nigeria shine at Brandcom awards night -
28 November 2022, The Eagle Online

provided by Google News

Yugabyte Announces Release of YugabyteDB 2.17 and Major Enhancements to YugabyteDB Managed
8 December 2022, Datanami

Emergent Announces Partnership with Yugabyte
9 November 2022, PR Newswire

YugabyteDB Solutions Focus on Business-Critical Application Needs | Transforming Data with Intelligence
8 December 2022, TDWI

CockroachDB brings user-defined functions to distributed SQL
8 December 2022, TechTarget

Yugabyte Joins the Microsoft Intelligent Data Platform Partner Ecosystem
12 October 2022, businesswire.com

provided by Google News

Job opportunities

Junior Integration Developer
InterSystems, Cambridge, MA

System Administrator
Persistent Technology, Remote

Technical Specialist
InterSystems, Cambridge, MA

Market Intelligence Manager
InterSystems, Cambridge, MA

Caché DBA
Rackspace, United States

ETL SSIS SQL Server Data Engineer
Tek Ninjas, Minneapolis, MN

SQL Server DBA
Agelix Consulting, Remote

SQL Server Developer
Convazant, Remote

SQL Server DBA
Viviente Software, Floresville, TX

SQL Server Developer
Retail Backbone, Remote

Solr Search Developer
Ztek Consulting, Remote

Solr Consultant
Orpine, Inc. Internal, United States

Django/Python Developer
Quotient inc, Bethesda, MD

Solr Search Developer
Big Dossier, Union, NJ

Developer Analyst (100% telework available for Texas residents)
Texas State Library & Archives Commission, Austin, TX

Head Of Creative Services
YugabyteDB, United States

Product Data Analyst
Yugabyte, Sunnyvale, CA

Senior Software Engineer, Database
Airbnb, San Francisco, CA

Account Executive - Chicago
YugabyteDB, United States

Performance Engineer
Yugabyte, United States

jobs by Indeed



Share this page

Featured Products

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.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

AllegroGraph logo

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

Redis logo

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

Neo4j logo

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

Present your product here