UWB Logo

Computer Science and Software Engineering Capstone Presentations

Summer Quarter

August 21, 2020

Jiarong Zhou

"System and Database Management Project"

(Kai Venture LLC)

Faculty Advisor: Dr. Laurie Anderson

Abstract

The project in KAI Venture LLC focuses on cloud database management of the grocery enterprise and system testing. He first task I have done is database creation and the data modification. The purpose of the task is to choose a smaller from the old database and more accurate part of the data set and use that subset for viewing and implementing. The main issue for this ask is that the system will generate thousands of rows of data everyday and some necessary information is not accurate. In the new database statement, I implement database triggers which are special stored procedures that are run when specific actions occur within a database. Though implementing Change Data Capture (CDC) techniques, the new database works well for the new Point of Sales system. From this task, I leaned CDC implementation and improved my system thinking ability. I also learned the benefits and mechanisms of cloud storage (in this task, we stored data in AWS).

The second task I have completed is testing the Point of Sales system and Point of Sales administration system. My main duty is to make sure the Point of Sales system works well for both grocery stores and online stores. If issues are detected, I need to store my testing procedure and problems description in the system log and communicate with the software development team about the issue. I also need to make sure the software development team understand the issue and the bugs are fixed in case it crashes the system. Once I found that the search box in the Point of Sales system can only search the products have PLU, but the system cannot retrieve the products have SKU, I made a demo in order to make the description clear. Through this task, I mastered the system testing skill and made improvements on my communication skills.

Updated August 19, 2020, 17:53