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

Home -> Community -> Usenet -> c.d.o.server -> Re: General Purpose or Data Warehouse?

Re: General Purpose or Data Warehouse?

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 02 Feb 2006 12:28:03 -0800
Message-ID: <1138912083.180196@jetspin.drizzle.com>


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 know someone suggested datawarehouse and pointed to the fact that one of your tables has hundreds of columns. But the number of columns is more likely a sign of bad design than usage.

How is the database going to be used? Is it for an OLTP system such as a retail store or accounting system? Is it for data mining where you will build a star schema and use bitmap join indexes? I'd personally suggest General Purpose for starters. There is nothing in the parameters used to set up the database based on the DBCA radio-button that can't be appropriately tuned later.

I would suggest

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Feb 02 2006 - 14:28:03 CST

Original text of this message

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