|
scream-of-consciousness; "If you're trying to change minds and influence people it's probably not a good idea to say that virtually all elected Democrats are liars, but what the hell."
Tuesday, September 16, 2008
Funny Money Idea
"If the number of Islamic terror attacks continues at the current rate, candlelight vigils will soon be the number-one cause of global warming. " |
This will be the comment box |
7 comments:
-
-
Excel is the wrong tool for the job. What you want is a MySQL or Oracle standalone app. So long as the database is well designed response times would be near-instant even on a desktop computer.
It could be done in a week. - 9/16/08, 3:33 PM
- Rodger the Real King of France said...
-
*bangs head*
- 9/16/08, 5:52 PM
-
-
It's unlikely any PC yet built could handle the data manipulation required for 62 million loans. At work, I have available 4 dedicated servers (expensive Suns) and a mainframe. At quarter end, just to handle reporting on one million participants and their transactions, it takes my jobs 8 days to run. We've quite the team of programmers and DBA's just to get it done in that time.
The bigger issue is, you'd need more data than asked for. Household income and debt, including current assets. Zip codes ($50k in Alabama goes further than in California). Median housing prices in those zip codes. A weighting factor. And it really does go on.
A big problem is going to be this: So little checking was done for so many of those loans. Noone ensured that the one applying for the loan didn't lie through their teeth on income, debt, etc. Loan companies seemed to operate under their own "don't ask, don't tell" policy, because they didn't have to carry the loan, they'd just sell them to Freddy and Fannie and other idiot investment banks.
What really fries my banana is that a taxpayer like me, who actually can handle his mortgage but isn't otherwise wealthy, will be expected to pay the tab for all this moronicity. Screw 'em, let em fail. - 9/16/08, 7:04 PM
- pdwalker said...
-
http://www.dimins.com/
This puppy could take all those records, chew them up, spit them out and tell you everything you need to know about whatever you need to know.
And all on your PC.
As for your job Alear, I'd suggest that some of your DBAs are not up to snuff. Billions of daily transactions are easily handled on modern hardware. - 9/16/08, 7:38 PM
-
-
Ya know, I don't even know why I'm responding, Pdwalker, but what the heck. Here's all you need to know: We're a Fortune 125 company, and we didn't get that way by accident.
- 9/16/08, 8:34 PM
-
-
http://www.dimins.com/??? So a pizza place can handle all that? Wow!
ozaoB - 9/16/08, 10:32 PM
- Chuck said...
-
Weren't Fannie and Freddie Fortune listed companies?
I know AIG was.
Not much to brag about, one would think. - 9/16/08, 10:47 PM