DBMS > Adabas vs. PostgreSQL vs. RDF4J
System Properties Comparison Adabas vs. PostgreSQL vs. RDF4J
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Adabas denotes "adaptable data base" Xexclude from comparison||PostgreSQL Xexclude from comparison||RDF4J formerly known as Sesame Xexclude from comparison|
|Description||OLTP - DBMS for mainframes and Linux/Unix/Windows environments used typically together with the Natural programming platform||Widely used open source RDBMS Developed as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL||RDF4J is a Java framework for processing RDF data, supporting both memory-based and a disk-based storage.|
|Primary database model||Multivalue DBMS||Relational DBMS with object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.||RDF store|
|Secondary database models||Document store|
|Developer||Software AG||PostgreSQL Global Development Group www.postgresql.org/developer||Since 2016 officially forked into an Eclipse project, former developer was Aduna Software.|
|Initial release||1971||1989 1989: Postgres, 1996: PostgreSQL||2004|
|Current release||11.3, May 2019|
|License Commercial or Open Source||commercial||Open Source BSD||Open Source Eclipse Distribution License (EDL), v1.0.|
|Cloud-based only Only available as a cloud service||no||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems||BS2000|
|Data scheme||yes||yes||yes RDF Schemas|
|Typing predefined data types such as float or date||yes||yes||yes|
|XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.||no||yes specific XML-type available, but no XML query functionality.|
|SQL Support of SQL||yes with add-on product Adabas SQL Gateway||yes standard with numerous extensions||no|
|APIs and other access methods||HTTP API with add-on software Adabas SOA Gateway|
SOAP-based API with add-on software Adabas SOA Gateway
|native C library|
streaming API for large objects
RIO RDF Input/Output
SeRQL Sesame RDF Query Language
Sesame REST HTTP Protocol
|Supported programming languages||Natural||.Net|
|Server-side scripts Stored procedures||in Natural||user defined functions realized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.||yes|
|Partitioning methods Methods for storing different data on different nodes||yes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas Vista||partitioning by range, list and (since PostgreSQL 11) by hash||none|
|Replication methods Methods for redundantly storing data on multiple nodes||yes, with add-on product Event Replicator||Master-slave replication other methods possible by using 3rd party extensions||none|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||no||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID||ACID Isolation support depends on the API used|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes||yes in-memory storage is supported as well|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no||no|
|User concepts Access control||only with OS-specific tools (e.g. IBM RACF, CA Top Secret)||fine grained access rights according to SQL-standard||no|
More information provided by the system vendor
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.|
pgDash: In-Depth PostgreSQL Monitoring.
Dremio is like magic for PostgreSQL accelerating your analytical queries up to 1,000x.
2ndQuadrant: PostgreSQL Solutions for the Enterprise.
Azure Database for PostgreSQL provides fully managed, enterprise-ready community PostgreSQL database as a service
DBHawk: a web-based PostgreSQL/Greenplum database tool. Boost database development and BI productivity with an online Universal database tool.
Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|Adabas denotes "adaptable data base"||PostgreSQL||RDF4J formerly known as Sesame|
|DB-Engines blog posts|
PostgreSQL is the DBMS of the Year 2018
|Conferences and events|
PGCon 2019, PostgreSQL Conference for Users and Developers
Achieving High Availability with PostgreSQL
|Recent citations in the news|
Bringing a mainframe database into the modern era of reporting
Software AG (SOW) Receives €38.79 Consensus Price Target from Brokerages
Software (ETR:SOW) PT Set at €30.00 by JPMorgan Chase & Co.
Software (ETR:SOW) Given a €45.00 Price Target by Baader Bank Analysts
Software AG's Strategy To End Its 8-Year Growth Drought
provided by Google News
Oracle SQL: postGreSQL GENERATE_SERIES
Global Data Base Management Systems Market 2019 Analysis – Microsoft, Software, IBM, Oracle, PostgreSQL, NCR
Should I Support Postgres In-House?
provided by Google News
Amazon Neptune review: A scalable graph database for OLTP
Ontotext's GraphDB 8.9 Boosts Semantic Similarity Search
provided by Google News
Senior Software Developer/Analyst
Senior Software Developer--Lakewood, CO
Mainframe Software Engineer
ADABAS/NATURAL Software Developer
Staff Database Engineer
Database Engineer - PostgreSQL
Software Engineer/Data Scientist
Share this page