Modelling parallel oracle for performance prediction

Distributed and Parallel Databases

Volumn 13, Issue 3, 2003, Pages 251-269

  Dempster, E W ^a   Tomov, N T ^a   Williams, M H ^a   Taylor, H ^a   Burger, A ^a   Trinder, P ^a   Lu J ^b   Broughton, P ^c  

^a HERIOT WATT UNIVERSITY   (United Kingdom)

^b LONDON SOUTH BANK UNIVERSITY   (United Kingdom)

^c International Computers Limited   (United Kingdom)

Author keywords

Analytical modelling; Parallel database; Parallel Oracle; Performance prediction

Indexed keywords

CACHE MEMORY; CLIENT SERVER COMPUTER SYSTEMS; COMPUTER AIDED SOFTWARE ENGINEERING; COMPUTER SIMULATION; QUERY LANGUAGES; QUEUEING THEORY; RELATIONAL DATABASE SYSTEMS; RESPONSE TIME (COMPUTER SYSTEMS); STORAGE ALLOCATION (COMPUTER);

ANALYTICAL MODELLING; PARALLEL DATABASES; PARALLEL ORACLE; PERFORMANCE MODELLING;

PARALLEL PROCESSING SYSTEMS;

EID: 0037403974     PISSN: 09268782     EISSN: None     Source Type: Journal    
DOI: 10.1023/A:1022875525392     Document Type: Article

References (26)

1. The ASK Group Ltd., ASK Open (Ingres) Database Administrator's Guide. The ASK Group Limited: Bury St. Edmunds, UK, 1994.
2. BEZ Systems Inc., BEZPlus for NCR Teradata and Oracle Environments on MPP Machines. Available at http://www.bez.com/software.htm, 1997.
3. BMC Software Inc., Patrol DB-log Master, available at http://www.bmc.com/products/trx/index.html. 1998.
4. A. Dan and P.S. Yu, Performance analysis of coherency control policies through lock retention. in Proceedings of ACM SIGMOD Conference, California, USA, June 1992, pp. 114-123.
5. DB LAB PTY Ltd., Ingres DB_Maximiser, available at http://ingres.com.my/db_maximizer.html. 1996.
6. Dell Computer Corp., Oracle System Sizer, available at http://wwwdell.com/products/poweredge/partners/db/oracle/wp-sizer.htm, 1998.
7. Digital Equipment Corp., EcoTools, available at http://www.digital.com/alphaserver/products/internet/search/ecotools_3_3.html, 1998.
8. R. Eberhard, IBM Corp., DB2 Estimator for Windows, available at http://www.software.ibm.com/data/db2/os390/db2est-home.html, 1998.
9. T. Foxon, M. Garth, and P. Harrison, "Capacity planning in client-server systems," Journal of Distributed Systems Engineering vol. 3, pp. 32-38, 1996.
10. M. Garth, "Capacity planning for parallel IT systems," Computer Bulletin pp. 16-18, (Nov. 1996).
11. M. Gurry and P. Corrigan, Oracle Performance Tuning O'Reilly & Associates, Inc: California, USA, 1996.
12. IBM Corp., DB2, available at http://www.software.ibm.com/data/db2/, 1998.
13. Ifatec S.A., Smart2 User Guide, Release 2.1, Ifatec S.A.: Versailles, France, 1994.
14. Informix Software Inc., Informix-OnLine Dynamic Server & Administrator's Guide, Informix Press, California, USA, 1994
15. G. Koch and K. Loney, Oracle, The Complete Reference, Osborne, McGraw-Hill, California, USA. 1997.
16. M. G. Norman and P. Thanisch, Parallel Database Technology, Bloor Research Group: Netherlands, 1995 pp. 1-546.
17. Oracle Corporation, Oracle7 Parallel Server Concepts & Administration, Release 7.3, Oracle, Server Products, California, USA, 1996.
18. Oracle Corporation, Oracle7 Server Concepts, Release 7.3, Oracle, Server Products, California, USA, 1996.
19. Sybase Inc., available at http://www.sybase.com, 1998.
20. N. Tomov, E. Dempster, M.H. Williams, A. Burger, H. Taylor, P.J.B. King, and P. Broughton, "Some results from a new technique for response time estimation in parallel DBMS," in Proceedings of the Seventh International Conference, High Performance Computers and Networks Europe, April 1999 Springer, Berlin pp. 713-721.
21. N. T. Tomov, E.W. Dempster, M.H. Williams, P.J.B. King, and A. Burger, "Approximate estimation of transaction response time," The Computer Journal, vol. 42, pp. 241-250, 1999.
22. C. Turbyfill, C. Orji, and D. Bitton, "AS3AP: An ANSI SQL standard scaleable and portable benchmark for relational database systems," in The Benchmark Handbook, 2nd edn., J. Gray (Ed.), 1993.
23. M.H. Williams and S. Zhou, "Data placement in parallel database systems," Parallel Database Techniques, IEEE Computer Scoeity Press, 1997.
24. M.H. Williams, S. Zhou, H. Taylor, and N. Tomov, "Decision support for management of parallel database systems," in Proc. of Int. Conf. on High Performance Computers and Networks, Brussels, Belgium LNCS Series, vol. 1067, Springer-Verlag: Berlin April 1996, pp. 164-169.
25. M.H. Williams, S. Zhou, H. Taylor, N. Tomov, and A. Burger, "Cache modelling in a performance evaluator for parallel database systems," in Proceedings of the Fifth International Symposium on Modelling, Analysis and Simulation of Computer and Telecommunication Systems, IEEE Computer Society Press, Jan. 1997 pp. 46-50.
26. S. Zhou, M.H. Williams, and H. Taylor, "Practical throughput estimation for parallel databases," Software Engineering Journal, vol. 11, pp. 255-263, 1996.