Thu Apr 25 01:57:55 2024 EVENTS FREE SOFTWARE INSTITUTE POLITICS JOBS MEMBERS' CORNER MAILING LIST NYLXS Members have a lot to say and share but we don't keep many secrets. Join the Hangout Mailing List and say your peice. DATE 2014-11-01 LEARN 2024-04-25 | 2024-03-25 | 2024-02-25 | 2024-01-25 | 2023-12-25 | 2023-11-25 | 2023-10-25 | 2023-09-25 | 2023-08-25 | 2023-07-25 | 2023-06-25 | 2023-05-25 | 2023-04-25 | 2023-03-25 | 2023-02-25 | 2023-01-25 | 2022-12-25 | 2022-11-25 | 2022-10-25 | 2022-09-25 | 2022-08-25 | 2022-07-25 | 2022-06-25 | 2022-05-25 | 2022-04-25 | 2022-03-25 | 2022-02-25 | 2022-01-25 | 2021-12-25 | 2021-11-25 | 2021-10-25 | 2021-09-25 | 2021-08-25 | 2021-07-25 | 2021-06-25 | 2021-05-25 | 2021-04-25 | 2021-03-25 | 2021-02-25 | 2021-01-25 | 2020-12-25 | 2020-11-25 | 2020-10-25 | 2020-09-25 | 2020-08-25 | 2020-07-25 | 2020-06-25 | 2020-05-25 | 2020-04-25 | 2020-03-25 | 2020-02-25 | 2020-01-25 | 2019-12-25 | 2019-11-25 | 2019-10-25 | 2019-09-25 | 2019-08-25 | 2019-07-25 | 2019-06-25 | 2019-05-25 | 2019-04-25 | 2019-03-25 | 2019-02-25 | 2019-01-25 | 2018-12-25 | 2018-11-25 | 2018-10-25 | 2018-09-25 | 2018-08-25 | 2018-07-25 | 2018-06-25 | 2018-05-25 | 2018-04-25 | 2018-03-25 | 2018-02-25 | 2018-01-25 | 2017-12-25 | 2017-11-25 | 2017-10-25 | 2017-09-25 | 2017-08-25 | 2017-07-25 | 2017-06-25 | 2017-05-25 | 2017-04-25 | 2017-03-25 | 2017-02-25 | 2017-01-25 | 2016-12-25 | 2016-11-25 | 2016-10-25 | 2016-09-25 | 2016-08-25 | 2016-07-25 | 2016-06-25 | 2016-05-25 | 2016-04-25 | 2016-03-25 | 2016-02-25 | 2016-01-25 | 2015-12-25 | 2015-11-25 | 2015-10-25 | 2015-09-25 | 2015-08-25 | 2015-07-25 | 2015-06-25 | 2015-05-25 | 2015-04-25 | 2015-03-25 | 2015-02-25 | 2015-01-25 | 2014-12-25 | 2014-11-25 | 2014-10-25 Key: Value: Key: Value: MESSAGE DATE 2014-11-26 FROM Ruben Safir SUBJECT Subject: [LIU Comp Sci] Why Normalization Failed to Become the Ultimate Guide for Database From owner-learn-outgoing-at-mrbrklyn.com Wed Nov 26 02:17:32 2014 Return-Path: X-Original-To: archive-at-mrbrklyn.com Delivered-To: archive-at-mrbrklyn.com Received: by mrbrklyn.com (Postfix) id BFC39161143; Wed, 26 Nov 2014 02:17:32 -0500 (EST) Delivered-To: learn-outgoing-at-mrbrklyn.com Received: by mrbrklyn.com (Postfix, from userid 28) id A6325161157; Wed, 26 Nov 2014 02:17:32 -0500 (EST) Delivered-To: learn-at-nylxs.com Received: from mailbackend.panix.com (mailbackend.panix.com [166.84.1.89]) by mrbrklyn.com (Postfix) with ESMTP id 9756F161143 for ; Wed, 26 Nov 2014 02:17:31 -0500 (EST) Received: from [10.0.0.42] (unknown [96.57.23.82]) by mailbackend.panix.com (Postfix) with ESMTP id 302DF13A88; Wed, 26 Nov 2014 02:17:31 -0500 (EST) Message-ID: <54757ED9.1030902-at-panix.com> Date: Wed, 26 Nov 2014 02:18:49 -0500 From: Ruben Safir User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.1.0 MIME-Version: 1.0 To: ping-Tsai Chung , Samir Iabbassen , learn-at-nylxs.com, ping-Tsai Chung Subject: [LIU Comp Sci] Why Normalization Failed to Become the Ultimate Guide for Database Designers? References: <547578D7.1020604-at-panix.com> <54757AED.8070802-at-panix.com> <54757BE7.5020204-at-panix.com> <54757D01.9090904-at-panix.com> In-Reply-To: <54757D01.9090904-at-panix.com> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Sender: owner-learn-at-mrbrklyn.com Precedence: bulk Reply-To: learn-at-mrbrklyn.com http://papers.ssrn.com/sol3/papers.cfm?abstract_id=905060 Why Normalization Failed to Become the Ultimate Guide for Database Designers? Marin Fotache Al.I.Cuza University of Iasi May 1, 2006 *Abstract: * With an impressive theoretical foundation, normalization was supposed to bring rigor and relevance into such a slippery domain as database design is. Almost every database textbook treats normalization in a certain extent, usually suggesting that the topic is so clear and consolidated that it does not deserve deeper discussions. But the reality is completely different. After more than three decades, normalization not only has lost much of its interest in the research papers, but also is still looking for practitioners to apply it effectively. Despite the vast amount of database literature, comprehensive books illustrating the application of normalization to effective real-world applications are still waited. This paper reflects the point of view of an Information Systems academic who incidentally has been for almost twenty years a practitioner in developing database applications. It outlines the main weaknesses of normalization and offers some explanations about the failure of a generous framework in becoming the so much needed universal guide for database designers. Practitioners might be interested in finding out (or confirming) some of the normalization misformulations, misinterpretations, inconsistencies and fallacies. Theorists could find useful the presentation of some issues where the normalization theory was proved to be inadequate, not relevant, or source of confusion. *Number of Pages in PDF File:* 41 *Keywords:* database design, normalization, functional dependencies, multi-valued dependencies, normal forms *JEL Classification:* L86, M1 working papers series 2014-11-08 Ruben <ruben.safir-at-my.liu.edu> Subject: [LIU Comp Sci] Re: Welcome to learn 2014-11-08 Ruben <ruben.safir-at-my.liu.edu> Subject: [LIU Comp Sci] second post!! 2014-11-22 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Oracle Files for the Homework and Oracle Resources 2014-11-22 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Oracle Webineir on pl/sql 2014-11-22 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] UEFI and Secure Boot 2014-11-24 Ruben <ruben.safir-at-my.liu.edu> Re: [LIU Comp Sci] Oracle DBA short cuts 2014-11-24 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Oracle DBA short cuts 2014-11-24 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Re: Database Management Systems: DBMS Announcement on Nov. 23 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Problems with Normalization 2014-11-26 Ruben <ruben.safir-at-my.liu.edu> Subject: [LIU Comp Sci] =?UTF-8?B?UmU6IERhdGFiYXNlIE1hbmFnZW1lbnQgU3lzdGVtczogQ1MgNjQ5IEE=?= 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] More problems with modeling and normalization 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Normalize because your professor said too 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Problems with Normalization 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Why Data Models Shouldn't Drive Object Models (And Vice Versa) 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Why Normalization Failed to Become the Ultimate Guide for Database 2014-11-29 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Memory Cache theory Architecture Class 2014-11-30 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Cache Model in C programming NYLXS are Do'ers and the first step of Doing is Joining! Join NYLXS and make a difference in your community today!