[wp-hackers] Taxonomy Schema Proposal

[Jamie Talbot]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Matt Mullenweg wrote:
> Computer Guru wrote:
>> Yep, I believe that ties in with BCNF db schema.. It's just a bit "weird"
>> since WP hasn't been using this route - but this would be a huge step
>> towards a proper db schema :)
> 
> For those unfamiliar with the terminology:
> 
> http://en.wikipedia.org/wiki/Boyce-Codd_Normal_Form
> 
> Is this actual BCNF though?
> 

It isn't actually.  BCNF would be having a separate taxonomy lookup table.  An even more normalised
form would be having separate tags, categories and link cat tables, as well as the associated
post2cat, post2tag etc.  While initially I thought that would be the best way to go about it, Ryan's
proposal actually makes much more sense in terms of being mostly normalised while future proofing
without lots of future db alterations.  A nice compromise.

Cheers,

Jamie.

- --
http://jamietalbot.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGJq0arovxfShShFARAu0IAJ9eWJlul5J8p5mJH77pyt4XiuyoXgCfb/ds
6lEsg9ZiYtekP8EGV+4mrXY=
=M/F8
-----END PGP SIGNATURE-----