Record Details

DESIGN AND DEVELOPMENT OF DATA MART FOR CONSUMPTION EXPENDITURE SURVEY DATA

KrishiKosh

View Archive Info
 
 
Field Value
 
Title DESIGN AND DEVELOPMENT OF DATA MART FOR CONSUMPTION EXPENDITURE SURVEY DATA
M Sc
 
Creator Debasis Dutta
 
Contributor V. K. Mahajan)
 
Subject storage structures, biological phenomena, genetic processes, land resources, extraction, imports, manpower, thinning, selection, sets
 
Description T-8341
In our country, India, the resources particularly the agricultural resources are spread all over the nation. Therefore, the first and foremost need before developing a decision support system (DSS) on agriculture resources is to integrate the historical information which are scattered all over the nation into a central data warehouse. Integrated National Agricultural Resources Information System (INARIS), which is developed by IASRI, New Delhi, is an endeavour in developing a central information repository of major agricultural resources like Forestry, Horticulture, Agronomy, Social Science etc.
To fulfil the requirement of data on consumption expenditure (for planners, researchers, development agencies and Government of India) which is required for further studies and evolving realistic strategies for improvement of the standard of living of the people of this country the Consumption Expenditure Survey Data were collected from all over the country by NSSO. This collected data have been analysed to identify possible data marts and the dimensions that can be associated with these data marts. To find out the associated dimensions with the data marts and conformed dimensions, the top-down planning approach called as Data Warehouse Bus Architecture Matrix was used and it was found that a single mart is sufficient enough in order to integrate all the information into a single place. The dimensional models have also been designed and the data mart for consumption expenditure survey data was created. The data storage has been converted into a form of multidimensional model, known as cube. These cubes have been designed by using fact and dimension tables and deployed on Internet for on-line analysis, which is called as On-Line Analytical Processing (OLAP). The cubes have been integrated with previously developed data warehouse INARIS. The information in this data warehouse is available to the end-user in the form of decision support system in which all the flexibility of the presentation of the information, such as it’s on line analysis is inbuilt into the system. The data in the developed cubes can be viewed in cross tab view as well as graphical views including simple bar graph, pie chart, clustered bar graph, stacked bar graph, multiline graph, three dimensional bar graph etc. Drill downs and roll ups can be performed on the data available in the cubes. Another important functionality incorporated in these cubes is Drill Through in which user can find interesting trends or anomalies while analysing data.
81
The advantage of this approach is that the often query intensive work of ad hoc data analysis is performed using summarized data in the cube. Users can also import the results of their query in excel sheets and as well as in pdf files.
 
Date 2016-10-24T09:37:21Z
2016-10-24T09:37:21Z
2010
 
Type Thesis
 
Identifier http://krishikosh.egranth.ac.in/handle/1/81425
 
Format application/pdf
 
Publisher INDIAN AGRICULTURAL STATISTICS RESEARCH INSTITUTE