DB-EnginesExtremeDB for everyone with an RTOSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Apache IoTDB vs. OpenEdge vs. SAP Adaptive Server vs. SQLite vs. Titan

System Properties Comparison Apache IoTDB vs. OpenEdge vs. SAP Adaptive Server vs. SQLite vs. Titan

Editorial information provided by DB-Engines
NameApache IoTDB  Xexclude from comparisonOpenEdge  Xexclude from comparisonSAP Adaptive Server infoformer name: Sybase ASE  Xexclude from comparisonSQLite  Xexclude from comparisonTitan  Xexclude from comparison
Titan has been decommisioned after the takeover by Datastax. It will be removed from the DB-Engines ranking. A fork has been open-sourced as JanusGraph.
DescriptionAn IoT native database with high performance for data management and analysis, deployable on the edge and the cloud and integrated with Hadoop, Spark and FlinkApplication development environment with integrated database management systemThe SAP (Sybase) Adaptive Server Enterprise (ASE) is an enterprise-class RDBMSWidely used embeddable, in-process RDBMSTitan is a Graph DBMS optimized for distributed clusters.
Primary database modelTime Series DBMSRelational DBMSRelational DBMSRelational DBMSGraph DBMS
Secondary database modelsSpatial DBMS infowith Boeing's Spatial Query Server
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.19
Rank#183  Overall
#15  Time Series DBMS
Score3.53
Rank#94  Overall
#49  Relational DBMS
Score37.49
Rank#25  Overall
#17  Relational DBMS
Score118.16
Rank#10  Overall
#7  Relational DBMS
Websiteiotdb.apache.orgwww.progress.com/­openedgewww.sap.com/­products/­technology-platform/­sybase-ase.htmlwww.sqlite.orggithub.com/­thinkaurelius/­titan
Technical documentationiotdb.apache.org/­UserGuide/­Master/­QuickStart/­QuickStart.htmldocumentation.progress.com/­output/­ua/­OpenEdge_latesthelp.sap.com/­docs/­SAP_ASEwww.sqlite.org/­docs.htmlgithub.com/­thinkaurelius/­titan/­wiki
DeveloperApache Software FoundationProgress Software CorporationSAP, SybaseDwayne Richard HippAurelius, owned by DataStax
Initial release20181984198720002012
Current release1.1.0, April 2023OpenEdge 12.2, March 202016.03.45.2  (12 March 2024), March 2024
License infoCommercial or Open SourceOpen Source infoApache Version 2.0commercialcommercialOpen Source infoPublic DomainOpen Source infoApache license, version 2.0
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaC and C++CJava
Server operating systemsAll OS with a Java VM (>= 1.8)AIX
HP-UX
Linux
Solaris
Windows
AIX
HP-UX
Linux
Solaris
Unix
Windows
server-lessLinux
OS X
Unix
Windows
Data schemeyesyesyesyes infodynamic column typesyes
Typing infopredefined data types such as float or dateyesyesyesyes infonot rigid because of 'dynamic typing' concept.yes
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.noyesnono
Secondary indexesyesyesyesyesyes
SQL infoSupport of SQLSQL-like query languageyes infoclose to SQL 92yesyes infoSQL-92 is not fully supportedno
APIs and other access methodsJDBC
Native API
JDBC
ODBC
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
ADO.NET infoinofficial driver
JDBC infoinofficial driver
ODBC infoinofficial driver
Java API
TinkerPop Blueprints
TinkerPop Frames
TinkerPop Gremlin
TinkerPop Rexster
Supported programming languagesC
C#
C++
Go
Java
Python
Scala
Progress proprietary ABL (Advanced Business Language)C
C++
Cobol
Java
Java
Perl
PHP
Python
Actionscript
Ada
Basic
C
C#
C++
D
Delphi
Forth
Fortran
Haskell
Java
JavaScript
Lisp
Lua
MatLab
Objective-C
OCaml
Perl
PHP
PL/SQL
Python
R
Ruby
Scala
Scheme
Smalltalk
Tcl
Clojure
Java
Python
Server-side scripts infoStored proceduresyesyesJava and Transact-SQLnoyes
Triggersyesyesyesyesyes
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioning (by time range) + vertical partitioning (by deviceId)horizontal partitioning infosince Version 11.4horizontal partitioningnoneyes infovia pluggable storage backends
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication methods; using Raft/IoTConsensus algorithm to ensure strong/eventual data consistency among multiple replicasSource-replica replicationMulti-source replication
Source-replica replication
noneyes
MapReduce infoOffers an API for user-defined Map/Reduce methodsIntegration with Hadoop and Sparknononoyes infovia Faunus, a graph analytics engine
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Strong Consistency with Raft
Immediate ConsistencyImmediate ConsistencyEventual Consistency
Immediate Consistency
Foreign keys infoReferential integritynoyesyesyesyes infoRelationships in graph
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes infovia file-system locksyes
Durability infoSupport for making data persistentyesyesyesyesyes infoSupports various storage backends: Cassandra, HBase, Berkeley DB, Akiban, Hazelcast
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnoyes
User concepts infoAccess controlyesUsers and groupsfine grained access rights according to SQL-standardnoUser authentification and security via Rexster Graph Server

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 partiesNavicat for SQLite is a powerful and comprehensive SQLite GUI that provides a complete set of functions for database management and development.
» more

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

More resources
Apache IoTDBOpenEdgeSAP Adaptive Server infoformer name: Sybase ASESQLiteTitan
DB-Engines blog posts

Big gains for Relational Database Management Systems in DB-Engines Ranking
2 February 2016, Matthias Gelbmann

show all

Graph DBMS increased their popularity by 500% within the last 2 years
3 March 2015, Paul Andlinger

Graph DBMSs are gaining in popularity faster than any other database category
21 January 2014, Matthias Gelbmann

show all

Recent citations in the news

Linux 6.5 With AMD P-State EPP Default Brings Performance & Power Efficiency Benefits For Ryzen Servers
21 September 2023, Phoronix

AMD EPYC 8324P / 8324PN Siena 32-Core Siena Linux Server Performance Review
10 October 2023, Phoronix

Apache Promotes IoT Database Project
25 September 2020, Datanami

IoTDB Provides Data Management for Industrial Edge IT
15 October 2020, The New Stack

Intel Xeon Max Enjoying Some Performance Gains With Linux 6.6
12 October 2023, Phoronix

provided by Google News

OpenEdge Application Development | Progress OpenEdge
14 September 2014, Progress Software

PoC Exploit Released for OpenEdge Authentication Gateway & AdminServer Vulnerability
11 March 2024, GBHackers

provided by Google News

New Services for SAP HANA Cloud Database
7 April 2021, SAP News

Arcion Introduces SAP Sybase ASE Connector for Ultimate Migration Flexibility
5 January 2023, Business Wire

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

Patch SAP Adaptive Server Enterprise now to avoid takeover risk
3 June 2020, BleepingComputer

Newly Patched SAP ASE Flaws Could Let Attackers Hack Database Servers
3 June 2020, The Hacker News

provided by Google News

SQLite the New Hotness?! 🤔
21 March 2024, hackernoon.com

SQLite Vulnerability Could Put Thousands of Apps at Risk
22 March 2024, Dark Reading

Universal API Access from Postgres and SQLite
27 February 2024, oreilly.com

SQLite's new support for binary JSON is similar but different from a PostgreSQL feature • DEVCLASS
16 January 2024, DevClass

Stanchion Turns SQLite Into A Column Store
15 February 2024, iProgrammer

provided by Google News

Amazon DynamoDB Storage Backend for Titan: Distributed Graph Database | Amazon Web Services
24 August 2015, AWS Blog

Beyond Titan: The Evolution of DataStax's New Graph Database
21 June 2016, Datanami

Titan Graph Database Integration with DynamoDB: World-class Performance, Availability, and Scale for New Workloads
20 August 2015, All Things Distributed

DataStax acquires Aurelius, the startup behind the Titan graph database
3 February 2015, VentureBeat

DSE Graph review: Graph database does double duty
14 November 2019, InfoWorld

provided by Google News



Share this page

Featured Products

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Ontotext logo

GraphDB allows you to link diverse data, index it for semantic search and enrich it via text analysis to build big knowledge graphs. Get it free.

SingleStore logo

The database to transact, analyze and contextualize your data in real time.
Try it today.

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

Neo4j logo

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

Present your product here