- Feature Articles
- CodeSOD
- Error'd
- Forums
-
Other Articles
- Random Article
- Other Series
- 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
Oh how I'd love to see the rest of that database...if only to laugh my ass off at the creator...
First!?
Admin
The headphones! They do nothing!
Admin
Record 1 of 91318. I'm guessing this is the only table in the database. Nice.
Admin
Nice!
So what does it do?
Admin
This looks very familar, I think he stole our idea as this is exactly how we did our online store -- using asp with an MDB file.
Admin
My guess: The fields store binary numbers using blank space for 0 and X for 1.
Admin
Ooookay he's planned for the future as well.
Just in case the fields end up being toooo short, we could use 'y' and 'z' or noughts.
WTF!
Admin
Given the table's name, I HIGHLY doubt it.
Admin
Not that I have any real data to contradict you with, of course. Looks like some sort of faux-bitmap, each record represents a single order in various categories (DATAn).
But... "Nice" still applies.
Admin
The next WTF would be an implementation of the algorithm to zip this data using LZW and unzip it during runtime.
Oo and there would be the genius who would recommend a sparse matrix data structure to hold those XTFs.
Brillant. Pure x-tasy.
Admin
Our first x-rated WTF ...
Admin
You don't name your db tables with 3 random letters then the last 2 digits of the upcoming year and then an "X"? Weird. I thought that was standard....</joke>
Good point.
Admin
I'm sure the DataN fields are byte-mapped text fields. I have seen something like this before...thought it was only one field...
--Jim
Admin
Heh. I love the box there where it says "type a question for help." I would type
<font size="5">
WTF?</font>
Admin
Battleship + Tic-Tac-Toe = Transaction?
Admin
The original system (this system was modelled after) used punched cards; x is where the holes were.
Admin
My first thought: abacus
Admin
x is where the holes were (or not)
captcha: dichotomy
Admin
Bah! This is OBVIOUSLY not a WTF! Anyone smarter than a peice of lint could OBVIOUSLY tell you how this works! The table name is OBVIOUSLY the Backwards Relationship Katalogue for item group 7X! The ID's are OBVIOUSLY the ID numbers of the items. The columns numbered DATA1-DATA52 are OBVIOUSLY for all 52 weeks of the year, and the x's in them OBVIOUSLY represent the day of the week for the item was purchase. Another table OBVIOUSLY holds the quantity of items purchased (for apparent reasons). OBVIOUSLY the buisness owner was trying to optimize his inventory, isn't it OBVIOUS!
Admin
<quote>I'll leave it as an exersize for the reader to immagine how this point-of-sale system operated.</quote>
Are you sure it was a point-of-sale system? P.O.S. has another meaning....
Admin
That would be my guess as well. I've seen these types of tables on AS400's so I'll say the table was just imported from the primary system.
Admin
The WTF is not that MS Access was used as a database, it is the table structure that is the WTF. Well, your comment was funnier and a bigger WTF than Alex's post.
Admin
/me listens closely
/me dies
Admin
Yes, that's quite a P.O.S. system they've got there.
Admin
The real WTF is the last line of this post:
"I'll leave it as an exersize for the reader to immagine how this point-of-sale system operated."
Admin
DATA52 ?
My xoxxles!! They dont work.
Admin
I used to do stuff like this in my word processer (AppleWorks) though I was drawing ASCII art rather than trying to manage a business. And I was about 14. Other than that, it's the same. Not so big a WTF.
Admin
After de-anonymizing this, we'll find that Steve G. (not his real name) is not an independent consultant at all, but works for a major software company. The system in question is not an Access database, either, but a snippet of UI handling code in Visual Basic. Instead of x's and spaces, the code contains the usual VB statements and misnamed variables (not much more legible than the x's, granted). Of course there is a WTF in the original, but it's impossible to tell what it is, because the submission has been fictionalized by an unknown amount along an unspecified number of axes, sort of like this:
<font face="Courier New"> W
T------------|----------F
</font>
Yes, I'm still annoyed that Alex refuses to even hint how much of each posting is true, if any, and how much is fictional.
Admin
"
... the exception being that Steve told the business owner that he was on his own. I'll leave it as an <FONT style="BACKGROUND-COLOR: #ff0000">exersize</FONT> for the reader to <FONT style="BACKGROUND-COLOR: #ff0000">immagine</FONT> how this point-of-sale system operated.
"
L2Spell, imo...
Admin
minesweeper! YAY!!!
Admin
I submit that it is more likely that Steve G. nor Alex wanted to actually figure out how this mess worked.
/captcha : captcha
Admin
/me faints and goes into epileptic shock
heck, i'm tempted to press the Report Abuse button, if that's not the most clear case of abusing us, I don't know what else is...
Admin
I have 20+ years of database work. Started with INFO, DB2 & dBASE II. "Classically" trained in database theory. Read Codd & Date once for fun. I've been looking at this now for more time then I care to admit and I don't have a clue about how this works.
There needs to be a category beyond Daily WTF. Something like Uber-WTF.
Admin
Admin
If you laid all of the punch cards on a wooden table and photographed them, then you could store an image of each card in single field.
Admin
White space should always be meaningful.
Admin
x x x x x x x x
x x x x x x x
x x x x
I figured it out!
Admin
Anybody noticed the creative ID column?
I've got to start using ids like those: last char - 0-9, second last - A-Z, ... I can only guess that third char is from this set: [!@#$%^&()]
I should probably start using chars from local charset for next ones... that would make some unique ids like:
4, T5, %G2, A&L2, ðET0, ...
:)
Admin
A Meltdown WTF?
Admin
This is easy...
x marks the spot.
Admin
Looking at the horizontal scroll-bar I'd say there are about 23 columns in this table, not 52.
Admittedly as a step in understanding this application that's about as useful as climbing a step-ladder on the way to the moon. This is a first-class WTF.
Admin
Admin
It's a Bool, not a boolean - think: File Not Found
Admin
This is one frame in the simulation game "life", that the "brother's sister-in-law's mother's second-cousin's son" had to implement for his beginning CS class. This is the starting position, and he iterated through 91318 cycles before he ran out of disk space.
Then he printed all of them out on the old dot-matrix, peeled off the sprocket strips, and handed the pile in.
Admin
This is so bad you almost have to wonder if it was done on purpose to sabotage the company. Maybe Steve used to beat his brother's sister-in-law's mother's second-cousin's son when he was little.
Admin
I think the misspelling of xersixe was quite intentional.
Captcha: SomethingWhichCanBeCleverlyRelatedToTheSubject (not).
Admin
A creative interpretation:
bits:
0123ABCD
Meaning:
0 - X=Active, " "=no active (not for sale)
1 - X=Include batery, " "=no
2 - RESERVERD
A - X=Stock available, " "= no stock available
...
About the "ID", is another composed stuff
??.
? (first char) - catalog ( K,N,P,L,M...)
? (2th char) - id item number
So L2 read like that:
L2 is active and include vatery (data3 is "XXX ")
--Tei
Admin
Hey! I see Orion!
Admin
Actually, a sparse matrix data structure is exactly what should have been used before. A sparse matrix data structure just stores the row and column ids of the ones that are active. In otherwords, it would be a properly denormalized table. Of course, you would probably want to fix the row and column ids to something more meaningful than what they are now, but hopefully, you get the idea.
Admin
G#', 1sa
yes, spaces, apostrophes, quotes. A real pain to work with programatically.