Exclusive Content & Downloads from ASQ

Optimizing Data Warehouse Design

Summary: Production software development often involves reuse and customization of existing software components and solutions and is directly affected by design decisions made in early development stages. Applying statistical analysis to the historical production data can identify dependencies used to develop working models, and can provide software designers with guidelines for optimal design characteristics for future projects. Elements of response surface methodology (RSM) are applied to the database design of a corporate data warehouse. By applying identified optimal regions and a response optimizer model to the practical data mart designs, project risk could be identified and mitigated by screening out nonoptimal design options at early project stages. As a result, the design cycle time for the final product was reduced and the extraction, transformation, and loading (ETL) performance characteristics were improved.

Anyone with a subscription, including Site and Enterprise members, can access this article.

Other Ways to Access content:

Join ASQ

Join ASQ as a Full member. Enjoy all the ASQ member benefits including access to many online articles.

Subscribe to Six Sigma Forum Magazine

Access this and ALL OTHER Six Sigma Forum Magazine online articles. You'll also receive the print version by mail.

  • Topics: Data Quality, Software Quality
  • Keywords: Statistical methods,Data analysis,Design efficiencies,Response surface methodology (RSM),Software configuration management
  • Author: Boroditsky, Vladimir; Molinare, Christine
  • Journal: Six Sigma Forum Magazine