0

I am working on implementing a feature similar to "related questions" feature of SO.I want to suggest the most matching questions for few of the tags like C,C++. Is it more preferable to use a NoSQL DB like MongoDB for this kind of project if I want good performance or should I stick with the traditional relational DBs like MySQL.

I have seen some similar questions but not exactly what I am looking for - What is the SQL used to do a search similar to "Related Questions" on Stackoverflow

Community
  • 1
  • 1
code4fun
  • 2,661
  • 9
  • 25
  • 39

1 Answers1

0

A litte more information would help giving you directions. What data volume do you expect? How many concurrent users will query the database? Do you plan to store all the questions in the database or just relate to them by ID:s?

Also, any requirements for environment? Java, .NET or other?

If you aim for a relation implementation between tags and questions/topics I would go for an object oriented database with some easy to use query langage. Like:

public class Question
{
   String QuestionsText;
}

public class Tag
{
   String Tag;
}

public class TagPerQuestion
{
    Tag ConnectedTag;
    Question ConnectedQuestion;
}

Then you could very easily query all Questions with similar Tag using TagPerQuestion. It would be clean and easy. This implementation could be done easily in Starcounter (.NET), VoltDB (Linux).

If your number of items are not extreme and number of simultanius users are low, you could use a traditional database like MySQL as well and replace the classes with tables instead.

Niklas Bjorkman
  • 678
  • 5
  • 8
  • thanks Niklas.My number of concurrent users is very low but the number of items is goona be huge as I am trying to store the complete data of all the questions. – code4fun Apr 16 '13 at 05:37