none
How many Codd's rules are followed by latest version of sql server?

    Question

  • i wanted to know how many codd's database rules are followed by latest sql server version coz i am in the process of making a dbms that follows all 12 of them.

    Please help

     

    Sunday, July 18, 2010 3:30 PM

Answers

All replies

  • I usually going till third normal form normalization if you did mean that
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, July 19, 2010 9:01 AM
    Moderator
  • The following thread deals with the same topic. Let us know if helpful.

    http://social.msdn.microsoft.com/Forums/en-US/sqldocumentation/thread/5e2bebff-886b-4c65-89d9-01bed19067f3


    Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM
    Monday, July 19, 2010 9:32 AM
    Moderator
  • I think he is talking about the twelve rules that Codd presented (I think) in the paper "Providing OLAP (on-line analytical processing) to user-analysts: An IT mandate" (It can be found through google)

    the twelve rules are

    OLAP Product Evaluation Rules
    The twelve rules for evaluating OLAP products are:
    1. Multidimensional Conceptual View
    2. Transparency
    3. Accessibility
    4. Consistent Reporting Performance
    5. Client-Server Architecture
    6. Generic Dimensionality
    7. Dynamic Sparse Matrix Handling
    8. Multi-User Support
    9. Unrestricted Cross-dimensional Operations
    10. Intuitive Data Manipulation
    11. Flexible Reporting
    12. Unlimited Dimensions and Aggregation Levels

     

    I think the question would be easier to answer if Mr. Chaturvedi could lay out what he think is missing in earlier versions.

     

    //kind regards

    Monday, July 19, 2010 9:36 AM
  • Vinay, do really mean Codd's rules or do you actually mean normalization rules? They are different.

    Codd's rules are about the RDBMS features. I'm sure we, the developers, do not build our RDBMS products! Although, we can use (and are using) the existing products like SQL Server and hope that the vendor complies to all of the Codd's rules. Many think that none of the current RDBMS products are fully compliant.
    http://en.wikipedia.org/wiki/Codd%27s_rules

    Normalization is a database design concept independent of the RDBMS product. As a designer, you can design your tables and relationships to comply to the Normal Forms to minimize redundancy and inconsistency. You might like the External Links on the following Wikipedia page.
    http://en.wikipedia.org/wiki/Database_normalization


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers.
    Thanks!
    Aalam | Blog (http://aalamrangi.wordpress.com)

    Saturday, December 29, 2012 1:21 PM
  • >Many think that none of the current RDBMS products are fully compliant.

    Affirmative. Also Codd rules do not deal with indexing, which is a major part of today's database development extending to XML indexing, Full-text indexing, ColumnStore indexing and more.


    Kalman Toth SQL 2008 GRAND SLAM
    New Book: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012

    Saturday, December 29, 2012 3:12 PM
    Moderator