X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B93EBD1B38E for ; Wed, 28 Jul 2004 09:20:44 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 23230-04 for ; Wed, 28 Jul 2004 12:20:18 +0000 (GMT) Received: from mail.gmx.net (pop.gmx.net [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 646F3D1B74A for ; Wed, 28 Jul 2004 09:20:13 -0300 (ADT) Received: (qmail 30846 invoked by uid 65534); 28 Jul 2004 12:20:15 -0000 Received: from p5087EE47.dip0.t-ipconnect.de (EHLO hermes.hilbert.loc) (80.135.238.71) by mail.gmx.net (mp015) with SMTP; 28 Jul 2004 14:20:15 +0200 X-Authenticated: #1433807 Received: (from ncq@localhost) by hermes.hilbert.loc (8.11.6/8.11.6/SuSE Linux 0.5) id i6SC42a01311 for pgsql-sql@postgresql.org; Wed, 28 Jul 2004 14:04:02 +0200 Date: Wed, 28 Jul 2004 14:04:02 +0200 From: Karsten Hilbert To: pgsql-sql@postgresql.org Subject: Re: surrogate key or not? Message-ID: <20040728140402.A607@hermes.hilbert.loc> References: <1090325769.3241.27.camel@dicaprio.akademie1.de> <002801c472fc$be62af40$7201a8c0@mst1x5r347kymb> <20040726223441.T699@hermes.hilbert.loc> <04072711335024.01150@thenilgiris.com> <001f01c47442$4dd673a0$7201a8c0@mst1x5r347kymb> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <001f01c47442$4dd673a0$7201a8c0@mst1x5r347kymb> User-Agent: Mutt/1.3.22.1i Re-X-turn-receipt-to: Karsten.Hilbert@gmx.net Di-X-sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi-X-rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri-X-ority: 2 (High) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/235 X-Sequence-Number: 18487 > retrievable. I imagine a system whereby you define keywords and attributes > for them (attributes would be an episode date, or dosage, etc). This is pretty much exactly what we are working on. We are factoring out data into dedicated tables where that is possible due to the structured nature of the data and store the remaining narrative as TEXT with associated attributes of all kinds. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346