Research And Application Of XML Data Storage Technique In Relational Database

Along with Internet and information technology rapit development, the quantity of XML data is increaseing with exponential level.How to store and manage XML data reliably and efficiently is a grand challenge in database research field.This paper is based on the study of XML SchemaBased Mapping Storage,hybrid inlining algorithm,data-centric and document-centric XML doccuments storage method. An improved method is put forward for hybrid inlining algorithm coming short of semantic mapping.In the improved hybrid inlining algorithm,XML Schema is adopted, default values and 12 facts ect semantemes are mapped from XML Schema ro relational schema, the features of XML such as level and sequential is fully taken into account, schema mapping with keeping semantic constraint is realized. Different solutions is proposed for the two types of XML document storage method.For data-centric XML documents,DOM is adopted to parser XML documents, each element is added sequence number to maintain the order of XML features.For document-centric XML documents,SAX is adopted to parser XML documents and prevent XML documents with a large number of data led to the system works slowly.XML data store program is created with the core technology of improved hybrid inlining algorithm.this program is transparent to user in the course of storage, supports for XML Schema and relational schema mapping, supports for two types of XML documents storage.Through analysis of the experiment results of real data sets ,it is proved that XML SchemaBased Mapping Storage of this paper is feasible and effective,the improved hybrid inlining algorithm enhances the consistency between ralational schema and XML Schema,raises the accuracy of XML data storage and expands the application space of the algorithm.