Employing Data Warehousing for Contract Administration: e-Dispute Resolution Prototype

Although data warehouse is very practical for decision making, its application in contract administration is rather limited because of the complicated legal issues and the voluminous data involved. This research attempts to bridge this gap in two ways. First, conceptual models of data warehouse are developed to explain the contents and overall features of the system that were verified by 12 experts in Malaysia. Second, an electronic dispute resolution template, known as e-Dispute Resolution (e-DR), is prototyped by using a database tool based on the guidelines of contractual variations agreed by the experts. Subsequently, the prototype is evaluated by 16 professional quantity surveyors from an established consulting firm. The prototype was organized based on a systematic breakdown of issues and incorporated a Boolean keyword search feature. The results show that the concept of datawarehouse is applicable to contract administration and is well received by practitioners. Overall, this article renders significant theoretical and practical contributions in which the resulting e-DR does not only lead toward more informed decision making but is also able to mitigate or prevent contractual disputes in the construction industry, where such a phenomenon seems to be inevitable. DOI: 10.1061/(ASCE)CO.1943-7862.0000642. © 2013 American Society of Civil Engineers. CE Database subject headings: Databases; Contracts; Data collection; Dispute resolution; Construction industry. Author keywords: Database application; Contract administration; Data warehouse; e-Dispute Resolution; Contractual variations; Construction industry.

[1]  W. H. Inmon,et al.  Building the Data Warehouse,3rd Edition , 2002 .

[2]  Pollaphat Nitithamyong,et al.  Web-based construction project management systems: how to make them successful? , 2004 .

[3]  Mandar Mitra,et al.  Information Retrieval from Documents: A Survey , 2000, Information Retrieval.

[4]  Florence Yean Yng Ling,et al.  Risks faced by Singapore firms when undertaking construction projects in India , 2006 .

[5]  Binshan Lin,et al.  An Ecological Model for Organizational Knowledge Management , 2010, J. Comput. Inf. Syst..

[6]  Jieh-Haur Chen,et al.  KNN based knowledge-sharing model for severe change order disputes in construction , 2008 .

[7]  H. Randolph Thomas,et al.  Interpretation of Construction Contracts , 1994 .

[8]  Sheikh Sabah Jaber Ali Al-Sabah,et al.  A database management system to document and analyse construction claims , 2003 .

[9]  Rosli Mohamad Zin,et al.  A case study into the language structure of construction standard form in Malaysia , 2010 .

[10]  Alan Richard,et al.  New Trends and Bad Results in Construction Contracts, Part I , 2004 .

[11]  Keith R. Molenaar,et al.  Prediction of Construction Disputes in Change Issues , 2000 .

[12]  Inderpal Singh Mumick,et al.  Selection of Views to Materialize in a Data Warehouse , 2005, IEEE Trans. Knowl. Data Eng..

[13]  S. Cheung,et al.  A study of construction mediator tactics—Part I: Taxonomies of dispute sources, mediator tactics and mediation outcomes , 2007 .

[14]  Victor B. Kreng,et al.  The application of Fuzzy Delphi Method and Fuzzy AHP in lubricant regenerative technology selection , 2010, Expert Syst. Appl..

[15]  Shing-Ko Liang,et al.  Determinants of the Assignment of Managers to Foreign Branches by Banks, Using the Fuzzy Delphi Method , 2006 .

[16]  Sai On Cheung,et al.  Construction Negotiation Online , 2004 .

[17]  Amr A. Oloufa,et al.  Model for Quantifying the Impact of Change Orders on Project Cost for U.S. Roadwork Construction , 2010 .

[18]  Mark I. Hwang,et al.  A Structural Model of Data Warehousing Success , 2008, J. Comput. Inf. Syst..

[19]  Min-Yuan Cheng,et al.  Fuzzy case-based reasoning for coping with construction disputes , 2009, Expert Syst. Appl..

[20]  Lucio Soibelman,et al.  Factor selection for delay analysis using Knowledge Discovery in Databases , 2008 .

[21]  Mustafa Alshawi,et al.  Augmented process model for e-tendering: Towards integrating object models with document management systems , 2010 .

[22]  Francis T. Hartman,et al.  Construction Claims and Disputes: Causes and Cost/Time Overruns , 1994 .

[23]  Ying-Feng Kuo,et al.  Constructing performance appraisal indicators for mobility of the service industries using Fuzzy Delphi Method , 2008, Expert Syst. Appl..

[24]  Wenhong Luo,et al.  A framework for selecting business process modeling methods , 1999 .

[25]  Khaled El-Rayes,et al.  Change Orders Impact on Labor Productivity , 2005 .

[26]  Essam Zaneldin,et al.  Construction claims in United Arab Emirates: Types, causes, and frequency , 2006 .

[27]  Timos K. Sellis,et al.  Designing Data Warehouses , 1999, Data Knowl. Eng..

[28]  Samuel Labi,et al.  Frequency of Change Orders in Highway Construction Using Alternate Count-Data Modeling Methods , 2010 .

[29]  Jonathan Jingsheng Shi,et al.  A project-oriented data warehouse for construction , 2006 .

[30]  Nayem Rahman.  Refreshing Data Warehouses with near Real-Time Updates , 2007, J. Comput. Inf. Syst..

[31]  Kwok-wing Chau,et al.  Application of a PSO-based neural network in analysis of outcomes of construction claims , 2007 .

[32]  Tanaya Korde,et al.  Visual representation of construction management data , 2009 .

[33]  Kwok-wing Chau,et al.  Application of data warehouse and Decision Support System in construction management , 2003 .

[34]  Keith W. Hipel,et al.  Conflict resolution in construction disputes using the graph model , 2006 .

[35]  Jon C. Broome,et al.  A comparison of the clarity of traditional construction contracts and of the New Engineering Contract , 1997 .

[36]  Po-Han Chen,et al.  Augmented IDEF1-based process-oriented information modeling , 2004 .

[37]  Siong Choy Chong,et al.  Construction contract administration in Malaysia using DFD: a conceptual model , 2011, Ind. Manag. Data Syst..

[38]  Robert A. Perkins,et al.  Sources of Changes in Design – Build Contracts for a Governmental Owner , 2009 .

[39]  Raufdeen Rameezdeen,et al.  Contract interpretation: the impact of readability , 2007 .

[40]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[41]  Charles T. Jahren,et al.  Investigation Into Construction Disputes , 1990 .