DB-EnginesExtremeDB: the first and only COTS deterministic embedded database management system for mission- and safety-critical hard real-time applicationsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > HyperSQL vs. LokiJS vs. Microsoft SQL Server vs. Oracle Berkeley DB vs. SAP SQL Anywhere

System Properties Comparison HyperSQL vs. LokiJS vs. Microsoft SQL Server vs. Oracle Berkeley DB vs. SAP SQL Anywhere

Editorial information provided by DB-Engines
NameHyperSQL infoalso known as HSQLDB  Xexclude from comparisonLokiJS  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparisonOracle Berkeley DB  Xexclude from comparisonSAP SQL Anywhere infoformerly called Adaptive Server Anywhere  Xexclude from comparison
DescriptionMultithreaded, transactional RDBMS written in Java infoalso known as HSQLDBIn-memory JavaScript DBMSMicrosofts flagship relational DBMSWidely used in-process key-value storeRDBMS database and synchronization technologies for server, desktop, remote office, and mobile environments
Primary database modelRelational DBMSDocument storeRelational DBMSKey-value store infosupports sorted and unsorted key sets
Native XML DBMS infoin the Oracle Berkeley DB XML version
Relational DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score5.04
Rank#73  Overall
#40  Relational DBMS
Score0.60
Rank#224  Overall
#34  Document stores
Score954.02
Rank#3  Overall
#3  Relational DBMS
Score2.94
Rank#102  Overall
#18  Key-value stores
#3  Native XML DBMS
Score5.53
Rank#70  Overall
#38  Relational DBMS
Websitehsqldb.orggithub.com/­techfort/­LokiJSwww.microsoft.com/­en-us/­sql-serverwww.oracle.com/­technetwork/­database/­database-technologies/­berkeleydb/­overview/­index.htmlwww.sap.com/­products/­sql-anywhere.html
Technical documentationhsqldb.org/­web/­hsqlDocsFrame.htmltechfort.github.io/­LokiJSdocs.microsoft.com/­en-US/­sql/­sql-serverdocs.oracle.com/­cd/­E17076_05/­html/­index.htmlhelp.sap.com/­sql-anywhere
DeveloperMicrosoftOracle infooriginally developed by Sleepycat, which was acquired by OracleSAP infoformerly Sybase
Initial release20012014198919941992
Current release2.6.1, October 2021SQL Server 2019, November 201918.1.40, May 202017, July 2015
License infoCommercial or Open SourceOpen Source infobased on BSD licenseOpen Sourcecommercial inforestricted free version is availableOpen Source infocommercial license availablecommercial
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.
Implementation languageJavaJavaScriptC++C, Java, C++ (depending on the Berkeley DB edition)
Server operating systemsAll OS with a Java VM infoEmbedded (into Java applications) and Client-Server operating modesserver-less, requires a JavaScript environment (browser, Node.js)Linux
Windows
AIX
Android
FreeBSD
iOS
Linux
OS X
Solaris
VxWorks
Windows
AIX
HP-UX
Linux
OS X
Solaris
Windows
Data schemeyesschema-freeyesschema-freeyes
Typing infopredefined data types such as float or dateyesnoyesnoyes
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.nonoyesyes infoonly with the Berkeley DB XML editionyes
Secondary indexesyesyes infovia viewsyesyesyes
SQL infoSupport of SQLyesnoyesyes infoSQL interfaced based on SQLite is availableyes
APIs and other access methodsHTTP API infoJDBC via HTTP
JDBC
ODBC
JavaScript APIADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
ADO.NET
HTTP API
JDBC
ODBC
Supported programming languagesAll languages supporting JDBC/ODBC
Java
JavaScriptC#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
.Net infoFigaro is a .Net framework assembly that extends Berkeley DB XML into an embeddable database engine for .NET
others infoThird-party libraries to manipulate Berkeley DB files are available for many languages
C
C#
C++
Java
JavaScript (Node.js) info3rd party binding
Perl
Python
Tcl
C
C#
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
Server-side scripts infoStored proceduresJava, SQLView functions in JavaScriptTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Javanoyes, in C/C++, Java, .Net or Perl
Triggersyesyesyesyes infoonly for the SQL APIyes
Partitioning methods infoMethods for storing different data on different nodesnonenonetables can be distributed across several files (horizontal partitioning); sharding through federationnonenone
Replication methods infoMethods for redundantly storing data on multiple nodesnonenoneyes, but depending on the SQL-Server EditionSource-replica replicationSource-replica replication infoDatabase mirroring
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencynoneImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesnoyesnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDno infoatomic operations within a single collection possibleACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyes infoSerialization of a DB in a Node.JS/Cordova/PhoneGap environment. Usage of the IndexedDB-API in a browser.yesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyesyesyes
User concepts infoAccess controlfine grained access rights according to SQL-standardnofine grained access rights according to SQL-standardnofine 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 partiesNavicat Monitor is a safe, simple and agentless remote server monitoring tool for SQL Server and many other database management systems.
» more

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

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

Navicat for SQL Server gives you a fully graphical approach to database management and development.
» more

SQLFlow: 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

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

More resources
HyperSQL infoalso known as HSQLDBLokiJSMicrosoft SQL ServerOracle Berkeley DBSAP SQL Anywhere infoformerly called Adaptive Server Anywhere
DB-Engines blog posts

New kids on the block: database management systems implemented in JavaScript
1 December 2014, Matthias Gelbmann

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

How to Set Up a New Database With LibreOffice Base
19 November 2020, MakeUseOf

DataGrip 1.0: A New IDE for DBs and SQL
31 December 2015, DZone News

provided by Google News

LokiJS - A JavaScript Database
18 November 2014, iProgrammer

Fast, Lightweight Data Storage for Cordova Apps with LokiJS
26 January 2016, SitePoint

LinkedIn open-sources URL-Detector Java library, LokiJS 1.4, and Bulgaria's new open-source law—SD Times news digest: July 5, 2016
5 July 2016, SDTimes.com

provided by Google News

DH2i and Pythian to Present Live Webinar, "Highly Available SQL Server AGs in Google Kubernetes Engine"
2 December 2021, The Grand Junction Daily Sentinel

Introducing SQL Server 2022: Top 3 New Features Announced at Microsoft Ignite
2 November 2021, Redmondmag.com

Clumio Protect Expands to Microsoft SQL Server
23 November 2021, CRN

Clumio Announces Clumio Protect for Microsoft SQL Server on Amazon EC2, Further Strengthening Ransomware Protection for Mission Critical Applications in AWS
10 November 2021, Yahoo Finance

Microsoft SQL Server 2017 Connector Comes to Google Data Studio
5 November 2021, CMSWire

provided by Google News

Oracle switches Berkeley DB license
5 July 2013, InfoWorld

ACM recognizes far-reaching technical achievements with special awards
26 May 2021, EurekAlert

Oracle vs SQL Server: RDBMS Comparison 2021
4 June 2021, Datamation

Israel Mukuamu drafted by Dallas Cowboys
1 May 2021, Live 5 News WCSC

The best IoT databases for the edge – an overview and guide
15 October 2020, AZ Big Media

provided by Google News

SAP SQL Anywhere
3 April 2018, TechTarget

SAP gives SQL Anywhere a new IoT injection
16 July 2015, Computerworld

Rimini Streets adds support for open source databases -
3 September 2021, Enterprise Times

Top Data Management Platforms & Systems 2021 | ESF
22 July 2021, Enterprise Storage Forum

Rimini Street to offer database, security services
7 June 2017, ZDNet

provided by Google News

Job opportunities

Software Engineer
Consumer Direct Care Network, Missoula, MT

Associate Full Stack Software Developer
Maxar Technologies, Ypsilanti, MI

Data Integration Engineer, Sales Compensation
Uber, Chicago, IL

Business Support Specialist
Diligene, New York, NY

SQL Server Support Engineer
Covestic, Remote

SQL Server Developer - Telecommute
UnitedHealth Group, Minnetonka, MN

SQL Server DBA
Technica Corporation, Washington, DC

Microsoft SQL Server DBA - Chicago, IL
Apexon, Chicago, IL

SQL Server Consultant
Triune Infomatics Inc, Washington, DC

Senior Integration Engineer- US Remote
Zendesk, Remote

Senior Systems Engineer (Salesforce Developer)
Zendesk, California

Junior Server and Network Technician
Association For Energy Affordability, Inc., Bronx, NY

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!

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

Neo4j logo

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

AllegroGraph logo

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

Present your product here