Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed-fusi2.netcologne.de!newsreader3.netcologne.de!news.netcologne.de!nhp.netcologne.de!sienna.impulse.net!216.168.1.162.MISMATCH!sn-xt-sjc-02!sn-xt-sjc-11!sn-xt-sjc-09!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.server Subject: Re: General Purpose or Data Warehouse? Date: Thu, 02 Feb 2006 12:28:03 -0800 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1138912083.180196@jetspin.drizzle.com> User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <1138901787.055468.127310@o13g2000cwo.googlegroups.com> In-Reply-To: <1138901787.055468.127310@o13g2000cwo.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: jetspin.drizzle.com!unknown@oracle.advtechserv.com X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 43 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:260607 g_chime@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@x.washington.edu (replace x with u to respond)