I am a novice in database administration and have a design question.

My use-case is storing data annotations(data labels) for Machine Learning, which can run into hundreds of thousands for each client. I will also need to query based on information within those annotations.

Would I be better off using a NoSQL database like MongoDB, or a relational one like PostgreSQL, where I can save each annotation as a json? In case of a relational database, would it make sense to save each client's annotations in separate tables?

PS - I also need to store other data that is usually stored in relational databases, like users, tasks etc.

  • When you say "labels", what are these attached to exactly? Just a client with a lot of binary flags, or some entity belonging to a client?
    – bbaird
    Jan 26 at 14:28

Browse other questions tagged or ask your own question.