Re:A NoSQL Database with ACID Transactions
by jt2190 on Monday March 04, 2013 @10:54AM
(#5318768)
Part of the problem is that people present this as a choice between relational and non-relational models, when the choice is actually about how the database will scale when the data set gets very large.
[ Parent
| on HN ]
Re:A NoSQL Database with ACID Transactions
by obviouslygreen on Monday March 04, 2013 @11:49AM
(#5319047)
You're turning one false dichotomy into... I don't know the word for it, but while how it scales can be part of choosing a database system, it definitely is not the main difference between the relational and noSQL models. How your data storage will scale is an important but tangential topic that should be addressed as complementary to deciding which class of storage will help you most effectively and efficiently model your data.
> ...[database scaling is] definitely is not the main
> difference between the relational and noSQL models.
The post I was responding to strongly implies that one simply has to decide whether they want to use a relational model or not. I contend that framing the question this way is contributing to the misunderstandings of what the advantages and disadvantages of the popular noSQL databases are, which become very apparent when one thinks of what happens when the data set gets very large. Relational databases don't work nearly as well when you have to split the schema across multiple databases, and you can no longer use the database provided transactions or joins.
Re:A NoSQL Database with ACID Transactions
by papsosouid on Monday March 04, 2013 @12:06PM
(#5319140)
Except that virtually everyone can easily have everything in a single, fully normalized relational database on a single server. People have convinced themselves that relational databases can't scale, based on nothing at all.