Data Warehousing of Solid Minerals in Nigeria. A Study of South South Region Nigeria

Scientific Study from the year 2023 in the subject Geography / Earth Science - Geology, Mineralogy, Soil Science, Michael Okpara University of Agriculture (NRCRI - Federal College of Agriculture, Ishiagu, Ebonyi State, Nigeria), course: Earth Science and Solid Minerals Warehousing, language: English, abstract: In recent years, decision support systems otherwise called Data Warehouse have become an integral part of organization's decision-making strategy. Organizations these days are competing in the global market. In order for any organization to gain competitive advantage over the others and also to help make better decisions, Data warehousing cum Data Mining are now playing a significant role in strategic decision making, nationally and globally. It helps in better decisions, streamline work-flows, and provide better customer services. This paper gives the report about developing data warehouse for solid minerals in Nigeria, using a model of management system as a case study to capture solid minerals in the South South Region of Nigeria. It describes the process of data warehouse design and development using Microsoft SQL Server Analysis Services. It also outlines the development of a data cube as well as application of Online Analytical processing (OLAP) tools and Data mining tools in data analysis. It was concluded that the effective use of Data-Warehousing and Data mining in solid minerals resource management system will promote the rapid growth of the Nigerian diverse mineral resources and offer information on past, present and future prospects of mineral deposits, for exploration and utilization for economic development.