I want to feed an HTML5 data grid with large data sets that the client will want to manipulate in different ways, e.g. aggregation, grouping, pivoting.
The data comes from different web services and the client will be carrying out transactional operations on it.
The data grid will contain various controls for manipulating the data and will fire off requests to the server for many of them when it can't do it itself.
I envisage some sort of flattened data structure cached in the MVC layer which maintains different views on the same data. It would feed out the requested data through a pagination control to the data grid.
Presumably this has been done before in many places. Is there a design pattern to follow? Is there an open-source implementation?
icanhazpatternzquestion, and they reached into their Gang of Four book to answer it. For what it's worth, 3rd party companies like Telerik have built grids just like this. It's a non-trivial task to do well.