i
iii
iv
v ABSTRACT A Development of An Integrated Agricultural Outlook Information System: Outlook & Agricultural Statistics Information System(OASIS) The Agricultural Outlook Information Center(AOIC) developed information systems in 2002. However they suffered from inconveniency and time-consuming problems. There has been some trial to tackle those problems and improve the systems. In 2004, AOIC improves data collection system by adopting a digital way in the sense that it uses web and PDA(Personal Digital Assistant) intensively, instead using an analog one which uses telephone, facsimile, etc. This project is to develop an integrated agricultural outlook information system which is named the "Outlook & Agricultural Statistics Information System(OASIS)." The integrated system is developed so as to collect, process, and distribute data conveniently and intuitively. This report is consisted of three main sections: 1) Outline of an integration of Agricultural Outlook Information Systems, 2) Improvement of data survey and management function using digital facsimile, SMS(Short Message Service), PDA(Personal Digital Assistant), accounting system, and 3) A production and distribution of intuitive information via OLAP(On-Line Analytical Processing) and GIS(Geographic Information System). Researcher: Yong-Sun Lee, Jeah-Hwan Kim, Hong-Won Kim, Jee-Yun Won, Jae-Hong Park, Sung-Hwan Song, Wu-Jin Song, Won-Tae Kim E-mail Address: yslee@krei.re.kr
vii
viii
ix
x
xi
xii
xiii
1
2
3
4
5 농업관측정보시스템 생산 ( 표본농가, 모니터 ) 농업관측지원정보시스템 (DB) 유통 ( 저장, 물류 ) 소비자 PDA 를활용한산지정보수집시스템 관측정보수집 농축산물생산및수급분석시스템 (DW) OLAP 통계 GIS 를활용한농업관측정보서비스 관측정보제공
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42 화면홈페이지회원연구원관리자기준정보 admmin 메뉴메뉴등록관리 사용자그룹권한관리공통코드관리사용자로그조회마감관리차트생성설정차트생성공지사항관리기초코드관리가락시장코드 표준품목코드품관원품목코드 GIS산지, 지역등록전국시도지역코드 주산지코드관리지역코드기상청지역코드기초자료시장자료조회가락시장반입량 가락시장가격전국축산물경락가격 ( 등급판정소 ) 농협자료공판장경락가격 유통센터정산가격산지조사가격도매공판조사가격축산물산지조사가격축산물도매공판조사가격축산물유통일보가격농수산물유통공사자료중도매조사가격 소비자조사가격축산물중도매조사가격축산물소비자조사가격산지자료성주참외조사가격 통계자료표준소득정보 기상자료 관세청자료 중국자료 자료관리가락시장반입량조정계수관리 농가표준소득 품관원농가정보 관세청자료 관측정보거래동향정보가락시장가격 농수산물유통공사가격농협가격축산물산지가격성주공판장참외가격표준소득정보 수입자료정보 생산정보 기상정보 GIS정보기상정보 GIS 생산정보 GIS
43
44
45 관측지원정보시스템 DW OLAP : SAGENT 통계및전망 : 아하넷 DW 관리 (SAGENT) 관측지원정보시스템 DB 농업관측센터홈페이지 홈페이지서버 DW 서버
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62 HS HS 102902000 ( / ) 41 ( ) 4123 412399 201200000 (, / ) 43 4303 430300 201300000 (, / ) 43 4303 430300 202100000 ( /, ) 43 4303 430300 202200000 ( / ) 43 4303 430300 202300000 ( / ) 43 4303 430300 (, /, 203120000 ) 43 4304 430400 203191000 (, / / ) 43 4304 430400 203199000 (, / / ) 43 4304 430400 203210000 ( /, ) 43 4304 430400 ( /, 203220000 ) 43 4304 430400 203291000 ( / / ) 43 4304 430400 203299000 ( / / ) 43 4304 430400
63
64
65 가락시장 Flat File Flat File Excel Download FTP 통신품목별평균가격품목별반입량 자료보정 - 표준분석조회자료추출및가공단계를자동화 1 차가공 2 차가공처리 DBMS 과거자료분석자료입력
66
67
68
69
70
71
72
73
74
75 원 /100개 45,000 백다다기 -2 개월 톤 500 38,000 400 31,000 300 24,000 200 17,000 100 10,000 0 8.19 8.27 9.5 9.13 9.23 월일 10.1 10. 10 10.18 원 /100개 45,000 백다다기 -3 개월 톤 500 38,000 400 31,000 300 24,000 200 17,000 100 10,000 0 7.18 7.26 8.3 8.11 8.19 8.27 9.5 9.13 9.23 10.1 10. 10 10.18 월일
76
77
78
79
80
81
82
83
84
85
86 X310 RW6100 SC8000 HP LG SK KT/KTF SK/LGT PocketPC 2003 PocketPC 2003 SE PocketPC 2003 PDA XScale PXA255 400Mhz XScale PXA270 520Mhz XScale PXA260 400Mhz CPU MSM5500 : IS 95A / CDMA 95B / 1x RTT / EVDOCDMA2000 1x EV-DOCDMA2000 1x EV-DO ROM 32/512MB 128MB 64/128MB RAM 64MB 64MB 64MB (240 320) (240 320) TFT LCD TFT Color LCD TFT Color LCD (26 ) (26 ) (26 ) 3.0 2.8 2.8 1500mAh 2800mAh 2800mAh 1200mAh 1400mAh 1400mAh 80~130 ( ) 170~ 180 ( ) 170~180 ( ) 3 20 ( ) 3 360~380 ( ) 180~200 ( ) 420~450 ( ) WLAN 802.11b GPS 3.5 5 3 20 VGA / 30 VGA / 110 VGA / 110 Chip Yamaha 64Poly MA5 64 2.5Ø, 6 / / ( ) 2.5Ø 2.5Ø Mini SD Mini SD SD SD (mm) 63.5 116 22~25( ) 63.5 116 22~26( ) 59 114 26.5 58 110 24.2 (g) 193g, 199g 203g 192g
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124