Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Scenario: Think you have got 100TB of text in 200 tables. This is structured related data. compareable to dbpedia only more data. Any really relational and distributed and performant database would do the job. Don’t expect as many updates as a social network but about 500read queries/s 20updates/s But main feature required besides those is running big analyses on the database in high speed since the data shall be reworked and improved with machine learning like apache mahout constantly.

Now the first issue is, which database technologies to start with (or to wait for them beeing relased) to first maintain all that data with a relativly low amount of webvisitors but a high demand on analysis/machine learning running fast? And second, which other databases to keep track of for special particular purposes that may occure and which to drop off the list or to put in pairs of which only one(/the better) should be applyed.

  • Cloudera/Brisk (Cassandra,Hive)
  • mysql(cluster), mariadb
  • Berkeley DB
  • drizzle, nimbusdb,
  • scidb (http://www.theregister.co.uk/2010/09/13/michael_stonebraker_interview/)
  • mongodb
  • datadraw
  • neo4j
share|improve this question
This seems to me to be the epitome of Chatty, open-ended questions diminish the usefulness from the FAQ –  Patrick Apr 23 '11 at 16:50
Hi Jonas, welcome to the site. I'ld like to reinforce what Patrick has to say and I'ld like to ask that we restrict the questions to real-world scenarios that have reasonably decisive answers. Questions which focus on "in a dream world, what would you do" can't really thrive in a "Q&A" world. If this were an academic question (which it has the hints of being) then I think a further focus on the specifics of database design that you were trying to hammer out would be great. But this question is too "chatty" as Patrick pointed out. How can we help you reshape it? –  jcolebrand Apr 23 '11 at 21:59
This almost seems like a topic for Quora and not StackExchange. –  RobPaller Apr 24 '11 at 4:48
I agree with others who think this is not for here... but also want to ask... why aren't you considering PostgreSQL –  xenoterracide Apr 25 '11 at 8:32
Based on consensus amongst the mods, and based on this question being cross posted on stackoverflow and getting not much more traction there, and given that the user Jonas does not seem to want to contribute to SE, nor to be involved on his own question, and since the community wants to see this question gone, I hereby mark it as closed. –  jcolebrand Apr 27 '11 at 14:38
add comment

closed as not a real question by Gaius, jcolebrand Apr 27 '11 at 14:38

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.