News for hackers. Stuff that matters.
Re:Now that people are considering NOSQL will more people co... by artsrc on Wednesday August 31, 2011 @09:27PM (#2948285)
You loose some features of SQL when you have historical values.

For example if you only want customers to create orders you can set a foreign key between customer and order. If you don't delete orders and customers, then the database will allow you to insert new orders against old customers, unless you apply a more complex constraint.

Re:Now that people are considering NOSQL will more people co... by kfool on Wednesday August 31, 2011 @09:38PM (#2948308)
This can be handled by deleting orders from the logical representation, yet preserving them in the historical layer.