Best Practices in Data Warehousing

Best Practices in Data Warehousing

Les Pang (University of Maryland University College, USA)
Copyright: © 2009 |Pages: 7
DOI: 10.4018/978-1-60566-010-3.ch024
OnDemand PDF Download:
$37.50

Abstract

Data warehousing has been a successful approach for supporting the important concept of knowledge management— one of the keys to organizational success at the enterprise level. Based on successful implementations of warehousing projects, a number of lessons learned and best practices were derived from these project experiences. The scope was limited to projects funded and implemented by federal agencies, military institutions and organizations directly supporting them. Projects and organizations reviewed include the following: • Census 2000 Cost and Progress System • Defense Dental Standard System • Defense Medical Logistics Support System Data Warehouse Program • Department of Agriculture Rural Development Data Warehouse • Department of Defense (DoD) Computerized Executive Information System • Department of Energy, Lawrence Livermore National Laboratory, Enterprise Reporting Workbench • Department of Health and Human Services, Health Care Financing Administration (HFCA) Teraplex Integration Center • Environmental Protection Agency (EPA) Envirofacts Warehouse • Federal Bureau of Investigation (FBI) Investigative Data Warehouse • Federal Credit Union • Internal Revenue Service (IRS) Compliance Data Warehouse • Securities and Exchange Commission (SEC) Data Warehouse • U.S. Army Operational Testing and Evaluation Command • U.S. Coast Guard Executive Information System • U.S. Navy Type Commander’s Readiness Management System
Chapter Preview
Top

Introduction

Data warehousing has been a successful approach for supporting the important concept of knowledge management—one of the keys to organizational success at the enterprise level. Based on successful implementations of warehousing projects, a number of lessons learned and best practices were derived from these project experiences. The scope was limited to projects funded and implemented by federal agencies, military institutions and organizations directly supporting them.

Projects and organizations reviewed include the following:

  • Census 2000 Cost and Progress System

  • Defense Dental Standard System

  • Defense Medical Logistics Support System Data Warehouse Program

  • Department of Agriculture Rural Development Data Warehouse

  • Department of Defense (DoD) Computerized Executive Information System

  • Department of Energy, Lawrence Livermore National Laboratory, Enterprise Reporting Workbench

  • Department of Health and Human Services, Health Care Financing Administration (HFCA) Teraplex Integration Center

  • Environmental Protection Agency (EPA) Envirofacts Warehouse

  • Federal Bureau of Investigation (FBI) Investigative Data Warehouse

  • Federal Credit Union

  • Internal Revenue Service (IRS) Compliance Data Warehouse

  • Securities and Exchange Commission (SEC) Data Warehouse

  • U.S. Army Operational Testing and Evaluation Command

  • U.S. Coast Guard Executive Information System

  • U.S. Navy Type Commander’s Readiness Management System

Top

Main Thrust

Each best practice (indicated in boldface) and its rationale are listed below. Following each practice is a description of illustrative project or projects (indicated in italics), which support the practice.

Complete Chapter List

Search this Book:
Reset