1 / 22

Data Warehousing

Virtual University of Pakistan. Data Warehousing. Lecture-37 Case Study: Agri-Data Warehouse. Ahsan Abdullah Assoc. Prof. & Head Center for Agro-Informatics Research www.nu.edu.pk/cairindex.asp FAST National University of Computers & Emerging Sciences, Islamabad. Background.

khan
Download Presentation

Data Warehousing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Virtual University of Pakistan Data Warehousing Lecture-37 Case Study: Agri-Data Warehouse Ahsan Abdullah Assoc. Prof. & Head Center for Agro-Informatics Research www.nu.edu.pk/cairindex.asp FAST National University of Computers & Emerging Sciences, Islamabad DWH-Ahsan Abdullah

  2. Background DWH-Ahsan Abdullah

  3. Area under study DWH-Ahsan Abdullah

  4. Area under study: Map Graphics • Key Markaz • 1 Bosan • 2 Qadirpurran • 3 Multan • Makhdum Rashid • Mumtazabad • 6 Shujabad • 7 Hafizwala • 8 Jalalpur Pirwala • 9 Qasba Marral DWH-Ahsan Abdullah

  5. Major Players DWH-Ahsan Abdullah

  6. Pests & Predators Graphics Pests Predators Source: United States Department of Agriculture (USDA) DWH-Ahsan Abdullah

  7. Economic Threshold Level (ETL_A) DWH-Ahsan Abdullah

  8. ETL_A: Graph Economic Injury Graphics ETL_A Pest Population Time DWH-Ahsan Abdullah

  9. The need DWH-Ahsan Abdullah

  10. The need: IT in Agriculture DWH-Ahsan Abdullah

  11. Agro-Informatics • “I.T. sector is at the heart of the economic revival of Pakistan”President of Pakistan, Launching of VU, Mar. 23, 2003. • Agriculture is the backbone of our economy, about 70% of the population is dependent on it. • IT is an enabler, and has the potential to benefit everyone when applied in Agriculture. • IT + Agriculture: A win-win scenario. ALL Goes to graphics DWH-Ahsan Abdullah

  12. Agro-Informatics: Interesting URL ALL Goes to graphics To know more about Agro-Informatics, visit www.nu.edu.pk/cairindex.asp DWH-Ahsan Abdullah

  13. How to go about? DWH-Ahsan Abdullah

  14. The 12-step Approach of Shaku Atre ALL Goes to graphics DWH-Ahsan Abdullah

  15. Step-1: Determine User’s needs DWH-Ahsan Abdullah

  16. Step-1: Determine Users needs DWH-Ahsan Abdullah

  17. Steps-2&3: Determine DBMS Sever & Hardware Platform DWH-Ahsan Abdullah

  18. Step-4: Information & Data Modeling Graphics Dimensional Modeling DWH-Ahsan Abdullah

  19. Step-4: Information & Data Modeling Simplified ERD Graphics Other field inputs such as irrigation, fertilizer etc. not included as data not available DWH-Ahsan Abdullah

  20. Step-4: Information & Data Modeling KEY WFN: White Fly Nymph WFA: White Fly Adult W: White B: Brown S: Small Larvae L: Large Larvae (optional) Graphics Logical & Physical Design DWH-Ahsan Abdullah

  21. Step-5: Construct Metadata Repository DWH-Ahsan Abdullah

  22. Graphics Step-5: Surprise case Sucking pests Ball Worm Complex SBW: Spotted Ball Worm ABW: Army Ball Worm PBW: Pink Ball Worm If pest population is low, predator population will also be low, because there will be less “food” for predators to live on i.e. pests. DWH-Ahsan Abdullah

More Related