Materialized View Selection Based on Adaptive Genetic Algorithm and Its Implementation with Apache Hive

References

• R. Hylock, F. Currim, “A maintenance centric approach to the view selection problem,” Information Systems, (2013).
   Web of Science ®Google Scholar
• J. Li, X. Li, J. Lv, “Selecting Materialized Views Based on Top-k Query Algorithm for Lineage Tracing,” Proc. Third Global Congress on Intelligent Systems (GCIS) (IEEE, 2012), pp. 46–49.
   Google Scholar
• A. Cuzzocrea, M. S. Hacid, N. Grillo, “Effectively and efficiently selecting access control rules on materialized views over relational databases,” Proc. Fourteenth International Database Engineering & Applications Symposium, (ACM, 2010), pp. 225–235.
   Google Scholar
• J. S. Sohn, J. H. Yang, I. J. Chung, “Improved View Selection Algorithm in Data Warehouse,” IT Convergence and Security, (Springer Netherlands, 2013), pp. 921–928.
   Google Scholar
• Ashish Thusoo, Joydeep Sen Sarma, Namit Jain, Zheng Shao, Prasad Chakka, Ning Zhang, Suresh Antony, Hao Liu, Raghotham Murthy, “Hive - A petabyte scale data warehouse using hadoop,” Proc. 26th IEEE International Conference on Data Engineering, ICDE. (2010), pp. 996–1005.
   Google Scholar
• Ashish Thusoo, Joydeep Sen Sarma, Namit Jain, Zheng Shao, Prasad Chakka, Suresh Anthony, Hao Liu, Pete Wyckoff, Raghotham Murthy, “Hive - A warehousing solution over a map-reduce framework,” Proc. the VLDB Endowment, 2(2), (2009), pp. 1626–1629.
   Google Scholar
• V. Harinarayan, A. Rajaraman, J. D. Ullman, “Implementing data cubes efficiently,” Proc. ACM SIGMOD Record, 25(2), ( ACM, 1996), pp. 205–216.
   Google Scholar
• J. J. M. Mendes, J. F. Gonalves, M. G. C. Resende, “A random key based genetic algorithm for the resource constrained project scheduling problem,” Computers & Operations Research, 36(1), (2009), pp. 92–109.
   Web of Science ®Google Scholar
• M. H. Mehta, “Hybrid Genetic Algorithm with PSO Effect for Combinatorial Optimization Problems,” International Journal of Advanced Computer Research, 2(4), (2012), pp. 300–305.
   Google Scholar
• Michael Negnevitsky, “Artificial Intelligence: A Guide to Intelligent Systems,” Third Edition, Pearson Education Limited, (2011)
   Google Scholar
• L. Zhou, X. He, K. Li, “An Improved Approach for Materialized View Selection Based on Genetic Algorithm,” Journal of Computers, 7(7), (2012), pp. 1591–1598.
   Google Scholar
• T. V. V. Kumar, M. Haider, “A query answering greedy algorithm for selecting materialized views, Computational Collective Intelligence,” Technologies and Applications, (Springer Berlin Heidelberg, 2010), pp. 153–162.
   Google Scholar
• Yue Liu, Songlin Hu, Tilmann Rab, Wantao Liu, Hans Arno Jacobsen, Kaifeng Wu, Jian Chen, Jintao Li, “DGFIndex for smart grid: Enhancing hive with a cost-effective multidimensional range index,” Proc. the VLDB Endowment, 7(13), (2014), pp. 1496–1507.
   Google Scholar
• I. Mami, Z. Bellahsene, “A survey of view selection methods,” ACM SIGMOD Record, 41(1), (2012), pp. 20–29.
   Web of Science ®Google Scholar
• C. Zhang, J. Yang, “Genetic algorithm for materialized view selection in data warehouse environments,” Data Warehousing and Knowledge Discovery, (Springer Berlin Heidelberg, 1999), pp. 116–125.
   Google Scholar
• X. Li, X. Qian, J. Jiang, et al., “Shuffied frog leaping algorithm for materialized views selection,” Proc. Second International Workshop on Education Technology and Computer Science (ETCS), (IEEE, 2010), pp. 7–10.
   Google Scholar
• K. V. Badmaeva, “The algorithm of view selection for materializing in specialized data warehouses,” Proc. 34th International Convention of MIPRO, (IEEE, 2011), pp. 1555–1559.
   Google Scholar
• S. H. Talebian, S. A. Kareem, “A weight based genetic algorithm for selecting views,” Proc. 2012 International Conference on Graphic and Image Processing, International Society for Optics and Photonics, (2013).
   Google Scholar
• M. Lawrence, “Multiobjective genetic algorithms for materialized view selection in OLAP data warehouses,” Proc. the 8th annual conference on Genetic and evolutionary computation, (ACM, 2006), pp. 699–706.
   Google Scholar
• Z. Wang, D. Zhang, “Optimal genetic view selection algorithm under space constraint,” International Journal of Information Technology, 11(5), (2005), pp. 44–51.
   Google Scholar
• H. Gupta, I.S. Mumick, “Selection of views to materialize in a data warehouse,” IEEE Transactions on Knowledge and Data Engineering, 17, (2005), pp. 2443.
   Web of Science ®Google Scholar
• Yin Huai, Ashutosh Chauhan, Alan Gates, Gunther Hagleitner, Eric N. Hanson, Owen O'Malley, Jitendra Pandey, Yuan Yuan, Rubao Lee, Xiaodong Zhang, “Major technical advancements in Apache Hive.” Proc. 2014 ACM SIGMOD International Conference on Management of Data, (2014), pp. 1235–1246.
   Google Scholar
• Yingzhong Xu, Songlin Hu, “QMapper: A tool for SQL optimization on hive using query rewriting,” Proc. 22nd International Conference on World Wide Web, (2013), pp. 211–212.
   Google Scholar
• Mahsa Mofidpoor, Nematollaah Shiri, T. Radhakrishnan, “Index-based join operations in Hive,” Proc. IEEE International Conference on Big Data, (2013), pp. 26–33.
   Google Scholar
• Taoying Liu, Jing Liu, Hong Liu, Wei Li, “A performance evaluation of Hive for scientific data management,” Proc. IEEE International Conference on Big Data, (2013), pp. 39–46.
   Google Scholar
• Zhixiang Zhu, Dongjin Yu, “Selecting Materialized Views based on Genetic Algorithm,” Advanced Science and Technology Letters,Vol.45, (2014), pp.65–69.
   Google Scholar