Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2FKELx56026 for ; Thu, 15 Mar 2001 15:14:22 -0500 (EST) (envelope-from josh@agliodbs.com) Received: from [207.172.28.154] (HELO agliodbs.com) by davinci.ethosmedia.com (CommuniGate Pro SMTP 3.4.1) with ESMTP id 25511; Thu, 15 Mar 2001 12:14:20 -0800 Message-ID: <3AB12266.CC2C9FA3@agliodbs.com> Date: Thu, 15 Mar 2001 12:13:26 -0800 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions X-Mailer: Mozilla 4.73 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: jkakar@expressus.com CC: sqllist Subject: Re: Normalization is always good? References: <20010314212627.H12986@mail.perdue.net> <20010315114619.A18169@expressus.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200103/317 X-Sequence-Number: 1981 Jamu, > I have been working with SQL databases for about a year in a half and > in that time I've come to the conclusion that it is not always > preferable to normalize to a high level (like 3rd level). In some > cases, depending on the application, I've found that normalizing to a > ridiculous degree has shot me in the foot in terms of the > responsibility of my code to manage what happens in the database. There I'd agree with you ... there is the question of *how rigorous* you want your normalization to be. I tend to hover around the simplest normal form, most of the time. And I do a few things (such as polymorhic sub-tables) that would give Fabian Pascal fits :-) However, there is (in my mind) no question as to whether a database should be normalized, just how much effort is spent on normalization as opposed to other considerations (UI, performance, development time). > I've found referential integrity makes normalization a less expensive > notion as it absolves you of the task of keeping data current in all > your tables. I've also found that working in an object oriented > language makes normalization less expensive. What do you use? I've given up on OODB interfaces, myself, as I did not find them helpful, but that's modtly because I was working in MS-land. > What are the views of the people on this list re: Normalization > Guidelines? Anybody know of any good web sites that talk about this > in depth? Yup. http://www.databasedebunking.com/ Dig through the archives. -Josh Berkus -- ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco