DB-EnginesExtremeDB: the first and only COTS deterministic embedded database management system for mission- and safety-critical hard real-time applicationsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > AlaSQL vs. Hive vs. Neo4j vs. Oracle

System Properties Comparison AlaSQL vs. Hive vs. Neo4j vs. Oracle

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAlaSQL  Xexclude from comparisonHive  Xexclude from comparisonNeo4j  Xexclude from comparisonOracle  Xexclude from comparison
DescriptionJavaScript DBMS librarydata warehouse software for querying and managing large distributed datasets, built on HadoopScalable, ACID-compliant graph database designed with a high-performance distributed cluster architecture, available in self-hosted and cloud offeringsWidely used RDBMS
Primary database modelDocument store
Relational DBMS
Relational DBMSGraph DBMSRelational DBMS
Secondary database modelsDocument store
Graph DBMS infowith Oracle Spatial and Graph
RDF store infowith Oracle Spatial and Graph
Spatial DBMS infowith Oracle Spatial and Graph
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.67
Rank#215  Overall
#32  Document stores
#108  Relational DBMS
Score85.58
Rank#14  Overall
#9  Relational DBMS
Score57.63
Rank#18  Overall
#1  Graph DBMS
Score1271.55
Rank#1  Overall
#1  Relational DBMS
Websitealasql.orghive.apache.orgneo4j.comwww.oracle.com/­database
Technical documentationgithub.com/­agershun/­alasqlcwiki.apache.org/­confluence/­display/­Hive/­Homeneo4j.com/­docsdocs.oracle.com/­en/­database
DeveloperAndrey Gershun & Mathias R. WulffApache Software Foundation infoinitially developed by FacebookNeo4j, Inc.Oracle
Initial release2014201220071980
Current release3.1.2, August 20194.3.4, September 202119c, February 2019
License infoCommercial or Open SourceOpen Source infoMIT-LicenseOpen Source infoApache Version 2Open Source infoGPL version3, commercial licenses availablecommercial inforestricted free version is available
Cloud-based only infoOnly available as a cloud servicenononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Neo4j Aura: Neo4j’s fully managed cloud service: The zero-admin, always-on graph database for cloud developers.
Implementation languageJavaScriptJavaJava, ScalaC and C++
Server operating systemsserver-less, requires a JavaScript environment (browser, Node.js)All OS with a Java VMLinux infoCan also be used server-less as embedded Java database.
OS X
Solaris
Windows
AIX
HP-UX
Linux
OS X
Solaris
Windows
z/OS
Data schemeschema-freeyesschema-free and schema-optionalyes infoSchemaless in JSON and XML columns
Typing infopredefined data types such as float or datenoyesyesyes
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.noyes
Secondary indexesnoyesyes infopluggable indexing subsystem, by default Apache Luceneyes
SQL infoSupport of SQLClose to SQL99, but no user access control, stored procedures and host language bindings.SQL-like DML and DDL statementsnoyes infowith proprietary extensions
APIs and other access methodsJavaScript APIJDBC
ODBC
Thrift
Bolt protocol
Cypher query language
Java API
Neo4j-OGM infoObject Graph Mapper
RESTful HTTP API
Spring Data Neo4j
TinkerPop 3
JDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
Supported programming languagesJavaScriptC++
Java
PHP
Python
.Net
Clojure
Elixir
Go
Groovy
Haskell
Java
JavaScript
Perl
PHP
Python
Ruby
Scala
C
C#
C++
Clojure
Cobol
Delphi
Eiffel
Erlang
Fortran
Groovy
Haskell
Java
JavaScript
Lisp
Objective C
OCaml
Perl
PHP
Python
R
Ruby
Scala
Tcl
Visual Basic
Server-side scripts infoStored proceduresnoyes infouser defined functions and integration of map-reduceyes infoUser defined Procedures and FunctionsPL/SQL infoalso stored procedures in Java possible
Triggersyesnoyes infovia event handleryes
Partitioning methods infoMethods for storing different data on different nodesnoneShardingyes using Neo4j FabricSharding, horizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesnoneselectable replication factorCausal Clustering using Raft protocol infoavailable in in Enterprise Version onlyMulti-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyes infoquery execution via MapReducenono infocan be realized in PL/SQL
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneEventual ConsistencyCausal and Eventual Consistency configurable in Causal Cluster setup
Immediate Consistency in stand-alone mode
Immediate Consistency
Foreign keys infoReferential integrityyesnoyes infoRelationships in graphsyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayes infoonly for local storage and DOM-storagenoACIDACID infoisolation level can be parameterized
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyes infoby using IndexedDB, SQL.JS or proprietary FileStorageyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes infoVersion 12c introduced the new option 'Oracle Database In-Memory'
User concepts infoAccess controlnoAccess rights for users, groups and rolesUsers, roles and permissions. Pluggable authentication with supported standards (LDAP, Active Directory, Kerberos)fine grained access rights according to SQL-standard
More information provided by the system vendor
AlaSQLHiveNeo4jOracle
Specific characteristicsNeo4j delivers graph technology that has been battle tested for performance and scale...
» more
Competitive advantagesNeo4j is the market leader, graph database category creator, and the most widely...
» more
Typical application scenariosReal-Time Recommendations Master Data Management Identity and Access Management Network...
» more
Key customersOver 800 commercial customers and over 4300 startups use Neo4j. Flagship customers...
» more
Market metricsNeo4j boasts the world's largest graph database ecosystem with more than 140 million...
» more
Licensing and pricing modelsGPL v3 license that can be used all the places where you might use MySQL. Neo4j Commercial...
» more
News

This Week in Neo4j – Liquibase, Crypto Txns Breadcrumbs, Cloud Empire, Java Version Diffs, Gephi, GraphQL 2.2.0, GraphKer
25 September 2021

What’s New with Graph Data Science: GDS 1.7 Release
23 September 2021

Kafka for Neo4j Aura Is Available Now
21 September 2021

This Week in Neo4j – GraphXR, CARD, Relational vs. Graph, Azure Functions, Neo4j Spring Data 6, Load JSON, Videos Galore
18 September 2021

#GraphCast: 8 Tips to Decide If Knowledge Graph Is Right for You
17 September 2021

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 partiesSQLFlow: 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
Graphable delivers expert services for Neo4j and other Graph DBMS.
» more
Fivetran: Quickly and easily centralize your on-premise and cloud databases.
» 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

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

More resources
AlaSQLHiveNeo4jOracle
DB-Engines blog posts

Why is Hadoop not listed in the DB-Engines Ranking?
13 May 2013, Paul Andlinger

show all

Applying Graph Analytics to Game of Thrones
12 June 2019, Amy Hodler & Mark Needham, Neo4j (guest author)

MySQL, PostgreSQL and Redis are the winners of the March ranking
2 March 2016, Paul Andlinger

The openCypher Project: Help Shape the SQL for Graphs
22 December 2015, Emil Eifrem (guest author)

show all

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
25 November 2016, Tony Branson (guest author)

show all

Recent citations in the news

Meet AlaSQL, a speedy SQL database for JavaScript
15 January 2019, JAXenter

Introduction to Apache Spark: Big Data Analytics Simplified
4 September 2018, Business 2 Community

indexeddb | Read the Tea Leaves
22 August 2021, nolanlawson.com

provided by Google News

Best Data Warehouse Tools for Managing Your Data | ESF
24 September 2021, Enterprise Storage Forum

Open-Source Database Software Market Size, Analysis, and Key Manufacturers – Titan, Neo4j, SQLite, MariaDB, Apache Hive, Couchbase, MongoDB – Stillwater Current
21 September 2021, Stillwater Current

What is Apache Hadoop? Understanding Hadoop Ecosystem & Architecture | ITBE
9 September 2021, IT Business Edge

Tabular Seeks to Remake Cloud Data Lakes in Iceberg's Image
7 September 2021, Datanami

The Apache Drill Project Announces Apache® Drill(TM) v1.19
30 August 2021, GlobeNewswire

provided by Google News

NASA, The German Center for Diabetes Research (DZD), TCS, and More Use Neo4j Knowledge Graphs for Next-Level Digital Transformation
8 September 2021, PRNewswire

Graph Databases Software Market Size, Growth And Analysis By Leading Keyplayers – Neo4j, ArangoDB, SAP, Twitter – Stillwater Current
22 September 2021, Stillwater Current

Open-Source Database Software Market Size, Analysis, and Key Manufacturers – Titan, Neo4j, SQLite, MariaDB, Apache Hive, Couchbase, MongoDB – Stillwater Current
21 September 2021, Stillwater Current

What are graph database query languages?
3 September 2021, VentureBeat

Neo4j raises Neo$325M as graph-based data analysis takes hold in enterprise
17 June 2021, TechCrunch

provided by Google News

Adenza Chooses Oracle Autonomous Database to Expand its Multi-Cloud Risk Analytics Services
16 September 2021, inForney.com

Database Wars: Oracle Attacks Amazon with High-Speed Upgrade
16 September 2021, Cloud Wars

Finding Ready With Oracle 1Z0-082 Exam Dumps
24 September 2021, The African Exponent

Genuine Oracle Exam Questions With Updated 1Z0-083 Greatest High-quality Of PDF Exam Dumps
24 September 2021, The African Exponent

Nosql Market is Set To Fly High in Years to Come | CloudDB, Oracle Database, MongoLab, MarkLogic - Herefordshire Live
25 September 2021, Herefordshire Live

provided by Google News

Job opportunities

Developer
Axle Informatics, Rockville, MD

Applications Developer
Axle Informatics, Rockville, MD

Software Engineer
Indeed, Remote

Associate Data Lake Consultant
Amazon Web Services, Inc., Remote

Spark Scala Developer / Apache Hive
Atlantisitgroup, Phoenix, AZ

Big Data Developer
Purple Drive Solution, Quincy, MA

Hadoop Administrator
Logic Loops, Atlanta, GA

Vice President of Global Customer Support
Neo4j, Boston, MA

Customer Support Engineer - Aura
Neo4j, Boston, MA

Vice President of Global Customer Support - Remote
Neo4j, United States

Developer Relations Director
Neo4j, United States

Neo4j Technical Product Marketing (Remote)
Neo4j, Boston, MA

Oracle Database Administrator
Velocity Technology Solutions, Inc., United States

Oracle Database Administrator
Oracle, United States

Database Administrator- REMOTE *
Sierra7, Falls Church, VA

Database Administrator 3/Senior Database Administrator
MidAmerican Energy, Salt Lake City, UT

Oracle SQL Database Developer
Byrne Software Technologies, Remote

jobs by Indeed



Share this page

Featured Products

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 5 GB free..

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here