Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DB Design - Architecture Question.
Dear Michal,
Thanks for your mail and the links.Our requirement is the client is having 3 different systems for each business line and financing module, he wants to keep a generic application. Data keyed in from individaul business lines will be moved to this generic application/db and this application will process this business data and will compute money flow. We don't have control over all the 3 applications. We are the owner of one application and this generic system. We have to move the data from other system as well... I meant a generic database in this sense. I was thinking of a generic interface, which will populate data in my generic database and all 3 different systems will give data in the required format.
Thanks
A Ganesh
Michal Kuratczyk wrote:
> AnGanesh wrote:
> > We are planning to have a generic database
> That doesn't sound good...
>
> > Whenever, the source DB is populated we would like to have the
> > GENERIC_TBL1 in generic schema populated with the data at real time.
> And that sounds like a real time data warehouse.
>
> So here is a good article on generic databases:
> http://www.simple-talk.com/opinion/opinion-pieces/bad-carma/
>
> Here is an intro to RTDW:
> http://www.dbazine.com/datawarehouse/dw-articles/rittman5
>
> And here is some info about connecting to SQL Server:
> http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96544/gencon.htm
>
> --
> Michal Kuratczyk
Received on Fri Oct 27 2006 - 21:59:49 CDT