Data Warehousing

1
Data Warehousing
Virtual University of Pakistan

• 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
2
Background
3
Area under study
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

5
Major Players
6
Pests Predators
Graphics
Pests
Predators
Source United States Department of Agriculture
(USDA)
7
Economic Threshold Level (ETL_A)
8
ETL_A Graph
Economic Injury
Graphics
ETL_A
Pest Population
Time
9
The need
10
The need IT in Agriculture
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
12
Agro-Informatics Interesting URL
ALL Goes to graphics
To know more about Agro-Informatics,
visit www.nu.edu.pk/cairindex.asp
13
How to go about?
14
The 12-step Approach of Shaku Atre
ALL Goes to graphics
15
Step-1 Determine Users needs
16
Step-1 Determine Users needs
17
Steps-23 Determine DBMS Sever Hardware
Platform
18
Step-4 Information Data Modeling
Graphics
Dimensional Modeling
19
Step-4 Information Data Modeling
Simplified ERD
Graphics
Other field inputs such as irrigation, fertilizer
etc. not included as data not available
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
21
Step-5 Construct Metadata Repository
22
Step-5 Surprise case
Graphics
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.