Publications / 2010 Proceedings of the 27th ISARC, Bratislava, Slovakia

Project Data Warehouse Management with Multivariate Analysis

Jui-Sheng Chou, Hsin Wang, Hsien-Cheng Tseng
Pages 430-439 (2010 Proceedings of the 27th ISARC, Bratislava, Slovakia, ISBN 978-80-7399-974-2, ISSN 2413-5844)

Many studies have generated cost estimating relationships (CERs) for transportation projects via data analysis. Some studies collected data from databases, while others sourced data from conventional paper-based formats. When cost data were not in a consistent format, many studies failed to discuss the streamlining of pattern recognition. This study adopts a standard procedure for identifying CERs for transportation projects. A pavement maintenance and rehabilitation project type was selected as a case study for extracting data and concealed prediction rules. Linear and log-linear statistical approaches were employed to create optimal models. The resulting optimum estimation models via knowledge discovery in databases process can be then integrated into an expert system to facilitate information management and generate preliminary budgets for transportation agencies.

Keywords: Data Warehouse, Multivariate Analysis, Estimation, Project Management, Transportation