Chapter 10: Join Methods and Query Optimization

被引:0
|
作者
Braga, Daniele [1 ]
Ceri, Stefano [1 ]
Grossniklaus, Michael [1 ]
机构
[1] Politecn Milan, Dipartimento Elettron & Informat, I-20133 Milan, Italy
关键词
D O I
暂无
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
Joins between data sources are an essential ingredient of multidomain queries, as they exploit connection patterns defined between service marts or between service interfaces. This chapter moves from the definition of a query language over service interfaces, sketching how queries can be directly expressed over service marts and how these can be translated over service interfaces. The fundamental operation discussed in this chapter is the binary join between two sources, which is influenced by the type (search vs. exact) of services and by the management (parallel vs. sequential) of service calls. Then. this chapter presents an optimization framework for queries over several service interfaces, which considers several cost metrics for mapping queries into query plans, consisting of specific operations over services, and includes a branch and bound approach to the exploration of the combinatorial search space of all possible query plans.
引用
收藏
页码:188 / 210
页数:23
相关论文
共 50 条
  • [21] OPTIMIZATION OF METHODS IN A NAVIGATIONAL QUERY LANGUAGE
    JIAO, Z
    GRAY, PMD
    [J]. LECTURE NOTES IN COMPUTER SCIENCE, 1991, 566 : 22 - 42
  • [22] Optimal Ant and Join Cardinality for Distributed Query Optimization Using Ant Colony Optimization Algorithm
    Tiwari, Preeti
    Chande, Swati, V
    [J]. EMERGING TRENDS IN EXPERT APPLICATIONS AND SECURITY, 2019, 841 : 385 - 392
  • [23] Storing Join Relationships for Fast Join Query Processing
    Hamdi, Mohammed
    Yu, Feng
    Alswedani, Sarah
    Hou, Wen-Chi
    [J]. DATABASE AND EXPERT SYSTEMS APPLICATIONS, DEXA 2017, PT I, 2017, 10438 : 167 - 177
  • [24] Multi-Join Query Optimization in Distributed Database Based on Genetic Algorithm
    Zhu, Jing
    Du, Lin
    [J]. PROGRESS IN INTELLIGENCE COMPUTATION AND APPLICATIONS, 2008, : 188 - 190
  • [25] Graph-based cyclic multi-join query optimization algorithm
    Yu, H
    Wang, XK
    Zhang, JY
    [J]. ADVANCES IN WEB-AGE INFORMATION MANAGEMENT: PROCEEDINGS, 2004, 3129 : 745 - 750
  • [26] Multi-copy join query optimization of heterogeneous information integration systems
    Fang, Liying
    Yan, Jianzhuo
    Wang, Pu
    [J]. ADVANCING SCIENCE THROUGH COMPUTATION, 2008, : 339 - 343
  • [27] Improved Multi Join Query Optimization for RDBMS Based on Swarm Intelligence Approaches
    Al-Saedi, Ahmed Khalaf Zager
    Ghazali, Rozaida
    Deris, Mustafa Mat
    [J]. ADVANCED SCIENCE LETTERS, 2016, 22 (10) : 2847 - 2851
  • [28] Coral: federated query join order optimization based on deep reinforcement learning
    Gu, Rong
    Zhang, Yi
    Yin, Liangliang
    Song, Lingyi
    Huang, Wenjie
    Yuan, Chunfeng
    Wang, Zhaokang
    Zhu, Guanghui
    Huang, Yihua
    [J]. WORLD WIDE WEB-INTERNET AND WEB INFORMATION SYSTEMS, 2023, 26 (05): : 3093 - 3118
  • [29] Coral: federated query join order optimization based on deep reinforcement learning
    Rong Gu
    Yi Zhang
    Liangliang Yin
    Lingyi Song
    Wenjie Huang
    Chunfeng Yuan
    Zhaokang Wang
    Guanghui Zhu
    Yihua Huang
    [J]. World Wide Web, 2023, 26 : 3093 - 3118
  • [30] An Efficient Multi Join Query Optimization for DBMS Using Swarm Intelligent approach
    Al Saedi, Ahmed Khalaf Zager
    Ghazali, Rozaida Bt.
    Deris, Mustafa Bin Mat
    [J]. 2014 4TH WORLD CONGRESS ON INFORMATION AND COMMUNICATION TECHNOLOGIES (WICT), 2014, : 113 - 117