What is the biggest pitfall when performing cloud database testing?

What is the biggest pitfall to avoid when executing cloud database testing? That is, when the database is hosted within the cloud, what sort of challenges should software testers expect?

Requires Free Membership to View

Amy Reichert

Make sure the testing environment has an exact replica of the production database. By "exact," I mean exact. Not close, not similar, not "basically the same." It has to be exact. Otherwise, you're not testing your application as it will perform for your users, including not testing the performance, accessibility or availability of your production database.

If there is a cloud database for the application, you can also host a test database in the cloud that mimics production. It's the only way to ensure your team is testing the application as it'll behave for a user. You will need to use test data rather than live production data because of privacy and confidentiality regulations. Ask your database testing team to provide masked test data to replace production data so you do not break any privacy or confidentiality rules applied to your type of software.

If there is a cloud database for the application, you can also host a test database in the cloud that mimics production.

By "masked," I am referring to data masking. Data masking provides protection from breaching sensitive information when copying production data to test environments. Masking removes the original data with fictitious data so it can be used for testing. Unlike data encryption -- or a virtual private database where data is hidden but can be retrieved with access -- data masking removes the ability to access the original data at all.

Taking the time to verify a data breach is an extremely expensive and reputation-damaging mistake for a company of any size. Use the rule of thumb: Trust but verify. Your test team is part of the larger development team. Team members need to trust each other, but it is more critical to the company that confidential data is not breached, so always verify that the data has been masked.

Data masking allows you to neutralize sensitive data records and still have usable data for cloud database testing -- data that resembles the original in appearance and integrity. This ensures applications are fully tested while removing the risk of unauthorized access to the original data. For more information on data masking for Oracle systems, go to section 15 of its user guide.

Do you have a question for our software quality testing experts? Let us know by emailor ping us on Twitter @SoftwareTestTT.

This was first published in June 2013

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: