--- title: "National data warehouse process architecture" subject: "Data Mining" chapter: 1 key: "semester_7/data_mining:nepal-national-data-warehouse" source: https://www.bctengineer.com/q/semester_7/data_mining/nepal-national-data-warehouse site: BCT Engineering --- # National data warehouse process architecture Data Mining · Chapter 1: Introduction - Asked in: year not given, 10 marks - Answer checked by Claude Opus 5.5 (high effort) on 2026-10-14 - Page: https://www.bctengineer.com/q/semester_7/data_mining/nepal-national-data-warehouse - Whole chapter: https://www.bctengineer.com/md/semester_7/data_mining/chapter-1 ## Question Nepal Government is going to build a national data center (National Data Warehouse) for running e-Governance project. Propose your own process architecture of the warehouse system and explain the responsibilities of each entity within the proposed warehouse architecture. ## Short answer Architecture connects ministry sources via secure network to load manager (extract, validate), warehouse manager (clean, integrate, aggregate), national warehouse with marts, query manager (security, routing), serving ministries and public. Responsibilities: sources provide data, load manager stages, warehouse manager integrates, query manager controls access, metadata team maintains lineage, marts serve analysis, security ensures privacy, analysts mine for policy. ## Answer #### Assumptions Sources are ministries and departments: citizenship (home), tax (IRD), land, health, education, transport and local governments. They use different systems and formats. #### Proposed process architecture ```text Ministry/Dept source systems (many, heterogeneous) | secure network (e-gov network) v +-------------------------------+ | LOAD MANAGER | | extract, validate, stage | +---------------+---------------+ v +-------------------------------+ | WAREHOUSE MANAGER | | clean, integrate, aggregate, | | index, backup, archive | +---------------+---------------+ v +-------------------------------+ | National Data Warehouse | | detail | summary | metadata | | Marts: Health, Edu, Tax, Land | +---------------+---------------+ v +-------------------------------+ | QUERY MANAGER | | security, routing, scheduling | +---------------+---------------+ v Ministries | Planning Commission | Public portal ``` #### Responsibilities | Entity | Responsibility | |---|---| | Source departments | Provide accurate data, define business rules, maintain source systems | | Load manager | Extract, validate and move data on schedule to staging | | Warehouse manager | Cleaning, standard codes (e.g. national ID, district code), integration, summaries, backup, archive, metadata | | Query manager | Control access by role, route and schedule queries, audit log | | Metadata team | Maintain data dictionary and lineage | | Data marts | Serve ministry-specific analysis | | Security / admin | Authentication, encryption, privacy, disaster recovery | | Analysts and users | Reports, OLAP, data mining for policy making | | Governing body | Data standards, policy and legal compliance | ## Check yourself The answer's key points as multiple-choice questions, with the correct option and why. 1. What are source departments responsible for? A. Building the query manager B. Routing queries C. Providing accurate data, defining business rules, maintaining source systems D. Backup of warehouse Answer: C. They own source data quality and rules. (Key point: Source departments) 2. Which entity applies standard codes like national ID and district code? A. Source departments only B. Warehouse manager C. Governing body D. Public portal Answer: B. The warehouse manager cleans and integrates using standard codes. (Key point: Standard codes) 3. What does the query manager do? A. Cleans data B. Extracts data C. Sets legal policy D. Controls access by role, routes and schedules queries, keeps audit log Answer: D. It handles secure query access and scheduling. (Key point: Query manager) 4. What does the governing body do? A. Sets data standards, policy and legal compliance B. Runs ETL C. Builds marts D. Writes SQL Answer: A. Standards and compliance are governance responsibilities. (Key point: Governing body) ## Related in Data Mining - [College warehouse project leader responsibilities](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Acmis-college-warehouse-project) — Data Mining, chapter 1 - [Kathmandu Mall warehouse architecture](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Akathmandu-mall-warehouse) — Data Mining, chapter 1 - [Data warehouse architecture and components](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Adw-architecture-components) — Data Mining, chapter 1 - [Typical process flow in warehouse](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Adw-process-flow) — Data Mining, chapter 1 - [Warehouse architecture and three phases](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Adw-architecture-three-phases) — Data Mining, chapter 1 - [Architecture of data mining system](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Adm-system-architecture) — Data Mining, chapter 1 ## Related in other subjects - [Globalization and development within own culture](https://www.bctengineer.com/question.md?key=semester_8%2Fengineering_professional_practice%3Aglobalization-development-own-culture) — Engineering Professional Practice, chapter 6 - [VHDL entity, architecture; D flip-flop](https://www.bctengineer.com/question.md?key=semester_6%2Fembedded_system%3Avhdl-entity-architecture-dff) — Embedded System, chapter 9 - [Steps to build a hydro project and sell to NEA](https://www.bctengineer.com/question.md?key=semester_8%2Fpower_plant_design%3Ahydro-project-steps-nea) — Power Plant Design, chapter 3, asked 4× - [Case study: existing vs proposed system](https://www.bctengineer.com/question.md?key=semester_5%2Finstrumentation_ii%3Acs-2074asoj) — Instrumentation II, chapter 10