ETL过程的调度控制管理研究

Research on dispatching and controlling management of ETL process

对抽取、转换、装载(extract,transform,load,ETL)过程的元数据、调度控制管理进行研究,着重研究数据处理流程之间的逻辑关系,以及如何依据这些逻辑关系以及关联数据处理流程的执行状态,合理地对数据处理流程进行调度控制。通过研究这些问题,给出了ETL元数据管理、规划管理、执行管理以及异常处理的处理办法,并提出了一套调度控制管理流程。

Metadata, dispatching and controlling management of ETL （extract, transform, load） process are researched. And pays more attention to research on logic relationship between data processes and how to dispatch and control data processes according to the logic relationship and states of the correlative data processes reasonably. By research the problems, the methods to manage metadata are given including ETL, ETL design, ETL executing, error or exception, and a set of dispatching and controlling management process are provided.