How do you test a database ?
-
Hi Friends,
Someone asked me a (simple) question
How do you test a database ?
What should i answer to that person ?
Bobby
-
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?
-
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. -
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