Monday, May 28, 2012

NoSQL Data Modeling Techniques



NoSQL databases are often compared by various non-functional criteria, such as scalability, performance, and consistency. This aspect of NoSQL is well-studied both in practice and theory because specific non-functional properties are often the main justification for NoSQL usage and fundamental results on distributed systems like the CAP theorem apply well to NoSQL systems. At the same time, NoSQL data modeling is not so well studied and lacks the systematic theory found in relational databases. In this article I provide a short comparison of NoSQL system families from the data modeling point of view and digest several common modeling techniques.


I would like to thank Daniel Kirkdorffer who reviewed the article and cleaned up the grammar.


To explore data modeling techniques, we have to start with a more or less systematic view of NoSQL data models that preferably reveals trends and interconnections. The following figure depicts imaginary “evolution” of the major NoSQL system families, namely, Key-Value stores, BigTable-style databases, Document databases, Full Text Search Engines, and Graph databases: Good post and discussion of nosql design.

8 Rules For Creating A Passionate Work Culture


Several years ago I was in the Thomson Building in Toronto. I went down the hall to the small kitchen to get myself a cup of coffee. Ken Thomson was there, making himself some instant soup. At the time, he was the ninth-richest man in the world, worth approximately $19.6 billion. Enough, certainly, to afford a nice lunch. I looked at the soup he was stirring. “It suits me just fine,” he said, smiling.
Thomson understood value. Neighbors reported seeing him leave his local grocery store with jumbo packages of tissues that were on sale. He bought off-the-rack suits and had his old shoes resoled. Yet he had no difficulty paying almost $76 million for a painting (for Peter Paul Rubens’s Massacre of the Innocents, in 2002). He sought value, whether it was in business, art, or groceries. Please read more here