Дзюндзя ([info]syarzhuk) wrote,
@ 2004-04-16 21:36:00
Previous Entry  Add to memories!  Tell a Friend!  Next Entry
Heh
Joel Spolsky: ...the development version of CityDesk has been using a new, smaller database schema (it's mostly the same as the old schema but with some redundancies removed to make it better normalized)
Last time I checked, a database schema with redundancies could not ever be called normalized

(Post a new comment)


[info]ilyavinarsky
2004-04-16 06:40 pm UTC (link)
There are several normal forms. Also, some schemata may be denormalized for performance reasons.

(Reply to this) (Thread)

[info]rydel23
2004-04-17 08:31 am UTC (link)
So you will call a DB normalized if it's only in 1NF, let's say, but not in 2NF, 3NF...

(Reply to this) (Parent)(Thread)

[info]syarzhuk
2004-04-18 05:20 am UTC (link)
The usual approach is to call a database normalized if it is in third normal form. However, there is one notable exception that is typically allowed - can you guess what it is?

(Reply to this) (Parent)(Thread)

[info]rydel23
2004-04-18 11:21 am UTC (link)
Ну дык "Adhering to the third normal form, while theoretically desirable, is not always practical" як нас вучаць разумныя дзядзі. Ёсьць выпадкі, калі лепш дэнармалізаваць ДБ для паляпшэньня performance. Ты гэта меў на ўвазе?

(Reply to this) (Parent)(Thread)

[info]syarzhuk
2004-04-18 09:11 pm UTC (link)
Гэта добра гучыць тэарэтычна, й сапраўды бывае (але даволі рэдка, й звычайна абумоўлена вельмі канкрэтнымі рэчамі). Але ёсьць адзін выпадак, у якім практычна любая ЗШАйская база дадзеных парушае нармальнасьць - можаш назваць, які?

(Reply to this) (Parent)

Create an Account
Forgot your login or password?
Login w/ OpenID
English • Español • Deutsch • Русский…