COMBINING THE DATA WAREHOUSE AND OPERATIONAL DATA STORE

Ahmed Sharaf Eldin Ahmed, Yasser Ali Alhabibi, Abdel Badeeh M. Salem

2006

Abstract

Many of small business organizations tend to combine the operational data stores (ODS) and data warehousing (DW) in one structure in order to save the expenses of building two separate structures for each of them. The purpose of this paper is investigating the expected obstacles that may affect organizations that try to combine the ODS and DW in one structure. Both the analytical and comparative analysis are used to investigate the obstacles and drawbacks that have been faced in combining the ODS and DW in one structure.

References

  1. Awad H. K, 2000, A Multi-Entry Methodology for Data Warehouse Develop. Proc. of 8th Cairo Int. Conf on AI Applications, Cairo, Egypt, pp. 21-22.
  2. Dhor Vasant and Stein Roger, 1996, Seven Methods for Transforming Corporate Data into Business Intelligence, Prentice Hall PTR, London, UK
  3. Donald J. Brendt, John W. Fisber, Alan R. Hevner, 2001, Healthcare Data Warehousing and Quality Assurance, Computer, December 2001, Vol. 34, No. 12, pp. 56- 65, IEEE Computer Society, Piscataway, NJ, USA
  4. Farzad Shafiei, David Sundaram, 2004, Multi-Enterprise Collaborative Enterprise Resource Planning and Decision, Proceedings of the 37th Annual Hawaii International Conference on System Sciences (HICSS'04) - Track 8, pp. 80228a, January 05 - 08, 2004, Big Island, Hawaii.
  5. Harry Singh, 1999, Interactive Data Warehousing, Prentice Hall, Inc, A Simon & Schuster Company, Upper Saddle River, NJ 07458, USA
  6. Hemant K. Bhargava, Suresh Sridhar, and Craig Herrick, 1999, Beyond Spreadsheets: Tools for Building Decision Support Systems, Computing Practices, March 1999, pp. 31-39, 0018-9162/99 @ 1999 IEEE.
  7. Holger Schwarz, Ralf Wagner, Brenhard Mitschang, 2001, Improving the Processing of Decision Support Queries: The Case for a DSS Optimizer, 2001, International Database Engineering & Applications Symposium (IDEAS-01), Jul-01, pp. 0177.
  8. Inmon W. H., Imhoff Claudia and Sousa Ryan, 1998, Corporate Information Factory, Wiley Computer Publishing, New York, USA
  9. Kemal A. Delic, Laurent Douillet, Umeshwar Dayal, 2001, Towards Architecture for Real-Time Decision Support Systems: Challenges and Solutions, 2001 International Database Engineering & Applications Symposium (IDEAS-01), Jul-01, pp. 0303.
  10. Lilian Harada, Yuuji Hotta and Tadashi Ohmori, 2004, Detection of Sequential Patterns of Events for Supporting Business Intelligence Solutions, International Database Engineering and Application Symposium (IDEAS'04), July, 07-09, 2004, pp. 475- 479, Coimbra, Portugal , IEEE, Piscataway, NJ, USA.
  11. M. Poess, B. Smith, L. Collar, and P. A. Larson, 2002, TPC-DS: Taking Decision Support Benchmarking to the next level. In 2002 ACM SIGMOD International Conference on Management of Data, Madison, USA
  12. Michael Blaha, 2001, Data Warehouses and Decision Support Systems, Computer, December 2001, Vol. 34, No. 12, pp. 38-39, IEEE Computer Society, Piscataway, NJ, USA
  13. Murray E. Jennex, Lorne Olfman and Theophilus B. A. Addo, 2003, the Need for an Organizational Knowledge Management Strategy, 36th Annual Hawaii International Conference on System Sciences (HICSS'03) - Track 4, pp. 117a, January, 06 - 09, 2003, Big Island, Hawaii.
  14. N. Bolloju, 2001, Extended Role of Knowledge Discovery Techniques in Enterprise Decision Support Environments, 34th Annual Hawaii International Conference on System Sciences (HICSS-34) - Volume 3, Jan-2001, pp. 3012.
  15. R. Vahidov, 2002, Decision Station: A Notion for a Situated DSS, 35th Annual Hawaii International Conference on System Sciences (HICSS' 02), Vol. 3, pp. 'b, January, 07-10, 2002, Big Island, Hawaii.
  16. Rob Mattison, 1996, Data Warehousing, Irwin McGrawHill, New York, USA
  17. Robert Grover Little, Michael Lucas Gibson, 2003, Perceived Influences on Implementing Data Warehousing, IEEE Transactions on Software Engineering, April 2003 (Vol. 29, No. 4), pp. 290-296, IEEE, Piscataway, NJ, USA.
  18. Seoudi Group, 1998, SG Manual Reference, SG Documents, by permission from GM.
  19. Singh Harry, 1999, Data Warehousing: Concepts, Technologies, and Implementation Prentice Hall PTR, London, UK.
  20. Svetlozar Nestorov and Nenad Jukic, 2003, Ad-Hoc Association-Rule Mining within the Data Warehouse, 36th Annual Hawaii International Conference on System Sciences (HICSS'03) - Track 8, pp. 232a, January 06 - 09, 2003, Big Island, Hawaii.
  21. T. Hess, J. Wells, 2002, Understanding How Metadata and Explanations Can Better Support Data Warehousing and Related Decision Support Systems: Exploratory Case Study, 35th Annual Hawaii International Conference on System Sciences (HICSS-35) - Volume 8, Jan-2002, pp. 223.
  22. Transaction Processing Council, 1999, TCP Benchmark R standard Specification.
Download


Paper Citation


in Harvard Style

Sharaf Eldin Ahmed A., Ali Alhabibi Y. and Badeeh M. Salem A. (2006). COMBINING THE DATA WAREHOUSE AND OPERATIONAL DATA STORE . In Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-972-8865-41-2, pages 282-288. DOI: 10.5220/0002490802820288


in Bibtex Style

@conference{iceis06,
author={Ahmed Sharaf Eldin Ahmed and Yasser Ali Alhabibi and Abdel Badeeh M. Salem},
title={COMBINING THE DATA WAREHOUSE AND OPERATIONAL DATA STORE},
booktitle={Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2006},
pages={282-288},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002490802820288},
isbn={978-972-8865-41-2},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - COMBINING THE DATA WAREHOUSE AND OPERATIONAL DATA STORE
SN - 978-972-8865-41-2
AU - Sharaf Eldin Ahmed A.
AU - Ali Alhabibi Y.
AU - Badeeh M. Salem A.
PY - 2006
SP - 282
EP - 288
DO - 10.5220/0002490802820288