Scalability and resource usage of an OLAP benchmark on clusters of PCs

Annual ACM Symposium on Parallel Algorithms and Architectures

Volumn , Issue , 2002, Pages 83-94

  Taufer, Michela ^a   Stricker, Thomas ^a   Weber, Roger ^a  

^a ETH ZURICH   (Switzerland)

Author keywords

Cluster of PCs; Distributed OLAP processing; Parallel databases; Performance analysis; Workload characterization

Indexed keywords

COMPUTER ARCHITECTURE; COMPUTER HARDWARE; COMPUTER SOFTWARE; OPTIMIZATION; PERFORMANCE; PERSONAL COMPUTERS;

ON LINE ANALYTICAL PROCESSING; PARALLEL DATABASES;

DISTRIBUTED DATABASE SYSTEMS;

EID: 0036957552     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/564870.564882     Document Type: Conference Paper

References (21)

1. A. Ailamaki, D.J. DeWitt, M.D. Hill, and D.A. Wood. DBMSs on a modern processor: Where does time go? In Proc. of the 25th International Conference on Very Large Data Bases (VLDB), Edinburgh, UK, September 1999.
2. M.W. Blasgen. Personal communication.
3. K. Böhm, T. Grabs, U. Röhm, and H.-J. Schek. Evaluating the Coordination Overhead of Synchronous Replica Maintenance in a Cluster of Databases. In A. Bode, W. Karl T. Ludwig, and R. Wismüller, editors, Proc. of the 6th International Euro-Par Conference, Lecture Notes in Computer Science, pages 435-444, Munich, Germany, August 2000. Springer.
4. Q. Cao, J. Torrellas, and H. Jagadish. Unified Fine-Granularity Buffering of Index and Data: Approach and Implementation. In IEEE International Conference on Computer Design: VLSI in Computers and Processors (ICCD'00), pages 175-186, Washington - Brussels - Tokyo, September 2000. IEEE Computer Society.
5. Q. Cao, P. Trancoso, J.-L. Larriba-Pey, J. Torrellas, R. Knighten, and Y. Won. Detailed Characterization of a Quad Pentium Pro Server Running TPC-D. In Proc. of the International Conference on Computer Design (ICCD '99), pages 108-117, Washington - Brussels - Tokyo, October 1999. IEEE Computer Society.
6. C. Dye. Oracle Distributed Systems. 1st Edition. O'Reilly, 1999.
7. G.C. Fox. What have we learnt from using real parallel machines to solve real problems? In Proc. of the 3rd conference on Hypercube concurrent computers and applications, pages Vol. 2 pp 897-955, Pasadena, CA, January 1988.
8. T. Grabs, K. Böhm, and H.-J. Schek. High-level Parallelisation in a Database Cluster: a Feasibility Study Using Document Services. In Proc. of the International Conference on Data Engineering (ICDE), Heidelberg, Germany, April 2001. IEEE Computer Society.
9. M. Gurry. Oracle SQL Tuning Pocket Reference. O'Reilly, 2001.
10. Intel Corporation. Pentium Pro Family Developer's Manual, 1996.
11. R. Jain. The Art of Computer Systems Performance Analysis. Wiley Professional Computing, 1996.
12. K. Keeton, D. Patterson, Y. He, R. Raphael, and W. Baker. Performance characterization of a Quad Pentium Pro SMP using OLTP Workloads. In Proc. of the 25th Annual International Symposium on Computer Architecture (ISCA-98), volume 26,3 of ACM Computer Architecture News, New York, June 1998. ACM Press.
13. Oracle Corporation. Oracle8. http://www.oracle.com/, 1997.
14. P. Ranganathan, K. Gharachorloo, S. Adve, and L. Barroso. Performance of database workloads on shared-memory systems with out-of-order processors. In Proc. of the 8th International Conference on Architectural Support for Programming Languages and Operating Systems, San Jose, California, October 1998.
15. U. Röhm, K. Böhm, and H.-J. Schek. OLAP Query Routing and Physical Design in a Database Cluster. In Proc. of the International Conference on Extending Database Technology, Konstanz, Germany, March 2000.
16. U. Röhm, K. Böhm, and H.-J. Schek. Cache-Aware Query Routing in a Cluster of Databases. In Proc. of the International Conference on Data Engineering (ICDE), Heidelberg, Germany, Apr 2001. IEEE Computer Society.
17. A. Silberschatz, H. F. Korth, and S. Sudarshan. Database System Concepts. McGraw-Hill International editions, 1997.
18. M. Taufer and T. Stricker. Accurate Performance Evaluation, Modelling and Prediction of a Message Passing Simulation Code based on Middleware. In Proc. of the SC98 Conference, Orlando, FL, November 1998.
19. M. Taufer, T. Stricker, and R. Weber. Inverting Middleware Framework: a Framework for Performance Analysis of Distributed OLAP Benchmarks on Clusters of PCs by Filtering and Abstracting Low Level Resource Usage. Technical Report Technical Report 367, ETH Zurich, Institute of Computer Systems, Switzerland, March 2002.
20. The Transaction Processing Performance Council. TPC Benchmark C Standard Specification Revision 3.4. http://www.tpc.org, 1998.
21. The Transaction Processing Performance Council. TPC Benchmark D Standard Specification Revision 1.3.1. http://www.tpc.org, 1998.