ADAPTING A NOSQL QUERY LANGUAGE FOR QUERYING SQL AND NOSQL DATABASES

Simple item page
dc.contributor.authorWOJI, Alhamdu Shichet
dc.date.accessioned2017-09-26T07:48:34Z
dc.date.available2017-09-26T07:48:34Z
dc.date.issued2017-01
dc.descriptionA 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, NIGERIAen_US
dc.description.abstractNot 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.en_US
dc.identifier.urihttp://hdl.handle.net/123456789/9231
dc.language.isoenen_US
dc.subjectNOSQL QUERY LANGUAGEen_US
dc.subjectNOSQL DATABASESen_US
dc.subjectQUERYING SQLen_US
dc.titleADAPTING A NOSQL QUERY LANGUAGE FOR QUERYING SQL AND NOSQL DATABASESen_US
dc.typeThesisen_US
Files
Original bundle
Now showing 1 - 1 of 1
No Thumbnail Available
Name:
ADAPTING A NOSQL QUERY LANGUAGE FOR QUERYING SQL AND NOSQL DATABASES.pdf
Size:
1.01 MB
Format:
Adobe Portable Document Format
Description:
Download
License bundle
Now showing 1 - 1 of 1
No Thumbnail Available
Name:
license.txt
Size:
1.62 KB
Format:
Item-specific license agreed upon to submission
Description:
Download
Collections
SCIENCE