基于虚拟视图的数据集成方法研究及其应用

Research on data integration based on virtual view and its application

传统虚拟数据库产品在数据集成中存在着系统配置过程、数据查询过程复杂及数据大量复制移动等问题.针对这些问题,提出一种基于虚拟视图的多源数据集成方法.该方法利用分类包装器对底层物理数据进行包装和转换,统一异构数据源访问接口、把底层的数据转换为统一的数据模型.在上层保持原物理数据不变的情况下,建立物理数据局部虚拟数据视图和全局虚拟数据视图、建立数据映射字典,无需进行数据的复制和移动就能为用户提供统一的数据查询接口,使其能在各个系统中查询信息.实验证明,该方法解决了多源数据集成过程中的同名异义及异名同义问题,简化了数据集成的查询定义过程,有效地实现了多源异构数据的集成.

The paper brought out a multi-source data integration method based on virtual view because the traditional virtual data integration exists the faults of configuration inconvenience, the definition of process is complex and a large amount of data is copying in the process of data integration for traditional virtual database. The method converts the physical data into unified data model by using classification and wrapper and unifying the physical data interface of heterogeneous data sources in the bottom layer. Then it creates local virtual data view and global virtual data view of physical data in the upper layer. Users can query the information in each system by using unified ac- cess interface without moving and copying data. So it solves the problem of homonyms and synonyms of multi- source in data integration process, and simplifies the query definition process of data integration and realizes the integration of multi-source heterogeneous data effectively.