Skip to main content
SpringerLink
Log in

Accelerating EGENMR Database Operations Using GPU Processing

  • Conference paper
  • First Online:
Proceedings of the Second International Conference on Computational Intelligence and Informatics

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 712))

Abstract

Data is growing at faster speed. In cloud, fast processing has become essential need to process hefty data. The earlier EGENMR system was developed for process large amount of data present in cloud repositories with the help of MapReduce functions we concluded that the system is better than the latest techniques for processing large amount of data. In this paper, we are enhancing EGENMR by further enhancing the speed of database query operation by using GPU as a co-processor. A theoretical comparison is made in terms of time taken and complexity for hybrid query processing using GPU and EGENMR.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 129.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 169.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. S. Malhotra, M.N. Doja, B. Alam and M. Alam, “E-GENMR: Enhanced Generalized Query Processing using Double hashing technique through Map Reduce in cloud Database Management System,” Journal of Computer Science, 2017.

    Google Scholar 

  2. J. Dean and S. Ghemawat, “MapReduce: simplified data processing on large clusters,” Communications of the ACM, vol. 51, no. 1, pp. 107–113, 2008.

    Article  Google Scholar 

  3. P. Ghodsnia, “An In-GPU-Memory Column-Oriented Database for Processing Analytical Workloads,” in In proceedings of VLDB PhD Workshop, 2012.

    Google Scholar 

  4. B. He, K. Yang, R. Fang, M. Lu, N. Govindaraju, Q. Luo and P. Sander, “Relational joins on graphics processors,” Proceedings of the ACM SIGMOD international conference on Management of data, pp. 511–524, 2008.

    Google Scholar 

  5. N. K. Govindaraju, J. Gray, R. Kumar and D. Manocha, “GPUTeraSort: high performance graphics co-processor sorting for large database management,” Proceedings of the 2006 ACM SIGMOD international conference on Management of data, pp. 325–336, 2006.

    Google Scholar 

  6. J. Cheng, M. Grossman and T. McKercher, Professional CUDA C Programming, Indianapolis, Indiana: John Wiley & Sons, 2014.

    Google Scholar 

  7. P. Bakkum and K. Skadron, “Accelerating SQL database operations on a GPU with CUDA,” in Proceedings of the 3rd Workshop on General-Purpose Computation on Graphics Processing Units, Pittsburgh, Pennsylvania, 2010.

    Google Scholar 

  8. S. Breß, E. Schallehn and I. Geist, “Towards Optimization of Hybrid CPU/GPU Query Plans in Database Systems,” New Trends in Databases and Information Systems, vol. 185, pp. 27–35, 2013.

    Google Scholar 

  9. S. Breß and G. Saake, “Why it is time for a HyPE: A hybrid query processing engine for efficient GPU coprocessing in DBMS,” in Proceedings of the VLDB Endowment, Trento, Italy, 2013.

    Article  Google Scholar 

  10. S. Breß, N. Siegmund, M. Heimel, M. Saecker, T. Lauer, L. Bellatreche and G. Saake, “Load-aware inter-co-processor parallelism in database query processing,” Data & Knowledge Engineering, vol. 93, no. C, pp. 60–79, 2014.

    Article  Google Scholar 

  11. K. Angstadt and E. Harcourt, “A virtual machine model for accelerating relational database joins using a general purpose GPU,” in Proceedings of the Symposium on High Performance Computing, Alexandria, Virginia, 2015.

    Google Scholar 

  12. B. He, M. Lu, K. Yang, R. Fang, N. K. Govindaraju, Q. Luo and P. V. Sander, “Relational query coprocessing on graphics processors,” ACM Transactions on Database Systems, vol. 34, no. 4, pp. 1–39, 2009.

    Article  Google Scholar 

  13. E. Shehab, A. Algergawy and A. Sarhan, “Accelerating relational database operations using both CPU and GPU co-processor,” Computers & Electrical Engineering, vol. 57, no. C, pp. 69–80, 2017.

    Article  Google Scholar 

  14. H. H. O. Keh Kok Yong and V. V. Yap, “GPU SQL Query Accelerator,” International Journal of Information Technology, vol. 22, no. 1, pp. 1–18, 2016.

    Google Scholar 

  15. S. Breß, F. Beier, H. Rauhe, K.-U. Sattler, E. Schallehn and G. Saake, “Efficient co-processor utilization in database query processing,” Information Systems, vol. 38, no. 8, pp. 1084–1096, 2013.

    Article  Google Scholar 

  16. Y. Chen, Z. Qiao, S. Davis, H. Jiang and K.-C. Li, “Pipelined Multi-GPU MapReduce for Big-Data Processing,” in Computer and Information Science. Studies in Computational Intelligence, vol 493, Heidelberg, 2013.

    Chapter  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Jamia Millia Islamia, New Delhi, India

    Shweta Malhotra, Mohammad Najmud Doja, Bashir Alam & Mansaf Alam

Authors
  1. Shweta Malhotra
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Mohammad Najmud Doja
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Bashir Alam
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Mansaf Alam
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Shweta Malhotra .

Editor information

Editors and Affiliations

  1. Department of Electronics and Communication Engineering, Shri Ramswaroop Memorial Group of Professional Colleges, Lucknow, Uttar Pradesh, India

    Vikrant Bhateja

  2. Departamento de Engenharia Mecânica, Universidade do Porto, Porto, Portugal

    João Manuel R.S. Tavares

  3. Department of Computer Science and Engineering, JNTUH College of Engineering Hyderabad (Autonomous), Hyderabad, Telangana, India

    B. Padmaja Rani

  4. Department of Computer Science and Engineering, JNTUH College of Engineering Hyderabad (Autonomous), Hyderabad, Telangana, India

    V. Kamakshi Prasad

  5. CMR Technical Campus, Hyderabad, Telangana, India

    K. Srujan Raju

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer Nature Singapore Pte Ltd.

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Malhotra, S., Doja, M.N., Alam, B., Alam, M. (2018). Accelerating EGENMR Database Operations Using GPU Processing. In: Bhateja, V., Tavares, J., Rani, B., Prasad, V., Raju, K. (eds) Proceedings of the Second International Conference on Computational Intelligence and Informatics . Advances in Intelligent Systems and Computing, vol 712. Springer, Singapore. https://doi.org/10.1007/978-981-10-8228-3_62

Download citation

  • DOI: https://doi.org/10.1007/978-981-10-8228-3_62

  • Published:

  • Publisher Name: Springer, Singapore

  • Print ISBN: 978-981-10-8227-6

  • Online ISBN: 978-981-10-8228-3

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics

Search

Navigation