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

DBMS > Alibaba Cloud Log Service vs. IBM Db2 vs. jBASE vs. PostgreSQL vs. Riak TS

System Properties Comparison Alibaba Cloud Log Service vs. IBM Db2 vs. jBASE vs. PostgreSQL vs. Riak TS

Editorial information provided by DB-Engines
NameAlibaba Cloud Log Service  Xexclude from comparisonIBM Db2 infoformerly named DB2 or IBM Database 2  Xexclude from comparisonjBASE  Xexclude from comparisonPostgreSQL  Xexclude from comparisonRiak TS  Xexclude from comparison
DescriptionA complete real-time data logging service that supports collection, consumption, shipping, search, and analysis of logs.Common in IBM host environments, 2 different versions for host and Windows/LinuxA robust multi-value DBMS comprising development tools and middlewareWidely used open source RDBMS infoDeveloped as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQLRiak TS is a distributed NoSQL database optimized for time series data and based on Riak KV
Primary database modelSearch engineRelational DBMS infoSince Version 10.5 support for JSON/BSON documents compatible with MongoDBMultivalue DBMSRelational DBMS infowith object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.Time Series DBMS
Secondary database modelsDocument store
RDF store infoin Db2 LUW (Linux, Unix, Windows)
Spatial DBMS infowith Db2 Spatial Extender
Document store
Graph DBMS infowith Apache Age
Spatial DBMS
Vector DBMS infowith pgvector extension
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.46
Rank#268  Overall
#19  Search engines
Score127.75
Rank#8  Overall
#5  Relational DBMS
Score1.68
Rank#151  Overall
#3  Multivalue DBMS
Score634.91
Rank#4  Overall
#4  Relational DBMS
Score0.28
Rank#308  Overall
#27  Time Series DBMS
Websitewww.alibabacloud.com/­product/­log-servicewww.ibm.com/­products/­db2www.rocketsoftware.com/­products/­rocket-multivalue-application-development-platform/­rocket-jbasewww.postgresql.org
Technical documentationwww.alibabacloud.com/­help/­en/­slswww.ibm.com/­docs/­en/­db2docs.rocketsoftware.com/­bundle?labelkey=jbase_5.9www.postgresql.org/­docswww.tiot.jp/­riak-docs/­riak/­ts/­latest
DeveloperAlibabaCloud Inc.IBMRocket Software (formerly Zumasys)PostgreSQL Global Development Group infowww.postgresql.org/­developerOpen Source, formerly Basho Technologies
Initial release20161983 infohost version19911989 info1989: Postgres, 1996: PostgreSQL2015
Current release12.1, October 20165.716.2, February 20243.0.0, September 2022
License infoCommercial or Open Sourcecommercialcommercial infofree version is availablecommercialOpen Source infoBSDOpen Source
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.
Aiven for PostgreSQL: Fully managed PostgreSQL for developers with 70+ extensions and flexible orchestration tools.
Implementation languageC and C++CErlang
Server operating systemshostedAIX
HP-UX
Linux
Solaris
Windows
z/OS
AIX
Linux
Windows
FreeBSD
HP-UX
Linux
NetBSD
OpenBSD
OS X
Solaris
Unix
Windows
Linux
OS X
Data schemeschema-freeyesschema-freeyesschema-free
Typing infopredefined data types such as float or dateyesyesoptionalyesno
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.noyesyes infospecific XML-type available, but no XML query functionality.no
Secondary indexesyesyesyesrestricted
SQL infoSupport of SQLSQL for queryingyesEmbedded SQL for jBASE in BASICyes infostandard with numerous extensionsyes, limited
APIs and other access methodsHTTP RESTADO.NET
JDBC
JSON style queries infoMongoDB compatible
ODBC
XQuery
JDBC
ODBC
Proprietary protocol
RESTful HTTP API
SOAP-based API
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
HTTP API
Native Erlang Interface
Supported programming languagesC
C#
C++
Cobol
Delphi
Fortran
Java
Perl
PHP
Python
Ruby
Visual Basic
.Net
Basic
Jabbascript
Java
.Net
C
C++
Delphi
Java infoJDBC
JavaScript (Node.js)
Perl
PHP
Python
Tcl
C infounofficial client library
C#
C++ infounofficial client library
Clojure infounofficial client library
Dart infounofficial client library
Erlang
Go infounofficial client library
Groovy infounofficial client library
Haskell infounofficial client library
Java
JavaScript infounofficial client library
Lisp infounofficial client library
Perl infounofficial client library
PHP
Python
Ruby
Scala infounofficial client library
Smalltalk infounofficial client library
Server-side scripts infoStored proceduresnoyesyesuser defined functions inforealized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.Erlang
Triggersyesyesyesyesyes infopre-commit hooks and post-commit hooks
Partitioning methods infoMethods for storing different data on different nodesShardingSharding infoonly with Windows/Unix/Linux VersionShardingpartitioning by range, list and (since PostgreSQL 11) by hashSharding
Replication methods infoMethods for redundantly storing data on multiple nodes3 replicasyes infowith separate tools (MQ, InfoSphere)yesSource-replica replication infoother methods possible by using 3rd party extensionsselectable replication factor
MapReduce infoOffers an API for user-defined Map/Reduce methodsES-Hadoop Connectornononoyes
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual ConsistencyImmediate ConsistencyEventual Consistency
Foreign keys infoReferential integritynoyesnoyesno infolinks between datasets can be stored
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDACIDACIDno
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.noyesno
User concepts infoAccess controlAlibaba Cloud user access controlfine grained access rights according to SQL-standardAccess rights can be defined down to the item levelfine grained access rights according to SQL-standardno
More information provided by the system vendor
Alibaba Cloud Log ServiceIBM Db2 infoformerly named DB2 or IBM Database 2jBASEPostgreSQLRiak TS
Specific characteristicsA real-time service for telementry data (log, metric, trace). Alibaba Cloud Log Service...
» more
Competitive advantages* Ease of use: Completes data collections from more than 30 data sources within five...
» more
Typical application scenarios* Log/Trace/Event Search & Analysis * Application Monitoring * Operation Analysis...
» more
Key customers* Alibaba & Ant-Finance:he infrastructure service for the Corp * Over 22k Subscriber...
» more
Licensing and pricing modelsPay-As-You-Go https://www.alibabacloud.com/product/log-service/pricing
» more

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 partiesFujitsu Enterprise Postgres: An Enterprise Grade PostgreSQL with the flexibility of a hybrid cloud solution combined with industry leading security, availability and performance.
» more

Redgate webinars: A series of key topics for new PostgreSQL users.
» more

Instaclustr: Fully Hosted & Managed PostgreSQL
» more

SharePlex is the reliable and affordable data replication solution for PostgreSQL migrations, high availability and more.
» more

Timescale: Calling all PostgreSQL users – the 2023 State of PostgreSQL survey is now open! Share your favorite extensions, preferred frameworks, community experiences, and more. Take the survey today!
» more

Aiven for PostgreSQL: Fully managed PostgreSQL for developers with 70+ extensions and flexible orchestration tools.
» more

Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
» more

Datasentinel: Platform for Monitoring and Analyzing the performance problems of your PostgreSQL Clusters
» more

CYBERTEC is your professional partner in PostgreSQL topics for over 20 years. As our main aim is to be your single-source all-in-one IT service provider, we offer a wide range of products and services. Visit our website for more details.
» more

Navicat Monitor is a safe, simple and agentless remote server monitoring tool for PostgreSQL and many other database management systems.
» more

pgDash: In-Depth PostgreSQL Monitoring.
» more

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

More resources
Alibaba Cloud Log ServiceIBM Db2 infoformerly named DB2 or IBM Database 2jBASEPostgreSQLRiak TS
DB-Engines blog posts

PostgreSQL is the DBMS of the Year 2023
2 January 2024, Matthias Gelbmann, Paul Andlinger

Snowflake is the DBMS of the Year 2022, defending the title from last year
3 January 2023, Matthias Gelbmann, Paul Andlinger

Snowflake is the DBMS of the Year 2021
3 January 2022, Paul Andlinger, Matthias Gelbmann

show all

Recent citations in the news

2 Methods for Installing Serverless Kubernetes in Alibaba Cloud
29 March 2022, hackernoon.com

Alibaba Cloud Further Facilitates Digital Transformation Acceleration across Asia in the Year of the Pandemic
27 January 2021, PR Newswire

Alibaba (BABA) Boosts Global Presence With New Cloud Products
5 June 2019, Yahoo Finance

Alibaba Cloud Further Facilitates Digital Transformation Acceleration Across Asia
27 January 2021, MESA Website

Alibaba Cloud targets SMEs with SaaS accelerator
3 June 2019, Channel Asia Singapore

provided by Google News

IBM's vintage Db2 database jumps on AWS's cloud bandwagon
29 November 2023, The Register

Getting started with new Amazon RDS for Db2 | Amazon Web Services
27 November 2023, AWS Blog

Celebrating 40 years of Db2: Running the world's mission critical workloads
11 September 2023, ibm.com

How Amazon RDS for IBM Db2 Showcases the Power of Co-Creation
21 December 2023, Acceleration Economy

IBM Collaborates with AWS to Launch a New Cloud Database Offering, Enabling Customers to Optimize Data ...
27 November 2023, PR Newswire

provided by Google News

Temenos signs first customer in India
24 August 2009, Finextra

provided by Google News

AI GPTs for PostgreSQL Database: Can They Work?
22 March 2024, Unite.AI

Relational Data at the Edge: How Cloudflare Operates Distributed PostgreSQL Clusters
21 March 2024, InfoQ.com

General availability: Microsoft Entra ID integration with Azure Cosmos DB for PostgreSQL | Azure updates
13 March 2024, azure.microsoft.com

Introducing OCI Database with PostgreSQL: Completing Our Cloud Database Suite for Every Need
14 November 2023, blogs.oracle.com

PostgreSQL and Databricks founders join forces for DBOS to create a new type of operating system
12 March 2024, VentureBeat

provided by Google News

NoSQL pioneer Basho stamps its mark on time stamp data with Riak TS
6 October 2015, The Register

Enterprise NoSQL Database for the IoT Becomes Open Source
11 May 2016, ENGINEERING.com

What you missed in the Smart World: Amazon enters IoT space
12 October 2015, SiliconANGLE News

Best open source databases for IoT applications
26 May 2017, Open Source For You

Managing time series data using InfluxData
26 May 2017, Open Source For You

provided by Google News



Share this page

Featured Products

SingleStore logo

Database for your real-time AI and Analytics Apps.
Try it today.

Milvus logo

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

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online 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.

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

Present your product here