Index Desing for IMDb Dataset

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.


This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.