by Angela Guess
Ilya Katsov recently posted an in depth analysis of NoSQL data modeling techniques. Katsov begins, “First, we should note that SQL and relational model in general were designed a long time ago to interact with the end user. This user-oriented nature had vast implications: (1) End user is often interested in aggregated reporting information, not in separate data items, and SQL pays a lot of attention to this aspect. (2) No one can expect human users to explicitly control concurrency, integrity, consistency, or data types validity. That’s why SQL pays a lot of attention to transactional guaranties, schemas, and referential integrity.”
Katsov continues, “On the other hand, it turned out that software applications are not so often interested in in-database aggregation and able to control, at least in many cases, integrity and validity themselves. Besides this, elimination of these features had extremely important influence on performance and scalability of the stores. And this was where a new evolution of data models began.”
photo credit: Ilya Katsov
