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 > Amazon Neptune vs. Impala vs. Informix vs. SAP Adaptive Server vs. STSdb

System Properties Comparison Amazon Neptune vs. Impala vs. Informix vs. SAP Adaptive Server vs. STSdb

Editorial information provided by DB-Engines
NameAmazon Neptune  Xexclude from comparisonImpala  Xexclude from comparisonInformix  Xexclude from comparisonSAP Adaptive Server infoformer name: Sybase ASE  Xexclude from comparisonSTSdb  Xexclude from comparison
DescriptionFast, reliable graph database built for the cloudAnalytic DBMS for HadoopA secure embeddable database from IBM, positioned besides IBM 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 RDBMSKey-Value Store with special method for indexing infooptimized for high performance using a special indexing method
Primary database modelGraph DBMS
RDF store
Relational DBMSRelational DBMS infoSince Version 12.10 support for JSON/BSON datatypes compatible with MongoDBRelational DBMSKey-value store
Secondary database modelsDocument storeDocument store
Spatial DBMS
Time Series DBMS infowith Informix TimeSeries Extension
Spatial DBMS infowith Boeing's Spatial Query Server
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score3.09
Rank#103  Overall
#6  Graph DBMS
#3  RDF stores
Score17.56
Rank#40  Overall
#25  Relational DBMS
Score24.16
Rank#34  Overall
#20  Relational DBMS
Score44.82
Rank#25  Overall
#17  Relational DBMS
Score0.00
Rank#357  Overall
#56  Key-value stores
Websiteaws.amazon.com/­neptunewww.cloudera.com/­products/­open-source/­apache-hadoop/­impala.htmlwww.ibm.com/­products/­informixwww.sap.com/­products/­sybase-ase.htmlgithub.com/­STSSoft/­STSdb4
Technical documentationaws.amazon.com/­neptune/­developer-resourcesdocs.cloudera.com/­documentation/­enterprise/­latest/­topics/­impala.htmlinformix.hcldoc.com
www.ibm.com/­support/­knowledgecenter/­SSGU8G/­welcomeIfxServers.html
help.sap.com/­viewer/­product/­SAP_ASE
DeveloperAmazonClouderaIBM, 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, SybaseSTS Soft SC
Initial release20172013198419872011
Current release4.0.0, July 202114.10.FC5, November 202016.04.0.8, September 2015
License infoCommercial or Open SourcecommercialOpen Source infoApache Version 2commercial infofree developer edition availablecommercialOpen Source infoGPLv2, commercial license available
Cloud-based only infoOnly available as a cloud serviceyesnononono
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++C#
Server operating systemshostedLinuxAIX
HP-UX
Linux
macOS
Solaris
Windows
AIX
HP-UX
Linux
Solaris
Unix
Windows
Windows
Data schemeschema-freeyesyesyesyes
Typing infopredefined data types such as float or dateyesyesyes infoSince Version 12.10 support for JSON/BSON datatypesyesyes 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.nonono
Secondary indexesnoyesyesyesno
SQL infoSupport of SQLnoSQL-like DML and DDL statementsyesyesno
APIs and other access methodsRDF 1.1 / SPARQL 1.1
TinkerPop Gremlin 3.3
JDBC
ODBC
JDBC
JSON API infoMongoDB compatible
MQTT (Message Queue Telemetry Transport)
ODBC
RESTful HTTP API
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
.NET Client API
Supported programming languagesC#
Go
Java
JavaScript
PHP
Python
Ruby
Scala
All languages supporting JDBC/ODBC.Net
C
C++
Java
JavaScript (Node.js)
PHP
Python
Ruby
C
C++
Cobol
Java
Java
Perl
PHP
Python
C#
Java
Server-side scripts infoStored proceduresnoyes infouser defined functions and integration of map-reduceyesJava and Transact-SQLno
Triggersnonoyesyesno
Partitioning methods infoMethods for storing different data on different nodesnoneShardingShardinghorizontal partitioningnone
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-availability zones high availability, asynchronous replication for up to 15 read replicasselectable replication factorMulti-source replication
Source-replica replication
Multi-source replication
Source-replica replication
none
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyes infoquery execution via MapReducenonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyes infoRelationships in graphsnoyesyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoACIDACIDno
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyes infowith encyption-at-restyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyes
User concepts infoAccess controlAccess rights for users and roles can be defined via the AWS Identity and Access Management (IAM)Access rights for users, groups and roles infobased on Apache Sentry and KerberosUsers with fine-grained authentication, authorization, and auditing controlsfine 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

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

More resources
Amazon NeptuneImpalaInformixSAP Adaptive Server infoformer name: Sybase ASESTSdb
Recent citations in the news

Amazon announces general availability of its Graph Database called Neptune
29 July 2022, Analytics India Magazine

How graph databases took over relationship mapping
19 July 2022, The Register

Here’s how you can predict graphs accurately, quickly, and securely with Amazon Neptune
2 November 2021, YourStory

Amazon Neptune update: Machine learning, data science, and the future of graph databases
30 July 2021, ZDNet

Catching up with Amazon Neptune
26 November 2019, ZDNet

provided by Google News

Cloudera Boosts Hadoop App Development On Impala
10 November 2014, InformationWeek

Man Busts Out of Google, Rebuilds Top-Secret Query Machine
24 October 2012, WIRED

How to add a data source to Redash
5 April 2022, TechRepublic

How to deploy the Redash data visualization dashboard with the help of Docker
23 March 2022, TechRepublic

Unravel Data Adds Native Support for Impala and Kafka
29 June 2017, insideBIGDATA

provided by Google News

Jonathan Rende Articles and Insights
12 August 2022, DevOps.com

The women writing checks: A list of female venture capitalists in the Pacific Northwest
10 August 2022, GeekWire

The Data Replication Market in 2022
24 February 2022, Datamation

Best Data Migration Tools and Software 2022 | ENP
29 December 2021, EnterpriseNetworkingPlanet

Fugitive Silicon Valley tech executive hauled into federal court
15 October 2019, The Mercury News

provided by Google News

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

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

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

The Backup Storage Market in 2022
10 August 2022, Enterprise Storage Forum

Partners become central to SAP industry cloud business
16 May 2022, TechTarget

provided by Google News

Job opportunities

SDE - Amazon Neptune Platform
Amazon Dev Center U.S., Inc., Seattle, WA

SDE - Amazon Neptune Platform
Amazon Dev Center U.S., Inc., Irvine, CA

Amazon Neptune - Database Engine Performance
Amazon Dev Center U.S., Inc., Bellevue, WA

Core Database Engine Development, Amazon Neptune
Amazon Dev Center U.S., Inc., Bellevue, WA

Security Engineer
Corelight, Remote

Software Engineer Specialist
FIS Global, Cincinnati, OH

Business Intelligence Developer - Treasury and Liquidity
Barclays, Whippany, NJ

Business Analyst
Lumen, United States

Business Analyst - US Remote
Lumen, Remote

Planning Engineer II
Lumen, Remote

Warehouse Shipping and Receiving Clerk
Inmar, Remote

Warehouse Receiving Clerk
Inmar, Winston-Salem, NC

Informix Software Engineer (Remote)
Inmar, United States

1st Shift Warehouse Research Clerk
Inmar, Libertyville, IL

Research Clerk
Inmar, Grand Prairie, TX

Director, Information Systems
California School Employees Association, San Jose, CA

Technical Partner Delivery Lead
BlueCat Networks, Remote

Sr. Financial Analyst
Super Micro Computer, Inc., San Jose, CA

Sr. IT Application Analyst - Enterprise Applications
Cytel, Inc (USA), United States

Channel Solution Architect - Eastern Region
Lenovo, Morrisville, NC

jobs by Indeed



Share this page

Featured Products

AllegroGraph logo

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

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.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Redis logo

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

Neo4j logo

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

Present your product here