X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 6FA24D1B56A for ; Thu, 9 Oct 2003 11:51:38 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 00339-02 for ; Thu, 9 Oct 2003 08:50:54 -0300 (ADT) Received: from news.hub.org (unknown [64.117.224.194]) by svr1.postgresql.org (Postfix) with ESMTP id 84BC5D1B52E for ; Thu, 9 Oct 2003 08:50:51 -0300 (ADT) Received: from news.hub.org (host-64-117-224-194.altec1.com [64.117.224.194] (may be forged)) by news.hub.org (8.12.9/8.12.9) with ESMTP id h99BopQh052086 for ; Thu, 9 Oct 2003 11:50:51 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id h99BiGXc050951 for pgsql-performance@postgresql.org; Thu, 9 Oct 2003 11:44:16 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.performance Subject: Re: Compare rows Date: Thu, 09 Oct 2003 07:41:28 -0400 Organization: cbbrowne Computing Inc Lines: 32 Message-ID: References: <3F841A28.8060504@cranel.com> <200310081611.59179.josh@agliodbs.com> <200310082236.59305.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1003 (Gnus v5.10.3) XEmacs/21.4 (Reasonable Discussion, linux) Cancel-Lock: sha1:za8sSPx7iWy7lQcTUIlgPHc980I= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/264 X-Sequence-Number: 4012 The world rejoiced as josh@agliodbs.com (Josh Berkus) wrote: > Chris, >> Some time in the late '80s, probably '88 or '89, there was a paper >> presented in Communications of the ACM that proposed using this sort >> of "hypernormalized" schema as a way of having _really_ narrow schemas >> that would be exceedingly expressive. They illustrated an example of > >> The entertaining claim was that they felt they could model the >> complexities of the operations of any sort of company using not >> more than 50 tables. It seemed somewhat interesting, at the time; >> it truly resonated as Really Interesting when I saw SAP R/3, with >> its bloat of 1500-odd tables. > > One can always take things too far. Trying to make everying 100% > dynamic so that you can cram your whole database into 4 tables is > going too far; so is the kind of bloat that produces systems like > SAP, which is more based on legacy than design (I analyzed a large > commercial billing system once and was startled to discover that 1/4 > of its 400 tables and almost half of the 40,000 collective columns > were not used and present only for backward compatibility). With R/3, the problem is that there are hundreds (now thousands) of developers trying to coexist on the same code base, with the result tables containing nearly-the-same fields are strewn all over. It's _possible_ that the design I saw amounted to nothing more than a clever hack for implementing LDAP atop a relational database, but they seemed to have something slightly more to say than that. -- wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','ntlug.org'). http://www3.sympatico.ca/cbbrowne/emacs.html Why does the word "lisp" have an "s" in it?