Carleton University - School of Computer Science Honours Project
Winter 2022
Application of Database Systems in Mobile Computing
Victor Yang
SCS Honours Project Image
ABSTRACT
In COMP 2601 Mobile Computing, which is for mobile application development, there have not been any database components in its assignments. In my thesis, I study the possibilities of adding database components to these mobile app assignments, which had not been done before. In the Fall term, I first survey popular open-source database systems, both SQL and NoSQL. I also study how to design SQL and NoSQL database applications, and the differences between SQL and NoSQL databases. I then study how to set up both Android and XCode development environments with SQL and NoSQL database packages. I choose to use SQLite, a SQL database system, and Couchbase Lite, a NoSQL database system, because they are embeddable in mobile applications. For each COMP 2601 assignment, I study the possibility of adding database components, and propose both relational and NoSQL database schemas for each assignment. In the Winter term, I have implemented the proposed database components for all these assignments in both Android Studio and XCode using SQLite and Couchbase Lite. From my database implementations for the 4 Mobile Computing assignments, I have shown that it is possible to add database components to each of them. Therefore, in the future offerings of COMP 2601, adding database components can be considered for its assignments, tutorials and other deliverables.