用SQL2000与XML技术整合实现电力通信网信息集成  

Application of data exchange of SQL 2000 and XML in electric communication networks

作　　者：徐扬[1] 高会生[1] 胡智奇[1] 薛云山[1] 

机构地区：[1]华北电力大学电子与通信工程系,河北保定071003

出　　处：《电力系统通信》2005年第7期65-68,共4页Telecommunications for Electric Power System

摘　　要：XML正在成为Internet上进行数据描述和交换的标准,并将取代HTML而成为Web上存取数据的主要格式。文章根据XML数据库的研究现状,探讨了XML和SQL的技术特点,提出将技术上相辅相成的二者巧妙地结合起来,可实现数据库的无损存储、检索和修改以及异构数据库间连接交互的方案;具体分析了XML和SQL之间的影射关系,展示了XML和数据库之间数据的相互转换方法;最后以“电力通信设备告警管理系统”为例,给出了实现的具体过程。XML is becoming a standard of data representation and exchanging over the Internet. Instead of HTML it will be the main format for accessing Web data. According to the current research of XML database this paper discusses the speciality of XML and the SQL techniques, proposes to combine together these two kinds of technique, which are complemented each other. Then the no harm storing, search and revising can be realized and the different constructed databases can be connected mutually. This paper analyzes the mapping relation between XML and SQL, gives out the method how to interchange information between them. At the end of the paper, according to a case of “The alarming information management system of electric power equipments”, it is illustrated how to realize information interchanging between them.

关 键 词：SQL XML 数据库 数据交换 

分 类 号：TN915.853[电子电信—通信与信息系统]