DB-EngineseXtremeDB: Active Replication Fabric for Reliable IoT Database ManagementEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Adabas vs. ClickHouse vs. SAP SQL Anywhere vs. TimescaleDB

System Properties Comparison Adabas vs. ClickHouse vs. SAP SQL Anywhere vs. TimescaleDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAdabas infodenotes "adaptable data base"  Xexclude from comparisonClickHouse  Xexclude from comparisonSAP SQL Anywhere infoformerly called Adaptive Server Anywhere  Xexclude from comparisonTimescaleDB  Xexclude from comparison
DescriptionOLTP - DBMS for mainframes and Linux/Unix/Windows environments infoused typically together with the Natural programming platformColumn-oriented Relational DBMS powering YandexRDBMS database and synchronization technologies for server, desktop, remote office, and mobile environmentsA time series DBMS optimized for fast ingest and complex queries, based on PostgreSQL
Primary database modelMultivalue DBMSRelational DBMSRelational DBMSTime Series DBMS
Secondary database modelsRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score4.76
Rank#76  Overall
#1  Multivalue DBMS
Score6.60
Rank#58  Overall
#32  Relational DBMS
Score6.79
Rank#54  Overall
#31  Relational DBMS
Score2.73
Rank#105  Overall
#6  Time Series DBMS
Websitewww.softwareag.com/­corporate/­products/­adabas_natural/­adabas/­default.htmlclickhouse.techwww.sap.com/­products/­sql-anywhere.htmlwww.timescale.com
Technical documentationclickhouse.tech/­docshelp.sap.com/­sql-anywheredocs.timescale.com
DeveloperSoftware AGYandex LLCSAP infoformerly SybaseTimescale
Initial release1971201619922017
Current releasev20.3.17.173, August 202017, July 2015
License infoCommercial or Open SourcecommercialOpen Source infoApache 2.0commercialOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++C
Server operating systemsBS2000
Linux
Unix
Windows
z/OS
z/VSE
FreeBSD
Linux
macOS
AIX
HP-UX
Linux
OS X
Solaris
Windows
Linux
OS X
Windows
Data schemeyesyesyesyes
Typing infopredefined data types such as float or dateyesyesyesnumerics, strings, booleans, arrays, JSON blobs, geospatial dimensions, currencies, binary data, other complex data types
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
Secondary indexesyesnoyesyes
SQL infoSupport of SQLyes infowith add-on product Adabas SQL GatewayClose to ANSI SQLyesyes infofull PostgreSQL SQL syntax
APIs and other access methodsHTTP API infowith add-on software Adabas SOA Gateway
SOAP-based API infowith add-on software Adabas SOA Gateway
HTTP REST
JDBC
ODBC
Proprietary protocol
ADO.NET
HTTP API
JDBC
ODBC
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
Supported programming languagesNaturalC# info3rd party library
C++
Elixir info3rd party library
Go info3rd party library
Java info3rd party library
JavaScript (Node.js) info3rd party library
Kotlin info3rd party library
Nim info3rd party library
Perl info3rd party library
PHP info3rd party library
Python info3rd party library
R info3rd party library
Ruby info3rd party library
Scala info3rd party library
C
C#
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
.Net
C
C++
Delphi
Java infoJDBC
JavaScript
Perl
PHP
Python
R
Ruby
Scheme
Tcl
Server-side scripts infoStored proceduresin Naturalnoyes, in C/C++, Java, .Net or Perluser defined functions, PL/pgSQL, PL/Tcl, PL/Perl, PL/Python, PL/Java, PL/PHP, PL/R, PL/Ruby, PL/Scheme, PL/Unix shell
Triggersnonoyesyes
Partitioning methods infoMethods for storing different data on different nodesyes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas Vistanoneyes, across time and space (hash partitioning) attributes
Replication methods infoMethods for redundantly storing data on multiple nodesyes, with add-on product Event ReplicatorSource-replica replication infoDatabase mirroringSource-replica replication with hot standby and reads on replicas info
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesyesno
User concepts infoAccess controlonly with OS-specific tools (e.g. IBM RACF, CA Top Secret)Access rights for users and rolesfine grained access rights according to SQL-standardfine grained access rights according to SQL-standard
More information provided by the system vendor
Adabas infodenotes "adaptable data base"ClickHouseSAP SQL Anywhere infoformerly called Adaptive Server AnywhereTimescaleDB
Specific characteristicsTimescale is the creator of TimescaleDB , the first open-source relational database...
» more
Competitive advantagesTimescaleDB is purpose-built to scale and handle time-series data workloads and is...
» more
Typical application scenariosDevOps and Infrastructure Monitoring All monitoring data is time-series data. Efficiently...
» more
Key customersTransferWise, Maersk, AppDynamics, Walmart, Comcast, LaunchDarkly, IBM, NOV, Cisco,...
» more
Market metricsWith over 9,000 GitHub stars and growing, 600,000 active databases, and an active...
» more
Licensing and pricing modelsTimescaleDB comes in 3 versions, including fully managed Cloud-hosted solutions*,...
» 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

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"ClickHouseSAP SQL Anywhere infoformerly called Adaptive Server AnywhereTimescaleDB
Recent citations in the news

ADABAS DBA & Systems Programmer - Ensono
14 July 2020, Built In Chicago

OpenLegacy Offers Turnkey Access to Hard-to-Reach Legacy Data for Joint Customers with Talend
26 August 2020, Yahoo Finance

Software AG Announces New “Adabas & Natural 2050” Agenda
31 August 2016, Business Wire

Software AG Government Solutions Achieves FedRAMP Authorization
19 August 2020, Yahoo Finance

Software : announces Q2 and H1 2020 financial results; delivers strong second quarter and accelerated transformation progress
22 July 2020, marketscreener.com

provided by Google News

Why Snowflake is about to raise $3bn in a record software IPO
15 September 2020, The Economist

From Russia with OLAP: Percona uses ClickHouse analytics
10 October 2019, ComputerWeekly.com

ClickHouse - from website clicks to ultra-fast analytics solution -
27 April 2020, Enterprise Times

ClickHouse Experiencing Explosive Growth in EU, US and Asia in Q1 2018
23 April 2018, PR Newswire

Time Series Databases, the Future of Monitoring and Logging
3 December 2019, Security Boulevard

provided by Google News

SAP SQL Anywhere
13 October 2016, TechTarget

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

Best Database Management Software 2020
14 July 2020, Datamation

Rimini Street expands support beyond SAP and Oracle
9 June 2017, Inside SAP Magazine

SAP IoT products: How do they work with ERP and big data?
28 December 2015, TechTarget

provided by Google News

How I Power My Trading Bot with TimescaleDB
23 August 2020, hackernoon.com

Timescale Brings Powerful Time-Series Data Analysis to Developers Worldwide, Now Available in 75+ Cloud Regions
12 August 2020, Business Wire

TimescaleDB Delivers Another Option for Time-Series Analytics
17 October 2019, Datanami

Timescale Database Now Available in 76 Cloud Regions
12 August 2020, Datanami

The First Complete Life-Cycle Database Management Solution for TimescaleDB
16 April 2019, PRNewswire

provided by Google News

Job opportunities

Mainframe Migration Specialist – Financial Services
Amazon Web Services, Inc., Remote

ADABAS NATURAL Programmer
Peer Solutions Group, Columbia, SC

Senior Natural/ADABAS Developer
West Advanced Technologies (WATI), Sacramento, CA

Adabas Natural Programmer Analyst
Peer Solutions Group, Columbia, SC

Systems Analyst Pos.
Virginia Dept of Motor Vehicles, Richmond, VA

MySQL Database Administrator
BODIS, Miami, FL

MySQL Consultant
Percona, Remote

Systems Engineer - Database
Cloudflare, Austin, TX

Sr. Timestream Specialist SA
Amazon Web Services, Inc., New York, NY

Senior Software Engineer at Databento
Databento, Boston, MA

Database Administrator
ECR Software Corporation, Boone, NC

Hydrological Software Engineer
University of Massachusetts Amherst, Amherst, MA

Python Engineer
TrailStone Group, Austin, TX

Software Engineers Multiple Levels – Cloud Infrastructure Predictive Analytics
PCI, Maryland

Systems Reliability Engineer
PacketFabric, Culver City, CA

Software Engineer III
UNAVCO, Inc., Boulder, CO

jobs by Indeed




Share this page

Featured Products

Datastax Astra logo

Cassandra made easy in the cloud. Build cloud-native applications faster with CQL, REST and GraphQL APIs.
Try for Free.

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

AllegroGraph logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here