From oracle-l-bounce@freelists.org Thu Jul 29 11:35:16 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6TGZ1Z02462 for ; Thu, 29 Jul 2004 11:35:11 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6TGYo602439 for ; Thu, 29 Jul 2004 11:35:00 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EE17A72D2CC; Thu, 29 Jul 2004 11:12:55 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28094-98; Thu, 29 Jul 2004 11:12:55 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4782572C3D5; Thu, 29 Jul 2004 11:12:55 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 29 Jul 2004 11:11:30 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0318572C3B1 for ; Thu, 29 Jul 2004 11:11:30 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28094-73 for ; Thu, 29 Jul 2004 11:11:29 -0500 (EST) Received: from mail.acelerate.com (mail.acelerate.com [200.105.128.132]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 4492472D6F7 for ; Thu, 29 Jul 2004 11:11:29 -0500 (EST) Received: (qmail 28708 invoked from network); 29 Jul 2004 16:38:40 -0000 Received: from dazasoftware.com (HELO cachitoss) (200.105.151.94) by 0 with SMTP; 29 Jul 2004 16:38:40 -0000 MIME-Version: 1.0 Message-Id: <410926F0.000003.01220@CACHITOSS> Date: Thu, 29 Jul 2004 12:33:52 -0400 Content-type: text/plain; charset=iso-8859-1 X-Mailer: IncrediMail (3001524) From: "Juan Carlos Reyes Pacheco" References: <0C3690346404A94CBF4DDDD4724FC61411E8F3D8@csmail.corpsys.csedge.com> To: Subject: RE: Normalization X-FID: PLAINTXT-NONE-0000-0000-000000000000 Content-Transfer-Encoding: 8bit X-Priority: 3 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 6419 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jreyes@dazasoftware.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi bob definetively I think you are right, but it depends until which level you normalize. any way standard edition not have full materialized view features. Juan Carlos Reyes Pacheco OCP -------Original Message------- From: oracle-l@freelists.org Date: 07/29/04 12:02:42 To: 'oracle-l@freelists.org' Subject: RE: Normalization I have to disagree. With materialized views I see no reason at all to denormalize. Keep the base tables fully normalized and speed your queries by pre-joining into materialize views. Correctness and speed. The only price is disk space and that is a small price to pay to avoid inconsistant data. -----Original Message----- From: Juan Carlos Reyes Pacheco [mailto:jreyes@dazasoftware.com] Sent: Thursday, July 29, 2004 10:48 AM To: oracle-l@freelists.org Subject: Re: Normalization Hi Paul I am not an expert, but yes trying to become "expert". Q: What are the basic guidelines one should keep in mind while designing a database? Is denormalization always good? In simple words. The reason to normalize is don't duplicate data fooly The reason to denormalize is don't get you boss kick your ass, because a query is taking too much time. There is a limit when tuning, when you can't get more performance, unless you denormalize, buy hardware or move to RAC. The guideline is performance, and common sense. If denormalizating it takes 0,03 s and without denormalizating takes 2s without taking in count that it increase 10x the amount of block read, etc. and this is a process t hat run 1000's of time a day, don't denormalizing is a mistake. but if this process is run few times a day, denormalizing is a mistake. 4th and 5th normalization is not always advisable, all depends. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------