Post reply

How do you test a database ?

  • May 9, 2004 at 11:49 pm

    #108178

    Hi Friends,

    Someone asked me a (simple) question

    How do you test a database ?

    What should i answer to that person ?

    Bobby

  • May 10, 2004 at 5:50 am

    #505767

    There are several sorts of test.

    • Does the database do what it says it should do in the functional requirement spec.
    • Bounds testing.  What happens if I try and enter silly values in the database (hopefully the front end app should trap these before they get near the database).
    • Stress test/capacity testing.  How many users can my database handle.
    • Security tests.
    • Coding standards tests.  Is your code commented, have you used qualified object names (owner.object), have you conformed to your company standard.
    • Stored procedures test.  Do they work for all combinations of parameters?

     

    LinkedIn Profile

  • May 10, 2004 at 12:23 pm

    #505855

    I would also add to the list:

    Backup and restore testing, along with transaction dumps and differentials (if used.) PRACTICE restoring and applying these. Also, update (or create) Disaster recovery procedures for the database/server and them.

     

  • May 11, 2004 at 8:07 am

    #505975

    Don't forget those indexes. No point in building the best application in the world if runs like a pig.

    Get the right indexes in the right places set at the optimum level and test thoroughly.

    Don't isolate this testing to the apllication side testing!

    ------------------------------
    The Users are always right - when I'm not wrong!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply