9.1. CHAPTER OBJECTIVES

  • Find out why metadata is so important

  • Understand who needs metadata and what types they need

  • Review metadata types by the three functional areas

  • Discuss business metadata and technical metadata in detail

  • Examine all the requirements metadata must satisfy

  • Understand the challenges for metadata management

  • Study options for providing metadata

We discussed metadata briefly in earlier chapters. In Chapter 2, we considered metadata as one of the major building blocks for a data warehouse. We grouped metadata into the three types, namely, operational, extraction and transformation, and end-user metadata. While discussing the major data warehousing trends in Chapter 3, we reviewed the industry initiatives to standardize metadata.

This chapter deals with the topic of metadata in sufficient depth. We will attempt to remove the fuzzy feeling about the exact meaning, content, and characteristics of metadata. We will also get an appreciation for why metadata is vitally important. Further, we will look for practical methods to provide effective metadata in a data warehouse environment.

Get DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.