XML文档在关系数据库中的存储方法

Storage Method of XML Documents in Relational Database

XML是网络中跨平台数据发布与交换的标准格式,它在数据库领域有着广阔的应用空间,然而XML文档的树型结构与关系数据库的二维表结构之间存在着巨大的差异,因此在关系数据库中存储XML文档需要进行一些特殊处理。本文分析了XML文件在数据库领域中的存储与管理方法,并重点就Oracle9i中XML相关技术在现代远程教育中的应用进行了讨论,针对以数据为中心和以文档为中心两类文档资料的存储给出了可行的存储方案。

XML is the standard format for cross-platform data release and exchange in Internet and is widely applied in the database field. However,the tree structure of XML document differs from the table structure of relational database greatly,so some special disposals are needed when storing XML documents into the relational database. The way of storage and management of XML documents in the relational database are analyzed in this paper,and the applications of Oracle9i correlative techniques of XML in distance education are discussed also. For two types document datum (data-centric and document-centric),feasible storage schemes are analyzed and given.