XQuery bib book book title title section author
XQuery ﺯﺑﺎﻥ <bib> book <book> * <title>. . . </title> section <author>. . . </author> </book> * title section </bib> title XML پﺮﺱﻭﺟﻮی ﺍﺳﺘﺎﻧﺪﺍﺭﺩ × ﺯﺑﺎﻥ /bib/book/title/text() for /bib//title $b in document("bib. xml")//book //title where $b/publisher = “Springer Verlag” /book/section//title /book/section/title and $b/@year gt “ 2000” order by $b/@year return $b/title <book> {$b/title} </book> XQuery × ﺍﺟﺰﺍی ﺯﺑﺎﻥ XPath ﻋﺒﺎﺭﺕﻫﺎی § FLOWR ﻋﺒﺎﺭﺕﻫﺎی § ﻋﺒﺎﺭﺕﻫﺎی ﺳﺎﺯﻧﺪﻩ § § ﺗﻮﺍﺑﻊ ﻭ ﻋﻤﻠگﺮﻫﺎ ����� – �������� – �� ������ – ����� –. . . – 3
کﺎﺭﻫﺎی ﻣﺮﺗﺒﻂ "XML-to-SQL Query Translation Literature: The State of Art and Open Problems” R. Krishnamurthy R. Kaushik J. F. Naughton 2003 6
ﻣﻨﺎﺑﻊ 1. 2. 3. 4. 5. Rajasekar Krishnamurthy, XML-to-SQL Query Translation, Ph. D. Thesis, university of Wisconsin, Madison, 2004. Yingwen Chen, XQuery Processing in Relational Systems, MS. Thesis, University of Waterloo, Ontario, Canada, 2004. R. Krishnamurthy, R. Kaushik and J. F. Naughton, XML-to-SQL Query Translation Literature: The State of Art and Open Problems, In Proc. of the 1 st Int'l XML Database Symposium (XSym), pages 1 -18, Berlin, Germany, September 2003. David De. Haan, David Toman, Mariano P. Consense and M. Tamer Ozsu, A Comprehensive XQuery to SQL Translation using Dynamic Interval Encoding, In Proceedings of the ACM SIGMOD. ACM Press, June 2003. Rajasekar Krishnamurthy, Raghav Kaushik and Jeffrey F Naughton, Efficient XML-to-SQL Query Translation: Where to Add the Intelligence? , In Proceeding of the 30 th VLDB Confrence, Torento, Canada, pages 144 -155, 2004. 13
( ﻣﻨﺎﺑﻊ)ﺍﺩﺍﻣﻪ 6. 7. 8. 9. 10. Rajasekar Krishnamurthy, Raghav Kaushik, and Jeffrey F Naughton, Unraveling the Duplicate Elimination Problem in XML to SQL Query Translation, Seventh International Workshop on the Web and Databases (Web. DB 2004), June 17 -18, Paris, France, 2004. Rajasekar Krishnamurthy, Venkatesan T. Chakaravarthy, Raghav Kaushik and Jeffrey F. Naughton, Recursive XML Schemas, Recursive XML Queries, and Relational Storage: XML-to-SQL Query Translation, Proceedings. 20 th International Conference on Data Engineering, pages 42 -53, 2004. Sandeep Prakash, Sourav S Bhowmick and Sanjay Madria, Efficient Recursive XML Query Processing Using Relational Database Systems, To appear in Data and Knowledge Engineering Journal, Special Issue on Best Papers of ER 2004, Elsevier Science, 2006. Torsten Grust, Sherif Sakr and Jens Teubner, XQuery on SQL Hosts, Proceedings of the 30 th VLDB Confrence, Torento, Canada, Aug. 2004. Torsten Grust and Jens Teubner, Relational Algebra: Mother Tongue— XQuery: Fluent, Proc. of the first Twente Data Management Workshop on XML Databases, Enschede, The Netherlands, 2004. 14
( ﻣﻨﺎﺑﻊ)ﺍﺩﺍﻣﻪ 11. Torsten Grust, Purely Relational FLWORs, XIME-P 2005, June 1617, Baltimore, Maryland. 12. Ling Wang, Song. Wang, Brian Murphy and Elke A. Rundensteiner, Order-sensitive XML Query Processing over Relational Sources: An Algebraic Approach, Proc. 9 th International Database Engineering ; Application Symposiom(IDEAS’ 05), pp. 175 -184, 2005. 13. Murali Mani, Song Wang, Dan Dougherty and Elke A. Rundensteiner, Join Minimization in XML-to-SQL Translation: An Algebraic Approach, SIGMOD Record, Vol. 35, No. 1, Mar. 2006. 14. H. Georgiadis, I. Varlamis and V. Vassalos, Quering and Updating XML with XML Schema constraints in an RDBMS, Web. DB 2005, June 16 -17, 2005, Baltimore, Maryland, USA. Copyright 2005 ACM. 15. Wenfei Fan, Jeffrey Xu Yu, Hongjun Lu, Jianhua Lu, Rajeev Rastogi, Query Translation from XPath to SQL in the Presence of Recursive DTDs, In Proceedings of the 31 st VLDB Conference, Trondheim, Norway, pages 337 -348, 2005. 15
( ﻣﻨﺎﺑﻊ)ﺍﺩﺍﻣﻪ 16. W 3 C Recommendation, Extensible Markup Language (XML) 1. 0 (Fourth Edition), Sep. 2006, http: //www. w 3. org/TR/REC-xml/. 17. W 3 C Candidate Recommendation, XQuery 1. 0: An XML Query Language, 8 June 2006, http: //www. w 3. org/TR/xquery. 18. W 3 C Proposed Recommendation, XML Path Language (XPath) 2. 0, 21 November 2006, http: //www. w 3. org/TR/xpath 20/. 19. Submission to the World Wide Web Consortium, XML-QL: A Query Language for XML, 19 -August-1998, http: //www. w 3. org/TR/NOTE-xmlql/. 20. W 3 C Working Draft, The XML Query Use Cases, 04 April 2005, http: //www. w 3. org/TR/2005/WD-xquery-use-cases-20050404/ 16
- Slides: 16