메타데이터 기반 데이터 웨어하우스 아키텍쳐 - ㅅ병원 사례를 중심으로

Abstract

Data warehouse is an intelligent store of data. A metadata is critical for implementing data warehouse. Integrating data warehouse with its metadata helps create a more adaptive information system. This paper proposes a metadata-oriented data warehouse architecture that consists of seven components: legacy, extracting, operational data store, data warehouse, data mart, application, and metadata. A taxonomy for dataflow and metaflow is proposed for better understnading of the architecture. In addition, a metadata schema is built within the framework of the seven componets. Lastly, the architecture with its metadata component is applied to a real-life data warehouse project for a large medical center in order to illustrate its practical usefulness.