Research on XML Data Storage Technology Based on Relational Database
|School||Liaoning Technical University|
|Course||Applied Computer Technology|
|Keywords||XML Schema Relational database Storage Mapping System tables|
This article focuses on the technology of XML documents stored in a relational database based on XML Schema . Existing storage solutions , build relationships based on XML Schema mode , a mode information is lost, the relational schema unreasonable , XML Schema - based XML documents stored in a relational database technology is still not mature . This paper presents a new storage solution designed storage from XML Schema information to the four system tables the mode information retained in the database , so that do not have to parse XML Schema documents each mode information is needed , the design of the system tables both the versatility of the program , its structure can guarantee mode information is not lost , there is conducive to the generation of the relational schema and XML document reconstruction ; generate relational schema , and learn from the XML Schema to the conversion of the P-Schema Theory , its generated the rules for the improvement and expansion , to avoid the table generation of no practical significance , such that the resultant pattern of the relationship is more rational, and is conducive to the query . Eclipse environment using the Java language to achieve a storage system , which verified the feasibility of the program . XML document storage system to establish the relationship between mode under any XML Schema , to meet the constraints of the XML Schema document to today's popular relational database , with good versatility .