Grant: Engage Plus Grants Program
University of Alberta
$12,500.00
A secure, cost-effective, and performance-optimized online social Web service
FY 2014-15
Summary
In the completed Engage project, a preliminary version of the social networking website for bridgingchina.ca was constructed with interface to Sina Microblog social networking site via OAuth 2.0. Currently under testing, several important steps remain before bridgingchina.ca can be taken into staging and eventually into production. These steps are centered around the issues of security, hosting and operational cost, performance, user data management, logging and analysis. In this continued project, we first aim to strengthening the security of the developed PHP and Mysql code so that the user information including password are strongly encrypted and protected and that malicious attacks to the database such as SQL injections can be detected and handled. Second, detailed cost analysis will be conducted to compare between dedicated servers, rented virtual hosts and cloud computing. Especially, the autoscaling mechanism of frontend servers as well as backend database via Amazon EC2, rackspace and possibly other cloud providers will be studied in detail to minimize the company operational cost. Third, several optimizations regarding page download and database query speed will be conducted to reduce the response time. Finally, detailed data analysis, logging and synchronization functions will be incorporated to handle the user data analysis and cleaning, move and synchronize data automatically between the testing server, staging server, and backup server. The objective is to continue to fix the problems found in the current version of code to build a secure, cost-effective and high performance website that matches production quality.
Program
Engage Plus Grants Program
Recipient
Location
Alberta, Canada
Recipient Type
Academia
Type
Grant
Source
NSERC's Awards Data
As published
Application id
463810-2014
Name nom
Niu, Di
Department département
Electrical and Computer Engineering
Organization id
9
Institution établissement
University of Alberta
Province en
Alberta
Province fr
Alberta
Country en
CANADA
Country fr
CANADA
Fiscal year exercice financier
2014
Competition year année de concours
2014
Award amount
12500
Program id
EGP2
Program name en
Engage Plus Grants Program
Program name fr
Programme de subvention d'engagement partenarial Plus
Group en
Research partnerships programs
Group fr
Programmes de partenariat
Committee code
1555
Committee name en
Prairie Internal Decision Committee
Committee name fr
Comité de décision interne pour les Prairies
Area of application code
801
Area of application group en
Information and communication services
Area of application group fr
Services d'information et de télécommunications
Area of application en
Computer software
Area of application fr
Logiciel
Research subject code
2720
Research subject group en
Information technology
Research subject group fr
Technologie de l'information
Research subject en
Computer systems software
Research subject fr
Logiciel de systèmes informatiques
Partie
1
Nb partie
1
Application title
A secure, cost-effective, and performance-optimized online social Web service
Keyword
NSERC
Application summary
In the completed Engage project, a preliminary version of the social networking website for bridgingchina.ca was constructed with interface to Sina Microblog social networking site via OAuth 2.0. Currently under testing, several important steps remain before bridgingchina.ca can be taken into staging and eventually into production. These steps are centered around the issues of security, hosting and operational cost, performance, user data management, logging and analysis. In this continued project, we first aim to strengthening the security of the developed PHP and Mysql code so that the user information including password are strongly encrypted and protected and that malicious attacks to the database such as SQL injections can be detected and handled. Second, detailed cost analysis will be conducted to compare between dedicated servers, rented virtual hosts and cloud computing. Especially, the autoscaling mechanism of frontend servers as well as backend database via Amazon EC2, rackspace and possibly other cloud providers will be studied in detail to minimize the company operational cost. Third, several optimizations regarding page download and database query speed will be conducted to reduce the response time. Finally, detailed data analysis, logging and synchronization functions will be incorporated to handle the user data analysis and cleaning, move and synchronize data automatically between the testing server, staging server, and backup server. The objective is to continue to fix the problems found in the current version of code to build a secure, cost-effective and high performance website that matches production quality.