Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!usc!cs.utexas.edu!ut-emx!ccwf.cc.utexas.edu!alext
From: alext@ccwf.cc.utexas.edu (Alex Tomlinson)
Newsgroups: comp.databases
Subject: Transaction Sequences Needed
Message-ID: <ALEXT.91Apr11024017@doc.cc.utexas.edu>
Date: 11 Apr 91 07:40:17 GMT
Sender: news@ut-emx.uucp
Distribution: comp
Organization: The University of Texas at Austin
Lines: 33


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