Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Connecting web users to their pre-existing data

Connecting web users to their pre-existing data

From: stv <>
Date: Fri, 26 Jan 2007 15:20:43 -0700
Message-ID: <>

I'm sure this has been solved, or at least thought about, many times. But I'm not sure what terms I should be using to begin my research.

We have a ten-year-old database with 200,000 names, addresses, etc. One of our long-range goals is to properly expose user data to users so they can access it, modify it, and so forth.

Obviously, we'll want to do this via the web. Obviously we'll want to have our security procedures nailed (there's no financial data or anything dangerous like SSN anywhere in the database).

Where should I start my search for methods for connecting un-authenticated users to pre-existing data. We're a non-profit Oracle shop in the US (middle-of-nowhere). Is there a term for this process? It's not a data scrub, per se, but that is part of the process (and, hopefully, part of the outcome as users connect to their data and update it).

We maintain old address/phone/email information in our database. We also maintain a lot of "relationships"--parents-children and spouse-spouse--with the same address information (but kids move out and so do spouses).

We also have data unique to our organization (courses: title, date, location etc). Right now address changes are done via a simple form-email. User queries about their course history are handled over the phone or email.

Our first step will be to get a major update of all our address data via one of the credit bureaus (Trans Union). This will allow us to have up-to-date data users can verify/correct.

Following that, there are several options:

I realize this is vague. What I'm looking for is direction: search terms, general patterns, industry standards, etc.

--Steve Smith (stv)

Received on Fri Jan 26 2007 - 16:20:43 CST

Original text of this message