Abstract
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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Aiken, A., Hellerstein, J.: Static Analysis Techniques for Predicting the Behavior of Active Database Rules. ACM Transactions on Database Systems 20(1) (1995) 3–41
Boulos, J., Boudigue, D.: An Application of SMART2: A Tools for Performance Evaluation of Relational Database Programs. Lecture Notes in Computer Science 977. 1995
Franklin, M., Johnson, B.T., Kossmann, D.: Performance Tradeoffs for Client-Server Query Processing. In Proc. of ACM SIGMOD International Conference on Management of Data. Montreal, Canada. Jun. 1996. 149–160
Healy, K.: The Use of Event Graphs in Simulation Modeling Instruction. In Proc. of the 1993 Winter Simulation Conference. Los Angeles, CA. Dec. 1993
HELIOS Consortium: HELIOS Project Technical Annex Version 4.0. 1997
HELIOS Consortium: PL/SQL and Multibase Performance Models. WP2T3-d1 R2.0 Technical Report, 1997
Kumar, J.: Recovery Mechanisms in Databases. Prentice-Hall International. 1998
Potier, D., Veran, M.: QNAP2: A Portable Environment for Queuing Systems Modelling. First International Conference on Modelling Techniques and Tools for Performance Analysis. Potier (Ed.) North-Holland, 1985. 25–63.
Rahm, E.: Performance Evaluation of Extended Storage Architectures for Transaction Processing. In Proc. ACM SIGMOD International Conference on Management of Data (SIGMOD’ 92). San Diego, CA. Jun. 1992. 308–317.
SIMULOG: QNAP2 User’s Manual. Jun. 1994.
Savino V., N. N., Puigjaner R.: An Object-Oriented Approach for the Design of Hierarchical Queuing Network Simulation Models with QNAP2. In Proc. Object-Oriented Simulation Conference, OOS’98. San Diego, CA. Jan. 1998. 101–106.
Savino V., N. N., Puigjaner R., Anciano M., J. L.: Including Methods and Inheritance of Hierarchical Models in HOOMA. In Proc. Thyrtieth Summer Computer Simulation Conference, SCSC’98. Reno, NV. Jul. 1998 (to appear).
IFATEC: SMART User’s Guide. Release 3.0. Dec. 1996.
Smith, C. U.: Performance Engineering of Software Systems. Addison-Wesley. 1990
Transaction Processing Council: TPC Benchmark C Standard Specification. Revision 3.3.2. Jun. 1997. Available at http://www.tpc.org/benchmark_specifications/TPC_C/tpcc332.pdf
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1998 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Martin, J.L.A., Vázquez, N.N.S., Corbacho, J.A., Puigjaner, R. (1998). Extending SMART2 to Predict the Behaviour of PL/SQL-based Applications. In: Puigjaner, R., Savino, N.N., Serra, B. (eds) Computer Performance Evaluation. TOOLS 1998. Lecture Notes in Computer Science, vol 1469. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-68061-6_24
Download citation
DOI: https://doi.org/10.1007/3-540-68061-6_24
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-64949-6
Online ISBN: 978-3-540-68061-1
eBook Packages: Springer Book Archive