Database testing is very important part of testing.

Database is always on target for hackers and others.
You should always well test the database for security also.

Other tests on database are for data,

There should no loss of data when we save it.
Data limit allowed to save through UI should same; limit allowed by database.
more depends on application.

__________________
Brijesh Jain
brijesh.tester@yahoo.co.in
http://softwaretestingexpertise.blogspot.com

Good to see you back JanBrijesh I was missing your posts...

Well, the questions asked were very clear. Why do we need database testing and what kind of testing we usually do in database testing. I think Brijesh's explaination has not covered all that was needed. So, decided to post an external article on this.

What to test in DB testing?

Why DB testing ?

Here's the link for a very good article regarding this.

http://www.agiledata.org/essays/databaseTesting.html

I hope this makes one understand the concepts in DB testing.

Cheers!
Kalayama

__________________
[COLOR="Blue"][SIZE="2"]"If you are not living on the edge of your life, you are wasting space"[/SIZE][/COLOR]

Someone says "Impossible is nothing". The man next him says "Let me see you licking your elbow tip!"

Hi Rose,
Testers should do the database testing in the case of using database,
90% of the application using database.

For example, for web application or any other application some data should be stored in database, the tester is the responsible person for veryfying whether the data stored or not, and also verify that the stored data will be a valied data.

so tester or developer should know the database knowledge.

regards,
ayypss

DB testing is to test the impact of actions in the application on its database.

the list for "What to test in DB testing?" give by kalayama is correct.

__________________
Lack of WILL POWER has caused more failure than
lack of INTELLIGENCE or ABILITY.

-sutnarcha-

Hi

check this link too.

http://www.oracle.com/technology/ora...45testing.html

I found it more rational.

can any body explain in detail database tesing

Relational database management systems (RDBMSs) often persist mission-critical data which is updated by many applications and potentially thousands if not millions of end users. Furthermore, they implement important functionality in the form of database methods (stored procedures, stored functions, and/or triggers) and database objects (e.g. Java or C# instances).

The best way to ensure the continuing quality of these assets, at least from a technical point of view, you should have a full regression test performed on each build for the Database.

Noe lets see DBTesting in terms of Testing methods :

Black-Box Testing (--at the Interface)
-O/R mappings (including the meta data)
-Incoming data values
-Outgoing data values (from queries, stored functions, views ...)

White/Clear-Box Testing (--Internally Within the Database)

-Scaffolding code (e.g. triggers or updateable views) which support refactorings
-Typical unit tests for your stored procedures, functions, and triggers
-Existence tests for database schema elements (tables, procedures, ...)
-View definitions
-Referential integrity (RI) rules
-Default values for a column
-Data invariants for a single column
-Data invariants involving several columns


this was a little abt DB testing if you wanna more then can contact me with your Qs

can anyone give me a simple example for how to do database testing ,and also one testcase related to database testing

As per my knowledge the Data base testing is done when the test data is not provided from the developer to link the fileds and to do verification of the same.

For this we mainly need SQL. To get the information from the data base that is required for our application.

Regards,
Sudha

What so ever you are talking about in what we can test externally see the behavior of database.
But what's happening in real , how you will know that.
I give you an example.

I was testing an application where during registration, an hash key is generated for verification purpose,This key generated is of size 16 characters always, but space allocated for it in database is of 50 characters, which is again a bug (loss of memory).That's why we need it to test internally.

__________________
Brijesh Jain
brijesh.tester@yahoo.co.in
http://softwaretestingexpertise.blogspot.com

What is scaffolding

Supporting test code, called scaffolding.It is sometimes necessary to support an individual test.

__________________
Brijesh Jain
brijesh.tester@yahoo.co.in
http://softwaretestingexpertise.blogspot.com