| Article: |
Hierarchical SQL | |
| Subject: | path strings | |
| Date: | 2004-11-13 06:37:26 | |
| From: | r937 | |
|
disclaimer: i have not yet implemented any of the storage methods other than the adjacency model (primarily because i could never understand them well enough to be able to write a query without having several reference books available -- they're just too hard) maybe it's me, but the "path-string" column sure looks like the dreaded bogeyman to-be-avoided-at-all-cost multiple-values-in-a-single-column non-first-normal-form terrible design that all sql gurus, including some guy named celko, have been warning us for years never to implement... what is the essential difference between 'ABD' and 'A/B/D' and 'A,B,D'? yet we jump all over php programmers who want to store values like 'A,B,D' in a column why aren't the path strings normalized into multiple rows like they should be? or would that be too inconvenient? ;o)
|
||
Women in Technology
Hear us Roar
