11

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?

Improve this question
4
  • 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). Commented Apr 27, 2012 at 10:33
  • 5
    not constructive question .... viewed +1K times....congrats to moderators as usual Commented Oct 24, 2012 at 10:16
  • Since when does the number of views correlate to whether a question is constructive or not? Commented Oct 24, 2012 at 10:46
  • 6
    I came here as i needed this information. Guess a lot of the the 2k+ users came for a similar reason.. Commented May 11, 2013 at 14:44

2 Answers 2

Reset to default
16

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.

Improve this answer
1
  • Just to mention another excellent video on the same website, a speech given by Martin Fowler: youtube.com/watch?v=qI_g07C_Q5I Commented Aug 14, 2014 at 19:36
15

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.

Improve this answer
2
  • 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 ? Commented Dec 31, 2014 at 16:35
  • When a say no schema, I mean no traditional relational schema, which uses columns and rows to represent everything. Commented Jan 2, 2015 at 15:00

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.