English 中文(简体)
How would a "NOSQL" database be designed for consumer apps (e.g. social bookmarking) [closed]
原标题:

I ve been reading up on a lot of posts about non-relational databases, the whole NOSQL movement, and there s a lot of fresh new activity around it. It seems like a very interesting approach to building highly scalable web applications but unfortunately (but also a good thing at this nascent stage) there isn t quite a clear leader/standard at the moment.

My background is in the LAMP stack (with MySQL as the dB) and I wanted to understand what differences and limitations there would be - but with using the example of real life web applications out there. There s a ton of good articles about the theory of pros/cons of RDBMS vs non-RDBMS, but I haven t found anything that walks through an example of how an existing web app (for example social bookmarking) would be built different to take advantage of the new dB structure and what features one would have to leave out if any - where the NOSQL dB could be key-value or document-centric or graphs.

Would anyone be willing to take a stab at a high-level comparison of a NOSQL vs RDBMS model/architecture of a real-world web app (such as social bookmarking or any other example that might explain the concepts well)?

For reference to others, here are a few of the articles I have come across:

问题回答

The main reason is scale (Facebook, MySpace)

Check out these articles:

Facebook s Cassandra - A Massive Distributed Store

MySpace Qizmt - MySpace s Mapreduce Framework

As you are already using Lucene, this may be of interest:

Katta - Lucene in the cloud





相关问题
Can an attribute designate one table over another?

I m creating a sports statistics database. With it, I d like to catalog game/match statistics for many types of sports. For example, this database would be able to tell you how many touchdowns the ...

Relational Data to Flat File

I hope you can help find an answer to a problem that will become a recurring theme at work. This involves denormalising data from RDBMS tables to flat file formats with repeating groups (sharing ...

questions and answers with multiple answers

This question is related to this post: SQL design for survey with answers of different data types I have a survey app where most questions have a set of answers that are 1-5. Now we have to do ...

MySQL: Has anyone used the TokuDB storage engine?

Has anyone used the TokuDB storage engine for MySQL? The product web site claims to have a 50x performance increase over other MySQL storage engines (e.g. Innodb, MyISAM, etc). Here are the ...

How to best implement a 1:1 relationship in a RDBMS?

Yesterday while working on a project I came up on a peculiar 1:1 relationship which left me wondering - how to best implement this (clearly, we had done it wrong :D) The idea is that there are two ...

热门标签