How can one strategize to test a database
Here are the details:
Suppose the website E-commerce software creates a report everyday.These reports are extracted from a database which includes all
hits to the site as well as path of the hits i.e from which banner or site did the hit originate etc.
These reports go through 3 phases,
first-The reports are stored in a informix
database-known as staging area and are in table form.
Then they are further classified into
more detailed reports but in this stage they
are in a oracle database.The reports are table form.
In the last stage the reports are converted into 'flat' files and not tables.
My question is how to test if the report generation is ok?Also how do I test using the
basic idea of'breaking the application'?
How can you put -ve values here etc.
Thanks in advance.
[This message has been edited by Testofinish (edited 03-22-2001).]
Re: Database testing
Maybe you need to start looking at each part in isolation. So you will trivially test report generation from an Oracle DB. Then you will test if the DB is being properly populated. Finally integrate everything and run an end-to-end test using a tool to simulate the hits, crosscheck the DB and finally the reports.