Generate Random SQL... 
Author Message
 Generate Random SQL...
Hi,

 I'm in need of a program that will generate random SQL statements
(Select/Insert/Update/Delete) based on bound conditions; DDL, # of joins, #
of expressions, etc.

 Has anyone built such a beast and/or know where one might exist?

 Why: I need to stress an application by testing large volumes of SQL
statements against a couple of the major databases. And it'll take me too
long to create such a program.

 Thanks.

Paul



Sun, 31 Jul 2005 18:57:51 GMT
 Generate Random SQL...



Quote:
>Hi,

> I'm in need of a program that will generate random SQL statements
>(Select/Insert/Update/Delete) based on bound conditions; DDL, # of joins, #
>of expressions, etc.

> Has anyone built such a beast and/or know where one might exist?

> Why: I need to stress an application by testing large volumes of SQL
>statements against a couple of the major databases. And it'll take me too
>long to create such a program.

I hope you'll excuse me for saying this, but this is the most
ridiculous thing I've ever heard of.

There are some well-known test suites out there, though ... I believe
one is called "crashme" or something like that. Might want to take a
look before re-inventing the wheel. Look on Google ... maybe someone
here has a link?

Bob Hairgrove



Mon, 01 Aug 2005 03:23:21 GMT
 Generate Random SQL...


Quote:
> I'm in need of a program that will generate random SQL statements
>(Select/Insert/Update/Delete) based on bound conditions; DDL, # of joins, #
>of expressions, etc.

> Has anyone built such a beast and/or know where one might exist?

IIRC, somebody from Microsoft wrote a tool and a white paper along
those lines.  Something like "Massive Stochastic Testing of SQL".  I
don't recall there being any implementation details in the paper, but
it might have bibliography.

--
Mike Sherrill
Information Management Systems



Wed, 03 Aug 2005 21:38:03 GMT
 Generate Random SQL...
There are some benchmark suites for SQL;  Look for the name DeWitt and
some stuff by Jim Grey.  I think DeWitt was with the Universtiy of
Wisconsin when he did his first set.


Fri, 05 Aug 2005 02:57:23 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Generate Random SQL...

2. EASY: SQL to generate a simple random number?

3. Generating Random Numbers in SQL Server 6.5 Stored Procedure

4. PL/SQL Generating a random number

5. SQL to Generate Random Numbers?

6. SQL 7.0 Random function, does not work like SQL 6.5 Random function

7. How to Generate True Random IDs?

8. generating a random number

9. How to generate random numbers!

10. Generating random string in a table

11. HOWTO: Generate Random Column ID as the Default

12. Generate random password as default value


 
Powered by phpBB® Forum Software