DB-EnginesExtremeDB for everyone with an RTOSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > EJDB vs. GridGain vs. Microsoft SQL Server vs. SAP SQL Anywhere vs. SQLite

System Properties Comparison EJDB vs. GridGain vs. Microsoft SQL Server vs. SAP SQL Anywhere vs. SQLite

Editorial information provided by DB-Engines
NameEJDB  Xexclude from comparisonGridGain  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparisonSAP SQL Anywhere infoformerly called Adaptive Server Anywhere  Xexclude from comparisonSQLite  Xexclude from comparison
DescriptionEmbeddable document-store database library with JSON representation of queries (in MongoDB style)GridGain is an in-memory computing platform, built on Apache IgniteMicrosofts flagship relational DBMSRDBMS database and synchronization technologies for server, desktop, remote office, and mobile environmentsWidely used embeddable, in-process RDBMS
Primary database modelDocument storeKey-value store
Relational DBMS
Relational DBMSRelational DBMSRelational DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.31
Rank#296  Overall
#44  Document stores
Score1.55
Rank#150  Overall
#26  Key-value stores
#70  Relational DBMS
Score821.56
Rank#3  Overall
#3  Relational DBMS
Score3.95
Rank#80  Overall
#42  Relational DBMS
Score111.41
Rank#10  Overall
#7  Relational DBMS
Websitegithub.com/­Softmotions/­ejdbwww.gridgain.comwww.microsoft.com/­en-us/­sql-serverwww.sap.com/­products/­technology-platform/­sql-anywhere.htmlwww.sqlite.org
Technical documentationgithub.com/­Softmotions/­ejdb/­blob/­master/­README.mdwww.gridgain.com/­docs/­index.htmllearn.microsoft.com/­en-US/­sql/­sql-serverhelp.sap.com/­docs/­SAP_SQL_Anywherewww.sqlite.org/­docs.html
DeveloperSoftmotionsGridGain Systems, Inc.MicrosoftSAP infoformerly SybaseDwayne Richard Hipp
Initial release20122007198919922000
Current releaseGridGain 8.5.1SQL Server 2022, November 202217, July 20153.46.0  (23 May 2024), May 2024
License infoCommercial or Open SourceOpen Source infoGPLv2commercialcommercial inforestricted free version is availablecommercialOpen Source infoPublic Domain
Cloud-based only infoOnly available as a cloud servicenonononono
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 languageCJava, C++, .NetC++C
Server operating systemsserver-lessLinux
OS X
Solaris
Windows
Linux
Windows
AIX
HP-UX
Linux
OS X
Solaris
Windows
server-less
Data schemeschema-freeyesyesyesyes infodynamic column types
Typing infopredefined data types such as float or dateyes infostring, integer, double, bool, date, object_idyesyesyesyes infonot rigid because of 'dynamic typing' concept.
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 indexesnoyesyesyesyes
SQL infoSupport of SQLnoANSI-99 for query and DML statements, subset of DDLyesyesyes infoSQL-92 is not fully supported
APIs and other access methodsin-process shared libraryHDFS API
Hibernate
JCache
JDBC
ODBC
Proprietary protocol
RESTful HTTP API
Spring Data
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
ADO.NET
HTTP API
JDBC
ODBC
ADO.NET infoinofficial driver
JDBC infoinofficial driver
ODBC infoinofficial driver
Supported programming languagesActionscript
C
C#
C++
Go
Java
JavaScript (Node.js)
Lua
Objective-C
Pike
Python
Ruby
C#
C++
Java
PHP
Python
Ruby
Scala
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
C
C#
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
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 infoStored proceduresnoyes (compute grid and cache interceptors can be used instead)Transact SQL, .NET languages, R, Python and (with SQL Server 2019) Javayes, in C/C++, Java, .Net or Perlno
Triggersnoyes (cache interceptors and events)yesyesyes
Partitioning methods infoMethods for storing different data on different nodesnoneShardingtables can be distributed across several files (horizontal partitioning); sharding through federationnonenone
Replication methods infoMethods for redundantly storing data on multiple nodesnoneyes (replicated cache)yes, but depending on the SQL-Server EditionSource-replica replication infoDatabase mirroringnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyes (compute grid and hadoop accelerator)nonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityno infotypically not needed, however similar functionality with collection joins possiblenoyesyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayes infoRead/Write Lockingyesyesyesyes infovia file-system locks
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyesyes
User concepts infoAccess controlnoSecurity Hooks for custom implementationsfine grained access rights according to SQL-standardfine grained access rights according to SQL-standardno

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
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
EJDBGridGainMicrosoft SQL ServerSAP SQL Anywhere infoformerly called Adaptive Server AnywhereSQLite
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

GridGain in-memory data and generative AI – Blocks and Files
10 May 2024, Blocks and Files

GridGain's 2023 Growth Positions Company for Strong 2024
24 January 2024, PR Newswire

GridGain Unified Real-Time Data Platform Version 8.9 Addresses Today's More Complex Real-Time Data Processing ...
12 October 2023, GlobeNewswire

GridGain Showcases Power of Apache Ignite at Community Over Code Conference
5 October 2023, Datanami

GridGain Announces Call for Speakers for Virtual Apache Ignite Summit 2024
8 February 2024, PR Newswire

provided by Google News

Upgrade Amazon RDS for SQL Server 2014 to a newer supported version using the AWS CLI | Amazon Web Services
11 June 2024, AWS Blog

SQL Server on Linux: What You Need to Know
30 May 2024, ITPro Today

SQL Server 2014 end of support: Keep your customers secure
28 March 2024, microsoft.com

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

The Essential Guide to SQL Server 2014 Series: Scalability
1 June 2024, ITPro Today

provided by Google News

SAP vulnerabilities Let Attacker Inject OS Commands—Patch Now!
11 July 2023, CybersecurityNews

SAP Products & Services Data Portfolio
2 July 2021, Datamation

Securing SAP with AWS Network Firewall: Part 2 – Managed Rules | Amazon Web Services
17 July 2023, AWS Blog

Rimini Street expands support beyond SAP and Oracle
21 May 2016, InsideSAP

MindsDB is now the leading and fastest growing applied ML platform in the world India - English
3 November 2022, PR Newswire

provided by Google News

Microsoft Research chief scientist has no issue with Windows Recall
6 June 2024, The Register

How to work with Dapper and SQLite in ASP.NET Core
10 May 2024, InfoWorld

SQLite Vulnerability Could Put Thousands of Apps at Risk
22 March 2024, Dark Reading

Copilot‘s screen-snapping Recall data stored in plain text
31 May 2024, CyberNews.com

A Guide to Working with SQLite Databases in Python
21 May 2024, KDnuggets

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

Neo4j logo

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

Present your product here