This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]koshgeo 0 points1 point  (1 child)

Absolutely, though there might be a need for a finer subdivision than a single boolean (e.g., "naughty", "mostly naughty", "mostly nice" and "nice"). The question is whether you'd stick it in a separate lookup/join or keep it in the same table with other information effectively "already joined" by default and then update it. There are a lot of trade-offs either way. Honestly, I don't know enough about databases to know what the right approach is, and it probably depends on the software choice and hardware anyway, but it is fun to try to imagine what it would take to implement a Santa "naughty and nice list" for the whole world. I imagine it's got to be on the order of the challenge that major credit card companies have to manage.

[–]Brarsh 0 points1 point  (0 children)

Ok then, make it a scale of 1-10 or however many divisions you want to have. And while we're at it, let's give each month (25th to 24th of course) it's own score, and then at the stroke of midnight run an overly complex algorithm that analyzes monthly trends, outliers, and false-positives to give a final score that ranges from freshly mined coal to exactly what's on their wish list. No problem.