MSE PROJECT

1
MSE PROJECT
(CIS895, Spring 2003)

• Fengyou Jia
• Department of Computing and Information Science
• Kansas State University

2
Supervisory Committee

• Major Professor
• Dr. Hankley, William (CIS)
• Committee Members
• Dr. Deloach, Scott (CIS)
• Dr. Zamfir-Bleyberg, Maria (CIS)

3
Academic Background
1. Ph. D., University of Kansas, Lawrence (USA),
Jan. 1995--- May 1999. Entomology. 2. M. Sc.,
The Chinese Academy of Forestry, Beijing (P. R.
China), Sept. 1987---Aug. 1990. Insect
Ecology. 3. B. Sc., Beijing Forestry University,
Beijing (P. R. China), Sept. 1980--- July 1984.
Forest Protection (Entomology). 4. MSE
(ongoing), Kansas State University (USA), Jan
2003---2004(?)
4
Current Employment
Research Assistant Professor (Official
title) Department of Entomology Kansas State
University Manhattan, KS 66506)
5
Research Projects
(Ongoing)
1) A developing user-oriented database for
pesticides 2) Kansas pesticide usage survey
and data analysis 3) Insect Pest Management (on
Cockroaches)
6
Program of Study (1)
(Courses taken, taking, and to be taken)
CIS764 A 3 Fall 2000 KSU Database
design CIS798 A 3 Fall 2001 KSU
Pesticide Database CIS748 A 3 Spring 2002 KSU
Software management
CIS864 A 3 Spring 2002 KSU
Data Engineering CIS740 A 3 Fall 2002 KSU
Software Engineering CIS771 3 Spring
2003 KSU Software
Specification CIS895 3 Spring 2003 KSU
MSE Project CIS895 3 Fall 2003 KSU MSE
Project CIS625 3 Spring 2004 KSU Parallel
Programming
Total KSU credits 27 (expected)
7
Program of Study (2)
(Courses taken, taking, and to be taken)
(Transferred WORK) Course Grade Credit Year Offe
r Institute Course Name BIOL701 A 2 19
96 University Of Kansas VB Programming BIOL985 A 1
1997 University Of Kansas VB Application BUS920 A
4 1996 University Of Kansas Probability Business
Research BUS921 A 4 1997 University Of
Kansas Statistics for Business Research
8
Program of Study (3)
(CIS895 MSE Project)

• I intend to integrate my MSE Project with my
  current research program, a user- oriented
  database for pesticides.
• I am planning to submit a research proposal to
  EPA for funding (RAMP)
• Second and third Presentation (Scheduled at
  next semester).

9
A developing user-oriented database for pesticides
(CIS895, MSE Project---Phase 1)
10
Problem Statement

• Pesticides were created to control pests and
  improve human living quality. Pesticide selection
  and application are based on following two
  considerations
• Pests
• Cost

11
Problem Statement

• One problem solved
• Many new problems created
• Hazardous potential to eco-system
• Kill non-target organisms (natural enemy)
• Hazardous potential to the environment
• Water pollution
• Soil pollution
• Pesticide residues in food

12
Example pesticide residues in food
Sources http//www.pesticides.gov.uk/committees/W
PPR/discdoc.pdf
1 Additive effect of pesticide residue? 2
Interaction between these residues? 3 some
cancer-related 4 some birth defect-related.
13
Problem Statement

• Existing pesticide databases
• Pest-oriented
• Product-oriented
• Administration-oriented
• User-oriented?

14
Problem Statement

• A new pesticide database with following features
• User-oriented
• Be able retrieve safety information
• Allow applicators to find the most safe
  pesticide product in pest control program

15
Purpose

• Provide an easy tool for users
• Storage and retrieval data
• Accessible to public
• Ultimately, reduce and minimizing the usage of
  certain hazardous pesticides via using this
  database

16
Proposed project overview

• Basic version
• Pesticide ingredients
• Pests
• Enhance version (upon funding)
• Pesticide ingredients
• Pests (album, assisting to identify the pest)
• Pesticide products
• Users

17
Fig. 1 ER Diagram for pesticide database (Basic
Version)
EPA_no
Ingredient_proportion
Ingredient_name
WHO
Pesticide_no
Model_action
1
Mamtoxicity
EPA_no
EPA
Have
Restrict
1
C/BD
1
Ingredients
EPA_no
1
n
Have
1
BEE
Ecotoxicity
BIRD
Control
Have
FISH
EPA_no
n
1
Pests
Pest_no
Environmental fate
Pest_album
Pest_name
EPA_no
PLP
Pest_description
Pest_group
DT50
FD50
Soil Half_life
Field dissipation Half_life
multiple-valued attributes.
18
Fig. 2 ER Diagram for pesticide database
(Enhanced version)
Formulation
Price
Product_no
Manufacture
User_no
User_name
n
1
n
1
Pesticides
Purchase
Contain
Users
Pest
Target_pest
User_address
EPA_no
Register_no
Register_state
multiple-valued attributes.
19
Fig. 2 (cont.)
EPA_no
Ingredient_proportion
Ingredient_name
WHO
Pesticide_no
Model_action
1
Mamtoxicity
EPA_no
EPA
Have
Restrict
1
C/BD
1
Ingredients
n
EPA_no
Contain
1
n
Have
1
1
BEE
Ecotoxicity
BIRD
Control
Have
FISH
EPA_no
n
1
Pests
Pest_no
Environmental fate
Pest_album
Pest_name
EPA_no
Pest_description
PLP
Pest_group
DT50
FD50
Soil Half_life
Field dissipation Half_life
multiple-valued attributes.
20
Solution

• PC based application
• Microsoft windows
• Graphical user Interface (FrontPage)
• User Configuration
• Designed for over 3000 pesticide ingredients and
  more than 1000 pest images

21
Who use it?

• Farmers/Ranches
• Professional pesticide applicators
• University and extension agencies
• Environmental protection agencies
• Related government agencies

22
Information Tracking and Record

• User information?
• https//www.oznet.ksu.edu/pesticidedatabase/user.a
  sp
• Pesticide safety information
• https//www.oznet.ksu.edu/pesticidedatabase/interf
  ace.asp

23
Information Tracking and Record
User information
Name First Last Profession
Address Street City State Zip code
Communication Phone Email Fax Pest to
be controlled Applied Sites Comments
24
Information Tracking and Record
Pesticide (product) information ()
Pest Pest to be controlled Pest description
Pest album Mamtoxicity EPA WHO
Cancer/Birth defects related Ecotoxicity
BIRD FISH HONEY BEES
Environmental fates Dissipation half-life (DF50)
Soil half-life (DT50) Leaching Potential
(LP) Pesticide products Active Formulation
Registration States Registration Number
Restricted federal Restricted State Cost
The information is subjected to change
25
Benefits (intangible)

• Data information easily to accessible for publics
  (final deliverable product only)
• Reducing or minimizing negative influence of
  pesticides
• Protecting the environment (underground waters
  and ecosystems)

26
My responsibility(in the proposed project)

• Data collections
• Date transformations
• PLP (High, Mid, Low)
• TD50 (High, Mid, Low)
• Database designs

27
Project Cost?

1. Based upon project plan
2. Person-hour 1108 hours,
3. Cost 110,800
4. Based upon COCOMO (4600 LC)
5. Person-hours 1350 hours
6. Cost 135,000

• The SW cost estimation is not applicable to my
  MSE Project due to following reasons. 1) The
  critical parts of this project are data
  collections and data transformations (including
  categorization), which may take approximately one
  year for 2 persons to complete the tasks. The
  reviewing process alone for data transformations
  may take to 4-6 months, ensuring that general
  publics understand the interfaces and all
  terminologies used. 2) Several automate tools
  will be used for the proposed program. One tool
  we will use in interface design is Microsoft
  FrontPage (2000), which can automatically
  generate desired user interfaces. Another tool we
  will use is Oracle9i, which is hugely different
  from the previous Oracle versions (e. g.,
  Oracle8i). Oracle9i provide the user interfaces
  for database designs, database constraint
  implementations, data populations, and data
  manipulations (insert, modify, delete, update,
  etc.).

28
Who own the database

• Kansas State university
• Database manipulation
• Data retrieval and data analysis

29
What can it do for them?

• Data Retrieval
• Report Generation
• Data Analysis

30
When is it going to be done?

• ? (whole project for five years)
• As my part
• Mail Documentation for Presentation 1 4/1/2003
• Presentation 1 4/4/2003
• Documentation Signed off from Presentation1
  4/4/2003
• Mail Documentation for Presentation 2 8/1/2003
• Presentation 2 8/22/2003
• Documentation Signed off from Presentation2
  8/22/2003
• Mail Documentation for Presentation 3 9/1/2003
• Presentation 3 9/26/2003
• Documentation Signed off from Presentation3
  9/26/2003

31
Questions suggestions?