Results 1 to 14 of 14

Thread: Database Testing

  1. #1
    Junior Member
    Join Date
    Nov 2005
    Answers
    28

    Database Testing

    Shall testers need to do a Database Testing on an application?
    1.What is the purpose of such a testing??
    2.What all testing need to be done on DB??



  2. #2
    Moderator
    Join Date
    Sep 2006
    Answers
    920

    Re: Database Testing

    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.

    Last edited by jainbrijesh; 11-20-2007 at 03:19 AM.
    Regards,
    Brijesh Jain
    ---------------------------------------------------------
    Connect with me on Skype: jainbrijesh
    Google Plus : jainbrijeshji

  3. #3
    Expert Member
    Join Date
    Sep 2006
    Answers
    477

    Re: Database Testing

    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?

    In DB testing we need to check for
    1. The field size validation
    2. Check constraints.
    3. Indexes are done or not (for performance related issues)
    4. Stored procedures
    5. The field size defined in the application is matching with that in the db.
    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!"

  4. #4
    Junior Member
    Join Date
    Jan 2007
    Answers
    4

    Re: Database Testing

    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


  5. #5
    Junior Member
    Join Date
    Nov 2005
    Answers
    28

    Re: Database Testing

    Thanks Kalayama for that article..It was worth reading

    But letme tell u frankly that Iam new to DB testing....So before Testing a DB
    I should know
    1.Why shall I test a DB??If we can look in to the UI and see if the data we enter through UI is getting reflecting in the UI and
    When we delete something from UI...it again can be seen in the UI...So Shall we need to test it to see that the data flow is proper??
    2.What all other purposes Database Testing serve for??
    (Its clearly mentioned in the article...but superficial for a beginner to understand)

    Will be helpful if anyone explain it clearly



  6. #6
    Expert Member
    Join Date
    Nov 2006
    Answers
    518

    Re: Database Testing

    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-

  7. #7
    Expert Member
    Join Date
    Apr 2006
    Answers
    124

    Re: Database Testing

    Hi

    check this link too.

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

    I found it more rational.


  8. #8
    Junior Member
    Join Date
    Aug 2007
    Answers
    2

    database testing

    can any body explain in detail database tesing


  9. #9
    Contributing Member
    Join Date
    Feb 2006
    Answers
    85
    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

    Last edited by jainbrijesh; 11-22-2007 at 01:30 AM.

  10. #10
    Junior Member
    Join Date
    Nov 2007
    Answers
    1

    Re: Database Testing

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


  11. #11
    Junior Member
    Join Date
    Nov 2007
    Answers
    2

    Re: 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


  12. #12
    Moderator
    Join Date
    Sep 2006
    Answers
    920

    Re: Database Testing

    Quote Originally Posted by rose View Post
    Thanks Kalayama for that article..It was worth reading

    But letme tell u frankly that Iam new to DB testing....So before Testing a DB
    I should know
    1.Why shall I test a DB??If we can look in to the UI and see if the data we enter through UI is getting reflecting in the UI and
    When we delete something from UI...it again can be seen in the UI...So Shall we need to test it to see that the data flow is proper??
    2.What all other purposes Database Testing serve for??
    (Its clearly mentioned in the article...but superficial for a beginner to understand)

    Will be helpful if anyone explain it clearly
    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.

    Regards,
    Brijesh Jain
    ---------------------------------------------------------
    Connect with me on Skype: jainbrijesh
    Google Plus : jainbrijeshji

  13. #13
    Junior Member
    Join Date
    Sep 2007
    Answers
    1

    Re: database testing

    What is scaffolding


  14. #14
    Moderator
    Join Date
    Sep 2006
    Answers
    920

    Re: Database Testing

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

    Regards,
    Brijesh Jain
    ---------------------------------------------------------
    Connect with me on Skype: jainbrijesh
    Google Plus : jainbrijeshji

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact