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 条
  • [11] VENN DIAGRAMS AND SQL QUERIES
    HALPIN, TA
    AUSTRALIAN COMPUTER JOURNAL, 1989, 21 (01): : 27 - 32
  • [12] MAKE BULLETPROOF SQL QUERIES
    LINTHICUM, DS
    BYTE, 1995, 20 (02): : 111 - 113
  • [13] Automated Grading of SQL Queries
    Chandra, Bikash
    Banerjee, Ananyo
    Hazra, Udbhas
    Joseph, Mathew
    Sudarshan, S.
    2019 IEEE 35TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE 2019), 2019, : 1630 - 1633
  • [14] Automatic Generation of SQL Queries
    Do, Quan
    Agrawal, Rajeev K.
    Rao, Dhana
    Gudivada, Venkat N.
    2014 ASEE ANNUAL CONFERENCE, 2014,
  • [15] Proving the safety of SQL queries
    Brass, S
    Goldberg, C
    QSIC 2005: FIFTH INTERNATIONAL CONFERENCE ON QUALITY SOFTWARE, PROCEEDINGS, 2005, : 197 - 204
  • [16] SQL queries with CASE expressions
    Gryz, Jarek
    Wang, Qiong
    Qian, Xiaoyan
    Zuzarte, Calisto
    FOUNDATIONS OF INTELLIGENT SYSTEMS, PROCEEDINGS, 2008, 4994 : 351 - +
  • [17] FORMAL SEMANTICS OF SQL QUERIES
    NEGRI, M
    PELAGATTI, G
    SBATTELLA, L
    ACM TRANSACTIONS ON DATABASE SYSTEMS, 1991, 16 (03): : 513 - 534
  • [18] An Appraisal to Optimize SQL Queries
    Myalapalli, Vamsi Krishna
    Shiva, Muddu Butchi
    2015 INTERNATIONAL CONFERENCE ON PERVASIVE COMPUTING (ICPC), 2015,
  • [19] Privacy preserving SQL queries
    Park, Hyun -A
    Zhan, Justin
    Lee, Dong Hoon
    PROCEEDINGS OF THE SECOND INTERNATIONAL CONFERENCE ON INFORMATION SECURITY AND ASSURANCE, 2008, : 549 - +
  • [20] Methodology of Transformation of Fuzzy Queries into Queries in the SQL Standard
    Nowakowski, Grzegorz
    PROCEEDINGS OF THE 2019 10TH IEEE INTERNATIONAL CONFERENCE ON INTELLIGENT DATA ACQUISITION AND ADVANCED COMPUTING SYSTEMS - TECHNOLOGY AND APPLICATIONS (IDAACS), VOL. 2, 2019, : 674 - 679