DBMS > EXASOL vs. Microsoft SQL Server vs. SQLite

System Properties Comparison EXASOL vs. Microsoft SQL Server vs. SQLite

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines

Name

Description

High-performance, in-memory, MPP database specifically designed for in-memory analytics.

Microsofts flagship relational DBMS

Widely used embeddable, in-process RDBMS

Primary database model

Relational DBMS

Secondary database models

Document store
Graph DBMS
Spatial DBMS

DB-Engines Ranking measures the popularity of database management systems
Trend Chart

Score	3.24
Rank	#87	Overall
	#47	Relational DBMS

Score	1007.97
Rank	#3	Overall
	#3	Relational DBMS

Score	125.06
Rank	#9	Overall
	#6	Relational DBMS

Website

www.exasol.com

www.microsoft.com/en-us/sql-server

www.sqlite.org

Technical documentation

www.exasol.com/resources

docs.microsoft.com/en-US/sql/sql-server

www.sqlite.org/docs.html

Developer

Exasol

Microsoft

Dwayne Richard Hipp

Initial release

2000

1989

2000

Current release

SQL Server 2019, November 2019

3.35.4 (2 April 2021), April 2021

License

Commercial or Open Source

commercial

restricted free version is available

Open Source

Public Domain

Cloud-based only

Only available as a cloud service

DBaaS offerings (sponsored links)

Database as a Service

Providers of DBaaS offerings, please contact us to be listed.

Implementation language

C++

Server operating systems

Linux
Windows

server-less

Data scheme

yes

dynamic column types

Typing

predefined data types such as float or date

yes

not rigid because of 'dynamic typing' concept.

XML support

Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.

yes

Secondary indexes

yes

SQL

Support of SQL

yes

SQL-92 is not fully supported

APIs and other access methods

.Net
JDBC
ODBC
WebSocket

ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)

ADO.NET

inofficial driver
JDBC

inofficial driver
ODBC

inofficial driver

Supported programming languages

Java
Lua
Python
R

C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic

Actionscript
Ada
Basic
C
C#
C++
D
Delphi
Forth
Fortran
Haskell
Java
JavaScript
Lisp
Lua
MatLab
Objective-C
OCaml
Perl
PHP
PL/SQL
Python
R
Ruby
Scala
Scheme
Smalltalk
Tcl

Server-side scripts

Stored procedures

user defined functions

Transact SQL, .NET languages, R, Python and (with SQL Server 2019) Java

Triggers

yes

Partitioning methods

Methods for storing different data on different nodes

Sharding

tables can be distributed across several files (horizontal partitioning); sharding through federation

none

Replication methods

Methods for redundantly storing data on multiple nodes

yes, but depending on the SQL-Server Edition

none

MapReduce

Offers an API for user-defined Map/Reduce methods

yes

Hadoop integration

Consistency concepts

Methods to ensure consistency in a distributed system

Immediate Consistency

Foreign keys

Referential integrity

yes

Transaction concepts

Support to ensure data integrity after non-atomic manipulations of data

ACID

Concurrency

Support for concurrent manipulation of data

yes

via file-system locks

Durability

Support for making data persistent

yes

In-memory capabilities

Is there an option to define some or all structures to be held in-memory only.

yes

User concepts

Access control

Access rights for users, groups and roles according to SQL-standard

fine 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 parties

General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more

Fivetran: Quickly and easily centralize your on-premise and cloud databases.
» more

Navicat 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

DBHawk: Secure access to SQL, NoSQL and Cloud databases with an all-in-one solution.
» more

Navicat for SQLite is a powerful and comprehensive SQLite GUI that provides a complete set of functions for 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

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

Big gains for Relational Database Management Systems in DB-Engines Ranking
2 February 2016, Matthias Gelbmann

show all

Recent citations in the news

Adstream Uses Exasol to Power Industry Consumer Behavior Dashboards
13 April 2021, MarTech Series

Exasol Named “Overall Data Analytics Company of the Year” in 2021 Data Breakthrough Awards Program
25 March 2021, Business Wire

Exasol and InfoCepts Partner to Help Organizations Unlock the Full Power of Their Data for Maximum Analytics Performance
7 April 2021, Business Wire

Global Main Memory Database System Market SWOT Analysis,Key Indicators,Forecast 2027 : , SAP, MenSQL, EXASOL, Oracle, ENEA, Kognitio – KSU | The Sentinel Newspaper
14 April 2021, KSU | The Sentinel Newspaper

Exasol Welcomes Wendy Kano as Chief Marketing Officer
17 March 2021, Business Wire

provided by Google News

IFI Techsolutions Has Earned the Windows Server and SQL Server Migration to Microsoft Azure Advanced Specialization
8 April 2021, PR Newswire India

DH2i Launches DxEnterprise v20 Improving Microsoft SQL Server High Availability (HA) and Disaster Recovery (DR) Performance
16 March 2021, PRNewswire

Planet Achieves Microsoft Advanced Specialization for Windows Server and SQL Server Migration to Microsoft Azure
31 March 2021, Herald-Mail Media

Global SQL Server Transformation Market SWOT Analysis,Key Indicators,Forecast 2027 : Oracle, Microsoft, SAP SE, IBM, Alphabet – KSU | The Sentinel Newspaper
13 April 2021, KSU | The Sentinel Newspaper

Engineering firm thwarts ransomware attack with Nasuni
14 April 2021, TechTarget

provided by Google News

Open-Source Database Software Market 2021 – 2025: SQLite, MySQL, MariaDB, Apache Hive, Neo4j – KSU | The Sentinel Newspaper
23 March 2021, KSU | The Sentinel Newspaper

Global Database Development and Management Tools Software Market (2020-2026) | Latest COVID19 Impact Analysis | Know About Brand Players: Oracle Corporation, SQLite, Microsoft Corporation, SAP SE, Amazon, IBM, etc.
14 April 2021, SoccerNurds

RDBMS Software market to see strong growth comprehensive analysis to 2025 | SQLite, IBM, SolarWinds IT Operations Management, Cubrid – SoccerNurds
1 April 2021, SoccerNurds

RDBMS Software Market 2021 Industry Size, Share, Growth and Top Companies Analysis- Microsoft, Oracle, PostgreSQL Global Development Group, SQLite, IBM, etc. – SoccerNurds
13 April 2021, SoccerNurds

provided by Google News

Job opportunities

Senior Reporting Analyst
Bumble, Austin, TX

Linux Support Engineer
Exasol, United States

Technical Writer - US
Exasol, Atlanta, GA

Lead Product Designer
Exasol, San Francisco, CA

Account Executive, US
Exasol, United States

SQL Server DBA
Zachary Piper Solutions, Fairfax, VA

MS SQL Server Database Admin
AGM Tech Solutions, Remote

SQL Server DBA
Cognizant Technology Solutions, Jessup, PA

SQL Server DBA/Data Warehouse Architect
9th networks Inc, North Chesterfield, VA

Data Assistant
ParentChild+, Mineola, NY

Jr. QA Analyst Trainee
SQA², Los Alamitos, CA

Xamarin.Forms Software Engineers (100% )
Computer Staff, Remote

Software Engineer
Serko, Remote

Mobile App Developers - Android & IOS
Ford Motor Company, Dearborn, MI

Senior C# Developers
Mailbird, Remote

jobs by

Share this page