DB-Tools.com - system comparision
19th September 2020, Saturday
 
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
System AllegroGraph Oracle DB
 Version AllegroGraph 6.4.2 [2018-06-18] 12c
 Drawbacks NA costly. You get comparable performance with open source rdbms databases
 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
Robust. Long proven history. Remote connections very stable
 Languages Supported Java, Python, Ruby, Perl, C#, Clojure and Common Lisp C, C++
 Website www.allegrograph.com,
www.franz.com/agraph/allegrograph
https://www.oracle.com
 Name AllegroGraph Oracle DB
 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
It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads
 Database Model Graph Database, A triplestore or RDF store Primarily a relational database
 Technical Documentation franz.com/agraph/support/documentation/current/agraph-introduction.html docs.oracle.com/en/database
 License Commercial Commercial
 Cloud-based / SaaS No Available in AWS, Azure Clouds. Available as a SaaS option in Oracle Cloud
 Implementation Language Common Lisp C,C++
 Operating System Supported Windows, Linux, and Mac OS X AIX HP-UX Linux OS X Solaris Windows z/OS
 Options for Integration / Access API Java, Python, Common Lisp and other APIs Rest API (Oracle Lite), Oracle Call Interface (OCI) 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 Exadata (high cost)
 Notable Users -- Most of the Fortune 500 Companies
 Key Differentiator -- Highly reliable as a transactional database
 Concurrency -- Yes
 Partitioning -- No
 Replication -- Yes
 Secondary Indexes -- Yes
 SchemaLess -- No
 SQL Query -- Yes