Data warehousing for Open Data sharing and decision support in agriculture: a case study of the VDSA Knowledge Bank and
- PDF / 481,014 Bytes
- 9 Pages / 595.276 x 790.866 pts Page_size
- 103 Downloads / 174 Views
ORIGINAL RESEARCH
Data warehousing for Open Data sharing and decision support in agriculture: a case study of the VDSA Knowledge Bank and its development process G. V. Anupama1
•
Rajni Jain2
•
Thomas Falk1
•
Uttam Deb3
•
Cynthia Bantilan1
Received: 1 November 2019 / Accepted: 8 June 2020 Ó Bharati Vidyapeeth’s Institute of Computer Applications and Management 2020
Abstract Acceptance of Open Data by the governments, foundations, science councils and other sponsors of research across the world have prompted the trend towards Open Data. Many researchers and organizations have embraced the Open Data policy. Most often the datasets are released through Dataverse. However, just making datasets available is not enough. We need inbuilt user-friendly data extraction and transformation techniques, and analytical features that can facilitate analyses of research data and generate new knowledge and insights from such data. The Village Dynamics in South Asia (VDSA) Knowledge Bank, (http://vdsakb.icrisat.ac.in/), is a unique data warehouse with user-friendly data retrieval and online analytical processing features for household level panel data on India and Bangladesh. It is the first of its kind in the world for managing household survey data. It exemplifies how digital innovation tools (Microsoft SQL and Business Intelligence tools) can be used in processing diverse, complex longterm databases and promoting the cause of Open Data and facilitates decision support needs. This paper has documented the development process, technical features and impacts of the VDSA Knowledge Bank. It provides an indepth understanding about how to plan, partner with information technology firms, design and implement a data warehouse project. Thus, the main contribution of this paper is featuring how developments in information & G. V. Anupama [email protected] 1
ICRISAT, Patancheru, Telangana, India
2
National Centre for Agricultural Economics and Policy Research, New Delhi, India
3
Department of Aquaculture and Fisheries, University of Arkansas, Pine Bluff, USA
technology can be innovatively used to promote Open Data and enhance impacts. Hopefully, this study will stimulate interests among researchers and donors in building data warehouse for management and dissemination of Open Data. Keywords Open Data Agricultural data warehouse VDSA OLTP
1 Introduction Data has long been handled as the private property of those who developed them. Databases were, and often still are, created and stored in different ways, analysed by different methods, and thus can be deeply siloed [1]. With the advancement of the global movement of Open Data and its acceptance by the governments, foundations, science councils and other sponsors of research all over the world has prompted the trend towards Open Data. The two main criteria for Open Data are that they must be freely available online and in a format that allows re-use [1]. Such data are new global public goods [2]. There have been substantial advances in Open Data over the last decade. Th
Data Loading...
