Re: .NET Reporting against and Orcale Database

On 07 May 2006, you wrote in comp.databases.oracle:

>
> "Larry Dooley" <larrydooley_at_yahoo.com> wrote in message
> news:Xns97BC63A0CF7Elarrydooley_at_216.196.97.142...

> Sounds like someone picked a technology for its "coolness" (eg someone
> wanted to learn the technology for their resume)
>
> If you know what the reports look like then the datawarehouse isn't
> that difficult and would vastly simplify queries and improve
> performance. If this is so business critical and worth a ton of money
> then doing it right with known techniques and best industry practices
> (learn from others who have gone before) is going to take less time
> and give you a better result than chasing a BSO. (bright shiny
> object) Building it from scratch is 2 orders of magnitude of effort
> greater than using a packaged application. (datawarehouses are
> designed for reporting, OLTP database schemas are not as easy to do
> cojmplex reporting out of. Also reporting out of your OLTP system may
> cause a performance hit there with the OLTP system. DW's usually have
> a lot of indexes especially bitmapped indexes - something you won't
> have in an OLTP system.(bitmapped indexes)
>
>
> I would seriosly reconsider your approuch. Yes, you can have stored
> procedures return refcursors. I am hoping you have someone familiar
> with how to do that.
> Jim
>
>
>

Yes I know (imho you give them to much credit). I build data wharehouses in the 80's in the fortune 10.

It's the complexity of the proc that worries me. I've built enough to be a bit daunted by it. And I've talked to some people who know and they shake their heads.

Since the visionary doesn't have any Oracle experience, any knowledge of the underlying complex package, or any reporting experience. I strongly suspect I'll be given the opportunity to do most of the stuff (with the attendent responsibility). Before I say no thanks, I want to make sure it's not just because I think he's an idiot and hasn't done his homework. Received on Sun May 07 2006 - 19:08:07 CEST