Research and Portfolios
For Web Development
A CSE154 Exploration Session by Shuowei Li
lis26@uw.edu
Attendance
Special thanks to Jeremy Zhang for the attendance app!
https://staff.washington.edu/jkzhang/attendance
Password:
Brief Introduction on my Research
Temperature Monitor
What if we have thousands of sensors that deployed,
and researchers across the country need to access the data?
SQL
A method of structuring data as tables associated by shared attributes
The image by xkcd.
SQL so far
Database querying
Database manipulation (create/insert)
Accessing SQL from PHP with the PDO object
Join Query
Then How About Apply it To Research?
- Database for data processing in research
What data do we have?
- Sensor type
- Sensor manufacturing companies
- Sensor deployment period
- Sensor deployment location
- Sensor reading
How about a giant table?
| id | sensor_type | mfr | |
|---|---|---|---|
| sensor_loc_x | sensor_loc_y | sensor_loc_z | loc_description |
| start_date | stop_data |
How about splitting table?
If the sample rate of the sensors is 100 MHz, does the insert function fast enough to store the data?
How about 100 GHz?
Database Design
How to design a database?
Question
If we want all temperature data that manufactured by company 1 during 03/15/2018 and 04/01/2018, what should we do?
Portfolio
Namecheap.com - one of many web hosting services (alternatives to UW student web hosting, but not free)
Dennis Video (JavaScript with music)
Cameron's World - enter at your own risk
Interactive story-mode website
Copyright: the materials are copied from the CSE 154 SPR 2018 lecture 28.
Google Analytics
The image by Kristi Hines.
Why do we need Google Analytics?
How to install Google Analytics
Set up account and property
The image by Kristi Hines.
Install your tracking code
The image by Kristi Hines.
Install your tracking code
Add the tracking code into a JS file or a HTML file.
The image by Kristi Hines.
View Google Analytics data
The image by Kristi Hines.