DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Adabas vs. Firebird vs. JaguarDB vs. Microsoft SQL Server vs. STSdb

System Properties Comparison Adabas vs. Firebird vs. JaguarDB vs. Microsoft SQL Server vs. STSdb

Editorial information provided by DB-Engines
NameAdabas infodenotes "adaptable data base"  Xexclude from comparisonFirebird  Xexclude from comparisonJaguarDB  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparisonSTSdb  Xexclude from comparison
DescriptionOLTP - DBMS for mainframes and Linux/Unix/Windows environments infoused typically together with the Natural programming platformFirebird is an open source RDBMS forked from Borland's InterBasePerformant, highly scalable DBMS for AI and IoT applicationsMicrosofts flagship relational DBMSKey-Value Store with special method for indexing infooptimized for high performance using a special indexing method
Primary database modelMultivalue DBMSRelational DBMSKey-value storeRelational DBMSKey-value store
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score4.78
Rank#82  Overall
#1  Multivalue DBMS
Score22.88
Rank#33  Overall
#19  Relational DBMS
Score0.01
Rank#379  Overall
#60  Key-value stores
Score919.39
Rank#3  Overall
#3  Relational DBMS
Score0.26
Rank#320  Overall
#46  Key-value stores
Websitewww.softwareag.com/­en_corporate/­platform/­adabas-natural.htmlwww.firebirdsql.orgwww.datajaguar.comwww.microsoft.com/­en-us/­sql-servergithub.com/­STSSoft/­STSdb4
Technical documentationwww.firebirdsql.org/­en/­reference-manualswww.datajaguar.com/­support.phpdocs.microsoft.com/­en-US/­sql/­sql-server
DeveloperSoftware AGFirebird FoundationDataJaguar, Inc.MicrosoftSTS Soft SC
Initial release19712000 infoAs fork of Borland's InterBase201519892011
Current release4.0.2, August 20222.9.4 September 2018SQL Server 2022, November 20224.0.8, September 2015
License infoCommercial or Open SourcecommercialOpen Source infoInitial Developer's Public LicenseOpen Source infoGPL V3.0commercial inforestricted free version is availableOpen Source infoGPLv2, commercial license available
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 languageC and C++C++ infothe server part. Clients available in other languagesC++C#
Server operating systemsBS2000
Linux
Unix
Windows
z/OS
z/VSE
AIX
FreeBSD
HP-UX
Linux
OS X
server-less infoFirebird Embedded Server
Solaris
Unix
Windows
LinuxLinux
Windows
Windows
Data schemeyesyesyesyesyes
Typing infopredefined data types such as float or dateyesyesyesyesyes infoprimitive types and user defined types (classes)
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.nonoyes
Secondary indexesyesyesyesyesno
SQL infoSupport of SQLyes infowith add-on product Adabas SQL GatewayyesA subset of ANSI SQL is implemented infobut no views, foreign keys, triggersyesno
APIs and other access methodsHTTP API infowith add-on software Adabas SOA Gateway
SOAP-based API infowith add-on software Adabas SOA Gateway
ADO.NET
C/C++ API
JDBC infoJaybird
ODBC
OLE DB
JDBC
ODBC
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
.NET Client API
Supported programming languagesNaturalC
C#
C++
Delphi
Java
JavaScript infoNode.js
Lua
Perl
PHP
Python
Ruby
C
C++
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Scala
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
C#
Java
Server-side scripts infoStored proceduresin NaturalPSQLnoTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Javano
Triggersnoyesnoyesno
Partitioning methods infoMethods for storing different data on different nodesyes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas VistanoneShardingtables can be distributed across several files (horizontal partitioning); sharding through federationnone
Replication methods infoMethods for redundantly storing data on multiple nodesyes, with add-on product Event ReplicatorSource-replica replicationMulti-source replicationyes, but depending on the SQL-Server Editionnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesnoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDnoACIDno
Concurrency infoSupport for concurrent manipulation of datayesyes infoFeatures a multi-generational MVCC architecture, readers do not block writersyesyesyes
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.nonoyes
User concepts infoAccess controlonly with OS-specific tools (e.g. IBM RACF, CA Top Secret)Users with fine-grained authorization conceptrights management via user accountsfine 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 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

Navicat Monitor is a safe, simple and agentless remote server monitoring tool for SQL Server and many other database management systems.
» 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

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

More resources
Adabas infodenotes "adaptable data base"FirebirdJaguarDBMicrosoft SQL ServerSTSdb
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

Recent citations in the news

Urbanization and physical activity in the global Prospective Urban ...
6 January 2023, Nature.com

COVID-19 Vaccination in the United States, August–November 2021
25 January 2023, American Journal of Preventive Medicine

A high-throughput sequencing survey characterizing European ...
20 January 2023, Nature.com

In 2023, legacy is out, integration is in
18 January 2023, ITWeb

Modernising applications? Integration with APIs is the way to go
14 September 2022, ITWeb

provided by Google News

Embedded Database System Market Present Scenario and Growth ...
23 January 2023, Digital Journal

Softbuilder Announces Launch of SB Data Generator 2.2
10 January 2023, EIN News

Major retailers, new restaurants coming to Loop 303 corridor in Surprise
23 January 2023, The Business Journals

Her Name Is Amore | The Observer
25 January 2023, Opelika Observer

Firebird - Director, Release Planning & Distribution (US)
10 October 2022, Music Business Worldwide

provided by Google News

Amazon RDS Supports Custom SQL Server Images | Petri IT
16 January 2023, Petri.com

SQLSRV Not Showing in PHP INFO using PHP 8.2.1 and Sql Server ...
23 January 2023, SitePoint

Local Event: Earn in six figures With SQL Server Certification in 2023 ?
20 January 2023, Patch

What Is the Difference Between Clustered and Non-Clustered ... - MUO
31 December 2022, MakeUseOf

Microsoft shares temporary fix for ODBC database connection issues
6 January 2023, BleepingComputer

provided by Google News

Job opportunities

Natural/ADABAS Developer
Devcare Solutions, Remote

Natural Adabas Developer (100% Remote)
Snappyhires, Remote

IT Application Analyst (Adabas)
Skill Quotient, Remote

COBOL Developer
Devcare Solutions, Remote

Natural Adabas Programmer
Karsun Solutions, LLC, Remote

Delphi Developer
Softacom, Remote

DevSecOps Software Engineer- Early Career
LOCKHEED MARTIN CORPORATION, Mount Laurel, NJ

Implementation Specialist - Mining
Canary Systems, Inc., Tucson, AZ

Software Engineer (Remote)
Demosphere International Inc, Falls Church, VA

QA Analyst (POS MUST)
proit-inc, Atlanta, GA

SQL Database Administrator
UTS Global, Remote

SQL Server DBA
1point system, Washington, DC

SQL Server DBA
1 Point System, Washington, DC

SQL Server Developer
BBR Partners, New York, NY

Sr. SQL Server/SSIS SSRS Developer
Astratrek, Remote

jobs by Indeed



Share this page

Featured Products

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

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.

Redis logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

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

Present your product here