Abstract
SMART2 is a performance evaluation tool for relational and transactional applications. As database applications become more and more complex and expensive, the goal of SMART2 is to help in the performance prediction of a database system and to assist designers in making choices on critical issues during the whole lifetime of a project. Though SMART2 is based on simulation techniques, it uses analytical Valued Query Execution Plans to evaluate the cost of a query or a transaction in terms of time and resource consumption. SMART2 facilities are its power to model hardware architecture, data schema and applications in order to obtain performance prediction with regard to capacity planning, schema normalisation, DBMS tuning, data distribution, ... The features of the present state of SMART2 are mainly oriented on the modelling of sophisticated platform architectures (client-server, multi-server architectures, parallel servers).
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
References
Selinger, P., et. al., “Access Path Selection in a Relational Database Management System,” Proc. ACM-SIGMOD Conf., Boston, May 1979.
Stonebraker, M., et. al., “The Design of XPRS,” Proc. of the 14th VLDB Conference, Los Angeles, California, 1988.
Lanzelotte, R., et. al. “Optimization of Object-Oriented Recursive Queries using Cost-Controlled Strategies,” Proc. of the 1992 ACM-SIGMOD, Int. Conference on Management of Data, San Diego, California, June 1992.
Lohman, G., et. al. “Query Processing in R*,” Query Processing in Database Systems, Springer-Verlag (Kim, Batory, & Reiner (eds.)), pp. 31–47, 1985.
Agrawal, R., and DeWitt, D., “Integrated Concurrency Control and Recovery Mechanisms: Design and Performance Evaluation,” ACM Transactions on Database Systems, Vol. 10, No. 4, December 1985.
Shapiro, L., “Join Processing in Database Systems with Large Main Memories,” ACM Transactions on Database Systems, Vol. 11, No. 3, Sept. 1986.
Biliris, A., “The Performance of Three Database Storage Structures for Managing Large Objects,” Proc. of the 1992 ACM-SIGMOD, Int. Conference on Management of Data, San Diego, California, June 1992.
DeWitt, D., et. al., “Implementation Techniques for Main Memory Database Systems,” Proc. 1984 ACM-SIGMOD Conference on Management of Data, 1984.
Bhide, A., and Stonebraker, M., “A performance Comparison of Two Architectures For Fast Transaction Processing,” Proc. 4th Int. Conf. on Data Engineering, Feb. 1988.
Sevcik, K., “Data Base System Performance Prediction Using An Analytical Model,” 7th Int. Conference on Very Large Data Bases, Cannes, France, Sept. 1981.
Schneider, D., and De Witt, D., “A Performance Evaluation of Four Parallel Join Algorithms in a Shared-Noting Multiprocessor Environment,” ACM 1989.
Delis, A., and Roussopouloos, N., “Performance and Scalability of Client-Server Database Architectures,” Proc. of the 18th VLDB Conference, Vancouver, British Columbia, Canada, 1992.
Rahm, E., “Performance Evaluation of Extended Storage Architectures for Transaction Processing,” Proc. of ACM-SIGMOD 1992, Int. Conference on Management of Data, San Diego, California, June 1992.
Liu, X., et al., “Transaction Management for Object-Oriented Databases: Performance Advantages of Using Multiple Versions,” Proc. of the 25th Annual Simulation Symposiom, Orlando, Floroda, April 1992.
Atkinson, M., et al., “The Object-Oriented Database System Manifesto,” Deductive and Object-Oriented Databases, Elsevier Science Publishers B. V. (North-Holland), 1990.
QNAP2 Reference Manual, SIMULOG-INRIA, August, 1991.
Turbyfill, C., et al., “AS3AP — An ANSI Sequel Standard Scalable and Portable benchmark for Relational Database Systems,” in the Performance Handbook for database and Transaction Processing Systems, San Mateo, CA: Morgan Kaufmann, 1991.
TPC Benchmark C, Standard Specifications, 01 August, 1993, Transaction Performance Council, 1993.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1995 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Boulos, J., Boudigue, D. (1995). An application of SMART2: A tool for performance evaluation of relational database programs. In: Beilner, H., Bause, F. (eds) Quantitative Evaluation of Computing and Communication Systems. TOOLS 1995. Lecture Notes in Computer Science, vol 977. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0024304
Download citation
DOI: https://doi.org/10.1007/BFb0024304
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-60300-9
Online ISBN: 978-3-540-44789-4
eBook Packages: Springer Book Archive