DB-Tools.com - system comparision
22nd September 2020, Tuesday
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
System AllegroGraph PostgresDB
 Name AllegroGraph Postgres SQL
 Version AllegroGraph 6.4.2 [2018-06-18] 10.5 release in august 2018
 Drawbacks NA Primarily a relational database
 Advantages -Database being explicitly pre-structured
-Data to self-define the schema at the time of ingest
-Able to connect concepts, properties, and entities across multiple databases and without further coding to extract new, actionable business insights from your data
Open Source Database with a nice ecosystem with periodic upgrades
 Website www.allegrograph.com,
 Languages Supported Java, Python, Ruby, Perl, C#, Clojure and Common Lisp C C# C++ Cobol Delphi Fortran Java JCL Perl PHP Python Ruby Visual Basic
 JSON Support yes yes
 XML Support yes yes
 Brief description -Modern, high-performance, persistent graph database
-Uses efficient memory utilization in combination with disk-based storage, enabling it to scale to billions of quads while maintaining superior performance
-Supports SPARQL, RDFS++ and Prolog reasoning from numerous applications
PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. It can handle workloads ranging from small single-machine applications to large Internet-facing applications (or for data warehousing) with many concurrent users; on macOS Server, PostgreSQL is the default database and it is also available for Microsoft Windows and Linux (supplied in most distributions). PostgreSQL is ACID-compliant and transactional. PostgreSQL has updatable views and materialized views, triggers, foreign keys; supports functions and stored procedures, and other expandability. PostgreSQL is developed by the PostgreSQL Global Development Group, a diverse group of many companies and individual contributors.It is free and open-source, released under the terms of the PostgreSQL License, a permissive software license.
 Database Model Graph Database, A triplestore or RDF store Primarily a relational database
 Technical Documentation franz.com/agraph/support/documentation/current/agraph-introduction.html www.postgresql.org/­docs/­manuals
 License Commercial Commercial
 Cloud-based / SaaS No Available in AWS and Azure SaaS Option - Available in Google Cloud
 Implementation Language Common Lisp C,C++
 Operating System Supported Windows, Linux, and Mac OS X FreeBSD, HP-UX, Linux, OS X, Solaris, Unix, Windows
 Options for Integration / Access API Java, Python, Common Lisp and other APIs Native C library JDBC ODBC
 Consistency Yes Highly Consistent
 Foreign Keys No Yes
 Streaming Support Yes No
 Data Storage Schema Yes Relational Database
 Analytics Support Yes, AllegroGraph Recognized Among Top 10 Analytics Solution Providers by Pharma Tech Outlook for 2016 Need to buy Netezza
 Notable Users -- Most of the startups and SMEs use this stable open source database with a nice ecosystem of tools supporting it
 Key Differentiator -- Go to Open Source Database. Earlier Mysql was the most popular but new features have been slow after oracle acquisition.
 Concurrency -- Yes
 Partitioning -- No
 Replication -- Yes
 Secondary Indexes -- Yes
 SchemaLess -- No
 SQL Query -- Yes