Re: How to make data unidentifiable?

On 9 Jun 2004 10:00:49 -0700, j_parrinello_at_msn.com (Joseph) wrote:

>Hello,
>
>I am building a database to be used for demonstration purposes. I wish to
>import the data from an existing database into the demo. However I need to
>tranform the data from the existing database so that the data is
>unidentifiable but meaningful. For example, I need to change the First
>name, Last name, Address, city, state, zip, Social Security etc...so that
>they are different to the original database but still have meaning in the
>new database. E.g. A record such as:
>
>Peter Paulas, 123 Main St, New York, New York, 10023, 555-342-3423
>becomes something like:
>Simon Trickle, 234 East St, Bronx, New York, 10023, 534-234-2333
>
>I would like the transformed record: Simon Trickle, to still be linked to
>the remaining data that is not tranformed. Has anybody tried this before
>and if so, do you have any easy solution.
>
>Thanks,
>Joseph

Oracle supplies a dbms_obfuscation_toolkit for this very purpose.

--
Sybrand Bakker, Senior Oracle DBA