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 > Ignite vs. MySQL vs. SAP Adaptive Server

System Properties Comparison Ignite vs. MySQL vs. SAP Adaptive Server

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameIgnite  Xexclude from comparisonMySQL  Xexclude from comparisonSAP Adaptive Server infoformer name: Sybase ASE  Xexclude from comparison
DescriptionApache Ignite is a memory-centric distributed database, caching, and processing platform for transactional, analytical, and streaming workloads, delivering in-memory speeds at petabyte scale.Widely used open source RDBMSThe SAP (Sybase) Adaptive Server Enterprise (ASE) is an enterprise-class RDBMS
Primary database modelKey-value store
Relational DBMS
Relational DBMS infoKey/Value like access via memcached APIRelational DBMS
Secondary database modelsDocument store
Spatial DBMS
Spatial DBMS infowith Boeing's Spatial Query Server
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score6.29
Rank#68  Overall
#9  Key-value stores
#36  Relational DBMS
Score1205.38
Rank#2  Overall
#2  Relational DBMS
Score42.97
Rank#25  Overall
#17  Relational DBMS
Websiteignite.apache.orgwww.mysql.comwww.sap.com/­products/­sybase-ase.html
Technical documentationapacheignite.readme.io/­docsdev.mysql.com/­dochelp.sap.com/­viewer/­product/­SAP_ASE
DeveloperApache Software FoundationOracle infosince 2010, originally MySQL AB, then SunSAP, Sybase
Initial release201519951987
Current releaseApache Ignite 2.68.0.30, July 202216.0
License infoCommercial or Open SourceOpen Source infoApache 2.0Open Source infoGPL version 2. Commercial licenses with extended functionallity are availablecommercial
Cloud-based only infoOnly available as a cloud servicenonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
ScaleGrid for MySQL: Fully managed MySQL hosting On-Premises and on a wide variety of cloud providers. Easily deploy, monitor, provision, and scale your deployments in the cloud.
Implementation languageC++, Java, .NetC and C++C and C++
Server operating systemsLinux
OS X
Solaris
Windows
FreeBSD
Linux
OS X
Solaris
Windows
AIX
HP-UX
Linux
Solaris
Unix
Windows
Data schemeyesyesyes
Typing infopredefined data types such as float or dateyesyesyes
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.yesyesno
Secondary indexesyesyesyes
SQL infoSupport of SQLANSI-99 for query and DML statements, subset of DDLyes infowith proprietary extensionsyes
APIs and other access methodsHDFS API
Hibernate
JCache
JDBC
ODBC
Proprietary protocol
RESTful HTTP API
Spring Data
ADO.NET
JDBC
ODBC
Proprietary native API
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
Supported programming languagesC#
C++
Java
PHP
Python
Ruby
Scala
Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
C
C++
Cobol
Java
Java
Perl
PHP
Python
Server-side scripts infoStored proceduresyes (compute grid and cache interceptors can be used instead)yes infoproprietary syntaxJava and Transact-SQL
Triggersyes (cache interceptors and events)yesyes
Partitioning methods infoMethods for storing different data on different nodesShardinghorizontal partitioning, sharding with MySQL Cluster or MySQL Fabrichorizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesyes (replicated cache)Multi-source replication
Source-replica replication
Multi-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes (compute grid and hadoop accelerator)nono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyes infonot for MyISAM storage engineyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACID infonot for MyISAM storage engineACID
Concurrency infoSupport for concurrent manipulation of datayesyes infotable locks or row locks depending on storage engineyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes
User concepts infoAccess controlSecurity Hooks for custom implementationsUsers with fine-grained authorization concept infono user groups or rolesfine 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 partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more

Percona: Database problems? Not on your watch.
Databases run better with Percona.
» more

DbVisualizer is equipping database professionals with the tools they need to build, manage and maintain state-of-the-art database technologies. It has sky-high user satisfaction and is the preferred tool for database professionals around the world. Customers include Tesla, Apple, Facebook, Deutsche Bank, NASA, and 25,000 others in 145 countries.
» 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

Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development.
» more

Arctype: A fast, beautiful database GUI for developers and teams. Download it for free today.
» more

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

More resources
IgniteMySQLSAP Adaptive Server infoformer name: Sybase ASE
DB-Engines blog posts

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

MariaDB strengthens its position in the open source RDBMS market
5 April 2018, Matthias Gelbmann

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

show all

Recent citations in the news

Introducing Apache Ignite, an open source dark horse…
18 July 2022, The Stack

GridGain, Apache Ignite founder talks in-memory databases
11 August 2022, TechTarget

GridGain Announces Virtual Apache Ignite Summit 2022, Opens Call for Papers
7 February 2022, GlobeNewswire

Apache Ignite Adds Change Data Capture
20 January 2022, iProgrammer

Organizations Turn to Open-Source Software to Improve HPC and AI Applications
12 September 2022, CIO

provided by Google News

Oracle SVP Nipun Agarwal on MySQL HeatWave | eWEEK
4 October 2022, eWeek

CommonSpirit Health "IT security issue," MySQL backdoor, P2P fraud
6 October 2022, CISO Series

mariadb vs. MySQL
12 September 2022, Database Journal

Inside Oracle’s partnership with AMD to boost MySQL HeatWave performance
22 September 2022, SiliconANGLE News

How to Migrate an Oracle Database to MySQL Using AWS Database Migration Service
7 September 2022, InfoQ.com

provided by Google News

What's New for Microsoft's Power Platform – September 2022
4 October 2022, Petri.com

SAP ASE leaves sensitive credentials in installation logs
24 September 2020, CSO Online

Critical SAP ASE Flaws Allow Complete Control of Databases
3 June 2020, Threatpost

The 28 Best Data Intelligence Software and Tools for 2022
4 October 2022, Solutions Review

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

provided by Google News

Job opportunities

Java Apache Camel Developer - C79099 5.4 Charlotte, NC
CapB InfoteK, Charlotte, NC

23.Software Developer
Executive Software Guild (ESG), Remote

Java Developer
NR Consulting LLC, Whippany, NJ

Senior Consultant - (USA/Remote)
GridGain Systems, Chicago, IL

Regional Vice President of Sales - North America
GridGain Systems, Chicago, IL

 PHP/MySQL Developer
Third Rock, Austin, TX

PHP/MySQL Developers
Webmasters.com, Tampa, FL

Senior MySQL Database Admin
findhelp, Remote

Technical Customer Service Specialist (EST), AWS Trust and Safety
Amazon Web Services, Inc., Remote

CampusPress Support Enthusiast
Incsub, Remote

SAP Technical Architect ABAP
DataMasters, Greensboro, NC

Technical Partner Delivery Lead
BlueCat Networks, Remote

SAP Solution Architect - 3700 (No C2C - W2 only)
Bridgewater Consulting Group, Remote

SAP Lead Developer/Architect
Honda Aircraft Company, Greensboro, NC

IT - Sybase Operations DBA
Administrative Office of PA Courts, Mechanicsburg, PA

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.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

Redis logo

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

Neo4j logo

Neo4j NODES 2022
Free online conference for developers and data scientists.
November 16/17 2022.
Register now for free!

Present your product here