Stephane - I think both you and Tom are right. Report writers like systems that are somewhat denormalized. But according to Paula it sounded like her developers didn't even understand normalization to begin with. I think there is normalization, denormalization, and "doesn't have a clue". I may have made a hasty assumption, but it sounded like this was the latter situation.
Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Tuesday, March 25, 2003 9:24 AM To: Multiple recipients of list ORACLE-L DBA are responsible for the data model. I spend time to show the developpers the benefits of data normalization. I do not agree with Tom on "A good data model produces good opportunities for all kinds of data retrieval tools in the later life of the application." as I just did a performance review of a Decision Support System and my conclusion is that the data model is too normalized for a query intensive usage. It depends on what the system will be use for. For OLTP, yes third normal form is good. For datawarehousing, a star schema is the way to go. Stephane -----Original Message----- Thomas F Sent: Tuesday, March 25, 2003 7:47 AM To: Multiple recipients of list ORACLE-L Paula, Keep fighting for normalization. Something almost all developers fail to recognize is the long-term use of the database - they only think in the "here and now" - they need to develop the application right now. What they fail to recognize are the poor untrained users down the line who will need to develop reports off of the data. Having denormalized data will cause tons data inconsistencies in a few years - exactly what we had back in the "good old Cobol flat file days". A real mess. One of the most important jobs that a DBA has is producing a good data model keeping all players and users in mind when designing the tables. A good data model produces good opportunities for all kinds of data retrieval tools in the later life of the application. Hope this helps. Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Monday, March 24, 2003 7:14 PM To: Multiple recipients of list ORACLE-L Guys, The emphasis in many places I have worked is developing quick and dirty systems as quickly as possible and working with developers that don't seem to have very much understanding of Relational Database Theory but who prefer to program using flat files in relational databases - calling it "object-oriented" when it truly is not. Let us just say that it is highly denormalized. As a DBA I care about data integrity, extensibility and scalability but the up and coming esp. SQL Server developer types seem to operate in a world where this doesn't matter - just buy more hardware, denormalize to make the programming easier, etc. I have been losing this battle. So - what is your experience with this? What about the idea of having everyone access all objects in the views so that if need be the DBA's could in fact still make physical changes to the schemas without a large amount of rewriting of code? - as a standard Living without normalization for most things - esp. small systems and w/o fk's except as they are maintained in the application for the sake of getting the application done quickly, cheaply. It turns my stomach but then I wonder about my own sanity - am I making too much out of nothing? What about these stovepipe systems? Case in-point 100,000 row table for asset management - moving different types of addresses to a separate address table and moving different types of people to a person table. Developers are aghast at the performance implications. I am thinking perf. implications not real esp. with small amount but provides extensibility and RI with these reference tables instead of denorma. in multiple tables. They say mostly batch inserts/updates and batch reads - but then they say some OLTP. This is a SQL Server database. I think the separate reference tables provides only way for extensibility and data integrity. I say I will write for them a joined view. They say perf. implications. - AARRRGGHH! Oracle OCP DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
