Transcript Document 7383952

MSE PROJECT
(CIS895, Spring 2003)
Fengyou Jia
Department of Computing and
Information Science
Kansas State University
Supervisory Committee
• Major Professor
– Dr. Hankley, William (CIS)
• Committee Members
– Dr. Deloach, Scott (CIS)
– Dr. Zamfir-Bleyberg, Maria (CIS)
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(?)
Current Employment
Research Assistant Professor
(Official title)
Department of Entomology
Kansas State University
Manhattan, KS 66506)
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)
Program of Study (1)
(Courses taken, taking, and to be taken)
CIS764
CIS798
CIS748
CIS864
CIS740
CIS771
CIS895
CIS895
CIS625
A
A
A
A
A
*
*
*
*
3
3
3
3
3
3
3
3
3
Fall 2000 KSU
Fall 2001 KSU
Spring 2002 KSU
Spring 2002 KSU
Fall 2002 KSU
Spring 2003 KSU
Spring 2003 KSU
Fall 2003 KSU
Spring 2004 KSU
Database design
Pesticide Database
Software management
Data Engineering
Software Engineering
Software Specification
MSE Project
MSE Project
Parallel Programming
Total KSU credits 27 (expected)
Program of Study (2)
(Courses taken, taking, and to be taken)
(Transferred WORK)
Course
Grade
Credit
Year
Offer Institute
BIOL701
BIOL985
BUS920
BUS921
A
A
A
A
2
1
4
4
1996
1997
1996
1997
University Of Kansas
University Of Kansas
University Of Kansas
University Of Kansas
Course Name
VB Programming
VB Application
Probability Business Research
Statistics for Business Research
Program of Study (3)
(CIS895 MSE Project)
I intend to integrate my MSE Project with
my current research program, a useroriented database for pesticides.
I am planning to submit a research
proposal to EPA for funding (RAMP)
Second and third Presentation:
(Scheduled at next semester).
A developing user-oriented
database for pesticides
(CIS895, MSE Project---Phase 1)
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
Problem Statement
One problem solved
Many new problems created
 Hazardous potential to eco-system
I. Kill non-target organisms (natural enemy)
 Hazardous potential to the environment
I. Water pollution
II. Soil pollution
III. Pesticide residues in food
Example: pesticide residues in food
Sources: http://www.pesticides.gov.uk/committees/WPPR/discdoc.pdf
1: Additive effect of pesticide residue? 2: Interaction between these
residues? 3: some cancer-related; 4: some birth defect-related.
Problem Statement
Existing pesticide databases:
Pest-oriented
Product-oriented
Administration-oriented
User-oriented?
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
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
Proposed project overview
• Basic version
– Pesticide ingredients
– Pests
• Enhance version (upon funding)
– Pesticide ingredients
– Pests (album, assisting to identify the pest)
– Pesticide products
– Users
Fig. 1
ER Diagram for pesticide database (Basic Version)
EPA_no
Ingredient_proportion
Ingredient_name
WHO
Pesticide_no
Model_action
1
EPA_no
Restrict
Mamtoxicity
EPA
Have
1
C/BD
Ingredients
n
1
EPA_no
1
Have
BEE
1
Ecotoxicity
BIRD
Control
Have
FISH
EPA_no
Pest_no
n
1
Pests
Environmental fate
Pest_album
Pest_name
Pest_description
EPA_no
PLP
Pest_group
FD50
multiple-valued attributes.
Field dissipation Half_life
DT50
Soil Half_life
Fig. 2
ER Diagram for pesticide database (Enhanced version)
Formulation
Price
Product_no
Manufacture
User_no
User_name
1
Users
n
Purchase
Pesticides
n
1
Contain
Pest
User_address
Target_pest
EPA_no
Register_state
multiple-valued attributes.
Register_no
Fig. 2
(cont.)
EPA_no
Ingredient_proportion
Ingredient_name
WHO
Pesticide_no
Model_action
1
EPA_no
Restrict
EPA
Have
1
C/BD
Ingredients
n
1
Mamtoxicity
n
Contain
1
EPA_no
1
Have
BEE
1
Ecotoxicity
BIRD
Control
Have
FISH
n
EPA_no
1
Pests
Pest_no
Environmental fate
Pest_album
Pest_name
EPA_no
Pest_description
PLP
Pest_group
FD50
multiple-valued attributes.
Field dissipation Half_life
DT50
Soil Half_life
Solution
PC based application
Microsoft windows
Graphical user Interface (FrontPage)
User Configuration
Designed for over 3000 pesticide
ingredients and more than 1000 pest
images
Who use it?
Farmers/Ranches
Professional pesticide applicators
University and extension agencies
Environmental protection agencies
Related government agencies
Information Tracking and Record
User information?
https://www.oznet.ksu.edu/pesticidedatabase/user.asp
Pesticide safety information
https://www.oznet.ksu.edu/pesticidedatabase/interface.asp
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
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
* The information is subjected to change
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
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)
My responsibility
(in the proposed project)
• Data collections
• Date transformations
– PLP (High, Mid, Low)
– TD50 (High, Mid, Low)
• Database designs
Project Cost?
1. Based upon project plan
1. Person-hour: 1108 hours,
2. Cost: $110,800
2. Based upon COCOMO (4600 = LC)
1. Person-hours: 1350 hours
2. 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.).
Who own the database
• Kansas State university
– Database manipulation
– Data retrieval and data analysis
What can it do for them?
• Data Retrieval
• Report Generation
• Data Analysis
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
– Mail Documentation for Presentation 2
8/1/2003
– Presentation 2
8/22/2003
– Documentation Signed off from Presentation2
– Mail Documentation for Presentation 3
9/1/2003
– Presentation 3
9/26/2003
– Documentation Signed off from Presentation3
4/4/2003
8/22/2003
9/26/2003
Questions &
suggestions?