Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!news.tele.dk!news.tele.dk!small.news.tele.dk!news.astraweb.com!newsrouter-eu.astraweb.com!border1.nntp.ams.giganews.com!nntp.giganews.com!proxad.net!news.clara.net!wagner.news.clara.net!nntp-peering.plus.net!ptn-nntp-feeder03.plus.net!ptn-nntp-spool02.plus.net!ptn-nntp-spool01.plus.net!ptn-nntp-reader03.plus.net!not-for-mail
Date: Fri, 03 Mar 2006 16:20:14 +0000
From: bugbear <bugbear@trim_papermule.co.uk_trim>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.12) Gecko/20050922 Fedora/1.7.12-1.3.1
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: slightly OT - cleaning up "dirty" keys?
References: <4405a556$0$3558$ed2619ec@ptn-nntp-reader03.plus.net>   <1141337909.206964.158370@t39g2000cwt.googlegroups.com>   <4408291a$0$70321$ed2619ec@ptn-nntp-reader03.plus.net> <1141395060.427234.4320@j33g2000cwa.googlegroups.com>
In-Reply-To: <1141395060.427234.4320@j33g2000cwa.googlegroups.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 19
Message-ID: <44086cbe$0$70293$ed2619ec@ptn-nntp-reader03.plus.net>
Organization: Customer of PlusNet plc (http://www.plus.net)
NNTP-Posting-Host: d0333194.ptn-nntp-reader03.plus.net
X-Trace: DXC=YM<=bd9\CUVn4VhQn\O2iYigd3Y`7Rb;^@`8gV4CC7IWfeJ;AX9aGU\FN_TS@8eEfSMcHWBhHIbdPhD\f7VD0?^Z
X-Complaints-To: abuse@plus.net
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:262716

EdStevens wrote:
> And that means looking at the human factors as well.  Not knowing anything about
> the application, I'm wonder WHY the operators are failing to find an
> existing record and end up createing a duplicate.  

There's an automatic feed from external sources, which
include all the "secondary" data (address, phone etc).

If the (primary)name doesn't match, a new record is created,
from all the fields in the external feed.

Combine this with multiple external sources,
run for 5 years, and you have a mess.

That's where I'm STARTING.

Now I have to "make it better".

    BugBear