[Dev] Log DB schema

[Frank Cohen]

A number of people have asked for TestMaker to log transaction and  
results data to a relational database to enable data analysis outside  
of TestMaker. For instance, PushToTest is partnering with DBA  
InfoPower to provide root-cause analysis while a test operates. You  
will be able to watch a test operate and when a result looks  
anomalous you will drill-down into the DBA InfoPower observed data.

Attached are two document that propose the database schema for log  
transaction and results data. There is a PDF file showing a schema  
model and an XML file (in Power*Architect format, http:// 
www.sqlpower.ca/page/architect) The XML file gives comments and  
descriptions of the tables and fields defined in the model.

Our thought, at the moment, is to create a log handler that  
identifies a JDBC database. The log handler will create the attached  
database schema of tables and indexes, and then log the results to it.

Feedback, ideas, suggestions are welcome.

-Frank

--
Frank Cohen, PushToTest, http://www.PushToTest.com, phone 408 374 7426
TestMaker: The open-source SOA test automation tool

-------------- next part --------------
A non-text attachment was scrubbed...
Name: TMDBSchema.architect
Type: application/octet-stream
Size: 24348 bytes
Desc: not available
Url : http://cake.pushtotest.com/pipermail/dev/attachments/20070704/0bbc0a51/TMDBSchema-0001.obj
-------------- next part --------------
A non-text attachment was scrubbed...
Name: TMDBSchmaDrawing.html.pdf
Type: application/pdf
Size: 190390 bytes
Desc: not available
Url : http://cake.pushtotest.com/pipermail/dev/attachments/20070704/0bbc0a51/TMDBSchmaDrawing.html-0001.pdf
-------------- next part --------------