The strategies of a data warehouse integrate heterogeneous data in different organizations. These data are extracted, transformed, and then loaded into a data warehouse by metadata. Metadata is used to abstract out the representational details of data and capture the information content during the technical or business process. The complete and well-defined metadata in a data warehouse can support the decision making of business intelligent. However, as modern technologies change so fast, the heterogeneity of the metadata becomes a problem since a data warehouse integrates more heterogeneous information resources consisting of a variety of digital data. In this paper, we explore the metadata collection during the data processing in a data warehouse. We present the structure of the metadata sharing management which can help trace the data variety and adjust the metadata appropriately. Moreover, we take the multimedia data as an example to present the process to collect and manage the metadata in a data warehouse.
商業智慧 Metadata 資料倉儲 ETL 資料探勘