Centiq Blog

Centiq Blog

Apr 15
2009

If your test system isn't legal how do you fix it?

Posted by: Alastair Williams in Application and Database

Tagged in: Security

Alastair Williams

Using production data for test and development could be illegal under the Data Protection Act or European Human rights laws, however what are the alternatives?

Three choices are available; create new data, encryption/scrambling and masking.

Creating new data is too time consuming in the first place let alone trying managing it on an ongoing basis.

Encryption seems the easiest but does it actually do the job? Encrypting the database protects the data until it is presented to the user and whilst encrypting the presentation layer hides the data it can significantly lower the viewer's ability to work with the information. Users who see "g5hfy7Hss9" in a name field are more likely to focus on this information as an "error" rather than the functionality of the screen.

Masking the data, with relationally aware tools when the test data is created, removes the presence of sensitive data and therefore the risk of inappropriate access in this environment whilst keeping the context of the data intact, even across multiple databases. If at the same time you are able to both right size the test environment and provide rapid comparison reports  to test the impact of changes, implementing data privacy could actually reduce your IT costs.

Hits: 5399
Trackback(0)
Comments (0)Add Comment

Write comment

security code
Enter the displayed characters


busy

Request more information

Want us to contact you right now?

Leave your details and we'll call you Immediately during work hours.

Name: *
Company:
Phone: *

Bloggers

Emily MalbonEmily Malbon:
Helpdesk and Support

Rebecca PritchardRebecca Pritchard:
Project Management

Robin WebsterRobin Webster:
UNIX

Steven CalvertSteven Calvert:
Storage

Steve StringerSteve Stringer:
Blade and SAP BWA

Glyn HeathGlyn Heath:
IT Industry

Tags

 Centiq Technical Wiki Site  Centiq is a 2012 IBM Beacon award winner and IBM Premier Business partner specialising in System x, Power and SAP BWA smarter_monitiq_logo v2 preferred partner_2012_solid_blue_vert_png accredit_uk_logo v2