Relational query coprocessing on graphics processors

ACM Transactions on Database Systems

Volumn 34, Issue 4, 2009, Pages

  He, Bingsheng ^a   Lu, Mian ^b   Yang, Ke ^c   Fang, Rui ^d   Govindaraju, Naga K ^c   Luo, Qiong ^b   Sander, Pedro V ^b  

^a MICROSOFT RESEARCH ASIA   (China)

^b HONG KONG UNIVERSITY OF SCIENCE AND TECHNOLOGY   (Hong Kong)

^c MICROSOFT   (United States)

^d Highbridge Capital Management LLC   (United States)

Author keywords

Graphics processors; Join; Parallel processing; Primitive; Relational database; Sort

Indexed keywords

CO-PROCESSORS; COMPLEX DATA; COMPUTATION POWER; COMPUTATION RESOURCES; COPROCESSING; DATA PARALLEL; DATA SETS; DATABASE QUERIES; DYNAMIC MEMORY ALLOCATION; EXECUTION MODEL; GENERAL PURPOSE; GPU-BASED ALGORITHMS; GRAPHICS PROCESSING; GRAPHICS PROCESSOR; HARDWARE FEATURES; HARDWARE SUPPORTS; HIGH MEMORY BANDWIDTH; INTER PROCESSOR COMMUNICATION; LIMITED BANDWIDTH; LOCAL MEMORIES; MEMORY BANDWIDTHS; MEMORY LOCATIONS; MEMORY OPTIMIZATION; MEMORY-RESIDENT; MICRO-BENCHMARK; MULTIPLE QUERIES; MULTITHREADED ARCHITECTURE; ON CHIPS; ORDER OF MAGNITUDE; PARALLEL COMPUTATION; PARALLEL PROCESSING; PARALLEL PROGRAMMING MODEL; RELATIONAL DATABASE; RELATIONAL QUERIES;

BANDWIDTH; COMPUTATIONAL EFFICIENCY; DATA TRANSFER; DATABASE SYSTEMS; MATHEMATICAL OPERATORS; OPTIMIZATION; PARALLEL PROGRAMMING; PROGRAM PROCESSORS;

COMPUTER GRAPHICS EQUIPMENT;

EID: 76149104641     PISSN: 03625915     EISSN: 15574644     Source Type: Journal    
DOI: 10.1145/1620585.1620588     Document Type: Conference Paper

References (45)

1. ABADI, D., MADDEN, S., AND FERREIRA, M. 2006. Integrating compression and execution in columnoriented database systems. In Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD'06). ACM, New York, NY, 671-682.
2. AILAMAKI, A., DEWITT, D. J., HILL, M. D., AND WOOD, D. A. 1999. DBMSs on a modern processor: Where does time go? In Proceedings of the 25th International Conference on Very Large Data Bases (VLDB). Morgan Kaufmann Publishers Inc., San Francisco, CA, 266-277.
3. AILAMAKI, A., GOVINDARAJU, N., HARIZOPOULOS, S., AND MANOCHA, D. 2006. Query co-processing on commodity processors. In Proceedings of the International Conference on Very Large Data Bases (VLDB).
4. BANDI, N., SUN, C., AGRAWAL, D., AND ABBADI, A. E. 2004. Hardware acceleration in commercial databases: a case study of spatial operations. In Proceedings of the 30th International Conference on Very Large Data Bases (VLDB). VLDB Endowment, 1021-1032.
5. BLELLOCH, G. E. 1990. Prefix sums and their applications. Tech. rep. CMU-CS-90-190, Carnegie Mellan University.
6. BLYTHE, D. 2006. The direct3d 10 system. SIGGRAPH, ACM Press, NY.
7. BONCZ, P. A., MANEGOLD, S., AND KERSTEN, M. L. 1999. Database architecture optimized for the new bottleneck: Memory access. In Proceedings of the 25th International Conference on Very Large Data Bases (VLDB). Morgan Kaufmann Publishers Inc., San Francisco, CA, 54-65.
8. BUCK, I., FOLEY, T., HORN, D., SUGERMAN, J., FATAHALIAN, K., HOUSTON, M., AND HANRAHAN, P. 2004. Brook for gpus: Stream computing on graphics hardware. SIGGRAPH, ACM Press, NY.
9. CIESLEWICZ, J., BERRY, J., HENDRICKSON, B., AND ROSS, K. A. 2006. Realizing parallelism in database operations: insights from a massively multithreaded architecture. In Proceedings of the 2nd International Workshop on Data Management on New Hardware (DaMoN). ACM, New York.
10. CIESLEWICZ, J. AND ROSS, K. A. 2007. Adaptive aggregation on chip multiprocessors. In Proceedings of the 33rd International Conference on Very Large Data Bases (VLDB). VLDB Endowment, 339-350.
11. DEWITT, D. ANDGRAY, J. 1992. Parallel database systems: the future of high performance database systems. Comm. ACM 35, 6, 85-98.
12. FRIGO, M., LEISERSON, C. E., PROKOP, H., AND RAMACHANDRAN, S. 1999. Cache-oblivious algorithms. In Proceedings of the 40th Annual Symposium on Foundations of Computer Science (FOCS). IEEE Computer Society, Washington, DC, 285.
13. GEDIK, B., BORDAWEKAR, R. R., AND YU, P. S. 2007. Cellsort: High performance sorting on the cell processor. In Proceedings of the 33rd International Conference on Very Large Data Bases (VLDB). VLDB Endowment, 1286-1297.
14. GEDIK, B., YU, P. S., AND BORDAWEKAR, R. R. 2007. Executing stream joins on the cell processor. In Proceedings of the 33rd International Conference on Very Large Data Bases (VLDB). VLDB Endowment, 363-374.
15. GOLD, B., AILAMAKI, A., HUSTON, L., AND FALSAFI, B. 2005. Accelerating database operators using a network processor. In Proceedings of the 1st International Workshop on Data Management on New Hardware (DaMoN). ACM, New York, NY, 1.
16. GOVINDARAJU, N., GRAY, J., KUMAR, R., AND MANOCHA, D. 2006. Gputerasort: high performance graphics co-processor sorting for large database management. In Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD). ACM, New York, NY, 325-336.
17. GOVINDARAJU, N., LLOYD, B., WANG, W., LIN, M., AND MANOCHA, D. 2004. Fast computation of database operations using graphics processors. In Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD). ACM, New York, NY, 215-226.
18. GOVINDARAJU, N. K., RAGHUVANSHI, N., ANDMANOCHA, D. 2005. Fast and approximate stream mining of quantiles and frequencies using graphics processors. In Proceedings of the ACM SIGMOD International Conference on Management of Data. New York, NY, 611-622.
19. GRAEFE, G. 1993. Query evaluation techniques for large databases. ACM Comput. Surv. 25, 2, 73-169
20. HARIZOPOULOS, S., ABADI, D. J., MADDEN, S., AND STONEBRAKER, M. 2008. OLTP through the looking glass, and what we found there. In Proceedings of the ACM SIGMOD International Conference on Management of Data. ACM, New York, NY, 981-992.
21. HARRIS, M., OWENS, J., SENGUPTA, S., ZHANG, Y., ANDDAVIDSON, A. 2007. CUDPP:CUDAdata parallel primitives library.
22. HE, B., GOVINDARAJU, N. K., LUO, Q., AND SMITH, B. 2007. Efficient gather and scatter operations on graphics processors. In Proceedings of the ACM/IEEE Conference on Supercomputing. ACM, New York, NY, 1-12.
23. HE, B. AND LUO, Q. 2008. Cache-oblivious databases: Limitations and opportunities. ACM Trans. Datab. Syst. 33, 2, 1-42.
24. HE, B., YANG, K., FANG, R., LU, M., GOVINDARAJU, N., LUO, Q., AND SANDER, P. 2008. Relational joins on graphics processors. In Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD). ACM, New York, NY, 511-524.
25. H́EMAN, S., NES, N., ZUKOWSKI, M., AND BONCZ, P. 2007. Vectorized data processing on the cell broadband engine. In Proceedings of the 3rd International Workshop on Data Management on New Hardware (DaMoN). ACM, New York, NY, 1-6.
26. HONG, W. AND STONEBRAKER, M. 1991. Optimization of parallel query execution plans in xprs. In Proceedings of the 1st International Conference on Parallel and Distributed Information Systems (PDIS). IEEE Computer Society Press, Los Alamitos, CA, 218-225.
27. JOHNSON, R., HARIZOPOULOS, S., HARDAVELLAS, N., SABIRLI, K., PANDIS, I., AILAMAKI, A., MANCHERIL, N. G., AND FALSAFI, B. 2007. To share or not to share? In Proceedings of the 33rd International Conference on Very Large Data Bases (VLDB). VLDB Endowment, 351-362.
28. LAMARCA, A. AND LADNER, R. E. 1997. The influence of caches on the performance of sorting. In Proceedings of the 8th Annual ACM-SIAM Symposium on Discrete Algorithms (SODA). Society for Industrial and Applied Mathematics, Philadelphia, PA, 370-379.
29. LIEBERMAN, M. D., SANKARANARAYANAN, J., AND SAMET, H. 2008. A fast similarity join algorithm using graphics processing units. In Proceedings of the International Conference on Data Engineering (ICDE).
30. LIU, B. AND RUNDENSTEINER, E. A. 2005. Revisiting pipelined parallelism in multi-join query processing. In Proceedings of the 31st International Conference on Very Large Data Bases. VLDB Endowment, 829-840.
31. LU, H., TAN, K. -L., AND SAHN, M. -C. 1990. Hash-based join algorithms for multiprocessor computers with shared memory. In Proceedings of the 16th International Conference on Very Large Databases. Morgan Kaufmann Publishers Inc., San Francisco, CA, 198-209.
32. MANEGOLD, S., BONCZ, P., AND KERSTEN, M. 2002. Generic database cost models for hierarchical memory systems. In Proceedings of the 28th International Conference on Very Large Data Bases (VLDB).
33. NGUYEN, H. 2008. GPU gems 3. Addison-Wesley.
34. OWENS, J. D., LUEBKE, D., GOVINDARAJU, N., HARRIS, M., KRUGER, J., LEFOHN, A. E., AND PURCELL, T. J. 2007. A survey of general-purpose computation on graphics hardware. Comput. Graph. Forum 26.
35. RAO, J. AND ROSS, K. A. 1999. Cache conscious indexing for decision-support in main memory. In Proceedings of the 25th International Conference on Very Large Data Bases (VLDB). Morgan Kaufmann Publishers Inc., San Francisco, CA, 78-89.
36. SCHNEIDER, D. A. ANDDEWITT, D. J. 1989. Aperformance evaluation of four parallel join algorithms in a shared-nothing multiprocessor environment. SIGMOD Rec. 18, 2, 110-121.
37. SELINGER, P. G., ASTRAHAN, M. M., CHAMBERLIN, D. D., LORIE, R. A., AND PRICE, T. G. 1979. Access path selection in a relational database management system. In Proceedings of the ACMSIGMOD International Conference on Management of Data (SIGMOD). ACM Press, New York, NY, 23-34.
38. SENGUPTA, S., HARRIS, M., ZHANG, Y., AND OWENS, J. D. 2007. Scan primitives for gpu computing. Proceedings of the ACM SIGGRAPH/EUROGRAPHICS Conference on Graphics Hardware.
39. SHAO, M., AILAMAKI, A., AND FALSAFI, B. 2005. DBmbench: Fast and accurate database workload representation on modern microarchitecture. In Proceedings of the Conference of the Centre for Advanced Studies on Collaborative Research (CASCON). IBM Press, 254-267.
40. SHATDAL, A., KANT, C., AND NAUGHTON, J. F. 1994. Cache conscious algorithms for relational query processing. In Proceedings of the 20th International Conference on Very Large Data Bases (VLDB). Morgan Kaufmann Publishers Inc., San Francisco, CA, 510-521.
41. STONEBRAKER, M., ABADI, D. J., BATKIN, A., CHEN, X., CHERNIACK, M., FERREIRA, M., LAU, E., LIN, A., MADDEN, S., O'NEIL, E., O'NEIL, P., RASIN, A., TRAN, N., AND ZDONIK, S. 2005. C-store: A columnoriented dbms. In Proceedings of the 31st International Conference on Very Large Data Bases. VLDB Endowment, 553-564.
42. SUN, C., AGRAWAL, D., AND ABBADI, A. E. 2003. Hardware acceleration for spatial selections and joins. In Proceedings of the ACM SIGMOD International Conference on Management of Data. ACM, New York, NY, 455-466.
43. TARDITI, D., PURI, S., AND OGLESBY, J. 2006. Accelerator: using data parallelism to program GPUS for general-purpose uses. In Proceedings of the International Conference on Architectural Support for Programming Languages and Operating Systems.
44. ZHOU, J., CIESLEWICZ, J., ROSS, K. A., AND SHAH, M. 2005. Improving database performance on simultaneous multithreading processors. In Proceedings of the 31st International Conference on Very Large Data Bases. VLDB Endowment, 49-60.
45. ZUKOWSKI, M., HEMAN, S., NES, N., AND BONCZ, P. 2006. Super-scalar RAM-CPU cache compression. In Proceedings of the 22nd International Conference on Data Engineering (ICDE). IEEE Computer Society, Washington, DC, 59.