3 ms·
I've never heard this called "refinement" before. The term I've always used was normalization[0]. I'm rather surprised that there is no mention of normalization
by moron4hire 12y ago
I've never heard this called "refinement" before. The term I've always used was normalization[0]. I'm rather surprised that there is no mention of normalization at all in the article. There are several "normal forms" that are quite well known and understood in relational databases.
Also, I've never heard this called "functional dependencies". The term I've always used is "relational algebra"[1]. For lay-people, the set-theory notation might be a bit off-putting, but take the time to learn the language and the concepts become a lot more intuitive.
[0] http://en.wikipedia.org/wiki/Database_normalization http://en.wikipedia.org/wiki/Database_normalization
[1] http://en.wikipedia.org/wiki/Relational_algebra http://en.wikipedia.org/wiki/Relational_algebra
- peterfirefly 12y agoC.J. Date uses the term "functional dependencies" in the section about various normal forms (at least he did in the second edition of "Introduction to Database Systems" from 1977). In fact, they are part of the definition of some of the normal forms.
- moron4hire 12y agoI guess my point is that it's just a little weird to see a discussion of relational algebra without actually using the word "relational algebra".
- CHY872 12y agoThe relational algebra and functional dependencies are different. The relational algebra is a number of operations that together provide a theoretical foundation to relational databases, whilst functional dependencies describe how data depends on other data. They're not in any sense the same term. Strictly speaking, you're only talking about the relational algebra if you're talking about what the page you mentioned is talking about. Schema refinement is also a known term; normalisation refers to refining a schema into a normal form; it is possible to refine a schema without deliberately reducing it to such a thing (although if you've produced a database that's not in 1NF, kudos!). Like you, I'm surprised that it's not mentioned, although I'm also not convinced that it needs to be mentioned. Normal forms just refer to what redundancies are avoided, and in practice all you care about is whether the redundancy is hindering you. Blindly normalising is a great cargo-cultish way to end up with an underperforming database.