OLAP query evaluation in a database cluster: A performance study on intra-query parallelism

Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

Volumn 2435 LNCS, Issue , 2002, Pages 218-231

  Akal, Fuat ^a   Böhm, Klemens ^a   Schek, Hans Jörg ^a  

^a ETH ZURICH   (Switzerland)

Author keywords

[No Author keywords available]

Indexed keywords

CLUSTER COMPUTING; DATABASE SYSTEMS; INFORMATION SYSTEMS; INFORMATION USE;

COMPLEX QUERIES; COORDINATION INFRASTRUCTURE; DATABASE CLUSTERS; DATABASE COMPONENTS; ON-LINE ANALYTICAL PROCESSING; PERFORMANCE STUDY; QUERY PARALLELISM; TWO-PHASE QUERIES;

QUERY PROCESSING;

EID: 84885224062     PISSN: 03029743     EISSN: 16113349     Source Type: Book Series    
DOI: 10.1007/3-540-45710-0_18     Document Type: Conference Paper

References (22)

1. Özsu, T., Valduriez, P., Distributed and Parallel Database Systems. ACM Computing Surveys, 28(1):125-128, March 1996.
2. Röhm, U., Böhm, K., Schek, H.-J., OLAP Query Routing and Physical Design in a Database Cluster. Advances in Database Technology, In Proceedings 7th EDBT Conference, pp. 254-268, March 2000.
3. Röhm, U., Böhm, K., Schek, H.-J., Cache-Aware Query Routing in a Cluster of Databases. In Proceedings 17th IEEE ICDE Conference, April 2001.
4. TPC, TPC Benchmark™ R (Decision Support).
5. Kossmann, D., The State of the Art in Distributed Query Processing. ACM Computing Surveys, 32(4): 422-469, September 2000.
6. Baru, C.K. et al., DB2 Parallel Edition. IBM System Journal, 34(2):292-322, 1995.
7. Oracle 8i Parallel Server. An Oracle Technical White Paper. January 20, 2000.
8. Informix Extended Parallel Server 8.3 XPS. White Paper, Informix, 1999.
9. Delaney, K., Inside Microsoft SQL Server 2000. Microsoft Press, 2001.
10. Bozas, G., Jaedicke, Mitschang, B., Reiser, A. Zimmermann, S., On Transforming a Sequential SQL-DBMS into a Parallel One: First Results and Experiences of the MIDAS Project. TUM-I9625, SFB-Bericht Nr. 342/14/96 A, May 1996.
11. DeWitt, D.J., Gray, J., Parallel Database Systems: The Future of High Performance Database Systems. Communications of the ACM, 35(6):85-98, June 1992.
12. DeWitt, D.J., et al, The Gamma Database Machine Project. IEEE Transactions on Knowledge and Data Engineering, 2(1):44-62, March 1990.
13. Boral, H., et al., Prototyping Bubba, A Highly Parallel Database System. IEEE Transactions on Knowledge and Data Engineering, 2(1):4-24, March 1990.
14. Stonebraker, M., et al., The Design of XPRS. In Proceedings 14th VLDB Conference, pp. 318-330, September 1988.
15. Graefe, G., Volcano - An Extensible and Parallel Query Evaluation System. IEEE Transactions on Knowledge and Data Engineering, 6(1):120-135, February 1994.
16. Exbrayat, M., Brunie, L., A PC-NOW based parallel extension for a sequential DBSM. In Proceedings IPDPS 2000 Conference, Cancun, Mexico, 2000.
17. Tamura, T., Oguchi, M., Kitsuregawa, M., Parallel Database Processing on a 100 node PC Cluster: Cases for Decision Support Query Processing and Data Mining. In Proceedings SC'97 Conference: High Performance Networking and Computing, 1997.
18. Microsoft SQL Server MegaServers: Achieving Software Scale-Out. White Paper, Microsoft Corporation, February 2000.
19. Ganski, R.A., Long, H.K.T. Optimization of Nested SQL Queries Revisited. In Proceedings ACM SIGMOD Conference, pp. 23-33, 1987.
20. The Project PowerDB, url: http://www.dbs.ethz.ch/~powerdb.
21. th VLDB Conference, 2002.
22. Shatdal, A., Naughton, J.F., Adaptive Parallel Aggregation Algorithms. In Proceedings ACM SIGMOD Conference, pp. 104-114, 1995.