SQL4X: A flexible query language for XML and relational databases

被引:0
作者
Cohen, S [1 ]
Kanza, Y [1 ]
Sagiv, Y [1 ]
机构
[1] Hebrew Univ Jerusalem, Inst Comp Sci, IL-91904 Jerusalem, Israel
来源
DATABASE PROGRAMMING LANGUAGES | 2002年 / 2397卷
关键词
D O I
暂无
中图分类号
TP18 [人工智能理论];
学科分类号
081104 ; 0812 ; 0835 ; 1405 ;
摘要
SQL4X, a powerful language for simultaneously querying both relational and XML databases is presented. Using SQL4X, one can create both relations and XML documents as query results. Thus, SQL4X can be thought of as an integration language. In order to allow easy integration of XML documents with varied structures, SQL4X uses flexible semantics when querying XML. SQL4X is also a powerful query language. It can express quantification, negation, aggregation, grouping and path expressions. Datalog(4x) and Tree-Datalog(4x), extensions of Datalog, are defined as elegant abstract models for SQL4X queries. Query containment is characterized for many common classes of SQL4X queries. Specifically, for Datalog(4x) queries, a complete characterization of containment of conjunctive queries and of unions of queries is presented. Equivalence of Datalog(4x) queries under bag-set semantics is also characterized. A sufficient condition for containment of Tree-Datalog(4x) queries is presented. This condition is shown to be complete for a large class of common queries..
引用
收藏
页码:263 / 280
页数:18
相关论文
共 31 条
  • [21] An Algorithm for Solving Natural Language Query Execution Problems on Relational Databases
    Enikuomehin, A. O.
    Okwufulueze, D. O.
    INTERNATIONAL JOURNAL OF ADVANCED COMPUTER SCIENCE AND APPLICATIONS, 2012, 3 (10) : 169 - 175
  • [22] Knowledge-based system and an ER query language for accessing relational databases
    Lagrange, J.-P.
    Proceedings of the International Conference on the Entity-Relationship Approach, 1991,
  • [23] Implementation of fuzzy classification query language in relational databases using stored procedures
    Veryha, Y
    ENTERPRISE INFORMATION SYSTEMS IV, 2002, : 90 - 97
  • [24] sql-schema-comparer: Support of Multi-Language Refactoring with Relational Databases
    Schink, Hagen
    2013 IEEE 13TH INTERNATIONAL WORKING CONFERENCE ON SOURCE CODE ANALYSIS AND MANIPULATION (SCAM), 2013, : 173 - 178
  • [25] Information Extraction for SQL Query Generation in the Conversation-Based Interfaces to Relational Databases (C-BIRD)
    Owda, Majdi
    Bandar, Zuhair
    Crockett, Keeley
    AGENT AND MULTI-AGENT SYSTEMS: TECHNOLOGIES AND APPLICATIONS, 2011, 6682 : 44 - 53
  • [26] Relational-like Query Language for Archetypes in Standardized Electronic Health Records Databases
    Sachdeva, Shelly
    Chu, Wanming
    Bhalla, Subhash
    PROCEEDINGS OF THE 6TH ACM IKDD CODS AND 24TH COMAD, 2019, : 272 - 275
  • [27] CNL-RDF-Query: A controlled natural language interface for querying ontologies and relational databases
    Henarejos-Blasco, Jose
    Antonio Garcia-Diaz, Jose
    Apolinario-Arzube, Oscar
    Valencia-Garcia, Rafael
    PROCEEDINGS OF THE 10TH EURO-AMERICAN CONFERENCE ON TELEMATICS AND INFORMATION SYSTEMS (EATIS 2020), 2020,
  • [28] Extension mechanism in extensible XML query language X2 QL
    Shinagawa, N
    Kitagawa, H
    SECOND INTERNATIONAL CONFERENCE ON WEB INFORMATION SYSTEMS ENGINEERING, VOL I, PROCEEDINGS, 2002, : 183 - 192
  • [29] Flexible modification of relational schema by X2RMap in storing XML into relations
    Kim, J
    Park, S
    EURASIA-ICT 2002: INFORMATION AND COMMUNICATION TECHNOLOGY, PROCEEDINGS, 2002, 2510 : 330 - 338
  • [30] Improving the Accuracy of Text-to-SQL Tools Based on Large Language Models for Real-World Relational Databases
    Coelho, Gustavo M. C.
    Nascimento, Eduardo R. S.
    Izquierdo, Yenier T.
    Garcia, Grettel M.
    Feijo, Lucas
    Lemos, Melissa
    Garcia, Robinson L. S.
    de Oliveira, Aiko R.
    Pinheiro, Joao P.
    Casanova, Marco A.
    DATABASE AND EXPERT SYSTEMS APPLICATIONS, PT I, DEXA 2024, 2024, 14910 : 93 - 107