OK, time to take my beating

I'm Confused.

You talk about BO and transaction processing in the same sentence as if you want to run those on the same box.

It's possible to do BO ( Data Warehouse ) and TP on the same box, but both kind of get compromised.

If you're serious TP (like me), then some things don't work well from the data warehouse world, like ROLLUPS and CUBES. At least you can't run them with your TP load. You have to run data warehouse stuff outside your prime TP processing window (eg. at night ). My take is that BO, Cognos, and MicroStrategy allow a business analyst to make data warehouse-like queries ( ROLLUPS and CUBES ) on a system.

So, if you're not careful, you're TP workload goes to hell in a handbasket as your business analyst is doing table scans to look at all the records for the summaries the VP wants, in the middle of the afternoon.

Maybe, if you have a big enough box, you don't care. But for our applications, the TP stuff has to add less than 1/2 second to our response time, and running data-warehouse queries puts us into 10-15 second response times very quickly.

Glen Austin

Post #75,773 by broomberg 1/20/03 7:26:24 PM Reply	OK, time to take my beating You are right. I am really looking for a person with domain experience if possible, who knows stats, and who has BO experience. The combination of the stats and the BO would get you through the door, since the BO is really a tool to apply the stats knowledge, while the domain experience (mortgage) would be nice but is certainly not a requirement. Is this clear enough?
Post #75,801 by tuberculosis 1/20/03 8:56:47 PM 8/21/07 6:33:52 AM Reply	Cool Now if we could just get the headhunters to behave accordingly we might all get a chance at food on the table. I think that it's extraordinarily important that we in computer science keep fun in computing. When it started out, it was an awful lot of fun. Of course, the paying customer got shafted every now and then, and after a while we began to take their complaints seriously. We began to feel as if we really were responsible for the successful, error-free perfect use of these machines. I don't think we are. I think we're responsible for stretching them, setting them off in new directions, and keeping fun in the house. I hope the field of computer science never loses its sense of fun. Above all, I hope we don't become missionaries. Don't feel as if you're Bible salesmen. The world has too many of those already. What you know about computing other people will learn. Don't feel as if the key to successful computing is only in your hands. What's in your hands, I think and hope, is intelligence: the ability to see the machine as more than when you were first led up to it, that you can make it more. --Alan Perlis Edited by tuberculosis Aug. 21, 2007, 06:33:52 AM EDT Expand All History
Post #76,446 by gdaustin 1/23/03 4:39:31 PM Reply	Re: OK, time to take my beating I'm Confused. You talk about BO and transaction processing in the same sentence as if you want to run those on the same box. It's possible to do BO ( Data Warehouse ) and TP on the same box, but both kind of get compromised. If you're serious TP (like me), then some things don't work well from the data warehouse world, like ROLLUPS and CUBES. At least you can't run them with your TP load. You have to run data warehouse stuff outside your prime TP processing window (eg. at night ). My take is that BO, Cognos, and MicroStrategy allow a business analyst to make data warehouse-like queries ( ROLLUPS and CUBES ) on a system. So, if you're not careful, you're TP workload goes to hell in a handbasket as your business analyst is doing table scans to look at all the records for the summaries the VP wants, in the middle of the afternoon. Maybe, if you have a big enough box, you don't care. But for our applications, the TP stuff has to add less than 1/2 second to our response time, and running data-warehouse queries puts us into 10-15 second response times very quickly. Glen Austin

Welcome to IWETHEY!