Original papers: Design and development of data mart for animal resources

Planners, researchers, development agencies and farmers require information on animal resources for further studies and evolving realistic strategies for improvement and rearing of livestock and poultry. Data is also required for keeping watch on prices and movement of animal products, animal feed and establishment of services such as veterinary hospitals, artificial insemination (AI) centers, meat and dairy industries, etc. Further, there is a need to study animal resources in relation to other aspects of agriculture, such as soils, vegetation, agro-meteorology, socio-economic, land use, water resources for overall development of agricultural production system. Indian Agricultural Statistics Research Institute (IASRI), New Delhi has designed and implemented a Central Data Warehouse (CDW) under a National Agricultural Technology Project (NATP) Mission Mode sub-project entitled ''Integrated National Agricultural Resources Information System (INARIS)''. In this CDW, 13 different data marts related to various subjects in agriculture were designed, implemented and integrated. In this article, attempt was made to discuss concepts and problems of dimensional modeling of the animal data mart in relation to available source data on livestock resources in the country. Alternative solutions to specific problems were also discussed along with the solution implemented for modeling of this data mart. The complete process of building On-line Analytical Processing (OLAP) system for research managers including inbuilt technique of data quality and consistency checks to be implemented is being described with special reference to animal resource management. This article will provide guidelines for design and development of similar complex data marts in agricultural sector, particularly in the field of livestock management.

[1]  Stefano Paraboschi,et al.  Designing data marts for data warehouses , 2001, TSEM.

[2]  Inderpal Singh Mumick,et al.  Maintenance of Materialized Views: Problems, Techniques, and Applications , 1999, IEEE Data Eng. Bull..

[3]  Esteban Zimányi,et al.  Hierarchies in a multidimensional model: From conceptual modeling to logical representation , 2006, Data Knowl. Eng..

[4]  Christian S. Jensen,et al.  A foundation for capturing and querying complex multidimensional data , 2001, Inf. Syst..

[5]  Goetz Graefe,et al.  Multi-table joins through bitmapped join indices , 1995, SGMD.

[6]  Patrick E. O'Neil,et al.  Improved query performance with variant indexes , 1997, SIGMOD '97.

[7]  Wolfgang Lehner,et al.  An Alternative Relational OLAP Modeling Approach , 2000, DaWaK.

[8]  Carsten Sapia,et al.  Automatically generating OLAP schemata from conceptual graphical models , 2000, DOLAP '00.

[9]  Franklin Maxwell Harper.  Data warehousing and the organization of governmental databases , 2004 .

[10]  G. Garson,et al.  Digital Government: Principles and Best Practices , 2003 .

[11]  Luca Cabibbo,et al.  The Design and Development of a Logical System for OLAP , 2000, DaWaK.

[12]  Scalzo,et al.  Oracle DBA Guide to Data Warehousing and Star Schemas , 2003 .

[13]  Mickey Yost.  Data Warehousing and Decision Support at the National Agricultural Statistics Service , 2000 .

[14]  Lei-da Chen,et al.  Measuring user satisfaction with data warehouses: an exploratory study , 2000, Inf. Manag..

[15]  Chia-Chen Chen,et al.  A web-based ERP data mining system for decision making , 2003, Int. J. Comput. Appl. Technol..

[16]  Laks V. S. Lakshmanan,et al.  What can Hierarchies do for Data Warehouses? , 1999, VLDB.

[17]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[18]  Kevin P. Scheibe,et al.  Dimensional issues in agricultural data warehouse designs , 2008 .

[19]  Ahsan Abdullah,et al.  The Case for an Agri Data Warehouse: Enabling Analytical Exploration of Integrated Agricultural Data , 2004, Databases and Applications.

[20]  Sean Kelly.  Data Warehousing in Action , 1997 .

[21]  Rodolfo Alfredo Bertone,et al.  Modern database management VI Edition. Jeffrey A. Hoffer, Mary B. Prescott, Fred R. McFadden Prentice Hall, Upper Saddle River, NJ, 2002 , 2003 .

[22]  Ralph Kimball,et al.  The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses , 1996 .

[23]  Ralph Kimball,et al.  The Data Warehouse Lifecycle Toolkit , 2009 .

[24]  Matthias Jarke,et al.  Proceedings of the 10th International Conference on Scientific and Statistical Database Management , 1998 .