Building OLAP Application to Exploit Database of Rice Pests

Abstract- On-line Analytical Processing (OLAP) is widely used in many business applications to analyze data and to help answer queries in multidimensional data to support the manager in making reasonable decision [23]. This paper describes and builds an OLAP application on database of rice pests by using data warehouse architecture, On-line Analytical Processing and web components. This application supports efficient exploitation of rice pest data warehouses in Horticulture and Plant Protection branch of Tra Vinh province in Viet Nam which is accumulated over the years. To achieve this goal, several tools are used to build successful applications such as SQL Server 2005 to build data warehouse, Analysis Services 2005 to build OLAP multidimensional databases and Microsoft Office Web Components to build the web-based reporting of data. With the results obtained, the application allows users a flexible on-line analysis of data on rice pests live on site. This suggests that the use of OLAP technology is not only effectively applied to support business applications, but also needed to be strongly applied in informatics systems to support the agricultural sector