数据仓库研究中最重要的问题之一是对ETL方法的研究.本研究提出ETL工具是元数据驱动的,以提供更好的柔性机制、扩展能力和可操作性.本文给出了一种基于SQL的元数据驱动的ETL方法的设计和实现细节,并且以国家海洋环境数据仓库为例,证明了这种方法的高效性.
The study on the approach of ETL is one of the most important parts of data warehouse research. This research focuses on ETL tool which is metadata-driven,by this way, the better flexibility, extensibility and maneuverability are provided. This paper presents the details of design and implementation of metadata-driven ETL approach and proves this approach is effective and efficient by the practice of National Environment Ocean Data Warehouse.