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.
Table of Contents
1. Introduction
2. Nigeria’s Solid Minerals Sector
3. Mineral Resources Classification
3.1 Metallic Mineral Resources
3.2 Non-metallic Mineral Resources
3.3 Fuel Mineral Resources
4. The South South Region
5. Geosciences
6. System Analysis and Research Methods
6.1 Functional requirements
6.2 Nonfunctional requirements
7. Data Warehouse
8. Why it matters
9. How data mining works
10. The Motivation for the Data Warehouse system
11. Designing the Data Ware-House
11.1 The logical Design
12. Implementation
12.1 Data WarehouseTransporting: Data from OLTP Database to Data Warehouse
13. DW Prototyping
13.1 User requirements
13.2 System requirements
13.3 System Design
13.4 The Software Development Methodology Adopted
14. Results and Implementation
14.1 System Prototype Development and Validation
14.2 Creating and loading of the DW prototype database
15. System Verification, Sample Reports and Analysis
15.1 The User Interface (Input and Output designs)
16. Conclusion
Research Objectives and Themes
This paper aims to address the challenges in Nigeria's solid minerals sector by designing a robust data warehousing and data mining framework. The core objective is to utilize strategic decision support systems to improve the management, exploitation, and economic utilization of mineral resources, particularly within the South South region, thereby assisting in the diversification of the national economy.
- Data warehouse design and development using Microsoft SQL Server.
- Application of Online Analytical Processing (OLAP) tools for data analysis.
- Implementation of data mining techniques to identify mineral resource patterns.
- Evaluation of the technical requirements for a functional decision support prototype.
- Strategic roadmap for mineral sector revitalization via improved information management.
Excerpt from the Book
The Motivation for the Data Warehouse system
The day-to-day operations of the school rely heavily upon the OLTP system. The managers make use of OLTP system for management information system. The need for strategic decision necessitates the development of the data warehouse. The OLTP can only handle few historical data, which are not enough to make strategic decisions. With a data warehouse and OLAP, database manager can perform roll-up and drill-down operations to Solid Minerals registered by type, by class, by name, by location, by usefulness or any combination desired.
The system will provide decision support that is flexible and user-friendly. Policy makers (Ministry of Solid Minerals, Geoscientists) would like to use the data-warehouse to answer questions such as: What is the quantity of Uranium found in the South South Region? At which state or location is it found? Wtaht can it be used for? Can it be exploited and processed or can it be exported in crude form? What is the cost of processing this mineral in Nigeria, etc. These types of questions need a lot of historical data to generate which the current system the OLTP system cannot support.
Summary of Chapters
Introduction: This chapter provides an overview of Nigeria's geological landscape and the major rock types found within its sedimentary basins.
Nigeria’s Solid Minerals Sector: It examines the economic status of the mining sector, highlighting its historical decline and current efforts toward diversification.
Mineral Resources Classification: This section categorizes mineral resources into metallic, non-metallic, and fuel minerals based on their chemical composition.
The South South Region: The chapter explores the endowment and exploitation status of solid minerals in the South South region of Nigeria.
Geosciences: It discusses the role of geosciences in gathering reliable geological data to drive investment in the mineral sector.
System Analysis and Research Methods: This section outlines the functional and non-functional requirements necessary for developing a data warehouse prototype.
Data Warehouse: It defines the concept of a data warehouse and the five stages of decision support evolution.
Why it matters: This chapter explains the benefits of integrating data from multiple sources into a comprehensive, queryable database for better decision-making.
How data mining works: It details the analytical techniques, such as clustering and association, used to extract patterns from transaction data.
The Motivation for the Data Warehouse system: It highlights the limitations of OLTP systems and the necessity of data warehousing for strategic, long-term decision support.
Designing the Data Ware-House: This chapter explains the design methodology, specifically the dimensional data modeling approach.
Implementation: It describes the technical process of moving data from an OLTP database to a structured data warehouse.
DW Prototyping: This chapter covers the hardware and software requirements and the selection of the Realistic Waterfall Model for development.
Results and Implementation: It presents the validation of the system prototype and the population of the database with quality-checked data.
System Verification, Sample Reports and Analysis: It details how sample reports are generated to demonstrate the utility of the system for stakeholders.
Conclusion: The final chapter concludes that data warehousing and data mining are essential tools for revitalizing the Nigerian economy through improved mineral management.
Keywords
Data Warehousing, Data Mining, Solid Minerals, Nigeria, OLTP, OLAP, Decision Support System, Economic Diversification, Mineral Exploration, Strategic Decision Making, SQL Server, Data Mart, Resource Management, Industrialization, Geotechnical Data.
Frequently Asked Questions
What is the fundamental purpose of this research?
The research aims to create a technological framework via data warehousing and data mining to enhance the management and economic utilization of Nigeria's solid mineral resources.
What are the core thematic areas discussed in the document?
The document covers the economic geology of Nigeria, the challenges of the mining sector, dimensional data modeling, and the technical implementation of decision support prototypes.
What is the primary research goal?
The primary goal is to provide a strategic roadmap for the revitalization of the solid minerals sector by overcoming information gaps that currently hinder investment and economic growth.
Which scientific methods are employed in this study?
The study utilizes software engineering methodologies, specifically the "Realistic Waterfall Model," combined with dimensional data modeling (Star Schema) and OLAP processing.
What content constitutes the main body of the work?
The main body focuses on the design and implementation of a data warehouse prototype, covering system requirements, database design, and the translation of raw mineral data into actionable analytical reports.
Which keywords best describe the focus of this work?
Key terms include Data Warehousing, Data Mining, Decision Support System, Solid Minerals, Nigeria, and Economic Diversification.
How does the proposed system differ from the traditional OLTP approach?
While OLTP handles day-to-day operational data, the proposed data warehouse system focuses on historical data and strategic analysis, allowing for roll-up and drill-down queries that OLTP cannot support.
Why is the South South region specifically highlighted?
The region is analyzed as a case study because it holds significant mineral potential that remains underexploited due to the historical national focus on oil and gas production.
- Arbeit zitieren
- Udeme Usanga (Autor:in), 2023, Data Warehousing of Solid Minerals in Nigeria. A Study of South South Region Nigeria, München, GRIN Verlag, https://www.grin.com/document/1387590
