Online Translation Service Capstone Design - PowerPoint PPT Presentation

1 / 33
About This Presentation
Title:

Online Translation Service Capstone Design

Description:

Protecting against SQL Injection Attacks. This login would allow. access to any invalid ... Professional web hosting or dedicated server. Questions? ... – PowerPoint PPT presentation

Number of Views:47
Avg rating:3.0/5.0
Slides: 34
Provided by: meruCecs
Category:

less

Transcript and Presenter's Notes

Title: Online Translation Service Capstone Design


1
Online Translation ServiceCapstone Design
  • Eunyoung Ku
  • Jason Roberts
  • Jennifer Pitts
  • Gregory Woodburn
  • Kim Tran

2
System Overview
  • A system is needed to facilitate the interactions
    between the customers, translators, and managers
    of an online translation service.
  • Must be implemented as a web interface to extend
    the service to users worldwide.

3
UsersCustomer
  • Receive translation quotes
  • Upload documents, specifying document
    information such as target and original languages
    and urgency of translation
  • Monitor progress of submissions
  • Download translated documents upon completion
  • Provide quality ratings for completed translations

4
UsersTranslator
  • View recent document submissions
  • Download documents to translate
  • Submit translated version of the document

5
Users Manager
  • Add new users to the system
  • Remove users from the system
  • View customer activity summaries
  • View translator productivity reports

6
Server and Development Environment
  • Apache HTTP server for Windows XP
  • MySQL Database Server
  • Server side scripting in PHP
  • World Wide Web Consortiums XHTML and CSS
    compliance

7
Security Requirements
  • Protect users identities by securing database as
    well as sessions
  • MySQL server configured to only accept local
    connections using named pipes
  • Limited session lifetime
  • Server behind a firewall to minimize malicious
    traffic
  • Uploaded documents stored in binary format in
    MySQL tables

8
Customer Requirements
  • Simple, easy to use interfaces for all user
    classes
  • Professional, trustworthy appearance
  • Several methods for contacting the service and
    providing feedback add to trustworthiness
  • Multilingual support for all three interfaces

9
Database Design
10
Database Design
11
GUI Design
  • Professional Look and Feel with CSS
  • Lack of images greatly decreases download time

12
Session Design
13
Session DesignURL Rewriting or Cookies?
14
System ImplementationERD for 1st Prototype
15
System ImplementationProtecting against SQL
Injection Attacks
  • This login would allow
  • access to any invalid
  • user.
  • For security, the special
  • characters in the values
  • must be escaped.

Other injection attacks may force the system to
display sensitive data.
16
System ImplementationForm Validation
  • Important for data driven applications
  • Ensure uploaded files are of proper type

17
Login and Registration
18
Customer Interface
19
Customer - Upload
20
Customer - View Order Status
21
Translator Interface
22
Translator - Download
23
Translator - Return Document
24
Manager Interface
25
Manager - Add User
26
Manager Remove User
27
Manager View Transactions
28
Manager Productivity Summary
29
System Testing
  • Repeated attempts to break the site and cause
    errors
  • Explore every possible scenario a user may
    encounter
  • Simulate everyday use of system
  • Providing bad input to verify system will not
    allow the user to present errors

30
System Testing
  • After verifying the input produced desirable
    results within one user interface, test the
    results caused by the same input within the other
    interfaces
  • Some not so obvious errors are caught by checking
    the web server and database server logs

31
Future Work
  • Multilingual support for all user interfaces
  • Separate database tables for each user class to
    simplify user interfaces
  • Addition of a new user class Admin or Super user
  • Support for monetary transactions (Pay Pal,
    Credit Card, etc)

32
Future Work
  • Secure Sockets Layer (SSL) Support to cater to
    corporations and small businesses
  • Extended user interfaces including translation
    support system
  • Professional web hosting or dedicated server

33
Questions?
Write a Comment
User Comments (0)
About PowerShow.com