XML queries via SQL

被引:0
|
作者
Chen, CX [1 ]
Malhotra, A
机构
[1] Univ Calif Los Angeles, Dept Comp Sci, Los Angeles, CA 90095 USA
[2] IBM Corp, Thomas J Watson Res Ctr, Hawthorne, NY 10532 USA
关键词
D O I
暂无
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
As XML [12] becomes more popular, we expect XML documents to be stored in databases with different representations. So an important issue is to translate XML queries into the language of the database. XPath [13], the XML Path Language, is a standard for expressing navigation and selection in XML documents. Hence it can be used to specify certain kinds of XML queries. If XML documents are stored in a relational database, XPath queries have to be translated into SQL [11]. This paper proposes an algorithm to translate queries expressed in XPath to SQL statements. The algorithm uses information that specifies the mapping of XML documents to relational tables.
引用
收藏
页码:53 / 60
页数:8
相关论文
共 50 条
  • [1] SQL/XML performance analysis of parent/ancestor queries
    Pardede, Eric
    Rahayu, J. Wenny
    Taniar, David
    Aujla, Ramanpreet Kaur
    [J]. COMPUTATIONAL SCIENCE AND ITS APPLICATIONS - ICCSA 2008, PT 2, PROCEEDINGS, 2008, 5073 : 1258 - +
  • [2] USING SQL/XML FOR EFFICIENTLY TRANSLATING QUERIES OVER XML VIEW OF RELATIONAL DATA
    Lemos, Fernando
    Costa, Clayton
    Vidal, Vania
    [J]. ICEIS 2010: PROCEEDINGS OF THE 12TH INTERNATIONAL CONFERENCE ON ENTERPRISE INFORMATION SYSTEMS, VOL 1: DATABASES AND INFORMATION SYSTEMS INTEGRATION, 2010, : 269 - 274
  • [3] Recursive XML schemas, recursive XML queries, and relational storage: XML-to-SQL query translation
    Krishnamurthy, R
    Chakaravarthy, VT
    Kaushik, R
    Naughton, JF
    [J]. 20TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING, PROCEEDINGS, 2004, : 42 - 53
  • [4] XML programming with SQL/XML and XQuery
    Funderburk, JE
    Malaika, S
    Reinwald, B
    [J]. IBM SYSTEMS JOURNAL, 2002, 41 (04) : 642 - 665
  • [5] Auditing SQL queries
    Motwani, Rajeev
    Nabar, Shubha U.
    Thomas, Dilys
    [J]. 2008 IEEE 24TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING, VOLS 1-3, 2008, : 287 - +
  • [6] Advancements in SQL/XML
    Eisenberg, A
    Melton, J
    [J]. SIGMOD RECORD, 2004, 33 (03) : 79 - 86
  • [7] XML-SQL: An XML query language based on SQL and path tables
    Pankowski, T
    [J]. XML-BASED DATA MANAGEMENT AND MULTIMEDIA ENGINEERING-EDBT 2002 WORKSHOPS, 2002, 2490 : 184 - 209
  • [8] Routing XML queries
    Koudas, N
    Rabinovich, M
    Srivastava, D
    Yu, T
    [J]. 20TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING, PROCEEDINGS, 2004, : 844 - 844
  • [9] Correcting queries for XML
    Cohen, Sara
    Brodianskiy, Tali
    [J]. INFORMATION SYSTEMS, 2009, 34 (08) : 690 - 710
  • [10] Proving the safety of SQL queries
    Brass, S
    Goldberg, C
    [J]. QSIC 2005: FIFTH INTERNATIONAL CONFERENCE ON QUALITY SOFTWARE, PROCEEDINGS, 2005, : 197 - 204