Authors:
Tanko Ishaya
1
;
James Chadband
1
and
Lucy Grierson
2
Affiliations:
1
The University of Hull, United Kingdom
;
2
C Spencer ltd, United Kingdom
Keyword(s):
Decision Support, Data Warehouse, Data Warehousing, Knowledge Discovery, Decision-Making, Data Mining, and Information Integration.
Related
Ontology
Subjects/Areas/Topics:
Coupling and Integrating Heterogeneous Data Sources
;
Data Warehouses and OLAP
;
Databases and Information Systems Integration
;
Enterprise Information Systems
;
Object-Oriented Database Systems
;
Organisational Issues on Systems Integration
;
Web Databases
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.