Managing unstructured data in relational databases

Abstract

A relational database is a basic repository for many businesses, with its robust data structure for retrieving, organizing, and managing data. However, despite its data structure characteristic, a massive amount of data it contains remains unstructured. These unstructured data affects query processing performance and contributes to the difficulty of the user to manage or retrieve the data. Many attempts have been made to reorganize or directly process these data. In this paper, discusses methods of managing unstructured data in the relational database management system. And show the significance of managing these data. Furthermore, the difference in managing such data between relational and NoSQL databases is highlighted. This study will help developers and researchers in managing unstructured data and in addressing important issues that affect query processing which otherwise meaningless if those were not well managed.