# Graph Data Modeling Question **URL:** \ **Category:** Modeling\ **Tags:** performance, neo4j-desktop, modeling, data-modeling\ **Created:** [December 17, 2020, 7:08am UTC](https://community.neo4j.com/t/graph-data-modeling-question/30522 "2020-12-17T07:08:28Z")\ **Posts on this page:** 1\ **Showing post:** 3
**Author:** ![TonyOD27](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/tonyod27/32/5200_2.png) [@TonyOD27](https://community.neo4j.com/u/TonyOD27)\ **Post date:** [December 19, 2020, 2:46am UTC](https://community.neo4j.com/t/graph-data-modeling-question/30522/3 "2020-12-19T02:46:38Z")
Hi Senthil, Thank you for your advice. You're right in that we have a densely connected node on A\_Law and Person, and quite frankly, I don't know what to do that about that. These articles I found seem promising in helping with these super node issues. I'll give these a shot: > **[Graph Modeling: All About Super Nodes](https://medium.com/neo4j/graph-modeling-all-about-super-nodes-d6ad7e11015b)** > > This article is the latest in a series on advanced graph modeling techniques; the other articles in the series deal with keys… > **[How to avoid costly traversals with join hints - Knowledge Base](https://neo4j.com/developer/kb/how-to-avoid-costly-traversals-with-join-hints/)** > > When matching a pattern using Cypher, the number of possible paths to evaluate often correlates with query execution time. When there is a supernode in the path (a node with… Still, we must have that A\_Access connection there with all 500,000,000 relationships as this is giving my team important insights as to how the Person nodes can access the A\_Law node. Otherwise, this Neo4j effort is going to fail because we can't have queries taking hours to finish. Here are my answers: > [@senthilc78](#): > > 1. What is the query you are trying to get from here - Any Data Model - Best way to design based on the Buesiness Question you are trying to do For example, let's say we want to count the number of A\_Law's being used by a person in the sales department. Then that query will be: ```auto MATCH(p:Person {dept: 'sales'})-[:A_Access]->(a:A_Law) RETURN COUNT(DISTINCT a.title) ``` This query alone takes about 20 minutes to finish. Additionally, this query forms part of a bigger query that we use to answer more complex business questions and this is causing the bigger queries to take more than an hour to finish. > [@senthilc78](#): > > 1. From your Business need, I understand you need to have unique relations for each node. This leads to me to think -unique ID for each person right? so better to have this as property in my the Node itself - instead of relations which actually reduces all these millions of paths Yes, there are unique ID's for each person. We loaded this graph using the neo4j-admin import tool which forced us to use unique id's on the nodes. > [@senthilc78](#): > > 1. Validate when we can turn property to Node or Node to Property- Based on whats your Business question Agreed. We discussed this internally at length to all agree on the Node entities and properties based on the business questions we wanted to answer. We iterated through this as well to arrive at a working data model. Querying all of the other relationships outside of the A\_Access relationship actually perform really well, within seconds actually. > [@senthilc78](#): > > When we have dense node- connecting millions of relations...best approach wud be having relations by Month or category . (Fan\_out technique) > Examples like > Orders -[:ORDER]-\> Product to Orders-[: ORDER\_JAN|ORDER\_FEB...]-\>(:Product) This is a good point. I guess I could shuffle some of the properties from A\_Rel into A\_Access to further segregate the relationships that we need, but I still think we're going to end up with 500,000,000. It would also be useful if I could place an index on these relationship properties for faster look up but I don't think that's supported yet as shown in the docs or this thread: > **[Indexes for search performance - Cypher Manual](https://neo4j.com/docs/cypher-manual/current/indexes-for-search-performance/)** > > This section explains how to manage indexes used for search performance. > [@How can i use index in relationship?](https://community.neo4j.com/t/how-can-i-use-index-in-relationship/1627/6): > > No, not currently. We would advise refactoring your model such that nodes have the relevant numerical or date properties, and add an index on them instead. Or do I need more memory on my Neo4j instance? I thought having 24G in heap would be more than plenty for a graph database this size, no? Thanks --- _[View the full topic](https://community.neo4j.com/t/graph-data-modeling-question/30522)._