DB-EnginesInfluxDB download bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Drizzle vs. Informix vs. SAP Adaptive Server vs. TerminusDB

System Properties Comparison Drizzle vs. Informix vs. SAP Adaptive Server vs. TerminusDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameDrizzle  Xexclude from comparisonInformix  Xexclude from comparisonSAP Adaptive Server infoformer name: Sybase ASE  Xexclude from comparisonTerminusDB infoformer name was DataChemist  Xexclude from comparison
Drizzle has published its last release in September 2012. The open-source project is discontinued and Drizzle is excluded from the DB-Engines ranking.
DescriptionMySQL fork with a pluggable micro-kernel and with an emphasis of performance over compatibility.A secure embeddable database from IBM, positioned besides DB2 as a relatively low-cost product optimized for OLTP and Internet of Things dataThe SAP (Sybase) Adaptive Server Enterprise (ASE) is an enterprise-class RDBMSScalable Graph Database platform making enterprise data available by exploiting inferred entities and relationships
Primary database modelRelational DBMSRelational DBMS infoSince Version 12.10 support for JSON/BSON datatypes compatible with MongoDBRelational DBMSGraph DBMS
Secondary database modelsDocument store
Time Series DBMS infowith Informix TimeSeries Extension
Document store
RDF store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score24.38
Rank#28  Overall
#16  Relational DBMS
Score53.09
Rank#17  Overall
#11  Relational DBMS
Score0.06
Rank#307  Overall
#29  Graph DBMS
Websitewww.ibm.com/­products/­informixwww.sap.com/­products/­sybase-ase.htmlterminusdb.com
Technical documentationinformix.hcldoc.com
www.ibm.com/­support/­knowledgecenter/­SSGU8G/­welcomeIfxServers.html
help.sap.com/­adaptive-server-enterpriseterminusdb.com/­docs
DeveloperDrizzle project, originally started by Brian AkerIBM, HCL Technologies infoEffective May 1st, 2017, HCL took on development, technical support, and product management teams, and works jointly with IBM on product strategy, marketing, and sales.SAP, SybaseDataChemist Ltd.
Initial release2008198419872018
Current release7.2.4, September 201214.10.FC3, December 201916.01.1.1, January 2020
License infoCommercial or Open SourceOpen Source infoGNU GPLcommercial infofree developer edition availablecommercialOpen Source infoGPL V3
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, C++ and JavaC and C++Prolog, Rust
Server operating systemsFreeBSD
Linux
OS X
AIX
HP-UX
Linux
macOS
Solaris
Windows
AIX
HP-UX
Linux
Solaris
Unix
Windows
Linux
Data schemeyesyesyesyes
Typing infopredefined data types such as float or dateyesyes infoSince Version 12.10 support for JSON/BSON datatypesyesyes
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.nono
Secondary indexesyesyesyes
SQL infoSupport of SQLyes infowith proprietary extensionsyesyesSQL-like query language (WOQL)
APIs and other access methodsJDBCJDBC
JSON API infoMongoDB compatible
MQTT (Message Queue Telemetry Transport)
ODBC
RESTful HTTP API
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
OWL
RESTful HTTP API
WOQL (Web Object Query Language)
Supported programming languagesC
C++
Java
PHP
.Net
C
C++
Java
JavaScript (Node.js)
PHP
Python
Ruby
C
C++
Cobol
Java
Java
Perl
PHP
Python
JavaScript
Python
Server-side scripts infoStored proceduresnoyesJava and Transact-SQLyes
Triggersno infohooks for callbacks inside the server can be used.yesyesyes
Partitioning methods infoMethods for storing different data on different nodesShardingShardinghorizontal partitioningGraph Partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesMaster-master replication
Master-slave replication
Master-master replication
Master-slave replication
Master-master replication
Master-slave replication
Journaling Streams
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesyesyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes infoin-memory journaling
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes
User concepts infoAccess controlPluggable authentication mechanisms infoe.g. LDAP, HTTPUsers with fine-grained authentication, authorization, and auditing controlsfine grained access rights according to SQL-standardRole-based access control

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

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

More resources
DrizzleInformixSAP Adaptive Server infoformer name: Sybase ASETerminusDB infoformer name was DataChemist
DB-Engines blog posts

MySQL won the April ranking; did its forks follow?
1 April 2015, Paul Andlinger

Has MySQL finally lost its mojo?
1 July 2013, Matthias Gelbmann

show all

Recent citations in the news

Delphix Partner Spotlight on Experior Tecnologia
27 May 2020, Security Boulevard

How a Modern Data Platform Can Power a Future-Ready Digital Business
27 May 2020, Security Boulevard

CFO's challenge: Balancing fast growth with controls
6 May 2020, CFO Dive

Relational Database Management System Market 2020: Growth & Profit Analysis, Forecast By 2026
2 June 2020, Jewish Life News

Embedded Database Management Systems Market 2020: Covid-19 Impact on Global Industry Analysis and Forecasts to 2025
1 June 2020, EIN News

provided by Google News

Install latest SAP Adaptive Server Enterprise patches, experts urge
3 June 2020, CSO Online

SAP May 2020 Security Patch Day delivers critical updates
13 May 2020, BleepingComputer

Survey Reveals Strategic Plans of SAP Sybase and ASE Customers as Product Support Nears End
10 October 2019, PRNewswire

What Will Happen After End Of Support For Sybase?
17 December 2019, E3zine.com

SAP data and analytics: in with the new, don't squander the old
22 July 2019, ZDNet

provided by Google News

Dublin's DataChemist announces expansion into the Netherlands
20 November 2019, Siliconrepublic.com

Ethics on agenda as full line-up of DataTech20 speakers revealed
13 February 2020, Insider.co.uk

provided by Google News

Job opportunities

Research Clerk - 1st Shift
Inmar, Grand Prairie, TX

Informix DBA
Applied Insight, San Antonio, TX

1st and Mid-Shift Receiving Clerk
Inmar, Fort Worth, TX

Systems Analyst
UST Global, Bentonville, AR

Business Intelligence Developer
Frontier Communications, Allen, TX

Cloud Engineer
BlueCat Networks, United States

Data Analytics Analyst
APTIM, Baton Rouge, LA

SAP Business Analytics Lead
Gulf States Toyota, Inc., Houston, TX

Cloud Engineer
BlueCat Networks, Boston, MA

jobs by Indeed




Share this page

Featured Products

Neo4j logo

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

Datastax Luna logo

Simple, subscription-based support for open source
Apache Cassandraâ„¢ from the Cassandra experts.
Learn more.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

RavenDB logo

Setup a fully managed RavenDB Cloud Database in minutes. Enjoy hosting, management, backups all in one place.
Grab a Free Instance

Couchbase logo

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

Present your product here