基于XML技术的非结构化数据到结构化数据转换的研究

Research on conversion of unstructured data to structured data based on XML technology

针对高速列车数字化仿真平台的数据来源各异,仿真输出文件非结构化,各子系统之间数据交换量大等特点,迫切需要研制一种协同仿真异构数据转换及统一数据交换接口解决方案。本文主要研究协同仿真异构数据转换与管理,提供统一的异构数据交换与访问接口。引入了数据提取的模板概念以及基于X M L技术的数据转换方法,该方法将表数据和表结构分别存放于XML和Schema文件中,再解析XML和Schema文件生成元数据及SQL建表语句完成异构数据的转换。该方法使得非结构化数据到结构化数据转换的流程高效、快捷。

Because of the difference for data sources of high-speed train digital simulation platform,unstructured simulation output file,a large of data exchange among subsystem and so on,it was needed urgently to research on a solution of collaborative simulation of heterogeneous data transformation and harmonization of data exchange interface.This article was mainly responsible for the collaborative simulation of heterogeneous data transformation and management,provided unified heterogeneous data exchange and access interface.This paper introduced the concept of template of data extraction as well as an XML-based data conversion method,by this method,the table data and the table structure was stored in XML file and Schema file respectively to parse XML and Schema file,generate metadata and SQL,build the table statement,complete the conversion of heterogeneous data.This approach made the conversion process of unstructured data to structured data fast and efficiently.