We are working on building search solution using IMDb dataset, where we are writing some aggregation queries like how many time cast X worked with crew Y.
##My question here is,
What would be the good index model to support aggregate queries? Would the flat structure is a good option or the embedded structure (movie having Cast and crew in it) would be the right option to have the aggregate queries.
Thanks