You seem to be asking this question all over the place. From your comment, the system you are considering building as well as the design choices for it are non-trivial. This falls under the field of machine learning and there are several methods used to
decide the answers to these data partitioning questions.
Machine Learning and Artificial Intelligence are my areas of research; I would be happy to discuss these methods with you more in depth.