DB-EnginesextremeDB - Data management wherever you need itEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > Adabas vs. Alibaba Cloud Log Service vs. Microsoft SQL Server vs. OpenTSDB vs. Transbase

System Properties Comparison Adabas vs. Alibaba Cloud Log Service vs. Microsoft SQL Server vs. OpenTSDB vs. Transbase

Editorial information provided by DB-Engines
NameAdabas infodenotes "adaptable data base"  Xexclude from comparisonAlibaba Cloud Log Service  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparisonOpenTSDB  Xexclude from comparisonTransbase  Xexclude from comparison
DescriptionOLTP - DBMS for mainframes and Linux/Unix/Windows environments infoused typically together with the Natural programming platformA complete real-time data logging service that supports collection, consumption, shipping, search, and analysis of logs.Microsofts flagship relational DBMSScalable Time Series DBMS based on HBaseA resource-optimized, high-performance, universally applicable RDBMS
Primary database modelMultivalue DBMSSearch engineRelational DBMSTime Series DBMSRelational DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.64
Rank#104  Overall
#1  Multivalue DBMS
Score0.44
Rank#257  Overall
#18  Search engines
Score807.76
Rank#3  Overall
#3  Relational DBMS
Score1.59
Rank#140  Overall
#12  Time Series DBMS
Score0.05
Rank#355  Overall
#150  Relational DBMS
Websitewww.softwareag.com/­en_corporate/­platform/­adabas-natural.htmlwww.alibabacloud.com/­product/­log-servicewww.microsoft.com/­en-us/­sql-serveropentsdb.netwww.transaction.de/­en/­products/­transbase.html
Technical documentationwww.alibabacloud.com/­help/­en/­slslearn.microsoft.com/­en-US/­sql/­sql-serveropentsdb.net/­docs/­build/­html/­index.htmlwww.transaction.de/­en/­products/­transbase/­features.html
DeveloperSoftware AGAlibabaCloud Inc.Microsoftcurrently maintained by Yahoo and other contributorsTransaction Software GmbH
Initial release19712016198920111987
Current releaseSQL Server 2022, November 2022Transbase 8.3, 2022
License infoCommercial or Open Sourcecommercialcommercialcommercial inforestricted free version is availableOpen Source infoLGPLcommercial infofree development license
Cloud-based only infoOnly available as a cloud servicenoyesnonono
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 languageC++JavaC and C++
Server operating systemsBS2000
Linux
Unix
Windows
z/OS
z/VSE
hostedLinux
Windows
Linux
Windows
FreeBSD
Linux
macOS
Solaris
Windows
Data schemeyesschema-freeyesschema-freeyes
Typing infopredefined data types such as float or dateyesyesyesnumeric data for metrics, strings for tagsyes
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.nonoyesnono
Secondary indexesyesyesyesnoyes
SQL infoSupport of SQLyes infowith add-on product Adabas SQL GatewaySQL for queryingyesnoyes
APIs and other access methodsHTTP API infowith add-on software Adabas SOA Gateway
SOAP-based API infowith add-on software Adabas SOA Gateway
HTTP RESTADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
HTTP API
Telnet API
ADO.NET
JDBC
ODBC
Proprietary native API
Supported programming languagesNaturalC#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
Erlang
Go
Java
Python
R
Ruby
C
C#
C++
Java
JavaScript
Kotlin
Objective-C
PHP
Python
Server-side scripts infoStored proceduresin NaturalnoTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Javanoyes
Triggersnoyesyesnoyes
Partitioning methods infoMethods for storing different data on different nodesyes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas VistaShardingtables can be distributed across several files (horizontal partitioning); sharding through federationSharding infobased on HBase
Replication methods infoMethods for redundantly storing data on multiple nodesyes, with add-on product Event Replicator3 replicasyes, but depending on the SQL-Server Editionselectable replication factor infobased on HBaseSource-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoES-Hadoop Connectornonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual ConsistencyImmediate ConsistencyImmediate Consistency infobased on HBaseImmediate Consistency
Foreign keys infoReferential integritynonoyesnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoACIDnoyes
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
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.nonoyesnono
User concepts infoAccess controlonly with OS-specific tools (e.g. IBM RACF, CA Top Secret)Alibaba Cloud user access controlfine grained access rights according to SQL-standardnofine grained access rights according to SQL-standard
More information provided by the system vendor
Adabas infodenotes "adaptable data base"Alibaba Cloud Log ServiceMicrosoft SQL ServerOpenTSDBTransbase
Specific characteristicsA real-time service for telementry data (log, metric, trace). Alibaba Cloud Log Service...
» more
Competitive advantages* Ease of use: Completes data collections from more than 30 data sources within five...
» more
Typical application scenarios* Log/Trace/Event Search & Analysis * Application Monitoring * Operation Analysis...
» more
Key customers* Alibaba & Ant-Finance:he infrastructure service for the Corp * Over 22k Subscriber...
» more
Licensing and pricing modelsPay-As-You-Go https://www.alibabacloud.com/product/log-service/pricing
» 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 partiesNavicat 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
Adabas infodenotes "adaptable data base"Alibaba Cloud Log ServiceMicrosoft SQL ServerOpenTSDBTransbase
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

Time Series DBMS are the database category with the fastest increase in popularity
4 July 2016, Matthias Gelbmann

show all

Conferences, events and webinars

PASS Data Community Summit
Seattle, Washington, 4-8 November 2024

Recent citations in the news

Re-evaluating legacy: Should you leave Adabas (and Natural) behind?
30 May 2024, ITWeb

Is it the end of the road for Software AG after selling its integration business to IBM?
12 January 2024, diginomica

IBM to buy Software AG’s integration businesses for €2.1 billion
19 December 2023, RCR Wireless News

IBM buys 50-year-old Software AG's enterprise tech units for €2.13B in cash
18 December 2023, The Register

Software AG sells data platform to IBM for €2.1bn
18 December 2023, Financial Times

provided by Google News

Alibaba Cloud waiting for hardware to dry out before trying to restore customer data
17 September 2024, The Register

Alibaba Cloud Further Facilitates Digital Transformation Acceleration across Asia in the Year of the Pandemic
27 January 2021, PR Newswire

The difference between no-logs and zero-logs VPNs – and why it matters
16 August 2024, TechRadar

The Evolution of Online Analytics from Alibaba Economy Ecosystem to the Cloud
20 February 2021, DataDrivenInvestor

Alibaba Cloud launches China Gateway program in Singapore
30 May 2019, China Daily

provided by Google News

Contractor Software Targeted via Microsoft SQL Server Loophole
18 September 2024, Dark Reading

Make SQL Server end of support the start of your AWS cloud journey
12 June 2024, AWS Blog

Getting started with delivering generative AI capabilities in SQL Server and Azure SQL
26 June 2024, Microsoft

SQL Server vNext: When and What Is Coming
15 May 2024, redmondmag.com

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

provided by Google News

Comparing Different Time-Series Databases
10 February 2022, hackernoon.com

Brain Monitoring with Kafka, OpenTSDB, and Grafana
5 August 2016, KDnuggets

LogicMonitor Rolls a Time Series Database for Finer-Grain Reporting
1 June 2016, The New Stack

provided by Google News



Share this page

Featured Products

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB 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

SingleStore logo

The data platform to build your intelligent applications.
Try it free.

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus 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