We help IT Professionals succeed at work.

Database Cleansing

Medium Priority
664 Views
Last Modified: 2013-11-15
Hi,

We are looking to reduce our database size by removing all our duplicate records of which there are quite a few.

Im going to use mobile phone number to identify the duplicates so Im after a way of first identifying the duplicates and then either moving to a 2nd database or just simply removing them.

Is this something which can be done within Goldmine or will this be a backend process?

Thanks
dw
Comment
Watch Question

GMGeniusSoftware Development Manager/Developer
CERTIFIED EXPERT

Commented:
Goldmine has a de-duplication process built in, you could create a filter to pick up all contacts with a mobile number then using the de-dupe process you can merge duplicates together.

Alternativly you could find the duplicates another way (by hand or using SQL) - mark these records by putting something in a field. Then using a filter to find these you could move them to another database (you would need to create this Database first), you can then use the tools >  copy - move records.

Author

Commented:
Sounds interesting, how does the merge work, does it delete the orphaned record - will the process utlimately reduce the database size or just hide the duplicate entries?

Im doing this process to improve the performance of our DB so Im guess the smaller the database the better it runs - hence the request to remove the duplicates.

Software Development Manager/Developer
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks GMG, I will read and get back to the thread this Thursday

Author

Commented:
Ive had a read of the help file and like what Im reading, Im going to perform the process after last day of the month (just in case!)

Thanks GMG.;

Author

Commented:
Thank you.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.