Portfolio

Correlation between Covid-19 and Economic (2020 - 2021)

• DBMS: MySQL.
• Languages: Python, HTML/CSS/Javascript, Shell script.
• Technologies: ETL, Apache Airflow, Apache Spark, Docker, Flask, Restful API
• Github: sb-capstone This project provides ready-to-analyze datasets for Covid-19 and other related aspects in our daily life such as stock index, unemployment rate, job opennings, bussiness activities. We implement a full stack solution includes: (1) the front-end dashboard with Flask + jQuery, (2) ETL pipeline with Apache Spark + Python and Apache Airflow for scheduling ETL tasks and (3) MySQL as the back-end DBMS.

Revisiting write-ahead logging with NVDIMM (2019)

• DBMS: MySQL.
• Languages: C/C++, Shell script.
• Technologies: PMDK from pmem.io, TPC-C, Linkbench.
• Public paper(s): conf. paper

PB-NVM: A High Performance Partitioned Buffer on NVDIMM (2018 - 2019)

• DBMS: MySQL, MongoDB.
• Languages: C/C++, Python, Shell script.
• Technologies: PMDK from pmem.io, TPC-C, YCSB, Linkbench.
• Public paper(s): SCIE paper
• Githubs: [MySQL 5.7], [MongoDB]

MongoDB Journaling evaluation with NVDIMM (2017)

• DBMS: MongoDB.
• Languages: C/C++, Shell script.
• Technologies: NVDIMM, YCSB.
• Public paper(s): [conf. paper]

Dynamic Stream Mapping on MongoDB (2017)

• DBMS: MongoDB.
• Languages: C/C++, Shell script.
• Technologies: Multi-streamed SSD, YCSB, Linkbench.
• Public paper(s): [SCIE paper], [Conf. paper]
• Github: [mongo-mssd]

Optimize MongoDB with TRIM command (2016)

• DBMS: MongoDB.
• Languages: C/C++, Shell script.
• Technologies: TRIM command, YCSB.
• Public paper(s): [conf. paper]
• Github: [mongo-trim]

Analyzed I/O characteristics of MongoDB using YCSB benchmark and blktrace. Described space management in WiredTiger. Optimized MongoDB using TRIM command, improved throughput up to 14.7%

Stock Prices Matching (2013)

• OS: Androi.
• Languages: Java.
• Technologies: Androi Studio, Eclipse.
• Public paper(s): [thesis paper]
• Github:
• Presentations:* [KDBC 2015]