A review of information modeling and its significance for the development of CASE tools for source integration in data warehouse

There are different data warehouse structures or architectures for source integration and along with corresponding modeling methods for representation and inference. Broadly they are categorized as traditional or two level perspective architecture that does not consider the enterprise conceptual model, and three/four level perspective architecture that does consider and center on the enterprise conceptual model. This paper reviews the architectural structure, and the associated representation and reasoning techniques developed-for quality (accurate, consistence and complete) source integration in data warehousing. Finally, tools and applications that implement this architectural structure and the associated representation and reasoning techniques are reviewed followed by the presentation of the significance and limitations of these architectures for the development of Computer Assisted Software Engineering (CASE) tools for data warehouse design and development.