6
votes
In what way is an XML database different from (is not specialization of) a graph database?
The terms XML database and graph database describe the use cases of each kind of database. The XML database is intended to store and search XML documents. Graph databases is intended to represent a ...
- 9,247
5
votes
Should I store large amounts of data in the properties of a node in a graph database?
I am not a Neo4J expert, but I can tell you how I would approach such an assessment:
Ask in a place where you find other Neo4j users and experts: the Neo4J community site looks good for me: https://...
- 221k
5
votes
Designing a graph database structure for an application with a large amount of connections
tl;dr: Use an RDBMS, as there's nothing in the problem statement to motivate neo4j or similar graph databases.
primary key
You said you have 40,000 rows in world_fact,
things that are immutably and ...
- 7,997
4
votes
Accepted
Is there something "dirty" about using a non-linear store in Event Sourcing?
Actually branches are reasonably common.
Look at EventStore and the event type $linkTo this is a use case for it! Basically you can have many steams linking back to an event in different ways/orders....
- 166
3
votes
Is there something "dirty" about using a non-linear store in Event Sourcing?
I think your gut feel is right.
Consider rebuilding the object in such a tree. when you come to a branch which one do you take? What about snapshotting to reduce disk space?
I'm going to go out on ...
- 84.6k
2
votes
Relational vs Graph Database for (initially) moderately-sized network
PostgreSQL scales wonderfully under the right conditions:
Digital Globe really does handle 1 billion transactions at least hourly on their database with PGGIS to boot
Verizon uses PostgreSQL as a data ...
- 197
2
votes
Accepted
How to model a ternary relationship in a graph-based paradigm?
Since you specifically state that you are looking for a solution from the graph DB point of view, I will assume that what you are talking about specifically would be a Labelled Property Graph (LPG). (...
- 160
2
votes
Accepted
Solution design leveraging Graph and Relational database types
A graph DB and a relational DB can represent the same data:
a tables is a set of relations between values of each columns in a row, that could be represented as nodes and edges of a (big) graph. A ...
- 82.3k
2
votes
How does a database update trigger a notification to application layer?
My first comment is that integrating through a database is an anti-pattern. You should strongly consider a different approach.
https://www.ben-morris.com/a-shared-database-is-still-an-anti-pattern-no-...
- 311
2
votes
Does it make sense to use a graph database (Neo4j) for a diagramming app?
If your diagrams somehow represent graphs (nodes and edges) there is indeed a natural match for the mapping of your database. Graph database also offer flexibility when you need to associate more ...
- 82.3k
2
votes
How to properly use a database containing common tables in a multi-application system?
I'm seeing a need for common tables, which then has exploded into multiple databases. This would concern me.
Separating the application tier into multiple applications can be a good place to start, ...
- 46.6k
2
votes
Accepted
How to properly use a database containing common tables in a multi-application system?
I like option 1. Your apps are then ignorant of their underlying persistence schema and the persistence management is done by the API (or layers below/within).
A common route would be your #1 option,...
- 2,692
1
vote
Accepted
In a graph database, how do I know whether to use a node, node property or relationship property?
Some things to think of are what your use case is and what the most likely queries will be. Depending on your graph, and I don't know specifically about neo4j, attributes on nodes and edges may create ...
- 377
1
vote
Neo4j graph performance: should I cache slow queries in a separate database?
I know this is a little more than half a year old, but thought I might share an answer just in case. I don't have a specific answer for this problem, but I can share my use case and personal solution ...
Only top scored, non community-wiki answers of a minimum length are eligible