Thread: Database testing.

Database testing.

From
"Niv Cohen"
Date:

Hi,

My questions are regarding the way you are doing tests to your database.

1.      Can you explain in general the method you test the database engine.

2.      Are you doing testing for data integrity?

3.      Are you using a special tool for testing? If yes, is it propriety for you or off the shelf?

4.      What is the ratio between people doing development to people doing testing or between development time to test time.

Some background on where these questions came from.

My name is Niv Cohen and Im working for SanDisk.

We developed a small embedded database for our needs and we feel the luck of expertise in the area of testing this module.

We by no mean going to sell this as stand a lone database.

Thanks a lot,

Niv

Re: Database testing.

From
"Jim C. Nasby"
Date:
On Mon, Dec 05, 2005 at 11:27:33AM +0200, Niv Cohen wrote:
> Hi,
> My questions are regarding the way you are doing tests to your database.
> 1.    Can you explain in general the method you test the database
> engine.
> 2.    Are you doing testing for data integrity?
> 3.    Are you using a special tool for testing? If yes, is it
> propriety for you or off the shelf?

Best bet is to Use The Source:
http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/

> 4.    What is the ratio between people doing development to people
> doing testing or between development time to test time.

There is not currently any group of people dedicated to coming up with
test cases.

> Some background on where these questions came from.
> My name is Niv Cohen and I'm working for SanDisk.
> We developed a small embedded database for our needs and we feel the
> luck of expertise in the area of testing this module.
> We by no mean going to sell this as stand a lone database.

Do you have more specific examples or problems?
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461