Please answer the short prompt regarding database storage solutions and structure. Which data storage solution is best?
You've just been brought into a company that's looking at how decisions are ultimately made by a Hollywood studio regarding casting. You have been asked to collect and store a wide variety of data in order to better understand how and when various actors, directors, producers, and agents have worked together in the past. For example, it's worth noting things like when a collection of actors worked together on a three year TV project. Or, which agents have represented which actors over the years. While what you may uncover and what patterns may emerge is unclear, what's evident is that you need a way to record and delve into the complex relationships between people in a variety of situations.
What type of data storage solution would you recommend and why?
For simplicity's sake, please limit suggestions to the concepts of:
Unstructured (or lightly structured) Data Lake Storage, Key-Value Store, Column Store, Document Store, Graph Database, Relational Database designed for OLTP, or Relational Database designed to serve as a Data Warehouse.