Database Software

Hi All,

My quesion is what's the popular design or architecture currectly for oracle data warehouse?

The architecture of project I did is upstream database(non-oracle) generates a lot of flat data files(txt in Unix). And then we used sqlloader to load all these files into oracle staging tables. After that, we wrote stored subprograms to process and load data into fact or dimension tables.

Every day we loaded millions of rows totally. And the main fact tables have about billions of rows. To be honest, I think this architecture is good, at least not bad.

I worked on this project for one year and then I transfered to oracle application development.

Recently, I heard of some opinions such as oracle is not fast enough and they just store data in oracle and use distribution processing (maybe c++ or java) to process data.

In my opinion, the main purpose of this design is to reduct the cost rather than to get better performance or more benefits.

Could anyone give me comments on it or talk something about the design of your projects, please?

I have tranfered to develop applications based on oracle for two years. So I must be out of date on DW. I am sorry if I said something stupid.


Thank you very much,

Leon