I’ve to design a system in which different datasets are added periodically to the system and user should be able to perform several predefined set of operations on the data. Datasets are large enough so it makes sense to keep them in separate tables/databases for performance reasons.
The problem I’m facing is that how does it fit into rails ActiveRecord architecture. Do I generate new Models for newly generated tables every time a new dataset is added? Suppose even if i’m able to somehow do that, I still need to provide a generic interface for all datasets. I’m not sure what the architecture should look like while following the rails conventions? Also it is preferable to add new datasets without having to worry about changing the code.
Any kind of help will be appreciated