Database cleaning software


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Database cleaning software
# 1  
Old 03-15-2005
Database cleaning software

Hi everybody,

I have been given a task to find the names of some products that can clean up databases by removing confidential information. The situation is that a client imports data from public sources (government websites, etc.) but that this data sometimes includes things like Social Security Numbers or other confidential data that must not be kept in the database for privacy reasons.

I've checked google, CNet reviews, and Oracle's website looking for suggestions but haven't turned up too much. Does anybody here work with or know of such software packages that can be used to clean up your database to prevent privacy compliance issues?

Thanks,
Ralph
 
Login or Register to Ask a Question

Previous Thread | Next Thread

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

cleaning the file

Hi, I have a file with multiple rows. each row has 8 columns. Column 8 has entries separated by commas. I want to exclude all the rows in which column 8 has more than 3 commas. 1234#0/1 - ABC_1234 3 ATGCATGCATGC HHHIIIGIHVF 1 49:T>C,60:T>C,78:C>A,76:G>T,65:T>G Thanks, Diya (3 Replies)
Discussion started by: Diya123
3 Replies

2. Shell Programming and Scripting

File cleaning

HI , I am getting the source data as below. Source Data CDR_Data,,,,, F1,F2,F3,F4,F5,F6 5,5,6,7,8,7 6,6,g,,, 7,7,76,,, 8,8,gt,,, 9,9,df ,d,d,d ,,,,, (4 Replies)
Discussion started by: wangkc
4 Replies

3. UNIX for Dummies Questions & Answers

AWK Data Cleaning

Hello, I am trying to analyze data I recently ran, and the only way to efficiently clean up the data is by using an awk file. I am very new to awk and am having great difficulty with it. In $8 and $9, for example, I am trying to delete numbers that contain 1. I cannot find any tutorials that... (20 Replies)
Discussion started by: carmar87
20 Replies

4. SCO

Tape drive cleaning

Hello everyone, First, thank you anyone who might be able to help : ) !! here it is, I am using SCO at my business, and I back up everything to a tape drive. I want to do my cleaning of the drive, and i put in the cartridge to the drive, it recognizes it yet it will not engage the... (5 Replies)
Discussion started by: RichardHeadd
5 Replies

5. UNIX for Dummies Questions & Answers

Cleaning file system

Hello all, I have a crontab entry to clean up a file system once a week that is used as tmp directory. 00 12 * * 0 find /mytmp -mtime +2 -exec rm {} \; The job starts ok but I always get an error message in mails because it is a file system and there is a directory lost+found that should... (1 Reply)
Discussion started by: qfwfq
1 Replies

6. AIX

doing some spring cleaning....

USERS="me you jim joe sue" for user in ${USERS}; do rmuser -p $user usrdir=`cat /etc/passwd|grep $user|awk -F":" '{ print $6 }'` rm -fr `cat /etc/passwd|grep $user|awk -F":" '{ print $6 }'` echo Deleting: $user '\t' REMOVING: $usrdir done This is for AIX ONLY!!! but easily ported to... (0 Replies)
Discussion started by: Optimus_P
0 Replies
Login or Register to Ask a Question
namespace::autoclean(3pm)				User Contributed Perl Documentation				 namespace::autoclean(3pm)

NAME
namespace::autoclean - Keep imports out of your namespace SYNOPSIS
package Foo; use namespace::autoclean; use Some::Package qw/imported_function/; sub bar { imported_function('stuff') } # later on: Foo->bar; # works Foo->imported_function; # will fail. imported_function got cleaned after compilation DESCRIPTION
When you import a function into a Perl package, it will naturally also be available as a method. The "namespace::autoclean" pragma will remove all imported symbols at the end of the current package's compile cycle. Functions called in the package itself will still be bound by their name, but they won't show up as methods on your class or instances. This module is very similar to namespace::clean, except it will clean all imported functions, no matter if you imported them before or after you "use"d the pragma. It will also not touch anything that looks like a method, according to "Class::MOP::Class::get_method_list". If you're writing an exporter and you want to clean up after yourself (and your peers), you can use the "-cleanee" switch to specify what package to clean: package My::MooseX::namespace::autoclean; use strict; use namespace::autoclean (); # no cleanup, just load sub import { namespace::autoclean->import( -cleanee => scalar(caller), ); } PARAMETERS
-also => [ ITEM | REGEX | SUB, .. ] -also => ITEM -also => REGEX -also => SUB Sometimes you don't want to clean imports only, but also helper functions you're using in your methods. The "-also" switch can be used to declare a list of functions that should be removed additional to any imports: use namespace::autoclean -also => ['some_function', 'another_function']; If only one function needs to be additionally cleaned the "-also" switch also accepts a plain string: use namespace::autoclean -also => 'some_function'; In some situations, you may wish for a more powerful cleaning solution. The "-also" switch can take a Regex or a CodeRef to match against local function names to clean. use namespace::autoclean -also => qr/^_/ use namespace::autoclean -also => sub { $_ =~ m{^_} }; use namespace::autoclean -also => [qr/^_/ , qr/^hidden_/ ]; use namespace::autoclean -also => [sub { $_ =~ m/^_/ or $_ =~ m/^hidden/ }, sub { uc($_) == $_ } ]; SEE ALSO
namespace::clean Class::MOP B::Hooks::EndOfScope AUTHOR
Florian Ragwitz <rafl@debian.org> CONTRIBUTORS
o Andrew Rodland <andrew@hbslabs.com> o Chris Prather <cprather@hdpublishing.com> o Dave Rolsky <autarch@urth.org> o Felix Ostmann <sadrak@sadrak-laptop.(none)> o Karen Etheridge <ether@cpan.org> o Kent Fredric <kentfredric@gmail.com> o Shawn M Moore <sartak@gmail.com> o Tomas Doran <bobtfish@bobtfish.net> COPYRIGHT AND LICENSE
This software is copyright (c) 2009 by Florian Ragwitz. This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself. perl v5.18.2 2013-12-14 namespace::autoclean(3pm)