Skip to main content

Need of DW and DM in government, medical, military

Short answer

Government, medical, and military sectors need warehousing to integrate scattered data and mining for insights like fraud detection, disease prediction, and threat analysis. Warehouse data is subject-oriented, integrated, time-variant, and non-volatile. Example: a hospital fact table Treatment(patient_key, doctor_key, disease_key, time_key, cost, stay_days) enables queries like average stay per disease per year.

Explain the necessity of Data warehousing and data mining in government, medical and military. Characterize the warehouse data with example.

Necessity of data warehousing and data mining

Government, medical and military organisations hold huge volumes of data in separate systems. A warehouse integrates them and data mining finds knowledge in them.

Government

  • Warehouse: integrates tax, census, land, citizenship and budget data for e-governance and planning.
  • Mining: detect tax evasion and fraud, predict population and resource needs, find areas for development projects, analyse crime patterns.

Medical

  • Warehouse: gives a complete patient history from hospitals and labs; supports hospital management and research.
  • Mining: diagnosis and disease prediction, finding treatment-outcome patterns, detecting insurance fraud, epidemic tracking.

Military

  • Warehouse: integrates intelligence, logistics, personnel and equipment data.
  • Mining: threat and anomaly detection, logistics and supply forecasting, personnel planning, analysis of surveillance data.

Characterising warehouse data with an example

Warehouse data is subject-oriented (by patient, not by department), integrated (one coding of disease and gender), time-variant (patient records over 10 years) and non-volatile (past diagnoses are never overwritten, new visits are added).

Example: a hospital warehouse has fact table Treatment(patient_key, doctor_key, disease_key, time_key, cost, stay_days) with dimensions patient, doctor, disease and time. Queries like "average stay per disease per year" can be answered quickly.

✓ Answer checked by Claude Opus 5.5 (high effort)

Related questions

All Data Mining chapter 1 questions →