{"title":"查询RDBMS中的XML数据","authors":"Xiangyu Hu, Xin Lian, Yunyin Mo, Haiwei Zhang, Xiaojie Yuan","doi":"10.1109/WISA.2012.12","DOIUrl":null,"url":null,"abstract":"With the rapid growing popularity of XML to represent data, how to make good use of XML data in relational databases is worthy of study. Storing XML data as text in relational databases is a traditional strategy which cannot reflect the feature of XML format. In this paper, a mechanism for XML data storage and query in relational databases is proposed. XML data can be stored in relational tables and XQuery expressions can be evaluated as a part of SQL for XML data query. XQuery grammar tree and Query tree model for XML data query in rela-tional databases is presented to gain more efficient performance while querying XML data. Appropriative algorithm for evaluating XPath is also presented in this paper by which XQuery can be evaluated rapidly and efficiency. Finally, experiments invalidate the strategy of XML storage and run the algorithm on real XML datasets to show the efficiency compared with other mechanisms.","PeriodicalId":313228,"journal":{"name":"2012 Ninth Web Information Systems and Applications Conference","volume":"35 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2012-11-16","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"1","resultStr":"{\"title\":\"Query XML Data in RDBMS\",\"authors\":\"Xiangyu Hu, Xin Lian, Yunyin Mo, Haiwei Zhang, Xiaojie Yuan\",\"doi\":\"10.1109/WISA.2012.12\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"With the rapid growing popularity of XML to represent data, how to make good use of XML data in relational databases is worthy of study. Storing XML data as text in relational databases is a traditional strategy which cannot reflect the feature of XML format. In this paper, a mechanism for XML data storage and query in relational databases is proposed. XML data can be stored in relational tables and XQuery expressions can be evaluated as a part of SQL for XML data query. XQuery grammar tree and Query tree model for XML data query in rela-tional databases is presented to gain more efficient performance while querying XML data. Appropriative algorithm for evaluating XPath is also presented in this paper by which XQuery can be evaluated rapidly and efficiency. Finally, experiments invalidate the strategy of XML storage and run the algorithm on real XML datasets to show the efficiency compared with other mechanisms.\",\"PeriodicalId\":313228,\"journal\":{\"name\":\"2012 Ninth Web Information Systems and Applications Conference\",\"volume\":\"35 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2012-11-16\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"1\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2012 Ninth Web Information Systems and Applications Conference\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/WISA.2012.12\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2012 Ninth Web Information Systems and Applications Conference","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/WISA.2012.12","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
With the rapid growing popularity of XML to represent data, how to make good use of XML data in relational databases is worthy of study. Storing XML data as text in relational databases is a traditional strategy which cannot reflect the feature of XML format. In this paper, a mechanism for XML data storage and query in relational databases is proposed. XML data can be stored in relational tables and XQuery expressions can be evaluated as a part of SQL for XML data query. XQuery grammar tree and Query tree model for XML data query in rela-tional databases is presented to gain more efficient performance while querying XML data. Appropriative algorithm for evaluating XPath is also presented in this paper by which XQuery can be evaluated rapidly and efficiency. Finally, experiments invalidate the strategy of XML storage and run the algorithm on real XML datasets to show the efficiency compared with other mechanisms.