SDMS: smart database management system for accessing heterogeneous databases. (2nd March 2021)

• Record Type: Journal Article
• Authors: Mershad, Khaleel; Hamieh, Ali
• Is Part Of: International journal of intelligent information and database systems. Volume 14:Number 2(2021)
• Page Start: 115
• Page End: 152
• Publication Date: 2021-03-02
• Subjects: big data -- structured data -- unstructured data -- smart database management system -- SDBMS -- mixed query language -- MQL -- heterogeneous databases; Database management -- Computer programs -- Periodicals; Information retrieval -- Computer programs -- Periodicals; Information storage and retrieval systems -- Computer programs -- Periodicals; Artificial intelligence -- Periodicals; Expert systems (Computer science) -- Periodicals; Intelligent agents (Computer software) -- Periodicals; 006.33
• Languages: English
• ISSNs: 1751-5858

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.