Google scholar arxiv informatics ads IJAIS publications are indexed with Google Scholar, NASA ADS, Informatics et. al.

Call for Paper

-

July Edition 2021

International Journal of Applied Information Systems solicits high quality original research papers for the July 2021 Edition of the journal. The last date of research paper submission is June 15, 2021.

Advanced SQL Query To Flink Translator

Yasien Ghallab Gouda, Hager Saleh Mohammed, Mohamed Helmy Khafagy. Published in Databases

International Journal of Applied Information Systems
Year of Publication: 2016
Publisher: Foundation of Computer Science (FCS), NY, USA
Authors: Yasien Ghallab Gouda, Hager Saleh Mohammed, Mohamed Helmy Khafagy
10.5120/ijais2016451532
Download full text
  1. Yasien Ghallab Gouda, Hager Saleh Mohammed and Mohamed Helmy Khafagy. Article: Advanced SQL Query To Flink Translator. International Journal of Applied Information Systems 10(8):11-15, April 2016. BibTeX

    @article{key:article,
    	author = "Yasien Ghallab Gouda and Hager Saleh Mohammed and Mohamed Helmy Khafagy",
    	title = "Article: Advanced SQL Query To Flink Translator",
    	journal = "International Journal of Applied Information Systems",
    	year = 2016,
    	volume = 10,
    	number = 8,
    	pages = "11-15",
    	month = "April",
    	note = "Published by Foundation of Computer Science (FCS), NY, USA"
    }
    

Abstract

Information in the digital world, data play an important role in most of Computer Engineering applications. The increasing of data has been more difficult to store and analyze data using the traditional database. Apache Flink is a framework to Big Data Analytics in the large cluster. SQL-likes Query set of rules for make an interface between the user and big database, so very need to SQL To Flink translator that allow the user to run Advanced SQL Query top Flink without need writing JAVA code to reach their request, and also, Complex SQL Query in Flink is limited scalability. 2. In this paper, the system is devolved to run top Flink without changing in Flink framework. This system calls, Advanced SQL Query To Flink Translator This proposed system receives Advanced SQL Query from the user then generate Flink Code for executing this Query. Finally, it returns the results of Query to the user.

Reference

  1. Apache flink, 2 2016. https://ci.apache.org/projects/flink/flink-docs-master/.
  2. Apache hadoop, 2 2016. http://hadoop.apache.org/.
  3. Mapreduce, 2 2016. https://cloud.google.com/appengine/docs/python/dataprocessing.
  4. Tpc-h, 2 2016. http://www.tpc.org/tpch/.
  5. Marwah N Abdullah, Mohamed H Khafagy, and Fatma A Omara. Home: Hiveql optimization in multi-session environment. In 5th European Conference of Computer Science (ECCS’14), volume 80, page 89, 2014.
  6. Hussien SH. Abdel Azez, Mohamed H. Khafagy, and Fatma A. Omara. Joum: An indexing methodology for improving join in hive star schema. International Journal of Scientific & Engineering Research, 6:111–119, 2015.
  7. Narayan Gowraj, Prasanna Venkatesh Ravi, V Mouniga, and MR Sumalatha. S2mart: smart sql to map-reduce translators. In Web Technologies and Applications, pages 571– 582. Springer, 2013.
  8. Katarina Grolinger, Michael Hayes, Wilson Akio Higashino, Alexandra L’Heureux, David S Allison, Miriam Capretz, et al. Challenges for mapreduce in big data. In Services (SERVICES), 2014 IEEE World Congress on, pages 182–189. IEEE, 2014.
  9. Hesham A Hefny, Mohamed Helmy Khafagy, and M Wahdan Ahmed. Comparative study load balance algorithms for map reduce environment. International Journal of Computer Applications, 106(18):41–50, 2014.
  10. Mohamed Helmy Khafagy. Index to index two-way join algorithm. International Journal of Digital Content Technology and its Applications, 9(4):25, 2015.
  11. Mohamed Helmy Khafagy. Indexed map-reduce join algorithm. International Journal of Scientific & Engineering Research, 6(5):705–711, 2015.
  12. Rubao Lee, Tian Luo, Yin Huai, FushengWang, Yongqiang He, and Xiaodong Zhang. Ysmart: Yet another sql-tomapreduce translator. In Distributed Computing Systems (ICDCS), 2011 31st International Conference on, pages 25–36. IEEE, 2011.
  13. Ebada Sarhan, Atif Ghalwash, and Mohamed Khafagy. Queue weighting load-balancing technique for database replication in dynamic content web sites. In Proceedings of the 9th WSEAS International Conference on APPLIED COMPUTER SCIENCE, pages 50–55, 2009.
  14. Fawzya Ramadan Sayed and Mohamed Helmy Khafagy. Sql to flink translator. IJCSI International Journal of Computer Science Issues, 12(1):169, 2015.
  15. Mina Samir Shanoda, Samah Ahmed Senbel, and Mohamed Helmy Khafagy. Jomr: Multi-join optimizer technique to enhance map-reduce job. In Informatics and Systems (INFOS), 2014 9th International Conference on, pages PDC–80. IEEE, 2014.
  16. Ashish Thusoo, Joydeep Sen Sarma, Namit Jain, Zheng Shao, Prasad Chakka, Suresh Anthony, Hao Liu, Pete Wyckoff, and Raghotham Murthy. Hive: a warehousing solution over a map-reduce framework. Proceedings of the VLDB Endowment, 2(2):1626–1629, 2009.
  17. Yingzhong Xu and Songlin Hu. Qmapper: a tool for sql optimization on hive using query rewriting. In Proceedings of the 22nd international conference on World Wide Web companion, pages 211–212. InternationalWorldWideWeb Conferences Steering Committee, 2013.

Keywords

Big data, Flink, SQL Translator, Hadoop, Hive, Advanced SQL Query