310 likes | 404 Views
MSE PROJECT. (CIS895, Spring 2003). Fengyou Jia Department of Computing and Information Science Kansas State University. Major Professor Dr. Hankley, William (CIS) Committee Members Dr. Deloach, Scott (CIS) Dr. Zamfir-Bleyberg, Maria (CIS). Supervisory Committee. Academic Background.
E N D
MSE PROJECT (CIS895, Spring 2003) Fengyou Jia Department of Computing and Information Science Kansas State University
Major Professor Dr. Hankley, William (CIS) Committee Members Dr. Deloach, Scott (CIS) Dr. Zamfir-Bleyberg, Maria (CIS) Supervisory Committee
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 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)
Program of Study (2) (Courses taken, taking, and to be taken) (Transferred WORK) Course Grade Credit Year Offer Institute Course Name BIOL701 A 2 1996 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
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).
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 • Kill non-target organisms (natural enemy) • Hazardous potential to the environment • Water pollution • Soil pollution • 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) Ingredient_proportion EPA_no Ingredient_name WHO Pesticide_no Model_action 1 Mamtoxicity EPA_no EPA Restrict Have 1 C/BD 1 Ingredients EPA_no n 1 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.
Fig. 2 ER Diagram for pesticide database (Enhanced version) Formulation Price Product_no Manufacture User_no User_name n 1 n 1 Purchase Pesticides Contain Users Pest Target_pest User_address EPA_no Register_no Register_state multiple-valued attributes.
Fig. 2 (cont.) Ingredient_proportion EPA_no Ingredient_name WHO Pesticide_no Model_action 1 Mamtoxicity EPA_no EPA Restrict Have 1 C/BD 1 Ingredients n EPA_no Contain n 1 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.
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 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
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? • Based upon project plan • Person-hour: 1108 hours, • Cost: $110,800 • Based upon COCOMO (4600 = LC) • Person-hours: 1350 hours • 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 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