Integrated Usage between Relational DBs and NoSQL DB
Kousuke Shiromoto, Teruhisa Hochin, Hiroki Nomiya · 2019
This paper proposes the system realizing integrated use of Relational Databases and a NoSQL Database. A heterogeneous information source integration system has been proposed. It enables equi-join and projection of tables without converting data. With this system, it became possible to handle various databases at the same time by using JDBC, but the databases which can be handled are only relational databases. Therefore, we add functions to the system to handle the NoSQL database which has been increasingly used in recent years. The table join execution time and the memory consumption of the system are experimentally evaluated. It showed that the performance is tolerable in practical use as compared with integrated use of only relational database. We also showed that it is practical to change the join order or to register column families which are unique elements of HBase.