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:
- Store the persons alias names in a single field, comma separated. This is simple, but makes query-ing difficult.
- 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?