Abstract
Data warehouses is a typical example of distributed systems where diverse tools and platforms need to communicate to understand each other. For the communication, metadata integration is significant. Seamless metadata interchange improves the data quality and the system effectiveness. Metadata standards exist, for instance, Common Warehouse MetaModel (CWM), which have enhanced the metadata integration. However, it is far from solving the problem of metadata integration in data warehouse environment. This paper proposes an approach to apply a knowledge-based system that supports the metadata integration. By utilizing the knowledge of software engineers on Common Warehouse MetaModels and the metadata interchange models, the knowledge-based system can give metadata interchange model suggestions. Such a knowledge-based system intends to partly automate the metadata integration to improve the efficiency and the quality of metadata integration in data warehouses.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Sen, A.: Metadata management: past, present and future. Decision Support System 37, 151–173 (2004)
Neaga, E.I., Harding, J.A.: An enterprice modeling and integration framwork based on knowledge discovery and data mining. International Journal of Production Research 37(6), 1089–1108 (2005)
Medina, E., Trujillo, J.: A Standard for Representing Multidimensional Properties: The Common Warehouse Metamodel (CWM). In: Manolopoulos, Y., Návrat, P. (eds.) ADBIS 2002. LNCS, vol. 2435, pp. 232–247. Springer, Heidelberg (2002)
Auth, G., von Maur, E.: A software architecture for XML-based metadata interchange in data warehouse systems. In: Chaudhri, A.B., Unland, R., Djeraba, C., Lindner, W. (eds.) EDBT 2002. LNCS, vol. 2490, pp. 1–14. Springer, Heidelberg (2002)
Poole, J., Chang, D., Tolbert, D., Mellor, D.: Common Warehouse Metamodel, An Introduction to the Standard for Data Warehouse Integration. John Wiley & Sons, Inc., New York (2002)
Mazón, J.-N., Trujillo, J.: An MDA approach for the development of data warehouses. Decision Support Systems 45, 41–58 (2008)
Zhao, L., Siau, K.: Information Mediation Using Metamodels: An Approach Using XML and Common Warhouse Metamodel. Journal of Database Management 18(3), 69–82 (2007)
Staudt, M., Vaduva, A., Vetterli, T.: Metadata Management and Data Warehousing. University of Zurich (1999)
Object Management Group: Common Warehouse Metamodel (CWM) Specification, Version 1.1, vol. 1 (2003)
Kimball, R., Ross, M., Thornthwaite, W., Mundy, J., Becker, B.: The Data Warehouse Lifecycle Toolkit, 2nd edn. Wiley, Indiana (2008)
Inmon, W.H.: Building the Data Warehouse, 3rd edn. Wiley, New York (2005)
Zhao, X., Huang, Z.: A Formal Framework for Reasoning on Metadata Based on CWM. In: Embley, D.W., Olivé, A., Ram, S. (eds.) ER 2006. LNCS, vol. 4215, pp. 371–384. Springer, Heidelberg (2006)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2010 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Wu, D., Håkansson, A. (2010). Applying a Knowledge Based System for Metadata Integration for Data Warehouses. In: Setchi, R., Jordanov, I., Howlett, R.J., Jain, L.C. (eds) Knowledge-Based and Intelligent Information and Engineering Systems. KES 2010. Lecture Notes in Computer Science(), vol 6279. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-15384-6_7
Download citation
DOI: https://doi.org/10.1007/978-3-642-15384-6_7
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-15383-9
Online ISBN: 978-3-642-15384-6
eBook Packages: Computer ScienceComputer Science (R0)