Classification of Metadata Categories in Data Warehousing - A Generic Approach

Using appropriate metadata is a central success factor for (re)engineering and using data warehouse systems effectively and efficiently. The approach presented in this paper aims to reduce the effort in developing and operating data warehouse systems and thus to increase the ability and acceptance of a data warehouse. To achieve these objectives identifying the appropriate metadata is an important task. To avoid processing the “wrong” object data and thus compromising the acceptance of a data warehouse system, a systematic approach to categorize and to identify the appropriate metadata is essential. This paper presents such a generic approach. After investing and structuring problem situations, that can occur in data warehousing, metadata categories are identified to solve a given problem situation. A use case illustrates the approach.

[1]  David Haynes.  Metadata: For Information Management and Retrieval , 2004 .

[2]  David Marco,et al.  Building and Managing the Meta Data Repository: A Full Lifecycle Guide , 2000 .

[3]  Murugan Anandarajan,et al.  Business Intelligence Techniques , 2004 .

[4]  InduShobha N. Chengalur-Smith,et al.  The Impact of Experience and Time on the Use of Data Quality Information in Decision Making , 2003, Inf. Syst. Res..

[5]  Jane P. Laudon,et al.  Management Information Systems: Managing the Digital Firm , 2010 .

[6]  Philip Barker.  Metadata for Information Management and Retrieval , 2005 .

[7]  M. Jarke,et al.  Fundamentals of Data Warehouses , 2003, Springer Berlin Heidelberg.

[8]  Michael Jennings,et al.  Universal Meta Data Models , 2004 .

[9]  Anca Vaduva,et al.  Metadata Management for Data Warehousing: An Overview , 2001, Int. J. Cooperative Inf. Syst..

[10]  Neil Foshay,et al.  Does data warehouse end-user metadata add value? , 2007, CACM.

[11]  Dennis Murray,et al.  Data warehousing in the real world - a practical guide for building decision support systems , 1997 .

[12]  Adrienne Tannenbaum.  Implementing a Corporate Repository: The Models Meet Reality , 1994 .

[13]  K Bellenberg,et al.  Managerial considerations. , 1976, Quintessence of dental technology.

[14]  Barbara Dinter,et al.  Process Orientation of Information Logistics An Empirical Analysis to Assess Benefits, Design Factors, and Realization Approaches , 2008, Proceedings of the 41st Annual Hawaii International Conference on System Sciences (HICSS 2008).

[15]  David Mellor,et al.  Common Warehouse Metamodel: An Introduction to the Standard for Data Warehouse Integration , 2001 .

[16]  Robert Winter,et al.  Information requirements engineering for data warehouse systems , 2004, SAC '04.

[17]  Giri Kumar Tayi,et al.  Enhancing data quality in data warehouse environments , 1999, CACM.

[18]  Larry P. English.  Improving Data Warehouse and Business Information Quality: Methods for Reducing Costs and Increasing Profits , 1999 .