Abstract:How to provide construction managers with information about and insight into the existing data, so as to make decision more efficiently without interrupting the daily work of an On-Line Transaction Processing (OLTP) system is a problem during the construction management process. To solve this problem, the integration of a data warehouse and a Decision Support System (DSS) seems to be efficient. ‘Data warehouse’ technology is a new database discipline, which has not yet been applied to construction management. Hence, it is worthwhile to experiment in this particular field in order to gauge the full scope of its capability. First reviewed in this paper are the concepts of the data warehouse, On-Line Analysis Processing (OLAP) and DSS. The method of creating a data warehouse is then shown, changing the data in the data warehouse into a multidimensional data cube and integrating the data warehouse with a DSS. Finally, an application example is given to illustrate the use of the Construction Management Decision Support System (CMDSS) developed in this study. Integration of a data warehouse and a DSS enable the right data to be tracked down and provide the required information in a direct, rapid and meaningful way. Construction managers can view data from various perspectives with significantly reduced query time, thus making decisions faster and more comprehensive. The applications of a data warehousing integrated with a DSS in construction management practice are seen to have considerable potential.

Data Warehouse Technique on SDH Configuration Management

Metadata Management Technology in Data Warehouse

Application of Data Warehouse Technology to Distribution Network Automation

On Improving GDSS Data Warehouse

On the Data Warehousing Techniques Introduced in Bank Credit Assessment Management Systems

Design Of Distributed Data Warehouse For Sales Decision Of Large-Scale Clothing Enterprise

Data warehouse for quality management system

Research on Customer Relationship Management System Based on Data Warehouse

Data Warehouse of Highway Management and Its Data Analysis Techniques

Data System Configuration and Organizing and Management Technologies of Information System

Design of SDH Network Management System

Application of Data Warehousing Technology to Modularizing Foreign Trade Auxiliary Decision System

Application of Data Warehouse to Power System

Study on Data Warehouse in Decision Support System of Ecological Demonstration Zone

APPLICATION OF DATA WAREHOUSE AND DATA MINING TECHNIQUES TO POWER SYSTEMS

The Application of DTS Technology on the Basis of the Data Warehouse

The Spatial Data Warehouse Establishment for Digital South China Sea

Hierarchically Distributed Data Warehouse

Application of data warehouse and Decision Support System in construction management

An Intelligent Decision Support System In Construction Management By Data Warehousing Technique

Design and Construction of a Provinical Level Distributed Data Warehouse about Ocean Dynamical Environment