g_chime_at_yahoo.com wrote:
> I am new to databases and today is the first that I'm working with
> ORACLE.
>
> I am switching for MySQL to ORACLE and trying to decide which template
> to use for my DB.
>
> In the Database Configuration Assistant (Step 2) there are 4 choices:
> Custom, Data Warehouse, General Purpose and Transaction Processing.
>
> I have lots of data, large tables hundreds of columns many millions of
> rows. I add data on a regular bases, almost never update or delete.
>
> I have to perform user created large and complicated queries.
> Some result sets can be as large as 10 GB. (That's what the customer
> wants.)
>
> I think what I have is a Data Warehouse but I'm not sure.
>
> If I choose Data Warehouse, would the maintenance, programming and
> query building a lot different or more complicated?
>
> Thanks for your help.
I am not an expert and you would probably do well not to heed my advice
but it sounds to me like you have a data warehouse. It is not often to
have a normalized table with hundreds of columns.
Received on Thu Feb 02 2006 - 12:37:22 CST
