Skip to main content

Data Warehouse Discovery Framework: The Case Study

  • Conference paper
Database Theory and Application, Bio-Science and Bio-Technology (BSBT 2010, DTA 2010)

Abstract

The cost of building an Enterprise Data Warehouse Environment runs usually in millions of dollars and takes years to complete. Even bigger than cost is the risk that all the design and development of the Data Warehouse and Business Intelligence Environment may not bring the result expected by the user. This was the main incentive behind author’s effort of laying down the foundation for new methodology called Data Warehouse Discovery [1]. The foundation met with acceptance by some scientific groups on one hand and industry interest on the other. At that point, the author faced a major challenge. In order to get industry full acceptance as viable tool for the development and maintenance of a robust DW/BI environment, an actual implementation of the methodology in production was necessary. The DW/BI Strategy and Design Project that author was just conducting for the Canadian Federal Government was a perfect opportunity to propose and implement the methodology. This paper is presenting the conduct and results of that business case.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Apanowicz, C.: Data Warehouse Discovery Framework - The Foundation. In: Proc. of DTA 2010, Springer, Heidelberg (2010)

    Google Scholar 

  2. Apanowicz, C.: Data Warehousing and Business Intelligence: Benchmark Project for the Platform Selection. In: Proc. of DTA 2009, Springer, Heidelberg (2009)

    Google Scholar 

  3. Apanowicz, C., Eastwood, V., Ślęzak, D., Synak, P., Wojna, A., Wojnarski, M., Wróblewski, J.: Method and System for Data Compression in a Relational Database. US Patent Application, 2008/0071818 A1 (2008)

    Google Scholar 

  4. Apanowicz, C., Eastwood, V., Ślęzak, D., Synak, P., Wojna, A., Wojnarski, M., Wróblewski, J.: Method and System for Storing, Organizing and Processing Data in a Relational Database. US Patent Application, 2008/0071748 A1 (2008)

    Google Scholar 

  5. Buretta, M.: Data Replication, Tools and Techniques for Managing Distributed Information. John Wiley & Sons, Chichester (1997)

    Google Scholar 

  6. Imhoff, C., Galemmo, N., Geiger, J.G.: Mastering Data Warehouse Design: Relational and Dimensional Techniques. Wiley Publishing Inc., Chichester (2009)

    Google Scholar 

  7. Infobright Inc., http://www.infobright.com http://www.infobright.org http://en.wikipedia.org/wiki/Infobright

  8. Inmon, W.H., Imhoff, C., Sousa, R.: Corporate Information Factory. Wiley Computer Publishing, Chichester (2001)

    Google Scholar 

  9. Inmon, W.H., O’Neil, B., Fryman, L.: Business Metadata: Capturing Enterprise Knowledge. Morgan Kaufman Publishers, San Francisco (2008)

    Google Scholar 

  10. Inmon, W.H., Strauss, D., Neushloss, G.: DW 2.0: The Architecture for the Next Generation of Data Warehousing. Morgan Kaufman Publishers, San Francisco (2008)

    Google Scholar 

  11. Kimball, R., Ross, M., Thornthwaite, W., Mundy, J., Becker, B.: The Data Warehouse Lifecycle Toolkit

    Google Scholar 

  12. Moss, L.T., Atre, S.: Business Intelligence Roadmap. Addison-Wesley, Reading (2003)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2010 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Apanowicz, C. (2010). Data Warehouse Discovery Framework: The Case Study. In: Zhang, Y., Cuzzocrea, A., Ma, J., Chung, Ki., Arslan, T., Song, X. (eds) Database Theory and Application, Bio-Science and Bio-Technology. BSBT DTA 2010 2010. Communications in Computer and Information Science, vol 118. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-17622-7_16

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-17622-7_16

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-17621-0

  • Online ISBN: 978-3-642-17622-7

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics