Migrate and Map: A Framework to Access Data from Mysql, Mongodb or Hbase Using Mysql Queries

Journal Title: IOSR Journals (IOSR Journal of Computer Engineering) - Year 2016, Vol 18, Issue 3

Abstract

Abstract: Due to ever-increasing amount of data, scalability factor of the databases becomes a major constraint. Moreover, traditional relational databases fix the user’s perspective to view data in tabular format. Parallel databases emerged to be one of the solutions to tackle the scalability constraint which was laterreplaced by more scalable and efficient solution called NoSQL databases. By using the advantages of NoSQL we proposed a framework to migrate data from MySQL to NoSQL databases that is HBase and MongoDB. The framework will be used to map the MySQL query to HBase and MongoDB query format and fetch the datafaster by introducing a decision maker that selects the database from which data can be fetched at a relatively faster rate, thus elevating the system performance.

Authors and Affiliations

Piyush Nikam , Tushar Patil , Gayatri Hungund , Ankit Pagar , Aditi Talegaonkar , Ms. Soudamini Pawar

Keywords

Related Articles

 Steps to System Reconfiguration in a Distributed DatabaseSystem: A Fault-tolerant Approach

 Abstract: In this paper, we examine steps to system reconfiguration in a Distributed Database using some faulttolerance scheme for a distributed database system that is compatible with respect to system failure i.e...

 Multipath Routing in Wireless Sensor Networks: A Survey and Analysis

 Abstract: Due to restricted communication range and high density of sensor nodes in wireless sensor network, forwarding packets is an important field of research in sensor networks. Nowadays, multipath routing appr...

Analysis and Interpretation of Coronary Artery Blockage using Soft Computing Techniques

Abstract: Analysis and interpretation of Myocardial infarction, is very important at the early stage to detect the possible risk for heart attacks. Various non-invasive imaging modalities have been used for better diagno...

 Wavelet Based Features for Defect Detection in Fabric using Genetic Algorithm

 Abstract: In this paper a new scheme is proposed for Fabric defect detection in textile industry. For this purpose, wavelet transformer is used as feature extractor of coefficients of fabric. These coefficients c...

 A Review of Optical Character Recognition System forRecognition of Printed Text

 Abstract: As we move ahead in technology advancements, from simple data processing, to intelligentcomputing, one area of research undergoing advancement, is the system of reading text characters on an image.Optical...

Download PDF file
  • EP ID EP133479
  • DOI -
  • Views 80
  • Downloads 0

How To Cite

Piyush Nikam, Tushar Patil, Gayatri Hungund, Ankit Pagar, Aditi Talegaonkar, Ms. Soudamini Pawar (2016). Migrate and Map: A Framework to Access Data from Mysql, Mongodb or Hbase Using Mysql Queries. IOSR Journals (IOSR Journal of Computer Engineering), 18(3), 13-17. https://europub.co.uk/articles/-A-133479