Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: DB design

Re: DB design

From: Arto Viitanen <arto.viitanen_at_csc.fi>
Date: Tue, 28 Feb 2006 08:57:44 +0200
Message-ID: <4403f468$0$10072$ba624cd0@newsread.funet.fi>


Baski wrote:
> Hi,
>
> How to design a generalized database that is used to store datas from
> any other database. The thing is that the tables and datas of the
> source database is not known while designing this target database. The
> design should be a generalized one to store data from any database. Can
> dummy tables be used? Should there be a provion to create the actual
> tables from the source db?? Or is there any better way??
>
> Thanks in advance...
> Baski.
>

You might like to check how Oracle does it, like where it stores information of tables, columns, types etc. and where it stores the values. But, then you have "Oracle" implemented with Oracle, so what's the catch?

--
Arto Viitanen, CSC Ltd.
Espoo, Finland
Received on Tue Feb 28 2006 - 00:57:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US