Image CAPTCHA
Enter the characters shown in the image.

You are here

Error message

Deprecated function: The each() function is deprecated. This message will be suppressed on further calls in _menu_load_objects() (line 579 of /home/aufr/public_html/includes/menu.inc).

Database Testing

Database testing is a layered process

It consists of 4 layers: A)User Interface, B)Business layer, C)Data access layer, D)Database archive.

We can target our testing on specific layer or do black box testing on all layers according to user expectancy of the data flow.

Many system and web softwares access databases from different back-ends. Testing productivity process is very difficult for client-server databases or web-based databases.

Data access layer is the only layer that deals with the database directly. The UI layer deals with the user, and the business layer verifies that the business rules and strategies are kept. And therefore, most of the database testing effort is on the data access layer.

 

The points why we need database testing are as follows:

1.       Data is very important from business point of view. Most of the big companies such as Google, Symantec who deal with storage of databases should have durable and consistent databases. If the database operations such as insert, delete, update are performed without testing the database for its consistency, then the entire database may crash.

2.       There are companies that have different types of database for different goals and mission. So, testing is necessary in order to verify that the system will work in order to achieve those targets and missions.

3.       Testing to verify that the process was not slowed down, with the new layer of development.

4.       Application with few databases has more risk of communication and synchronization problems, and therefore testing is needed.

5.       Database was upgraded. Data integrity must be verified.

           We can divide all testing types into 2 categories: Black box testing and White box testing.

Black box testing  involves testing interfaces, integration of the databases, which includes:

·         Mapping of data including meta data

·         Verifiying incoming data from data load.

·         Verifiying out going data from queried function.

Various techniques such as Cause effect graphing technique, Equivalence partitioning and boundary value analysis are used. With the help of these techniques,we can independently test the functionality of the database.

White box Testing mainly deals with the internal structure of the database. The specification details are hidden from the user.

It involves:

·         Testing the database triggers, logical views which are going to support database refactoring.

·         Performing module testing of our database functions,triggers,views, SQL queries etc.

·         Validating the database tables,data models,database schema etc.

·         Verify Rules of Referential integrity

·         Test database consistency

The techniques used in white box testing are Condition coverage, Decision coverage, Statement coverage, Cyclomatic complexity.

While generating the test cases for database testing, the semantic of SQL statement needs to be included in resulting test cases. For that purpose, a technique called White box database application technique (WHODATE) is used. SQL statements are independently converted into GPL statements, followed by traditional white box testing to generate test cases which include SQL semantics.

 

Media: 

MANUFACTURERS Wallboard

Testing tool manufacturers world-wide list
10Levels ABID CONSULTING AccelQ Accord Software ActiMind AdaCore
AdaLog AgileLoad AgileWay Agitar Algorismi ALL4TEC
Andreas Kleffel Android Apache Apica Apollo Systems AppAssist.mobi
Applitools AppPerfect Appsee ApTest Assertible Assure
Atlassian AutoIt Consulti .. Automation Anyw .. Automation Cons .. Axosoft Aztaz Software
Backtrace I/O Badboy BlazeMeter Borvid BrowserStack BSQUARE
BStriker Intern .. CA Technologies Canonical Canoo Engineeri .. Catch Software CelestialTeapot
Chris Mallett Cleanscape ClicTest CloudQA Codeborne CodeCentrix
CodePlex projec .. Codoid Cogitek Compuware Configure IT Conflair
ConSol Core Services Coronys Ltd Countersoft CresTech Softwa .. CrossBrowserTes ..
Crosscheck Netw .. Crowdsourced Te .. Cucumber Ltd Cyara Cygnet Infotech DareBoost
Databene Datamatics Glob .. DevExpress DTM soft Dynatrace LLC EasyQA
Eclipse EkaTechserv Elvior Emmanuel Jorge Empirix EPAM Systems
Equafy Esterel Technol .. eXept Software .. Experitest Finaris Froglogic
FrontEndART Ltd GeneXus GitHub project gnoso Google Code Pro .. GrammaTech
Gurock Software HelpSystems HENIX Hewlett Packard .. Hexawise High-Tech Bridg ..
Hiptest Hitex IBM Rational imbus Shanghai Impetus Inflectra
informUp InTENSO - IT Ex .. Ipswitch Jamo Solutions Janova JAR Technologie ..
JBoss Developer jClarity Jellly.io JetBrains Jively jQuery foundati ..
JS Foundation Jspresso Kanoah KMS Technology Kualitee LDRA Limited
Litmus LoadFocus Loadster Perfor .. MarathonITE Marketcircle Marketcircle
Maveryx Meliora Ltd Micro Focus Sof .. Microsoft Mobile Labs Mobile1st
Mockaroo, LLC Monkop Mozila MSys Technologi .. Navicat NeoTys
Neowise Softwar .. NetCart NORIZZK.COM Novosync Mobili .. NRG Global NTT Resonant
OC Systems Odin Technology OpCord Oracle Orcanos Original Softwa ..
OW2 PANAYA Parasoft PassMark Patterson Consu .. Perfecto Mobile
Pivotal, Inc. Plutora Postman (API To .. PractiTest PrimaTest Process One
Programming Res .. Psoda PureLoad PushToTest Python Q-Assurance
QA Systems QACube QASymphony QAWorks QMetry Quali
Qualitia Softwa .. Quality First S .. Quotium RadView Softwar .. Ranorex RedLine13
Reflective Solu .. ReQtest RevDeBug Robotium Tech Rogue Wave Soft .. Rommana Softwar ..
RTTS ruby-doc.org Runscope Sandklef GNU La .. Sauce Labs Seapine Softwar ..
SeleniumHQ Sencha Sensiple Siemens PLM Sof .. SmartBear Softw .. SmarteSoft
SOASTA SoftLogica Softomotive Softsmith Solution-Soft SonarSource
Sourceforge Spirent Technol .. SQS Software Qu .. Square Stimulus Techno .. Swifting AB
Synopsys T-komp T-Plan TechExcel TechTalk Telerik By Prog ..
Tellurium Test Collab Test Goat Test Recon TestCaseLab testCloud.de Gm ..
TestCraft Techn .. Testenium Testim.io TestingBot TestLodge Testmunk
Testomato TestOptimal TestPlant TestPro Testsigma Techn .. Testuff
The Core Bankin .. The MathWorks The Open Group thePHP.cc Thoughtbot Thoughtworks
Tigris.org Time Simulator Top-Q Trace Technolog .. TrendIC TRICENTIS
Tritusa Pty Ltd TWD Solutions P .. TypeMock Tyto Software Ubertesters UniTESK
Universal Test .. Usetrace Ltd Utrecht Univers .. Validata Group Vanamco AG Vector Software
Veracode Verifaya Corpor .. Verit VersionOne Viewlike.us Vornex Inc.
Watir.com WcfStorm Soluti .. We Are Mammoth Web Performance .. Wintask Wireshark Found ..
Worksoft Xceptance XK72 Xpand IT XQual ZAPTEST
Zeenyx Software .. Zephyr Zeta Software zutubi pty

Theme by Danetsoft and Danang Probo Sayekti