Need advice about which tool to choose?Ask the StackShare community!

Neo4j

1.2K
1.4K
+ 1
352
Oracle

2.3K
1.7K
+ 1
113
Add tool

Neo4j vs Oracle: What are the differences?

Introduction

Neo4j and Oracle are both popular database management systems, but they differ in several key aspects. In this article, we will explore the main differences between Neo4j and Oracle.

  1. Data Model: One of the key differences between Neo4j and Oracle is their data model. Neo4j is a graph database, which means it organizes data in nodes and relationships. This allows for highly connected data to be efficiently stored and queried. On the other hand, Oracle is a relational database, meaning it stores data in tables with predefined relationships and joins.

  2. Language and Querying: Another difference lies in the query language used. Neo4j uses a graph querying language called Cypher, which is specifically designed for graph databases. Cypher offers expressive syntax for traversing and querying graph data. In contrast, Oracle uses SQL (Structured Query Language), the standard language for relational databases.

  3. Scalability and Performance: Neo4j is known for its scalability and performance when dealing with highly interconnected datasets. Its native graph storage and query optimization make it suitable for handling complex queries efficiently. Oracle, as a relational database, is well-suited for handling large volumes of structured data but may face challenges when dealing with highly connected data.

  4. Flexibility: Neo4j offers flexible schema, allowing for dynamic changes in the structure and relationships of the data. Nodes and relationships can be added, modified, or removed without disrupting the existing data. Oracle, being a relational database, requires predefined schemas and a strict structure for data storage and modification.

  5. Use Cases: The choice between Neo4j and Oracle also depends on the specific use case. Neo4j is often favored when dealing with scenarios that have complex relationships and require advanced querying capabilities. It is commonly used in applications like social networks, recommendation engines, and fraud detection systems. Oracle, on the other hand, is more suitable for traditional enterprise applications, such as financial systems and transactional processing.

  6. Cost and Licensing: The cost and licensing models of Neo4j and Oracle can differ significantly. Neo4j offers both community edition and enterprise edition, with different features and support options. Oracle, as a commercial database, often requires a paid license and support agreement. The cost aspect should be considered when making a decision between the two.

In summary, Neo4j and Oracle differ in their data model, query language, scalability, flexibility, use cases, and cost. Choosing between them depends on factors such as data structure complexity, querying requirements, and budget considerations.

Advice on Neo4j and Oracle
Jaime Ramos
Needs advice
on
ArangoDBArangoDBDgraphDgraph
and
Neo4jNeo4j

Hi, I want to create a social network for students, and I was wondering which of these three Oriented Graph DB's would you recommend. I plan to implement machine learning algorithms such as k-means and others to give recommendations and some basic data analyses; also, everything is going to be hosted in the cloud, so I expect the DB to be hosted there. I want the queries to be as fast as possible, and I like good tools to monitor my data. I would appreciate any recommendations or thoughts.

Context:

I released the MVP 6 months ago and got almost 600 users just from my university in Colombia, But now I want to expand it all over my country. I am expecting more or less 20000 users.

See more
Replies (3)
Recommends
on
ArangoDBArangoDB

I have not used the others but I agree, ArangoDB should meet your needs. If you have worked with RDBMS and SQL before Arango will be a easy transition. AQL is simple yet powerful and deployment can be as small or large as you need. I love the fact that for my local development I can run it as docker container as part of my project and for production I can have multiple machines in a cluster. The project is also under active development and with the latest round of funding I feel comfortable that it will be around a while.

See more
David López Felguera
Full Stack Developer at NPAW · | 5 upvotes · 47.1K views
Recommends
on
ArangoDBArangoDB

Hi Jaime. I've worked with Neo4j and ArangoDB for a few years and for me, I prefer to use ArangoDB because its query sintax (AQL) is easier. I've built a network topology with both databases and now ArangoDB is the databases for that network topology. Also, ArangoDB has ArangoML that maybe can help you with your recommendation algorithims.

See more
Recommends
on
ArangoDBArangoDB

Hi Jaime, I work with Arango for about 3 years quite a lot. Before I do some investigation and choose ArangoDB against Neo4j due to multi-type DB, speed, and also clustering (but we do not use it now). Now we have RMDB and Graph working together. As others said, AQL is quite easy, but u can use some of the drivers like Java Spring, that get you to another level.. If you prefer more copy-paste with little rework, perhaps Neo4j can do the job for you, because there is a bigger community around it.. But I have to solve some issues with the ArangoDB community and its also fast. So I will preffere ArangoDB... Btw, there is a super easy Foxx Microservice tool on Arango that can help you solve basic things faster than write down robust BackEnd.

See more
Decisions about Neo4j and Oracle
Daniel Moya
Data Engineer at Dimensigon · | 4 upvotes · 419.4K views

We have chosen Tibero over Oracle because we want to offer a PL/SQL-as-a-Service that the users can deploy in any Cloud without concerns from our website at some standard cost. With Oracle Database, developers would have to worry about what they implement and the related costs of each feature but the licensing model from Tibero is just 1 price and we have all features included, so we don't have to worry and developers using our SQLaaS neither. PostgreSQL would be open source. We have chosen Tibero over Oracle because we want to offer a PL/SQL that you can deploy in any Cloud without concerns. PostgreSQL would be the open source option but we need to offer an SQLaaS with encryption and more enterprise features in the background and best value option we have found, it was Tibero Database for PL/SQL-based applications.

See more

We wanted a JSON datastore that could save the state of our bioinformatics visualizations without destructive normalization. As a leading NoSQL data storage technology, MongoDB has been a perfect fit for our needs. Plus it's open source, and has an enterprise SLA scale-out path, with support of hosted solutions like Atlas. Mongo has been an absolute champ. So much so that SQL and Oracle have begun shipping JSON column types as a new feature for their databases. And when Fast Healthcare Interoperability Resources (FHIR) announced support for JSON, we basically had our FHIR datalake technology.

See more

In the field of bioinformatics, we regularly work with hierarchical and unstructured document data. Unstructured text data from PDFs, image data from radiographs, phylogenetic trees and cladograms, network graphs, streaming ECG data... none of it fits into a traditional SQL database particularly well. As such, we prefer to use document oriented databases.

MongoDB is probably the oldest component in our stack besides Javascript, having been in it for over 5 years. At the time, we were looking for a technology that could simply cache our data visualization state (stored in JSON) in a database as-is without any destructive normalization. MongoDB was the perfect tool; and has been exceeding expectations ever since.

Trivia fact: some of the earliest electronic medical records (EMRs) used a document oriented database called MUMPS as early as the 1960s, prior to the invention of SQL. MUMPS is still in use today in systems like Epic and VistA, and stores upwards of 40% of all medical records at hospitals. So, we saw MongoDB as something as a 21st century version of the MUMPS database.

See more
Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of Neo4j
Pros of Oracle
  • 70
    Cypher – graph query language
  • 61
    Great graphdb
  • 33
    Open source
  • 31
    Rest api
  • 27
    High-Performance Native API
  • 23
    ACID
  • 21
    Easy setup
  • 17
    Great support
  • 11
    Clustering
  • 9
    Hot Backups
  • 8
    Great Web Admin UI
  • 7
    Powerful, flexible data model
  • 7
    Mature
  • 6
    Embeddable
  • 5
    Easy to Use and Model
  • 4
    Best Graphdb
  • 4
    Highly-available
  • 2
    It's awesome, I wanted to try it
  • 2
    Great onboarding process
  • 2
    Great query language and built in data browser
  • 2
    Used by Crunchbase
  • 44
    Reliable
  • 33
    Enterprise
  • 15
    High Availability
  • 5
    Expensive
  • 5
    Hard to maintain
  • 4
    Maintainable
  • 4
    Hard to use
  • 3
    High complexity

Sign up to add or upvote prosMake informed product decisions

Cons of Neo4j
Cons of Oracle
  • 9
    Comparably slow
  • 4
    Can't store a vertex as JSON
  • 1
    Doesn't have a managed cloud service at low cost
  • 14
    Expensive

Sign up to add or upvote consMake informed product decisions

- No public GitHub repository available -

What is Neo4j?

Neo4j stores data in nodes connected by directed, typed relationships with properties on both, also known as a Property Graph. It is a high performance graph store with all the features expected of a mature and robust database, like a friendly query language and ACID transactions.

What is Oracle?

Oracle Database is an RDBMS. An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism is called an object-relational database management system (ORDBMS). Oracle Database has extended the relational model to an object-relational model, making it possible to store complex business models in a relational database.

Need advice about which tool to choose?Ask the StackShare community!

What companies use Neo4j?
What companies use Oracle?
See which teams inside your own company are using Neo4j or Oracle.
Sign up for StackShare EnterpriseLearn More

Sign up to get full access to all the companiesMake informed product decisions

What tools integrate with Neo4j?
What tools integrate with Oracle?

Sign up to get full access to all the tool integrationsMake informed product decisions

Blog Posts

What are some alternatives to Neo4j and Oracle?
Titan
Titan is a scalable graph database optimized for storing and querying graphs containing hundreds of billions of vertices and edges distributed across a multi-machine cluster. Titan is a transactional database that can support thousands of concurrent users executing complex graph traversals in real time.
MongoDB
MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
Cassandra
Partitioning means that Cassandra can distribute your data across multiple machines in an application-transparent matter. Cassandra will automatically repartition as machines are added and removed from the cluster. Row store means that like relational databases, Cassandra organizes data by rows and columns. The Cassandra Query Language (CQL) is a close relative of SQL.
OrientDB
It is an open source NoSQL database management system written in Java. It is a Multi-model database, supporting graph, document, key/value, and object models, but the relationships are managed as in graph databases with direct connections between records.
JanusGraph
It is a scalable graph database optimized for storing and querying graphs containing hundreds of billions of vertices and edges distributed across a multi-machine cluster. It is a transactional database that can support thousands of concurrent users executing complex graph traversals in real time.
See all alternatives