Database testing in Software testing

The basic structure of data in a database

Definition one: The relationship of elements in a collection of data elements (also known as data Objects).

Definition two: A collection of data elements that have a particular relationship to each other.

A table (database), we call it a data structure, it consists of many records (data elements), each element also includes many fields (data items) composed of database test classification system test, integration test, Unit test, functional test, performance test, Safety test system test, The database needs to be analyzed and tested in the initial design.

The basic definition of database structure is to perfect the integration of various data elements and clarify the relationship between each other.

In the database, there is an established special relationship between different data, which belongs to a collection of various data elements. For a database, it can be called data structure, which will be composed of a large number of data element records, and each element can be divided into many fields, in the composition of the database, the overall can be divided into system testing, integration testing, unit testing, functional testing, performance testing, security testing and database testing.

Stored procedures, views, triggers, constraints, rules, etc. we all need to verify that these features are designed to meet the requirements.

Verify that the database design document is the same as the final database, and we also want to verify that the changes are implemented on the database when the design document changes.

Database design review to implement integration testing

The modification of data items, the addition of data items, the deletion of data items, the addition of data tables, the deletion of empty data tables, the deletion of records in an empty table, the concurrency of data tables, the interface test for stored procedures, and the interface test of relational tables in conjunction with business logic require that these interfaces be considered with equivalence classes, boundary values, Test unit testing by means of error guessing, etc.

? Unit tests focus on logical overrides, and unit tests for database development are relatively straightforward

– Statement Overrides

– Function testing by way of the daytime

? DBunit

– An open-source database Functional Testing framework that allows you to verify the input and output by using a white-box unit test of the basic operations of the database in a similar manner to JUnit.

? QTP

– By capturing the object, we can simulate the user's operation flow through the QTP, and test the data in the whole database through the verification method or the monitoring of the database background.

? DataFactory

An excellent database data automatic generation tool, through which you can easily build arbitrary database, populate the database, help you to generate the large amount of data needed to verify the function in our database is correct. This is part of the black box test.

Database performance

? Performance optimization in 4 parts

Physical storage aspects, logical design aspects, database parameter tuning, SQL statements to optimize database performance.

? SQL statement Analysis tool for database system to analyze the bottleneck of database statement execution to optimize SQL statement

? LoadRunner

Stress test the database by programming the Protocol

? Swingbench

specifically for Oracle

? ORACLE11G provides real application test, database performance test, analysis System Application bottleneck database security test

? SQL injection attacks, cross-site scripting attacks, unauthorized user access to so-called SQL injection (SQL injection), is to use the programmer to the legality of user input data detection is not strict or non-detection characteristics, intentionally from the client to submit special code, so as to collect program and server information, To get the information you want. Usually the goal of an ulterior motive is to get the webmaster's account number and password.

Database testing in Software testing