MQL: Mixed Query Language for Querying MySQL and HBase Databases

Abstract

During the last twenty years, the amount of stored digital data has witnessed an enormous growth. This data is usually divided by the scientific community into structured and unstructured data. Although unstructured data is becoming a significant part of big data, there are still a large number of data generators that save their data into traditional structured databases. With the advantages that exist in adopting non-structural database systems to save various kinds of data, many companies and institutions are shifting into acquiring and utilizing a professional non-structural DBMS. These organizations find themselves obliged to translate and convert their old structured data into new formats and forms, in order to make a copy of this data in the new system. In order to avoid the consequences of such costly operations, we present the basics of a query language that allows a database user to query structural and non-structural databases at the same time using a single query. Our proposed language allows a database user to view the two databases (structured and non-structured) as a single DB on which a single query is executed. We present a testing of our system by using MySQL and HBase as the structured and non-structured databases.