Development of a Korean rural information support system: Integrated database design for rural data in South Korea

Kyo Suh, Jimin Lee, Taegon Kim, Seongsoo Yoon, Jeongjae Lee

Research output: Contribution to conferencePaperpeer-review

Abstract

The Korean rural information support system (KRISS) followed up classic DSS design. This paper shows the database part of the system, efficient database design for KRISS. For supporting decision making of rural regions the system should have proper database schema through broad investigation and analysis of extant statistical data because rural regions have various and typical characteristics. The system database should be designed for integrated schema and constructed for supporting the decision making. The characteristics of rural data can be divided into industrial and social categories. 'National Agricultural Statistics (NAS)' and 'County Annual Statistical Report (CASR)' are representative statistical data in each category so the system adapted the analysis result. OLAP (Online Analytical Processing) is selected for improving query speed although a standard, normalized database structure is usually OLTP (Online Transaction Processing). The system database was applied to 2000 statistical data set including Agricultural Census Report (ACR) and County Annual Statistics Report (CASR) and tested related to speed and reliability.

Original languageEnglish (US)
StatePublished - Nov 7 2007
Event2007 ASABE Annual International Meeting, Technical Papers - Minneapolis, MN, United States
Duration: Jun 17 2007Jun 20 2007

Conference

Conference2007 ASABE Annual International Meeting, Technical Papers
CountryUnited States
CityMinneapolis, MN
Period6/17/076/20/07

Keywords

  • Database
  • Decision support systems (DSS)
  • Korean rural information support system (KRISS)
  • OLAP (Online Analytical Processing)
  • OLTP (Online Transaction Processing)

Fingerprint Dive into the research topics of 'Development of a Korean rural information support system: Integrated database design for rural data in South Korea'. Together they form a unique fingerprint.

Cite this