- Feature Articles
- CodeSOD
- Error'd
-
Forums
-
Other Articles
- Random Article
- Alex's Soapbox
- Announcements
- Best of…
- Best of Email
- Best of the Sidebar
- Bring Your Own Code
- Coded Smorgasbord
- Mandatory Fun Day
- Off Topic
- Representative Line
- News Roundup
- Editor's Soapbox
- Software on the Rocks
- Souvenir Potpourri
- Sponsor Post
- Tales from the Interview
- The Daily WTF: Live
- Virtudyne
Admin
WTF? I'd love to hear the justification for this crap. A PHB must have gotten his hands into this somehow. :-)
Admin
That is so scary!
The table names aren't too bad I guess (apart from the extraneous ".xml", but those columns - Jeez!!!
I hope the documentation is good.
Admin
Looks like auto-generated crap to me. I've seen worse -- like old mainframe COBOL copybooks being auto-converted into web services. The resulting XML can look like:
<A>
<AB>SCR-VAL</AB>
<Q>1</Q>
<Z2>
<Z1>7</Z1>
<H>GEORGE</H>
</Z2>
</A>
Nice an human-readable xml huh?
Admin
At least the XML overhead is low ;-)
Admin
Holy gobldy goop Batman!!!
Thats whay you get when you let business analyst design databases. What a cluster F.
Admin
Wow, just wow! Pray for me that I'll never inherit any bollocks like this!
Admin
Tim H, it soooo STINKS to be you, I feel for you... :-(
Admin
Hmmm - an 8-byte column named "guid" - wonder what the strategy is to ensure global uniqueness?
Just more confusion to heap on this mess...
Admin
Yeah, I know whats the [c:1:0:h] prefix is for... its for versioning.. so you know that field belongs to the "database" version 1.0 revision 'h'.
I bet it was a pleasure to code SQL joins on that database... lol
Admin
Finally a WTF where no-one said "ya know there is a perfectly acceptable reason for doing this blah blah blah"
Admin
Actually the column names look like SQL XML EXPLICIT syntax. Judging from that and the table names, it this database looks like a "creative" way to store xml files. Select a row by id, and based create the xml from the column names.
Admin
I think it's Estonian notation - similar to the better known Hungarian notation, but without the pretense of being intended for any purpose but obfuscation.