[comp.databases] Transaction Sequences Needed

alext@ccwf.cc.utexas.edu (Alex Tomlinson) (04/11/91)

I need a database transaction generator so I can test some concurrency
control schemes (e.g. 2-phase locking, etc.).  I could use any one of 
the following:

	1.  a program that produces transaction sequences

	2.  the output of such a program

	3.  some recorded transactions from real database systems


Of course, the more data the merrier...

I'm looking for something with a simple format, but with realistic
access patterns and distributions.

Example format:
	
	Begin Transaction 1, R(a), R(b), W(b), ..... , Commit
	Begin Transaction 2, R(c), W(b), W(a), ..... , Commit
		.
		.
		.

Note, I need the transactions themselves, NOT the schedule
resulting from concurrent execution of the transactions.  Although
If I can extract the transactions from a schedule, I could use it.

Any information or pointers to information would be appreciated.

Thanks,
Alex Tomlinson	-> alext@ccwf.cc