quote:Very nice article. We should all know these rules, but more importantly the database vendors should keep them in mind whenever they build something.
quote:Here is a paper that discusses in more detail the Codd's twelve rules and how "the big three" DBMS-s are following them:http://www.handels.gu.se/epc/archive/00002948/01/Nr18_MIB.pdf
quote:1. Parameter strings2. xml3. Delimited lists4. Integers that are interpreted via bit-wise operators for multiple boolean values.
quote:Are there any justifications for these practices?
quote:But I think you're mistakenly mixing data atomicity into Codd's Information Rule. I didn't check your sources, but decomposition is a function of schema design (first normal form) and not something which can or should be enforced by a DBMS.
quote:An RDBMS can be designed to support one of Codd's rules, but it doesn't necessarily prevent one from ignorantly breaking that rule; e.g. one can also create a table without a primary key in SQL Server, so the database is therefore not relational, but that cannot be blamed on SQL Server.
quote:Ok article, not sure what I got from it though Codd and co had his day, and the pioneer work done in and around this era was revolutionary, but dont see how this improves/build/differentiates me into the future, or perhaps even, provides an interest outside of Uni..