I would like to learn something more about NoSQL databases, so I've chosen to create a new project from scratch to handle football results. In my traditional relational database, I have tournaments, teams, results and class tables. All are obviously related.

What might be a good approach for designing a project like this, using a NoSQL approach instead?

closed as not constructive by Oded, gnat, Jarrod Roberson, Karl Bielefeldt, ChrisF Apr 28 '12 at 10:55

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 4
    Which type of NOSQL database? I suggest you read up a bit on the different types before asking this question. Some are schemaless, and some are just key-value databases (and a whole range between the two). – Oded Apr 27 '12 at 10:33
  • 4
    not constructive question .... viewed +1K times....congrats to moderators as usual – Cris Oct 24 '12 at 10:16
  • Since when does the number of views correlate to whether a question is constructive or not? – Oded Oct 24 '12 at 10:46
  • 5
    I came here as i needed this information. Guess a lot of the the 2k+ users came for a similar reason.. – DMin May 11 '13 at 14:44

Use the right tool for a particular job. By asking this, it's clear you don't know when NoSQL is appropriate for data storage. A lot of people are using NoSQL just because it is the "thing of the moment". Usually NoSQL databases have no schema and should be used when the data is better represented by its model. You should not use a NoSQL database to store data that is typically relational; a relational database should be used in that case. I know that when there is a need to scale the application to be capable of handling millions of transactions then NoSQL model works better (even when the data is relational), but I think that is not your case.

  • When you say there is no schema @nohros, do you mean NoSQL is basically just key:value system ? ie { key1: value1, key2: value2, ... } ? Or can there be some more complicated schemas in NoSQL ? – Basj Dec 31 '14 at 16:35
  • When a say no schema, I mean no traditional relational schema, which uses columns and rows to represent everything. – nohros Jan 2 '15 at 15:00

First, there are clearly defined use cases for using NoSQL over a traditionnal RDBMS. Make sure your system meets one or more of these criteria before jumping into NoSQL, or else you could run into problems.

This youtube video has been a real eye-opener for me. It is about MongoDB and data modeling. You can read more about MongoDB on their website.

Not the answer you're looking for? Browse other questions tagged or ask your own question.