Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!o13g2000cwo.googlegroups.com!not-for-mail
From: "g_chime@yahoo.com" <g_chime@yahoo.com>
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc,comp.databases.oracle.tools
Subject: General Purpose or Data Warehouse?
Date: 2 Feb 2006 09:36:27 -0800
Organization: http://groups.google.com
Lines: 23
Message-ID: <1138901787.055468.127310@o13g2000cwo.googlegroups.com>
NNTP-Posting-Host: 128.49.216.153
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1138901793 6348 127.0.0.1 (2 Feb 2006 17:36:33 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 2 Feb 2006 17:36:33 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: o13g2000cwo.googlegroups.com; posting-host=128.49.216.153;
   posting-account=LOv3_wwAAADxwXKzg4CdsbaEblxJ8MJj
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:260573 comp.databases.oracle.misc:124996 comp.databases.oracle.tools:70095

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.