Re: unit testing oracle database - what's your experience?
Date: Thu, 16 Jul 2009 13:42:21 -0700 (PDT)
Message-ID: <651db4ff-54b6-49f2-96e4-b6098b43be9d_at_o15g2000yqm.googlegroups.com>
On Jul 16, 3:54 pm, berny <bern..._at_googlemail.com> wrote:
snip
> Hello,
>
> what experiences have you made with unit testing an Oracle database?
> What tools have you used?
> Thank you for your answers,
The basic plan of attack that we use starts with refreshing a database ( usually weekly ) to a known point in time. This gives you a specific set of data ( customers, inventory, orders ... whatever is relevant to you ) as a common starting point.
You need test plans for each part of the applications that are changing that control and specify who/what/why is being tested.
You need some set of people to review the results of the testing process and supply feedback to the lead developers ( or often the lead developers inherit those types of responsibilities ).
Does your organization have any kind of standards or methodology in place currently? You cannot realistically expect unit testing to occur if other pre-requisites are not in place already.
As far as exactly what tools are needed ... well that's for the lead developers and the testing team to specify and obtain. Decisions like that should logically "fall out" from a methodology or set of standards.
If you are new to this area ... it might be a good idea to bring in an outside person with proven relevant knowledge to help get your organization jump started. Received on Thu Jul 16 2009 - 15:42:21 CDT