INTEGRATING ENTERPRISE DATA FOR DECISION SUPPORT IN CONSTRUCTION ORGANISATIONS

Tanko Ishaya, James Chadband, Lucy Grierson

Abstract

Information integration is one of the main problems to be addressed when designing a data warehouse for decision-making support. Possible inconsistencies and redundancies between data residing at the operational data sources needs to be resolved before migrating to a data warehouse, so that the data warehouse is able to provide an integrated and reconciled view of data within the organization. This paper presents a performance-oriented data warehouse as an integrated data for decision-making support within a construction organization. The process is based on a conceptual representation of the enterprise, which has been exploited both in the data integration phase of the warehouse information sources and during the decision-making activity from the information stored in the data warehouse. The application of the process has been supported by prototype software tools for data integration, reconciliation and analysis that provides some decision-making support.

References

  1. Adhikari, R. (1996). Migrating legacy data, Software Magazine 16(1), 1996, pp75-80
  2. Ahmed, I. (2000). Data warehousing in construction organizations, Construction Congress, VI 2000 In Proceeding, ASCE, 2000, pp.194-203.
  3. Calvanese, D., Dragone, L., Nardi, D., Rosati, R., and Trisolini, S, M. (2006). Enterprise Modelling and Data Warehouseing in TELECOM ITALIA, In Journal of Information Systems 31(2006), pp 1-32
  4. Checkland, P. (1999). Systems Thinking Practice, John Wiley & Sons, New York, 1999
  5. Decker, K., Oaks, A., and Salinas, M. (1997). Building a Cost Engineering Data Warehouse, In AACE International Transactions, Morgantown, 1997
  6. Gonzalez, C. (2005). Decision support for real-time, dynamic decision-making tasks, In Journal of Organizational Behaviour and Human Decision Process, 96(2005), pp142-154
  7. Inmon, W,H .(2002). Building the Data Warehouse, 3rd ed, Wiley, New York, 2002
  8. Jarke, M., Lenzerini, M., Vassiliou,Y., Vassiliadis, P (Eds.), Fundamentals of Data warehouses, Springer, Berlin, 1999
  9. Jones, K.(1998). An Introduction to Data Warehoursing: What Are the Implications for the Network, In International Journal of Network Management, 8(1998), pp42-56
  10. Kimball, R and Merz, R. (2000).The Data Webhouse Toolkit. Wiley, USA, 2000
  11. Levi, S., and Arsanjani, A. (2002). Developing and Integrating Enterprise Component and Service, in Enterprise Component and Service. Vol. 45. No.10
  12. Macomber, J, D., 2004. IT Strategy for Construction Companies: A Pragmatist's Vision, Retrieved October 2006, from http://ocw.mit.edu/NR/rdonlyres/Civiland-Environmental-Engineering/1- 464Spring2004/A0885389-423D-4B68-91BE5E89450572FD/0/jmacpragvision.pdf
  13. March, S, T., and Hevner, A, R., 2005. Integrated decision support systems: A data warehousing perspective, In Journal of Decision Support Systems (2005) 13 pages, retrieved September 2006, from www.Sciencedirect.com
  14. Matthes, F. et al. A Process-Oriented Approach to Software Component Definition, retrieved September 2005, from http://citeseer.nj.nec.com/cache/papers/ cs/22844/
Download


Paper Citation


in Harvard Style

Ishaya T., Chadband J. and Grierson L. (2007). INTEGRATING ENTERPRISE DATA FOR DECISION SUPPORT IN CONSTRUCTION ORGANISATIONS . In Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-972-8865-88-7, pages 534-539. DOI: 10.5220/0002376705340539


in Bibtex Style

@conference{iceis07,
author={Tanko Ishaya and James Chadband and Lucy Grierson},
title={INTEGRATING ENTERPRISE DATA FOR DECISION SUPPORT IN CONSTRUCTION ORGANISATIONS},
booktitle={Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2007},
pages={534-539},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002376705340539},
isbn={978-972-8865-88-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - INTEGRATING ENTERPRISE DATA FOR DECISION SUPPORT IN CONSTRUCTION ORGANISATIONS
SN - 978-972-8865-88-7
AU - Ishaya T.
AU - Chadband J.
AU - Grierson L.
PY - 2007
SP - 534
EP - 539
DO - 10.5220/0002376705340539