//Project




  • Database Design and Build

  • A Relational Bottom-up Layered Database Internal Components Build
    • Constructed a record-based file manager (RBFM) to manage records and pages in files and a catalog-based relation manager (RM) for maintaining catalogs/indexes files.
    • Implemented an index manager (IX) based on B+ Tree structure to create indexes over unordered records stored in heap file.
    • Built a query engine (QE) supporting relational operators like filtering, projection, join (nested-block join, nested-index join, grace hash join) and aggregation.
    • Database performance reached 1,000,000 records insertion within 5 minutes.







  • CatSneeze Online Movie Web Application

  • A Movie Selling Full Stack Web application build.
    • Constructed a MVC web-based application using Restful standrad with Java and DBMS techniques.
    • Using Java servlet for controller hierarchy build, Ajax for front-back end interaction in HTTPs style, jQuery for front end dynamic display and load the application onto AWS EC2 and Google GCP instance.
    • Using Apache load balancer in one instance to dispatcher requests in round-robin way combined with sticky session method and Tomcat in other two instances to handle requests. Enabling connection pooling and prepared statement with Master-Slave Mysql to scale system performance. Used JMeter for system performance evaluation.
    • Implemented movies/stars search service with full-text search and fuzzy search in a Database UDF method in C++, added stored procedures in database for complex service handling, implemented an external Java program for XML parsing to write movie records into database.
    • Implemented a simple corresponding Android APP interacting with the same back end service.







  • WoodMall Services

  • Back End Services Supporting Electronic Shopping.
    • Implemented whole shopping services with users, orders, carts, products management.
    • Used SpringMVC for requests routing and handling and Spring for IoC, used Mybatis for DAO/Mappers configuration and pagination, used LogBack plugin for exception log maintaining.
    • Built external vsftpd server in CentOs VM for img/richtext uploading, integrated alipay API in sandbox mode for payment testing, used Guava cache in LRU mode for user token memorization.







  • CS Building Indoor Routing

  • 4 Floors Building Indoor Routing
    • Built responsive layout available both for PC and mobile, suggested destinations among multi-floors sorted by distance by user’s input prefix, displayed shortest routes within canvas using Dijkstra.
    • Implemented modularize IoT based services calculating routes through tracking interaction between user’s phone and sensors(beacons/wifi routers) and obtaining data from Tippers services (http://tippersweb.ics.uci.edu/).







  • Alliance Website Build

  • An enterprises/colleges alliance organization website (link)
    • Led a small team to build the four roles permission system part and display part.
    • Built front/back stage services using auto-populated test data.
    • Front end with jQuery and back end with PHP in Restful standrad.







  • Oriented Crawler Construction

  • Downloading related product data automatically
    • Achieved recursively code parsing and data matching.
    • Provided a user-friendly interface with embedded browser (PyQt).
    • Stored crawled data/jpg (as json type) in Mongodb.







  • Hao Duo Yu online shopping website

  • • Implemented responsive home page with embedded baidu map, user center in which user can add/delete through ajax, and login system.
    • A responsive college-scope shopping website in which students can not only buy used things but buy skills (eg. academic services).
    • Front end with jQuery for http, back end with spring boot for service maintaining and data persistence with mysql.







  • College Lost&Found simple website

  • • Used Jsp as View, Servlet as controller, and Java Bean as model (Model-View-Control architecture).
    • Introduced Boostrap to build device-adaptive pages.







  • Fish feeding game

  • • Implemented a small device-adaptive H5 game to feed the fish.
    • Built a element monitor component to control the number of fish food.







  • Double Teris

  • • Implemented a small command line Teris game in C++.
    • player 1 use w/s/a/d, player 2 use up/down/left/right.







  • Image processing program

  • • Implemented a small image processing program.
    • The application can transform pictures basically.







  • Information Theoretical Approach of Interactive Secure Channels

  • Undergraduate graduation project advised by Prof. Angsheng Li, Institute of Software Chinese Academy of Sciences
    • Implemented whole communication system to transfer image signal in Matlab.
    • Designed interaction models which has lower Information leakage rate.