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 > Alibaba Cloud AnalyticDB for PostgreSQL vs. Apache Jena - TDB vs. Citus vs. SAP SQL Anywhere vs. Yanza

System Properties Comparison Alibaba Cloud AnalyticDB for PostgreSQL vs. Apache Jena - TDB vs. Citus vs. SAP SQL Anywhere vs. Yanza

Editorial information provided by DB-Engines
NameAlibaba Cloud AnalyticDB for PostgreSQL infoformer name was HybridDB  Xexclude from comparisonApache Jena - TDB  Xexclude from comparisonCitus  Xexclude from comparisonSAP SQL Anywhere infoformerly called Adaptive Server Anywhere  Xexclude from comparisonYanza  Xexclude from comparison
Yanza seems to be discontinued. Therefore it is excluded from the DB-Engines Ranking.
DescriptionAn online MPP (Massively Parallel Processing) data warehousing service based on GreenplumA RDF storage and query DBMS, shipped as an optional-use component of the Apache Jena frameworkScalable hybrid operational and analytics RDBMS for big data use cases based on PostgreSQLRDBMS database and synchronization technologies for server, desktop, remote office, and mobile environmentsTime Series DBMS for IoT Applications
Primary database modelRelational DBMSRDF storeRelational DBMSRelational DBMSTime Series DBMS
Secondary database modelsDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.76
Rank#220  Overall
#102  Relational DBMS
Score3.62
Rank#83  Overall
#3  RDF stores
Score2.15
Rank#117  Overall
#56  Relational DBMS
Score3.95
Rank#80  Overall
#42  Relational DBMS
Websitewww.alibabacloud.com/­product/­hybriddb-postgresqljena.apache.org/­documentation/­tdb/­index.htmlwww.citusdata.comwww.sap.com/­products/­technology-platform/­sql-anywhere.htmlyanza.com
Technical documentationwww.alibabacloud.com/­help/­en/­analyticdb-for-postgresql/­latest/­product-introduction-overviewjena.apache.org/­documentation/­tdb/­index.htmldocs.citusdata.comhelp.sap.com/­docs/­SAP_SQL_Anywhere
DeveloperAlibaba / Pivotal Software Inc. / PostgreSQL Global Development GroupApache Software Foundation infooriginally developed by HP LabsSAP infoformerly SybaseYanza
Initial release20162000201019922015
Current release4.9.0, July 20238.1, December 201817, July 2015
License infoCommercial or Open SourcecommercialOpen Source infoApache License, Version 2.0Open Source infoAGPL, commercial license also availablecommercialcommercial infofree version available
Cloud-based only infoOnly available as a cloud serviceyesnononono infobut mainly used as a service provided by Yanza
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaC
Server operating systemshostedAll OS with a Java VMLinuxAIX
HP-UX
Linux
OS X
Solaris
Windows
Windows
Data schemeyesyes infoRDF Schemasyesyesschema-free
Typing infopredefined data types such as float or dateyesyesyesyesno
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.yesyes infospecific XML type available, but no XML query functionalityyesno
Secondary indexesyesyesyesyesno
SQL infoSupport of SQLyesnoyes infostandard, with numerous extensionsyesno
APIs and other access methodsJDBC
ODBC
Fuseki infoREST-style SPARQL HTTP Interface
Jena RDF API
RIO infoRDF Input/Output
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
ADO.NET
HTTP API
JDBC
ODBC
HTTP API
Supported programming languagesC
Java
Perl
Python
R
Java.Net
C
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Tcl
C
C#
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
any language that supports HTTP calls
Server-side scripts infoStored proceduresyesyesuser defined functions inforealized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.yes, in C/C++, Java, .Net or Perlno
Triggersyesyes infovia event handleryesyesyes infoTimer and event based
Partitioning methods infoMethods for storing different data on different nodesSharding infoImplicit feature of the cloud servicenoneShardingnonenone
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoImplicit feature of the cloud servicenoneSource-replica replication infoother methods possible by using 3rd party extensionsSource-replica replication infoDatabase mirroringnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesyesyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACID infoTDB TransactionsACIDACIDno
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nonoyes
User concepts infoAccess controlfine grained access rights according to SQL-standardAccess control via Jena Securityfine grained access rights according to SQL-standardfine 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
Alibaba Cloud AnalyticDB for PostgreSQL infoformer name was HybridDBApache Jena - TDBCitusSAP SQL Anywhere infoformerly called Adaptive Server AnywhereYanza
Recent citations in the news

Alibaba Cloud upgrades AnalyticDB with vector database engine
25 July 2023, CloudTech News

Two Critical Flaws Found in Alibaba Cloud's PostgreSQL Databases
20 April 2023, The Hacker News

Accidental ‘write’ Permissions In Alibaba PostgreSQL Let Attackers Access Sensitive Data
22 April 2023, GBHackers

Two critical vulnerabilities spotted in Alibaba Cloud's PostgreSQL databases
21 April 2023, TEISS

How Data Analytics Capabilities of Alibaba Group Evolve Its Ecosystem to the Cloud
20 February 2021, DataDrivenInvestor

provided by Google News

Sparql Secrets In Jena-Fuseki
24 July 2022, Data Science Central

Extract and query knowledge graphs using Apache Jena (SPARQL Engine)
4 December 2019, Towards Data Science

6 Java Libraries for Machine Learning
2 October 2023, Analytics India Magazine

A catalogue with semantic annotations makes multilabel datasets FAIR
4 May 2022, Nature.com

MarkLogic Hones Its Triple Store
18 August 2015, Datanami

provided by Google News

Ubicloud wants to build an open source alternative to AWS
5 March 2024, TechCrunch

Ubicloud reels in $16M for its open-source cloud platform
5 March 2024, SiliconANGLE News

Microsoft acquires Citus Data, re-affirming its commitment to Open Source and accelerating Azure PostgreSQL ...
24 January 2019, blogs.microsoft.com

Distributed PostgreSQL Benchmarks: Azure Cosmos DB, CockroachDB, and YugabyteDB
8 July 2023, InfoQ.com

Microsoft Benchmarks Distributed PostgreSQL DBs
10 July 2023, Datanami

provided by Google News

SAP vulnerabilities Let Attacker Inject OS Commands—Patch Now!
11 July 2023, CybersecurityNews

SAP Products & Services Data Portfolio
2 July 2021, Datamation

Securing SAP with AWS Network Firewall: Part 2 – Managed Rules | Amazon Web Services
17 July 2023, AWS Blog

Rimini Street expands support beyond SAP and Oracle
21 May 2016, InsideSAP

MindsDB is now the leading and fastest growing applied ML platform in the world India - English
3 November 2022, PR Newswire

provided by Google News



Share this page

Featured Products

Neo4j logo

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

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

Milvus logo

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

Present your product here