Information Systems are nowadays becoming more and more complex and the use of the parallel and distributed approaches has introduced new difficulties in trying to guarantee the performance of end-user applications. In addition, the increasing volume of data to be stored, managed and processed requires to have a well-tuned database and well-designed-and-optimised database programs. SMART2 was developed as an initial solution to cop with the problem of predicting the performance of SQL-based relational programs. In this paper an extension of the SMART2 workbench for predicting the performance of PL/SQL applications is presented. The proposed tool provides end-users with a graph-oriented formalism for specifying the essential characteristics of the application he/she is conceiving and capabilities for matching software components and operational environment.
[1]
Erhard Rahm,et al.
Performance evaluation of extended storage architectures for transaction processing
,
1992,
SIGMOD '92.
[2]
Connie U. Smith,et al.
Performance Engineering of Software Systems
,
1990,
SIGMETRICS Perform. Evaluation Rev..
[3]
Jennifer Widom,et al.
Static analysis techniques for predicting the behavior of active database rules
,
1995,
TODS.
[4]
Kevin J. Healy.
The use of event graphs in simulation modeling instruction
,
1993,
WSC '93.
[5]
Didier Boudigue,et al.
An Application of SMART2: A Tool for Performance Evaluation of Relational DataBase Programs
,
1995,
MMB.
[6]
Björn Þór Jónsson,et al.
Performance tradeoffs for client-server query processing
,
1996,
SIGMOD '96.