Questions tagged [graph-databases]
37 questions
33
votes
1 answer
When should you use a document vs relational vs graph database?
For the purposes of discussion let's consider a FourSquare scenario.
Scenario
Entities:
Users
Places
Relationships:
Checkins: users <-> places, many to many
Friends: users <-> users, many to many
Database Design
These will most likely have…

wting
- 1,034
- 2
- 9
- 12
20
votes
3 answers
Why would I use ElasticSearch if I already use a graph database?
I don't find any deep explanation on the web about a comparison between ElasticSearch and the graph databases.
Both are optimized to traverse data.
ElasticSearch seems to be optimized for analytics.
However Neo4j is also based on Lucene to manage…

Mik378
- 3,838
- 7
- 33
- 60
11
votes
1 answer
Algorithm to generate Edges and Vertexes outwards from origin with max multiplicity of 3
I am creating a 2d game for a website where the universe can grow extremely large (basically infinitely large). Initially, the universe is composed of 6 stars that are an equal distance from the origin (0, 0). My task is to be able to generate more…

John F.
- 111
- 4
10
votes
7 answers
Nested Entities and calculation on leaf entity property - SQL or NoSQL approach
I am working on a hobby project called Menu/Recipe Management.
This is how my entities and their relations look like.
A Nutrient has properties Code and Value
An Ingredient has a collection of Nutrients
A Recipe has a Collection of Ingredients and…

Chandu
- 203
- 1
- 6
9
votes
2 answers
How Graph DB stores the data?
Recently read couple of Graph DB tutorials. Most of them tell what is Graph DB/when to use/fetch syntax but no where found high level description
how GraphDB stores the data internally to understand it better.
Coming from java background, I think…

user3198603
- 1,896
- 2
- 16
- 21
5
votes
2 answers
Is there something "dirty" about using a non-linear store in Event Sourcing?
I just stumbled upon an article by Lucas Majerowicz titled "Add git-like functionality to your application using Event Sourcing".
In it, he describes using Event Sourcing with events stored as nodes in a graph database (he uses Neo4j). In so doing,…

eggyal
- 189
- 6
5
votes
0 answers
Graph Database, Storing Transactions
I'm working on getting a handle on Graph Databases (using Neo4j) and am trying to wrap my head around where "the line" is between what makes a good fit for GraphDBs and what should be strictly RDBMSs.
Particularly, I'm looking at a graph model to…

jleach
- 2,632
- 9
- 27
4
votes
0 answers
How do you shard a graph database or graph data?
Imagine I have graph data that is beyond the size of a single machine.
How would you shard a graph database?
I asked on Hacker News and people suggested sharding based on a hash of the predicate-subject-object, ala RDF triples.
I could partition the…

Samuel Squire
- 149
- 3
4
votes
2 answers
How to properly use a database containing common tables in a multi-application system?
I'm trying to determine the best application and database architecture for a project I am working on.
The idea is that there will be multiple, separate applications that will all share a few tables like a User and an Employee table. Each Application…

SegFaultDev
- 109
- 6
4
votes
3 answers
Graph database keeping historical relationships
I'm starting the modeling of the following problem:
I have many clients (millions) that interact in a network forming a graph. At the highest granularity of my business problem, each realationship has 3 attributes.
In the "realistic" worst case…

Henrique Barcelos
- 909
- 1
- 10
- 18
4
votes
3 answers
Relational vs Graph Database for (initially) moderately-sized network
We're developing an application whose data domain (or at least 90% of it) can be modeled effectively using a relational database. We've been using PostgreSQL since the beginning and have had no problems whatsoever. However, now the need arises to…

Tony E. Stark
- 437
- 3
- 5
4
votes
2 answers
How does I/O work for large graph databases?
I should preface this by saying that I'm mostly a front end web developer, trained as a musician, but over the past few years I've been getting more and more into computer science.
So one idea I have as a fun toy project to learn about data…

tjb1982
- 249
- 1
- 7
4
votes
1 answer
What are graph datastores better at doing than other datastores and why?
Where previously there was only relational databases, the data store world is now rife with options like Key-Value, Document, and Graph datastores. Unfortunately, every datastore likes to show how it can be used for anything, but none of them really…

cdeszaq
- 322
- 1
- 13
3
votes
2 answers
In a graph database, how do I know whether to use a node, node property or relationship property?
For example, given node types User and Post, and expressing that a user posted something on Twitter, what factors would I need to consider in deciding between:
(u:User)-[posted]->(p:Post {platform: 'twitter'}),
(u:User)-[posted {platform:…

Isvara
- 610
- 6
- 18
3
votes
1 answer
In what way is an XML database different from (is not specialization of) a graph database?
XML is labelled tree, a special case of graphs. So, why there are separate XML databases and why is it that XML is not stored in graph databases? At a first glance it seems so easy - one should map XML parsing and storing operations to graph…

TomR
- 1,003
- 1
- 9
- 17