Practical techniques and test methods for database testing _ database Other

Similarly in the financial, leasing, retail, mailing, medical field, the database is also indispensable.

As the complexity of the application increases, a stronger and more secure database is required to meet the requirements. In order to meet high frequency application transactions (such as banking or financial applications), the security of the database is the primary priority.

At present, there are many active database tools in the market, such as Ms-access2010,ms SQL Server2008 r2,oracle 10g,oracle financial,mysql,postgresql,db2 and so on. They have their own advantages in cost, reliability, functionality, and security.

The following is a brief introduction to the operations that the ' CRUD ' represents in the database.

C: Create-Create user.

R: Retrieving--performing a retrieval view operation.

U: Update--Update database information.

D: Delete--Perform the delete database operation.

All four of these operations are used by universal users when manipulating data.

Database Test Preparation work:

ACID Properties

ACID, an abbreviation for the four basic elements that a database transaction performs correctly. Includes: atomicity (atomicity), consistency (consistency), isolation (isolation), persistence (durability). These four elements must be tested during database testing to ensure that they are correct.

Data integrity

Consider that applications of different modules use the same data in different ways and perform all crud operations on the data. Ensure that the data contained in the database is as accurate and consistent as possible, which is data integrity.

Business Accuracy

Database development So far, is no longer simply used to store records. In fact, the database system has developed into a powerful tool, providing developers with enough extended support. The database system has more powerful features than before, such as referential integrity, relational constraints, triggers, and stored procedures.

How to test a database:

Create a query

To test the correctness and accuracy of the test database. First, testers should be proficient in SQL and DML (database language) statements. Second, testers should master the structure of the database. If these two conditions are met, the test can be assured. Applications developed for small and medium sized technologies are a good test method. In addition, if the program is relatively complex, testers need help from the developer. But I suggest that you start testing from the beginning, with both confidence and the ability to improve your own SQL technology.

Querying data tables

Testers can verify the operation results of the application GUI by viewing the data table. However, this approach is quite tedious and tedious for databases with large amounts of data. Validating multiple data tables is also quite difficult.

Query from Developers

This is the easiest way to test the database, performing any crud operations from the GUI and executing their own SQL queries, obtaining validation from developers and their results. This approach seems to be the best way to test your database. If a developer queries out a statement error or does not meet the user's requirements, you can modify the error statement as soon as possible.

Summarize

A database is a core part of every software program. Database testing has been highly valued and testers need to have good SQL technology. In order to ensure that the test results are correct, the above four elements should be assigned to different testers to cross test to ensure foolproof. (Zhang Yi/compiling)

Original link: softwaretestinghelp.com