The entire noSQL family of servers is based on relaxing the reliability constraints of the classic ACID protections that SQL databases provided.
Posted Feb 8, 2012 15:00 UTC (Wed) by Wol
In reply to: The entire noSQL family of servers is based on relaxing the reliability constraints of the classic ACID protections that SQL databases provided.
Parent article: XFS: the filesystem of the future?
Well, the relational algebra does not discuss storage at all, and does not stipulate where relations might reside on permanent storage
Which is exactly my beef with relational databases. C&D FORBID you from telling the database where relations should be stored for efficiency. But in REALITY it is highly probable that, if you access one attributed associated with my primary key, that you will want to access others. But it's a complete gamble retrieving the same attribute associated with other primary keys. Because Pick guarantees (by accident, admittedly) that all attributes are stored in the same atom as the primary key they describe, all those attributes you are statistically most likely to want are exactly the attributes that coincidentally get retrieved together.
to post comments)