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
Last activity: Jul 24, 2020, 07:05 PM