Ask a Question
or
Create a Poll
  1. Home /
  2. Questions /
  3. Computers
  4. / Computer Software
  5. / Database Software
  6. / MySQL Database

by Charalambos Mattheou on April 8th, 2004

Charalambos Mattheou

Question

Help answer this question below.

To what extent does MySQL meet Cood's Rules?

  • Like
  • Report
Share:
Other

Answers. 2 helpful answers below.

  • by Jon the human on July 25th, 2007

    Jon the human

    Boyce-Codd Normal Form (BCNF) is a technique used for normalizing a database structure. MySQL provides all the tools necessary to structure your data to follow these rules.

    I have to disagree with slevin01 - 3rd normal form is how most good database designs start. However, it does run into issues with scalability and performance that cause it to become less usable over time. For instance, storing an aggregate value (such as the rating of an answer) instead of calculating it every time is a good example. There are always drawbacks and advantages to this approach, such as the answer aggregate rating can be incorrect, whereas in the BCNF form it will always be accurate, as long as the query is written correctly.

    Ultimately you'll have to pick a design that works for you. Experience will show you what techniques work and which ones will not. The example I gave above is one that we must apply on answerbag in order to deliver our pages as quickly as possible.

    for more info, the wikipedia entry: http://en.wikipedia.org/wiki/Boyce-Codd_normal_form

    • Like
    • Report

    No comments. Post one | Permalink

  • by slevin01 on April 19th, 2007

    slevin01

    Cood's Rules are fairly outdated now since most databases are not purely relational anymore, and most of them such as Oracle and SQL server have internal or direct calls that are not pure SQL.

    No comments. Post one | Permalink

Want to attach an image to your answer? Click here.

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

You're reading To what extent does MySQL meet Cood's Rules?

Follow us on Facebook!

Related Ads

Related Questions

Professionally Researched

ANSWERBAG BUZZ

Cood rule
To what degree mysql follow codd s rule
Cood rule mysql
Bcnf mysql
How many cood rules does mysql follow

Answerbag

a Demand Media company