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 条
  • [21] A system to transform natural language queries into SQL queries
    Solanki A.
    Kumar A.
    International Journal of Information Technology, 2022, 14 (1) : 437 - 446
  • [22] Auditing a batch of SQL queries
    Motwani, Rajeev
    Nabar, Shubha U.
    Thomas, Dilys
    2007 IEEE 23RD INTERNATIONAL CONFERENCE ON DATA ENGINEERING WORKSHOP, VOLS 1-2, 2007, : 186 - 191
  • [23] Fuzzy XML queries via context-based choice of aggregations
    Damiani, E
    Tanca, L
    Fontana, FA
    KYBERNETIKA, 2000, 36 (06) : 635 - 655
  • [24] Translating natural language questions to SQL queries (nested queries)
    Swamidorai, Sindhuja
    Murthy, T. Satyanarayana
    Sriharsha, K., V
    MULTIMEDIA TOOLS AND APPLICATIONS, 2023, 83 (15) : 45391 - 45405
  • [25] Reformulation of XML queries and constraints
    Deutsch, A
    Tannen, V
    DATABASE THEORY ICDT 2003, PROCEEDINGS, 2003, 2572 : 225 - 241
  • [26] S2CX: From relational data via SQL/XML to (Un-)Compressed XML
    Boettcher, Stefan
    Hartel, Rita
    Wolters, Dennis
    INFORMATION SYSTEMS, 2016, 56 : 198 - 213
  • [27] Certain Answers for XML Queries
    David, Claire
    Libkin, Leonid
    Murlak, Filip
    PODS 2010: PROCEEDINGS OF THE TWENTY-NINTH ACM SIGMOD-SIGACT-SIGART SYMPOSIUM ON PRINCIPLES OF DATABASE SYSTEMS, 2010, : 191 - 202
  • [28] Insert Queries in XML Database
    Vidhya, P. M.
    Samuel, Philip
    PROCEEDINGS 2010 3RD IEEE INTERNATIONAL CONFERENCE ON COMPUTER SCIENCE AND INFORMATION TECHNOLOGY, (ICCSIT 2010), VOL 1, 2010, : 9 - 13
  • [29] Translating natural language questions to SQL queries (nested queries)
    Sindhuja Swamidorai
    T Satyanarayana Murthy
    K V Sriharsha
    Multimedia Tools and Applications, 2024, 83 : 45391 - 45405
  • [30] Evolving SQL queries for data mining
    Salim, M
    Yao, X
    INTELLIGENT DATA ENGINEERING AND AUTOMATED LEARNING - IDEAL 2002, 2002, 2412 : 62 - 67