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

MIME type Extension Description
application/pdf .pdf Adobe Portable Document File
application/msword .doc Microsoft Word Document
application/rtf .rtf Rich Text Format
application/html .htm or .html Hyper Text Markup Language
text/plain .txt Plain text
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?