Title: SDMS: smart database management system for accessing heterogeneous databases

Authors: Khaleel Mershad; Ali Hamieh

Addresses: Department of Computer and Communications Engineering, Arts, Sciences & Technology University in Lebanon (AUL), P.O. Box 14 – 6495, Beirut, Lebanon ' Department of Computer and Communications Engineering, Arts, Sciences & Technology University in Lebanon (AUL), P.O. Box 14 – 6495, Beirut, Lebanon

Abstract: Digital data are usually divided into structured and unstructured types. Although unstructured data are becoming a significant part of digital data, there are still a large number of organisations that save their data into structured datastores. However, with many companies shifting into utilising non-structural database management systems (DBMS), they find themselves obliged to translate and convert their old structured data into new forms. In order to avoid the consequences of such costly operations, we present the basics of a new database management system that allows a database user to access and query both structural and non-structural databases at the same time using a single query. We explain the details of various types of queries (insert, update, delete, and search) that are performed by the proposed system, and discuss the tests that we made to measure the end-to-end delays of these queries on two MySQL and HBase databases.

Keywords: big data; structured data; unstructured data; smart database management system; SDBMS; mixed query language; MQL; heterogeneous databases.

DOI: 10.1504/IJIIDS.2021.114513

International Journal of Intelligent Information and Database Systems, 2021 Vol.14 No.2, pp.115 - 152

Received: 09 Nov 2019
Accepted: 19 Feb 2020

Published online: 02 Mar 2021 *

Full-text access for editors Access for subscribers Purchase this article Comment on this article