Problem: I have a $cursor with documents as a “vertical” data source. I need to show this on a sub-table “horizontally”, i.e. to pivot the data.
This is possible with RDBMS, though requires extra querying to process.
What is the MongoDB / document DB equivalent? Or have I modelled completely incorrectly? (First use case…)
Each player has a “round” document, with each hole played as a sub-document. Also, can someone confirm if this model is embedded or linked? Currently,
holes is an array of Objects, so I guess linked? Is this beneficial?
I would like to have a display like most websites or TV coverage, with the players name and score, and a lower table of the full round breakdown per hole.