ADAPTING A NOSQL QUERY LANGUAGE FOR QUERYING SQL AND NOSQL DATABASES
ADAPTING A NOSQL QUERY LANGUAGE FOR QUERYING SQL AND NOSQL DATABASES
No Thumbnail Available
Date
2017-01
Authors
WOJI, Alhamdu Shichet
Journal Title
Journal ISSN
Volume Title
Publisher
Abstract
Not all kinds of data can find efficient storage and manipulation in Relational (or SQL) database and neither is NoSQL database the best fit for all kinds of data. A hybrid database (a combination of both SQL and NoSQL databases for storage) is a better alternative where structured data are kept in the relational database and the rest in NoSQL database. The hybrid database comes with its challenges; among them is the necessity for the database administrator to learn the query languages of the databases that constitute the hybrid database. This research is focused on using one query language to query the hybrid database via a software layer. NoSQL (MongoDB) query language is adopted as the query language for the hybrid database in this research because it is the fastest growing query language and it is less vulnerable to injections as compared to SQL. The scope of operations supported by the software layer is limited to Create, Read, Update and Delete (CRUD) and MongoDB syntax had to be extended to cater for SQL functionalities necessary to execute CRUD operations in relational databases. The software layer was developed using Java Programming Language; it translates the MongoDB query language syntax to SQL for execution. For evaluation, both databases were fed with the same data via the software layer simultaneously and the CRUD operations were tested simultaneously on the hybrid database and the same result sets were obtained for each database; this asserts that the translation and execution were successful.
Description
A THESIS SUBMITTED TO THE SCHOOL OF POSTGRADUATE STUDIES,
AHMADU BELLO UNIVERSITY IN PARTIAL FULFILLMENT OF THE
REQUIREMENTS FOR THE AWARD OF THE DEGREE OF MASTER OF
SCIENCE IN COMPUTER SCIENCE
DEPARTMENT OF MATHEMATICS
AHMADU BELLO UNIVERSITY,
ZARIA, NIGERIA
Keywords
NOSQL QUERY LANGUAGE, NOSQL DATABASES, QUERYING SQL