cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.

How would you store contacts to find similar contacts between two Users?

geronimo4j
Graph Buddy

I currently have User nodes that each just represent a single user.

I'd like to store Contacts that have a relationship to other users so I can find Users that share common contacts.

Say I have someone in my contact list Johnny Appleseed and he's not yet a member of my app. I want to be able to return that Johnny Appleseed has 150 contacts already on Clubhouse. Basically it would know:

John Smith -[:HAS_CONTACT]-> Johnny Appleseed
Jane Smith -[:HAS_CONTACT]-> Johnny Appleseed
Joe Smith -[:HAS_CONTACT]-> Johnny Appleseed
etc.

I was thinking it may make sense to create a Node for each Contact, but then I was thinking that would require every user to have the name of the user the same. Is it better to do it like this?:

John Smith -[:HAS_CONTACT]-> Johnny Appleseed-[:HAS_PHONENUMBER]->1235557890
Jane Smith -[:HAS_CONTACT]-> J Appleseed-[:HAS_PHONENUMBER]->1235557890
Joe Smith -[:HAS_CONTACT]-> John A-[:HAS_PHONENUMBER]->1235557890

If I do it this way I could find how many Users have contacts who share the same phone number? And do it by phone number instead of Contact? Does that make sense? Is there a better way to store contacts such that I could see similar counts? Like the example above would have "Johnny Appleseed has 3 friends already on the app"

0 REPLIES 0