X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B96FD8B9CAD for ; Tue, 22 Feb 2005 21:05:12 +0000 (GMT) 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 10768-06 for ; Tue, 22 Feb 2005 21:05:02 +0000 (GMT) Received: from polaris.pinpointresearch.com (66-7-238-130.cust.telepacific.net [66.7.238.130]) by svr1.postgresql.org (Postfix) with ESMTP id 5F3A58B9C9E for ; Tue, 22 Feb 2005 21:05:03 +0000 (GMT) Received: from betelgeuse.pinpointresearch.com (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id EBF19103F4; Tue, 22 Feb 2005 13:05:02 -0800 (PST) From: Steve Crawford Organization: Pinpoint Research To: Heather Johnson Subject: Re: How to Prevent Certain Kinds of Joins? Date: Tue, 22 Feb 2005 13:05:02 -0800 User-Agent: KMail/1.5.1 Cc: pgsql-general@postgresql.org References: <421B8D2D.6050800@nypost.com> <20050222200915.GA71591@winnie.fuhr.org> <421B9674.4060807@nypost.com> In-Reply-To: <421B9674.4060807@nypost.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200502221305.02629.scrawford@pinpointresearch.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.125 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/1176 X-Sequence-Number: 73980 On Tuesday 22 February 2005 12:30 pm, Heather Johnson wrote: > One of the tables contains personally identifiable information > (PII) (e.g., email, first and last name, etc.). The other contains > "click stream" data (information about where on our website users > have gone). In order to be sensitive to users privacy, we don't > want to ever (even accidentally) run queries that would combine PII > and click stream data. So we're looking for ways to put "walls" up > against combining the data. We understand that anyone with ample > access to the database can deliberately combine the data if they > chose to do so in blatent violation of our policies. But we want to > set something up that would put an obstacle or two in the path of > anyone who might accidentally run such a query. How about separate databases? If there is absolutely no need to "relate" the data in two tables, I can't see much reason other, perhaps, than convenience of user/group management to have them both in the same database. This _will_ prevent joins as long as you don't install the contrib/dblink module. Of course anyone with access to both pieces of data can still export the data and reimport it to whatever database system they want in order to combine the data.