[wp-hackers] Taxonomy Schema Proposal
wphackers at jamietalbot.com
Wed Apr 18 23:43:22 GMT 2007
-----BEGIN PGP SIGNED MESSAGE-----
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:
> 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.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
-----END PGP SIGNATURE-----
More information about the wp-hackers