advertise
« The technology behind Tornado, FriendFeed's web server | Main | How to handle so many socket connection »
Thursday
Sep102009

Building Scalable Databases: Denormalization, the NoSQL Movement and Digg

Database normalization is a technique for designing relational database schemas that ensures that the data is optimal for ad-hoc querying and that modifications such as deletion or insertion of data does not lead to data inconsistency. Database denormalization is the process of optimizing your database for reads by creating redundant data. A consequence of denormalization is that insertions or deletions could cause data inconsistency if not uniformly applied to all redundant copies of the data within the database.

Read more on Carnage4life blog...

Reader Comments (2)

November 29, 1990 | Unregistered CommenterGridwiseTech

We use rdbms for most things, but we have the databases broken out by application and then have a central tool for updating the sub-systems. I imagine we're only going to continue in this direction for a while and just add more caching to the front of each section. So far that has often helped us scale the best.

Personally I'm looking forward to doing more caching/tuning not to mention process tiering in order to make things even faster. Also hoping to find ways to get even better performance from our rdbms. We already tune them pretty well.

---------------------------------------------------------------
http://blog.pe-ell.net http://wetnun.net

November 29, 1990 | Unregistered Commenterjstephens

PostPost a New Comment

Enter your information below to add a new comment.
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>