Vol 7 Issue 3 July 2019-September 2019

Abstract: Hive is an open source is designed to handle a large amount of data. It is an open source is built on top of Hadoop. It stores data at tables like a relational database management system. Today, a many organization use Apache Hive to process their data. Hive is begin increasingly used in the many organizations so, a more efficient and flexible technique is needed to improve the query performance in Hive. The goal of this paper to conduct a comparative analysis between a two of a query optimization technique that used by Hive. These techniques are map-reduce and cost-based optimization. In the paper, we determine the methodology to perform the test. After performing the test, we conclude that the map-reduce was best response time of a query in the hive.

Keywords: Hive; query optimization; map-reduce; cost-based optimization.

Title: Query optimization techniques in Hive: Comparative Analysis

Author: Khadeeja Alsolami, Fahad Alqurashi

International Journal of Engineering Research and Reviews

ISSN 2348-697X (Online)

Research Publish Journals

Abstract: Central Database processing is becoming most demanding approach for accessing required data through multiple mobile nodes in a Location Based Service (LBS) system. This could be easy for the single location based system, but facing a lot of challenges when in moving mobile nodes. However, in this paper, we have designed a physical architecture for multiple moving mobile nodes to access data from a central database through wireless network. We discovered the data access rate when multiple queries were made to access required data from the central database. Consequently, we noticed that increasing the number of mobile nodes, increase the time for data access over the wireless network system and maintain the data provision for large set of queries. This experimental work could be applied for heterogeneous wireless network to provide better service in a large region.

Keywords: Central Database; Mobile Nodes; Location Based Services (LBS).

Title: Central Database Manipulation for Multiple Mobile Nodes over Wireless Network

Author: Mohammad Nawaf Altouri, Fahad Alqurashi

International Journal of Engineering Research and Reviews

ISSN 2348-697X (Online)

Research Publish Journals