DBMS > AllegroGraph vs. PostgreSQL vs. TimesTen
System Properties Comparison AllegroGraph vs. PostgreSQL vs. TimesTen
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||AllegroGraph Xexclude from comparison||PostgreSQL Xexclude from comparison||TimesTen Xexclude from comparison|
|Description||High performance, persistent RDF store with additional support for Graph DBMS||Widely used open source RDBMS Developed as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL||In-Memory RDBMS compatible to Oracle|
|Primary database model||Document store with version 6.5|
|Relational DBMS with object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.||Relational DBMS|
|Secondary database models||Spatial DBMS||Document store|
Graph DBMS with Apache Age
Vector DBMS with pgvector extension
|Developer||Franz Inc.||PostgreSQL Global Development Group www.postgresql.org/developer||Oracle, TimesTen Performance Software, HP originally founded in HP Labs it was acquired by Oracle in 2005|
|Initial release||2004||1989 1989: Postgres, 1996: PostgreSQL||1998|
|Current release||7.3.1, December 2022||16.1, November 2023||11 Release 2 (184.108.40.206.0)|
|License Commercial or Open Source||commercial Limited community edition free||Open Source BSD||commercial|
|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.
|Aiven for PostgreSQL: Fully managed PostgreSQL for developers with 70+ extensions and flexible orchestration tools.|
|Server operating systems||Linux|
|Data scheme||yes RDF schemas||yes||yes|
|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 bulk load of XML files possible||yes specific XML-type available, but no XML query functionality.||no|
|SQL Support of SQL||SPARQL is used as query language||yes standard with numerous extensions||yes|
|APIs and other access methods||RESTful HTTP API|
native C library
streaming API for large objects
Oracle Call Interface (OCI)
|Supported programming languages||C#|
|Partitioning methods Methods for storing different data on different nodes||with Federation||partitioning by range, list and (since PostgreSQL 11) by hash||none|
|Replication methods Methods for redundantly storing data on multiple nodes||Multi-source replication|
|Source-replica replication other methods possible by using 3rd party extensions||Multi-source replication|
|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 or Eventual Consistency depending on configuration||Immediate Consistency||Immediate Consistency or Eventual Consistency depending on configuration|
|Foreign keys Referential integrity||no||yes||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes||yes by means of logfiles and checkpoints|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no||no||yes|
|User concepts Access control||Users with fine-grained authorization concept, user roles and pluggable authentication||fine grained access rights according to SQL-standard||fine grained access rights according to SQL-standard|
|More information provided by the system vendor|
|Specific characteristics||Knowledge Graph Platform Leader FedShard - Designed for Entity-Event Knowledge Graph...|
|Competitive advantages||AllegroGraph is uniquely suited to support adhoc queries through SPARQL, Prolog and...|
New – AllegroGraph v8 – Neuro-Symbolic AI Platform
AllegroGraph – Trend-Setting Product for 2024
Data + AI Day 2024
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.|
Instaclustr: Fully Hosted & Managed PostgreSQL
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!
Aiven for PostgreSQL: Fully managed PostgreSQL for developers with 70+ extensions and flexible orchestration tools.
pgDash: In-Depth PostgreSQL Monitoring.
Redgate webinars: A series of key topics for new PostgreSQL users.
Fujitsu Enterprise Postgres: An Enterprise Grade PostgreSQL with the flexibility of a hybrid cloud solution combined with industry leading security, availability and performance.
Navicat Monitor is a safe, simple and agentless remote server monitoring tool for PostgreSQL and many other database management systems.
Datasentinel: Platform for Monitoring and Analyzing the performance problems of your PostgreSQL Clusters
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|
Snowflake is the DBMS of the Year 2022, defending the title from last year
|Recent citations in the news|
Jans Aasman Articles and Insights
Neuro-Symbolic AI: The Peak of Artificial Intelligence
Why Enterprise Knowledge Graphs Need Semantics
The key to quantum computing AI applications: Flexible programming languages
The Amazing Applications of Graph Neural Networks
provided by Google News
OCI Database: Oracle Embraces PostgreSQL
Data Flow Tutorial With Mage.ai | Part 4: PostgreSQL Database - Technical Articles
VMware and Google Cloud Announce Planned PostgreSQL-Compatible Database Solution for Traditional and ...
PostgreSQL Takes a New Turn
Using Arrays in PostgreSQL: A Guide
provided by Google News
How Oracle Is Defending Itself Against SAP's Attack
provided by Google News
Senior Database Administrator (DBA) - Onsite
Sr PostgreSQL DBA
Full Stack Developer
Share this page