Sample Header Ad - 728x90

How to deal with a person that may have multiple alias names?

1 vote
2 answers
1828 views
I am designing a neo4j database which will be primarily be used to store information about people. One of the requirements is that it must be able to store an alias name of a person. I'm having trouble deciding how I should design my database so that it deals with people that have multiple aliases? I have two solutions: 1. Store the persons alias names in a single field, comma separated. This is simple, but makes query-ing difficult. 2. Store a persons alias name in a separate table/entity called alias. This seems to be overly-complex but makes querying easier than option 1. Which of these, if any, is the correct answer to the problem? Or alternatively, is there a better solution which I am overlooking?
Asked by JavascriptLoser (139 rep)
Jul 11, 2018, 02:56 AM
Last activity: Jul 24, 2020, 07:05 PM