b3ta.com board
You are not logged in. Login or Signup
Home » Messageboard » Message 4219623 (Thread)

# well this one will probably end up somewhere around 30 rows
and if i actually get around to populating it then it should have anywhere from 100-1000 rows... i'll try it and if it borks then i'll break it up a bit
(I helped save b3ta! lemony, Wed 2 Feb 2005, 11:38, archived)
# just normalise it and stop being such a relational wuss
:p
(I helped save b3ta! Reckless_Rik, Wed 2 Feb 2005, 11:39, archived)
# pah... i'm not a database person... they're far too organised
i'm still slightly miffed that i'm expected to use postgres for all my DB work this year... i like the unscariness of mysql
(I helped save b3ta! lemony, Wed 2 Feb 2005, 11:42, archived)
# there`s not a moleste difference actually; just slightly different syntaxsisisisisisis
plus postgres supports err triggers and stuff from what I remember (which ain`t much.. mysql all the way for me .. and oracle)
(I helped save b3ta! Reckless_Rik, Wed 2 Feb 2005, 11:44, archived)
# It's still scary
to me
(I helped save b3ta! lemony, Wed 2 Feb 2005, 11:49, archived)
# *coughdb2cough"
(I helped save b3ta! dazzla - Just blew up his shuttle and potentially lost all pr0n, Wed 2 Feb 2005, 11:54, archived)
# dBase IV
pronounced "dee basssssss" by my old database teacher - the same bloke who looked like Frank Drebin, and who pronounced MS-DOS as "emm ess doooooooooooos"

"- don`t forget to do your regular [backup] dumps"
(I helped save b3ta! Reckless_Rik, Wed 2 Feb 2005, 11:56, archived)
# BCNF
For the win!
(Mintman, Wed 2 Feb 2005, 11:46, archived)
# Normalisation as a general rule
actually impacts performance on a database as the RDBMS has to process the joins, access extra tables etc etc.

It does very well at reducing the amount of storage used overall in the DB though.
(I helped save b3ta! dazzla - Just blew up his shuttle and potentially lost all pr0n, Wed 2 Feb 2005, 11:49, archived)
# i can't even understand this
en.wikipedia.org/wiki/Database_normalization

darn it...

/humble undergrad
(I helped save b3ta! lemony, Wed 2 Feb 2005, 11:50, archived)
# i start to lose the plot
after second normal form and give up.
(I helped save b3ta! dazzla - Just blew up his shuttle and potentially lost all pr0n, Wed 2 Feb 2005, 11:53, archived)
# definitely
and a lot of normalisation is actually just common sense; relating stuff together and linking where appropriate - it works nicely with OO programming as you`re using the same approach there
(I helped save b3ta! Reckless_Rik, Wed 2 Feb 2005, 11:57, archived)
# oh definitely - that`s why indexes were created ;)
but if you`re writing object oriented code with object persistence layers, it makes no sense at all not to normalise as the data drives the design of data transfer objects and the like

I say screw the database and have one moleste XML file!
(I helped save b3ta! Reckless_Rik, Wed 2 Feb 2005, 11:54, archived)
# fair enough
not really had much exposure to the OO gubbins, purely dba me.

p.s. Gotta love the word filter at the moment
(I helped save b3ta! dazzla - Just blew up his shuttle and potentially lost all pr0n, Wed 2 Feb 2005, 11:59, archived)