毕业设计（论文）-将XML数据存入关系数据库中的方法设计.docVIP

摘 要 Abstract With the development of Internet and the people’s higher and higher requirement for data’s standardization and its independent of platform,XML(extensible markup language) is widely used,in the mean time the higher requirement for the storage of XML data is asked. This research group designed a method to store XML data into RDB(Relational Data Base) of which the technology have been very mature and widely used.Then we developed an application that can store the XML data into RDB using this method. At first this article will introduce basical knowledge of XML,and then discuss why store XML data using RDB.After that we’ll research and discuss the some methods for storing XML data into RDB that have been put forward.Based on them we’ll design a storage method from non-schema XML data to RDB.We classified XML data as four kind of nodes such as Document,Element,Atribute and Text.These four nodes are mapped to four tables in the RDB and we mapped the DOM Tree into a table too.The five tables is the core of the RDB design.The attribute information involved in the tables is required that both DOM and SAX interface can be easy to get information from the tables. After giving the method we designed we’ll develop an application that can storing the XML data into RDB using that method.It’s requirement analyse,design details and test result well be described in the second half part of the article.The test result will show that using the storage method we can storing the non-schema XML data into the RDB effectively. Key words:RDB(Relational Data Base),XML 目 录 摘 要 1 Abstract 2 目 录 3 1 绪 论 5 1.1 课题背景及研究意义 5 1.2 XML知识简介 5 1.2.1 XML 5 1.2.2 DTD和Schema 7 1.2.3 DOM 7 1.2.4 SAX 9 1.3 基于关系数据库的XML存储技术 10 1.3.1 现存的基于关系数据库的XML存储技术 10 1.3.2 一个模式驱动映射实例 10 1.4 作者的工作 11 1.5 本章小结 11 2 无模式映射的设计 12 2.1方案设计要求 12 2.2设计思想 12 2.3方案详细设计 12 2.3.1 E-R图(实体集中只画主码) 13 2.3.2 实体集和联系 13 2.3.3 设计方法与策略 14 2.3.4 数据库基本表设计 16 2.3.5数据库优化 16 2.3.6数据字典 16 2.4