The next big paradigm shift in database design
-
This is the structure for a MySQL table some anonymous guys from 6ib at the Koninklijk Atheneum Sint-Niklaas[^] created. It's in Dutch, but I'm guessing you'll get the point anyway. The table is supposed to store answers from an enquite.
CREATE TABLE IF NOT EXISTS `antwoorden` (
`id` int(11) NOT NULL auto_increment,
`geslacht` text NOT NULL,
`studeren` text NOT NULL,
`geboorteJaar` int(4) NOT NULL default '0',
`gsm` text NOT NULL,
`prijsGsmToestel` text,
`herlaadmanier` text,
`provider` text,
`bedragPerMaan` text,
`smsPerDag` text,
`belPerDag` text,
`mp3` text NOT NULL,
`prijsMp3` text,
`gebruikMp3` text,
`pc` text NOT NULL,
`aantalPc1` text,
`aantalPc2` text,
`aantalPc3` text,
`aantalPc4` text,
`aantalPc5` text,
`aantalPc6` text,
`aantalPc7` text,
`aantalPc8` text,
`aantalPc9` text,
`aantalPc10` text,
`prijsPc` text,
`pcWerk` text,
`pcSchool` text,
`pcGamen` text,
`pcFilm` text,
`pcComm` text,
`pcSociaal` text,
`pcMuziek` text,
`pcAndere` text,
`pcGebruik` text,
`pcProvider` text,
`pc2000` text,
`pcXp` text,
`pcVista` text,
`pc7` text,
`pcLeo` text,
`pcSnowLeo` text,
`pcLinux` text,
`pcUnix` text,
`pcAndereBest` text,
`pda` text NOT NULL,
`prijsPda` text,
`pdaWerk` text,
`pdaSchool` text,
`pdaGamen` text,
`pdaAndere` text,
`pdaGebruik` text,
`pdaProvider` text,
`tv` text NOT NULL,
`tvGebruik` text,
`tvProvider` text,
`gamen` text NOT NULL,
`play1` text,
`play2` text,
`play3` text,
`xbox` text,
`xbox360` text,
`psp` text,
`pspGo` text,
`gameCube` text,
`wii` text,
`ds` text,
`gameAndere` text,
`consoleAantal` text,
`prijsGames` text,
`digiFoto` text,
`filmCamera` text,
`extHD` text,
`memStick` text,
`videoRec` text,
`dvdSpelRec` text,
`bluRay` text,
`dlToetsMuis` text,
`gameToeb` text,
`surround` text,
`printer` text,
`webcam` text,
`scanner` text,
`enqueteLeuk` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;I think this is just brilliant and the authors should be nominated form the Nobel prize. EDIT: Check out my blog post[
-
This is the structure for a MySQL table some anonymous guys from 6ib at the Koninklijk Atheneum Sint-Niklaas[^] created. It's in Dutch, but I'm guessing you'll get the point anyway. The table is supposed to store answers from an enquite.
CREATE TABLE IF NOT EXISTS `antwoorden` (
`id` int(11) NOT NULL auto_increment,
`geslacht` text NOT NULL,
`studeren` text NOT NULL,
`geboorteJaar` int(4) NOT NULL default '0',
`gsm` text NOT NULL,
`prijsGsmToestel` text,
`herlaadmanier` text,
`provider` text,
`bedragPerMaan` text,
`smsPerDag` text,
`belPerDag` text,
`mp3` text NOT NULL,
`prijsMp3` text,
`gebruikMp3` text,
`pc` text NOT NULL,
`aantalPc1` text,
`aantalPc2` text,
`aantalPc3` text,
`aantalPc4` text,
`aantalPc5` text,
`aantalPc6` text,
`aantalPc7` text,
`aantalPc8` text,
`aantalPc9` text,
`aantalPc10` text,
`prijsPc` text,
`pcWerk` text,
`pcSchool` text,
`pcGamen` text,
`pcFilm` text,
`pcComm` text,
`pcSociaal` text,
`pcMuziek` text,
`pcAndere` text,
`pcGebruik` text,
`pcProvider` text,
`pc2000` text,
`pcXp` text,
`pcVista` text,
`pc7` text,
`pcLeo` text,
`pcSnowLeo` text,
`pcLinux` text,
`pcUnix` text,
`pcAndereBest` text,
`pda` text NOT NULL,
`prijsPda` text,
`pdaWerk` text,
`pdaSchool` text,
`pdaGamen` text,
`pdaAndere` text,
`pdaGebruik` text,
`pdaProvider` text,
`tv` text NOT NULL,
`tvGebruik` text,
`tvProvider` text,
`gamen` text NOT NULL,
`play1` text,
`play2` text,
`play3` text,
`xbox` text,
`xbox360` text,
`psp` text,
`pspGo` text,
`gameCube` text,
`wii` text,
`ds` text,
`gameAndere` text,
`consoleAantal` text,
`prijsGames` text,
`digiFoto` text,
`filmCamera` text,
`extHD` text,
`memStick` text,
`videoRec` text,
`dvdSpelRec` text,
`bluRay` text,
`dlToetsMuis` text,
`gameToeb` text,
`surround` text,
`printer` text,
`webcam` text,
`scanner` text,
`enqueteLeuk` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;I think this is just brilliant and the authors should be nominated form the Nobel prize. EDIT: Check out my blog post[
Very nice! With "AUTO_INCREMENT=3" they leave even some "empty" lines in between - what will they do with them? Another guess is that they want to do some data mining, because there you normally remove all normalization. Maybe these guys were a bit smarter than we'd expect from the first view of their table design.
-
This is the structure for a MySQL table some anonymous guys from 6ib at the Koninklijk Atheneum Sint-Niklaas[^] created. It's in Dutch, but I'm guessing you'll get the point anyway. The table is supposed to store answers from an enquite.
CREATE TABLE IF NOT EXISTS `antwoorden` (
`id` int(11) NOT NULL auto_increment,
`geslacht` text NOT NULL,
`studeren` text NOT NULL,
`geboorteJaar` int(4) NOT NULL default '0',
`gsm` text NOT NULL,
`prijsGsmToestel` text,
`herlaadmanier` text,
`provider` text,
`bedragPerMaan` text,
`smsPerDag` text,
`belPerDag` text,
`mp3` text NOT NULL,
`prijsMp3` text,
`gebruikMp3` text,
`pc` text NOT NULL,
`aantalPc1` text,
`aantalPc2` text,
`aantalPc3` text,
`aantalPc4` text,
`aantalPc5` text,
`aantalPc6` text,
`aantalPc7` text,
`aantalPc8` text,
`aantalPc9` text,
`aantalPc10` text,
`prijsPc` text,
`pcWerk` text,
`pcSchool` text,
`pcGamen` text,
`pcFilm` text,
`pcComm` text,
`pcSociaal` text,
`pcMuziek` text,
`pcAndere` text,
`pcGebruik` text,
`pcProvider` text,
`pc2000` text,
`pcXp` text,
`pcVista` text,
`pc7` text,
`pcLeo` text,
`pcSnowLeo` text,
`pcLinux` text,
`pcUnix` text,
`pcAndereBest` text,
`pda` text NOT NULL,
`prijsPda` text,
`pdaWerk` text,
`pdaSchool` text,
`pdaGamen` text,
`pdaAndere` text,
`pdaGebruik` text,
`pdaProvider` text,
`tv` text NOT NULL,
`tvGebruik` text,
`tvProvider` text,
`gamen` text NOT NULL,
`play1` text,
`play2` text,
`play3` text,
`xbox` text,
`xbox360` text,
`psp` text,
`pspGo` text,
`gameCube` text,
`wii` text,
`ds` text,
`gameAndere` text,
`consoleAantal` text,
`prijsGames` text,
`digiFoto` text,
`filmCamera` text,
`extHD` text,
`memStick` text,
`videoRec` text,
`dvdSpelRec` text,
`bluRay` text,
`dlToetsMuis` text,
`gameToeb` text,
`surround` text,
`printer` text,
`webcam` text,
`scanner` text,
`enqueteLeuk` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;I think this is just brilliant and the authors should be nominated form the Nobel prize. EDIT: Check out my blog post[
To quote Ray Stanz from Ghostbusters: "The guy who designed this was either a certified genius or an authentic wacko." But, he wasn't a genius though.
Dalek Dave: There are many words that some find offensive, Homosexuality, Alcoholism, Religion, Visual Basic, Manchester United, Butter. Pete o'Hanlon: If it wasn't insulting tools, I'd say you were dumber than a bag of spanners.
-
Very nice! With "AUTO_INCREMENT=3" they leave even some "empty" lines in between - what will they do with them? Another guess is that they want to do some data mining, because there you normally remove all normalization. Maybe these guys were a bit smarter than we'd expect from the first view of their table design.
"If you only knew the magnificence of the 3, 6 and 9, then you? would have a key to the universe." — Nikola Tesla Maybe this guy is a genius too. :laugh:
-
Very nice! With "AUTO_INCREMENT=3" they leave even some "empty" lines in between - what will they do with them? Another guess is that they want to do some data mining, because there you normally remove all normalization. Maybe these guys were a bit smarter than we'd expect from the first view of their table design.
bhiller wrote:
With "AUTO_INCREMENT=3" they leave even some "empty" lines in between
In MySQL, the AUTO_INCREMENT keyword on a table specifies the initial value for the first insert, not the increment size.
-
This is the structure for a MySQL table some anonymous guys from 6ib at the Koninklijk Atheneum Sint-Niklaas[^] created. It's in Dutch, but I'm guessing you'll get the point anyway. The table is supposed to store answers from an enquite.
CREATE TABLE IF NOT EXISTS `antwoorden` (
`id` int(11) NOT NULL auto_increment,
`geslacht` text NOT NULL,
`studeren` text NOT NULL,
`geboorteJaar` int(4) NOT NULL default '0',
`gsm` text NOT NULL,
`prijsGsmToestel` text,
`herlaadmanier` text,
`provider` text,
`bedragPerMaan` text,
`smsPerDag` text,
`belPerDag` text,
`mp3` text NOT NULL,
`prijsMp3` text,
`gebruikMp3` text,
`pc` text NOT NULL,
`aantalPc1` text,
`aantalPc2` text,
`aantalPc3` text,
`aantalPc4` text,
`aantalPc5` text,
`aantalPc6` text,
`aantalPc7` text,
`aantalPc8` text,
`aantalPc9` text,
`aantalPc10` text,
`prijsPc` text,
`pcWerk` text,
`pcSchool` text,
`pcGamen` text,
`pcFilm` text,
`pcComm` text,
`pcSociaal` text,
`pcMuziek` text,
`pcAndere` text,
`pcGebruik` text,
`pcProvider` text,
`pc2000` text,
`pcXp` text,
`pcVista` text,
`pc7` text,
`pcLeo` text,
`pcSnowLeo` text,
`pcLinux` text,
`pcUnix` text,
`pcAndereBest` text,
`pda` text NOT NULL,
`prijsPda` text,
`pdaWerk` text,
`pdaSchool` text,
`pdaGamen` text,
`pdaAndere` text,
`pdaGebruik` text,
`pdaProvider` text,
`tv` text NOT NULL,
`tvGebruik` text,
`tvProvider` text,
`gamen` text NOT NULL,
`play1` text,
`play2` text,
`play3` text,
`xbox` text,
`xbox360` text,
`psp` text,
`pspGo` text,
`gameCube` text,
`wii` text,
`ds` text,
`gameAndere` text,
`consoleAantal` text,
`prijsGames` text,
`digiFoto` text,
`filmCamera` text,
`extHD` text,
`memStick` text,
`videoRec` text,
`dvdSpelRec` text,
`bluRay` text,
`dlToetsMuis` text,
`gameToeb` text,
`surround` text,
`printer` text,
`webcam` text,
`scanner` text,
`enqueteLeuk` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;I think this is just brilliant and the authors should be nominated form the Nobel prize. EDIT: Check out my blog post[
Not speaking Dutch, I can't be sure, but I think the author has forgotten a column for right-hand or left-hand use. :)
Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
-
This is the structure for a MySQL table some anonymous guys from 6ib at the Koninklijk Atheneum Sint-Niklaas[^] created. It's in Dutch, but I'm guessing you'll get the point anyway. The table is supposed to store answers from an enquite.
CREATE TABLE IF NOT EXISTS `antwoorden` (
`id` int(11) NOT NULL auto_increment,
`geslacht` text NOT NULL,
`studeren` text NOT NULL,
`geboorteJaar` int(4) NOT NULL default '0',
`gsm` text NOT NULL,
`prijsGsmToestel` text,
`herlaadmanier` text,
`provider` text,
`bedragPerMaan` text,
`smsPerDag` text,
`belPerDag` text,
`mp3` text NOT NULL,
`prijsMp3` text,
`gebruikMp3` text,
`pc` text NOT NULL,
`aantalPc1` text,
`aantalPc2` text,
`aantalPc3` text,
`aantalPc4` text,
`aantalPc5` text,
`aantalPc6` text,
`aantalPc7` text,
`aantalPc8` text,
`aantalPc9` text,
`aantalPc10` text,
`prijsPc` text,
`pcWerk` text,
`pcSchool` text,
`pcGamen` text,
`pcFilm` text,
`pcComm` text,
`pcSociaal` text,
`pcMuziek` text,
`pcAndere` text,
`pcGebruik` text,
`pcProvider` text,
`pc2000` text,
`pcXp` text,
`pcVista` text,
`pc7` text,
`pcLeo` text,
`pcSnowLeo` text,
`pcLinux` text,
`pcUnix` text,
`pcAndereBest` text,
`pda` text NOT NULL,
`prijsPda` text,
`pdaWerk` text,
`pdaSchool` text,
`pdaGamen` text,
`pdaAndere` text,
`pdaGebruik` text,
`pdaProvider` text,
`tv` text NOT NULL,
`tvGebruik` text,
`tvProvider` text,
`gamen` text NOT NULL,
`play1` text,
`play2` text,
`play3` text,
`xbox` text,
`xbox360` text,
`psp` text,
`pspGo` text,
`gameCube` text,
`wii` text,
`ds` text,
`gameAndere` text,
`consoleAantal` text,
`prijsGames` text,
`digiFoto` text,
`filmCamera` text,
`extHD` text,
`memStick` text,
`videoRec` text,
`dvdSpelRec` text,
`bluRay` text,
`dlToetsMuis` text,
`gameToeb` text,
`surround` text,
`printer` text,
`webcam` text,
`scanner` text,
`enqueteLeuk` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;I think this is just brilliant and the authors should be nominated form the Nobel prize. EDIT: Check out my blog post[
O M G !!!! Aside from the fact that it is a massive table of text.....WHY WHY WHY WHY WHY do people design G.D. databases with an incremental ID as the mother fracking key!!!!! AHHHHHH I want to shoot that designer. [deep breath...pause... nope I still want to shoot the designer] [Buddhist chants...meditation...an hour of tai chi....hmmm nope I still want to shoot the designer] Oh well.
-
O M G !!!! Aside from the fact that it is a massive table of text.....WHY WHY WHY WHY WHY do people design G.D. databases with an incremental ID as the mother fracking key!!!!! AHHHHHH I want to shoot that designer. [deep breath...pause... nope I still want to shoot the designer] [Buddhist chants...meditation...an hour of tai chi....hmmm nope I still want to shoot the designer] Oh well.
LongRangeShooter wrote:
WHY do people design G.D. databases with an incremental ID as the mother fracking key
I'm not sure what you mean by "incremental ID" here. Do you mean auto-incrementing?
-
O M G !!!! Aside from the fact that it is a massive table of text.....WHY WHY WHY WHY WHY do people design G.D. databases with an incremental ID as the mother fracking key!!!!! AHHHHHH I want to shoot that designer. [deep breath...pause... nope I still want to shoot the designer] [Buddhist chants...meditation...an hour of tai chi....hmmm nope I still want to shoot the designer] Oh well.
LongRangeShooter wrote:
WHY WHY WHY WHY WHY do people design G.D. databases with an incremental ID as the mother fracking key
This bugs me too, sometime you find that such people grew writing VBA apps on Accees, which natually makes them database designers :-). Occaisionally technology "forces" it see: http://en.wikipedia.org/wiki/Surrogate_key#Compatibility[^] Genuinely, I blame lack of training as people often grow up hacking databases together, istead of understanding the theory behind them. To me, surrogate keys are a sign of bad normalisation, can lead to duplicates more easily, and increases the likelyhood of bad join conditions. I'm fascinated by the internicene warfare around relational database design, as these directly correlate to set theory and therefore we should largely agree about the principles at least. I mooted this point in the C# forum and got an immediate long rant informing me how a properly normalised database is too hard to use, I didn't even argue back as the guy was obviously too stupid to bother with. I worked in a company that collapsed because they bought a 3rd party software. The vendor pitched it "We handle all the information checking in code [i.e. referential integrity, duplication protection, orphaning protection etc], so our system is more flexible. Net result: Orphaned records, lost records, duplicate jobs, all because it is "too difficult" to normalize.
Dalek Dave: There are many words that some find offensive, Homosexuality, Alcoholism, Religion, Visual Basic, Manchester United, Butter. Pete o'Hanlon: If it wasn't insulting tools, I'd say you were dumber than a bag of spanners.
-
This is the structure for a MySQL table some anonymous guys from 6ib at the Koninklijk Atheneum Sint-Niklaas[^] created. It's in Dutch, but I'm guessing you'll get the point anyway. The table is supposed to store answers from an enquite.
CREATE TABLE IF NOT EXISTS `antwoorden` (
`id` int(11) NOT NULL auto_increment,
`geslacht` text NOT NULL,
`studeren` text NOT NULL,
`geboorteJaar` int(4) NOT NULL default '0',
`gsm` text NOT NULL,
`prijsGsmToestel` text,
`herlaadmanier` text,
`provider` text,
`bedragPerMaan` text,
`smsPerDag` text,
`belPerDag` text,
`mp3` text NOT NULL,
`prijsMp3` text,
`gebruikMp3` text,
`pc` text NOT NULL,
`aantalPc1` text,
`aantalPc2` text,
`aantalPc3` text,
`aantalPc4` text,
`aantalPc5` text,
`aantalPc6` text,
`aantalPc7` text,
`aantalPc8` text,
`aantalPc9` text,
`aantalPc10` text,
`prijsPc` text,
`pcWerk` text,
`pcSchool` text,
`pcGamen` text,
`pcFilm` text,
`pcComm` text,
`pcSociaal` text,
`pcMuziek` text,
`pcAndere` text,
`pcGebruik` text,
`pcProvider` text,
`pc2000` text,
`pcXp` text,
`pcVista` text,
`pc7` text,
`pcLeo` text,
`pcSnowLeo` text,
`pcLinux` text,
`pcUnix` text,
`pcAndereBest` text,
`pda` text NOT NULL,
`prijsPda` text,
`pdaWerk` text,
`pdaSchool` text,
`pdaGamen` text,
`pdaAndere` text,
`pdaGebruik` text,
`pdaProvider` text,
`tv` text NOT NULL,
`tvGebruik` text,
`tvProvider` text,
`gamen` text NOT NULL,
`play1` text,
`play2` text,
`play3` text,
`xbox` text,
`xbox360` text,
`psp` text,
`pspGo` text,
`gameCube` text,
`wii` text,
`ds` text,
`gameAndere` text,
`consoleAantal` text,
`prijsGames` text,
`digiFoto` text,
`filmCamera` text,
`extHD` text,
`memStick` text,
`videoRec` text,
`dvdSpelRec` text,
`bluRay` text,
`dlToetsMuis` text,
`gameToeb` text,
`surround` text,
`printer` text,
`webcam` text,
`scanner` text,
`enqueteLeuk` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;I think this is just brilliant and the authors should be nominated form the Nobel prize. EDIT: Check out my blog post[
jeroen de dauw wrote:
EDIT: Check out my blog post[^] about this
Dude. Who told you that black text on a dark grey background made for a good, READABLE, website?
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009... -
jeroen de dauw wrote:
EDIT: Check out my blog post[^] about this
Dude. Who told you that black text on a dark grey background made for a good, READABLE, website?
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009... -
Wow. IE7 at work. I fired up IE7 at home and it looks OK now. Back at work, it was all dark gray, except for the code snippets.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009... -
FF3.0: OK IE7: bad :)
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
Getting an article published on CodeProject now is hard and not sufficiently rewarded.
-
jeroen de dauw wrote:
EDIT: Check out my blog post[^] about this
Dude. Who told you that black text on a dark grey background made for a good, READABLE, website?
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009... -
Wow. IE7 at work. I fired up IE7 at home and it looks OK now. Back at work, it was all dark gray, except for the code snippets.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...I can second that. I am using IE7 and it's a grey background, black text. Very hard to read. The code snippets show up OK, with a white background. EDIT: Just tried it in FF3 and it's a white background. In IE7 there is a background image showing which is sort of a dark greyish colour. In FF3 that image is not displayed, so you only see the default browser back colour (i.e. a plain white background). It looks like some problem with the CSS file that defines the class for the box where you are showing your text. IE likes it, FF doesn't. Welcome to the world of cross-browser support.