Abstract
System Development Corporation has performed a number of evaluations of relational database management systems (RDBMS) to determine their capabilities and performance. We have developed a set of databases and queries to use in these evaluations. Among the problems faced have been: how to perform comparable operations on DMBSs with dissimilar capabilities and optimization strategies, blunders in the DBMS internal query optimizers which sometimes cause dramatic sensitivity to the order of presentation of the query, and even a few obscure bugs in some systems.
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
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
Britton-Lee Inc.; IDM Software Reference Manual; Version 1.4; January, 1983.
DeWitt, D. J., and Hawthorn, P., “Performance Evaluation of Database Machine Architectures,” Invited Paper 1981 Very Large Database Conference, Sept 1981.
Hawthorn, P., and DeWitt, D. J., “Performance Evaluation of Database Machines,”, IEEE Transactions on Sfotware Engineering, Mar 82.
Hevner, A., Yao, S. B., and Romeo, T., “Database System Analysis—A Benchmarking Methodology”, National Bureau of Standards Technical Report; Apr, 1984.
ORACLE Database System Manuals, Version 3.1
Templeton, M., Kameny, I., Kogan, D., Lund, E., Brill, D., Evaluation of Ten Data Management Systems, System Development Corp. TM-7817/000/00, 1981.
Yao, S. B., and Hevner, A. R., “An Analysis of Three Database System Architectures Using Benchmarks”, National Bureau of Standards Technical Report; Apr, 1984.
Youssefi, K., Ubell, M., Ries, D., Hawthorne, P., Epstein, B., Berman, R. and Allman, E.; INGRES Reference Manual — Version 6, Memorandum No. ERL-M579; Engineering Research Lab., College of Engineering, U. California, Berkeley; 14-Apr-77 (revised).
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1986 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Van Buer, D.J., Gates, R.O., Lund, E.O. (1986). A Comparison of Performance of Similar Queries on Similar Databases on Several Relational Systems—Hardware and Software. In: Sood, A.K., Qureshi, A.H. (eds) Database Machines. NATO ASI Series, vol 24. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-82937-6_11
Download citation
DOI: https://doi.org/10.1007/978-3-642-82937-6_11
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-82939-0
Online ISBN: 978-3-642-82937-6
eBook Packages: Springer Book Archive