Zerun Zhang

As required by the course, collaborated with a partner to develop a front-end and back-end separated system for placing orders with a logging company.
Partner used Vue and Node.js for the entire front-end development, while the back-end design and development was my responsibility.
Designed the back-end using a RESTful approach to ensure simplicity and efficiency.
Designed the MySQL database structure, splitting tables appropriately to reduce the number of queries per transaction.
Wrote all SQL queries using MyBatis, optimizing complex queries to prevent long execution times.
Designed APIs and implemented core back-end logic using Spring Boot.

Enabled the annotation of specific pedestrian images through the webpage, allowing the model to extract features.
Used these extracted features to search for pedestrians in videos, with the target pedestrians being highlighted with a red box in the output video.
Tested different feature extraction and comparison methods to improve accuracy.
Optimized real-time video transmission from the back-end to the front-end using WebSocket, ensuring smoother video playback

Developed a data processing demo application, covering tasks from reading raw data to analyzing and visualizing it.
Used Python to read raw data from Excel and Pandas to structure, clean, and fix missing or anomalous data.
Stored data in an HBase database on the server using HappyBase.
Connected to Spark via PySpark to retrieve data from HBase, performed various computational tasks, and aggregated the data for further analysis.
Visualized the processed data using Python to aid in analysis.