DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > AllegroGraph vs. GraphDB vs. PostgreSQL

System Properties Comparison AllegroGraph vs. GraphDB vs. PostgreSQL

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAllegroGraph  Xexclude from comparisonGraphDB infoformer name: OWLIM  Xexclude from comparisonPostgreSQL  Xexclude from comparison
DescriptionHigh performance, persistent RDF store with additional support for Graph DBMSEnterprise-ready RDF and graph database with efficient reasoning, cluster and external index synchronization support. It supports also SQL JDBC access to Knowledge Graph and GraphQL over SPARQL.Widely used open source RDBMS infoDeveloped as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL
Primary database modelDocument store infowith version 6.5
Graph DBMS
RDF store
Graph DBMS
RDF store
Relational DBMS infowith object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.
Secondary database modelsSpatial DBMSDocument store
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.05
Rank#174  Overall
#30  Document stores
#15  Graph DBMS
#7  RDF stores
Score2.55
Rank#113  Overall
#7  Graph DBMS
#5  RDF stores
Score618.00
Rank#4  Overall
#4  Relational DBMS
Websiteallegrograph.comwww.ontotext.comwww.postgresql.org
Technical documentationfranz.com/­agraph/­support/­documentation/­current/­agraph-introduction.htmlgraphdb.ontotext.com/­documentationwww.postgresql.org/­docs
Social network pagesTwitterLinkedInYouTubeGitHubMedium
DeveloperFranz Inc.OntotextPostgreSQL Global Development Group infowww.postgresql.org/­developer
Initial release200420001989 info1989: Postgres, 1996: PostgreSQL
Current release7.2.0, October 20219.8, June 202114.5, August 2022
License infoCommercial or Open Sourcecommercial infoLimited community edition freecommercial infoSome plugins of GraphDB Workbench are open sourcedOpen Source infoBSD
Cloud-based only infoOnly available as a cloud servicenonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
  • ScaleGrid for PostgreSQL: Fully managed PostgreSQL hosting on AWS, Azure and DigitalOcean with high availability and SSH access on the #1 multi-cloud DBaaS.
  • Aiven for PostgreSQL: Fully managed and hosted PostgreSQL® with 70+ extensions and orchestration tooling included.
Implementation languageJavaC
Server operating systemsLinux
OS X
Windows
All OS with a Java VM
Linux
OS X
Windows
FreeBSD
HP-UX
Linux
NetBSD
OpenBSD
OS X
Solaris
Unix
Windows
Data schemeyes infoRDF schemasschema-free and OWL/RDFS-schema support; RDF shapesyes
Typing infopredefined data types such as float or dateyesyesyes
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.no infobulk load of XML files possiblenoyes infospecific XML-type available, but no XML query functionality.
Secondary indexesyesyes, supports real-time synchronization and indexing in SOLR/Elastic search/Lucene and GeoSPARQL geometry data indexesyes
SQL infoSupport of SQLSPARQL is used as query languagestored SPARQL accessed as SQL using Apache Calcite through JDBC/ODBCyes infostandard with numerous extensions
APIs and other access methodsRESTful HTTP API
SPARQL
GeoSPARQL
GraphQL
GraphQL Federation
Java API
JDBC
RDF4J API
RDFS
RIO
Sail API
Sesame REST HTTP Protocol
SPARQL 1.1
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
Supported programming languagesC#
Clojure
Java
Lisp
Perl
Python
Ruby
Scala
.Net
C#
Clojure
Java
JavaScript (Node.js)
PHP
Python
Ruby
Scala
.Net
C
C++
Delphi
Java infoJDBC
JavaScript (Node.js)
Perl
PHP
Python
Tcl
Server-side scripts infoStored proceduresyes infoJavaScript or Common Lispwell-defined plugin interfaces; JavaScript server-side extensibilityuser defined functions inforealized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.
Triggersyesnoyes
Partitioning methods infoMethods for storing different data on different nodeswith Federationnonepartitioning by range, list and (since PostgreSQL 11) by hash
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication
Source-replica replication
Multi-source replicationSource-replica replication infoother methods possible by using 3rd party extensions
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency or Eventual Consistency depending on configurationImmediate Consistency, Eventual consistency (configurable in cluster mode per master or individual client request)Immediate Consistency
Foreign keys infoReferential integritynoyes infoConstraint checkingyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nono
User concepts infoAccess controlUsers with fine-grained authorization concept, user roles and pluggable authenticationDefault Basic authentication through RDF4J client, or via Java when run with cURL, default token-based in the Workbench or via Rest API, optional access through OpenID or Kerberos single sign-on.fine grained access rights according to SQL-standard
More information provided by the system vendor
AllegroGraphGraphDB infoformer name: OWLIMPostgreSQL
Specific characteristicsKnowledge Graph Platform Leader FedShard - Designed for Entity-Event Knowledge Graph...
» more
GraphDB Enterprise is a high-performance semantic repository created by Ontotext....
» more
Competitive advantagesAllegroGraph is uniquely suited to support adhoc queries through SPARQL, Prolog and...
» more
GraphDB allows you to link text and data in big knowledge graphs. It’s easy to experiment...
» more
Typical application scenariosMetadata enrichment and management, linked open data publishing, semantic inferencing...
» more
Key customersBBC, Press Association, Financial Times, DK, Euromoney, The British Museum, Getty...
» more
Market metricsGraphDB is the most utilized semantic triplestore for mission-critical enterprise...
» more
Licensing and pricing modelsGraphDB-Free is free to use. SE and Enterprise are licensed per CPU-Core used. Perpetual...
» more
News

AI50 – Companies Empowering Intelligent Knowledge Management
18 July 2022

Semantics for Data Lakehouses
30 June 2022

Franz Inc. Named to Database Trends and Applications Top 100 Companies
10 June 2022

The Foundation of Data Fabrics and AI: Semantic Knowledge Graphs
20 May 2022

SCALE 2022 – Southern California Linux Expo
19 May 2022

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 partiesCYBERTEC is your professional partner for PostgreSQL services and Data Science since 2000. With offices in Austria, Uruguay, Estonia, Poland, South Africa and Switzerland, CYBERTEC operates worldwide and is here for you 24/7!
» more

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

The State of PostgreSQL 2022 survey is now open!
» more

pgDash: In-Depth PostgreSQL Monitoring.
» more

Percona: Database problems? Not on your watch.
Databases run better with Percona.
» more

SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

EDB: BigAnimal is fully-managed PostgreSQL in the cloud from the database fanatics at EDB.
» more

DbVisualizer is equipping database professionals with the tools they need to build, manage and maintain state-of-the-art database technologies. It has sky-high user satisfaction and is the preferred tool for database professionals around the world. Customers include Tesla, Apple, Facebook, Deutsche Bank, NASA, and 25,000 others in 145 countries.
» more

Aiven for PostgreSQL: The familiar open source PostgreSQL® that you know and love, with no proprietary features or add-ons that will lock you in.
» more

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

Instaclustr: Fully Hosted & Managed PostgreSQL
» more

Fujitsu Enterprise Postgres: An Enterprise Grade PostgreSQL with the flexibility of a hybrid cloud solution combined with industry leading security, availability and performance.
» more

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

More resources
AllegroGraphGraphDB infoformer name: OWLIMPostgreSQL
DB-Engines blog posts

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

Driving the Future of PostgreSQL Adoption
15 November 2021,  Umair Shahid, Percona (sponsor) 

The Inexorable Rise of PostgreSQL
24 September 2021,  Matt Yonkovit, Percona (sponsor) 

show all

Conferences and events

GraphDB 10 – An Effortless Journey From The Small Business To The Large Enterprise
5pm CEST, 14 July 2022 (finished)

Recent citations in the news

The Conceptual Data Model’s Unwavering Role in Data Governance
5 August 2022, insideBIGDATA

Expert ai S p A : The Conceptual Data Model's Unwavering Role in Data Governance
8 August 2022, Marketscreener.com

Neuro-Symbolic AI: The Peak of Artificial Intelligence
16 November 2021, AiThority

The key to quantum computing AI applications: Flexible programming languages
2 July 2022, VentureBeat

Franz Inc. Named to Database Trends and Applications Top 100 Companies
14 June 2022, EIN News

provided by Google News

Ontotext Announces Latest Major Release, GraphDB 10
5 July 2022, Datanami

Ontotext's GraphDB 10 Brings Modern Data Architectures to the Mainstream with Better Resilience and Еаsier Operations
5 July 2022, PR Newswire

Ontotext Webinar - GraphDB as Company Data Central USA - English - USA - English
10 March 2022, PR Newswire

Ontotext Receives Growth Funding to Expand in the US, Strengthen its Leadership in the Knowledge Graph Market and Develop Industry-specific Offerings
30 May 2022, PR Newswire

Ontotext GraphDB 9.4 Enables SQL Access to Knowledge Graphs and Visual Mapping of Tabular Data to RDF
11 September 2020, PR Newswire

provided by Google News

Timescale Releases Third State of PostgreSQL Report
29 July 2022, PR Newswire

How to Work With a PostgreSQL Database Using psql Commands - MUO
20 July 2022, MakeUseOf

Install PostgreSQL pgAdmin 4 on Ubuntu 22.04 LTS Jammy Linux
4 August 2022, Linux Shout

How to return data from Postgresql pool in NodeJS?
1 August 2022, SitePoint

How to Create a CRUD API Using Node, PostgresSQL, and Express - MUO
28 July 2022, MakeUseOf

provided by Google News

Job opportunities

Head and VP of Data Architecture and Engineering
Totus Medicines, Emeryville, CA

Software Developer
The GBS Group, Philadelphia, PA

Data Architect (Data Engineer), Senior
TRIAEM, LLC, Springfield, VA

Senior Systems Architect
WELLS FARGO BANK, Chandler, AZ

Lead Systems Architect
WELLS FARGO BANK, Raleigh, NC

Remote Associate Director, Data Engineering (Knowledge Graph)
S&P Global, New Jersey

Semantic Engineer
TechOkaya, Remote

Ontology Taxonomy Semantic Engineer
TechOkaya, Remote

PostgreSQL Database Administrator
Xtivia Inc, Remote

PostgreSQL DBA
Career Soft Solutions, Jersey City, NJ

PostgreSQL Apps DBA
Career Soft Solutions, Jersey City, NJ

PostgreSQL DBA/Developer*
Virtual Service Operations, Remote

Senior PostgreSQL Database Engineer - Modernization
Global Payments, Alpharetta, GA

jobs by Indeed



Share this page

Featured Products

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

Redis logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

The right graph database.
Not a graph add-on.
Free forever.
Start solving today

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

Present your product here