Analysis and Improvement of Optimizer for Query Processing on Graph Store

被引:9
|
作者
Yao, Youyang [1 ]
Li, Jiaqi [1 ]
Chen, Rong [1 ]
机构
[1] Shanghai Jiao Tong Univ, Shanghai Key Lab Scalable Comp & Syst, Inst Parallel & Distributed Syst, Shanghai, Peoples R China
基金
中国国家自然科学基金;
关键词
Optimizer; Type-centric Estimation; Graph Store; Query Processing;
D O I
10.1145/3265723.3265729
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
RDF systems are widely used to store public knowledge bases and process SPARQL queries. A large number of such systems have been proposed in the recent literature to provide low latency and high throughput for concurrent query processing over large RDF data. We perform an in-depth analysis on three key components (cardinality estimation, cost model, and plan enumeration) of the query optimizer to reveal the main issues and challenges on the accuracy and performance for traditional approaches. This calls for a rethink of how to build an accurate and fast query optimizer for modern RDF systems. We introduce a type-centric approach to enhance the accuracy of cardinality estimation prominently, which naturally embeds the lineage of correlated query conditions (triple patterns) into existing type system of RDF data. The preliminary results show that our approach greatly improves the accuracy of query optimization by several orders of magnitude compared to state-of-the-art approaches and provides a better overall performance by reducing execution time or optimization time.
引用
收藏
页数:8
相关论文
共 50 条
  • [1] Grid query optimizer to improve query processing in grids
    Liu, Shuo
    Karimi, Hassan A.
    FUTURE GENERATION COMPUTER SYSTEMS-THE INTERNATIONAL JOURNAL OF ESCIENCE, 2008, 24 (05): : 342 - 353
  • [2] A graph query language and its query processing
    Sheng, L
    Özsoyoglu, ZM
    Özsoyoglu, G
    15TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING, PROCEEDINGS, 1999, : 572 - 581
  • [3] Efficient Query Processing on Graph Databases
    Cheng, James
    Ke, Yiping
    Ng, Wilfred
    ACM TRANSACTIONS ON DATABASE SYSTEMS, 2009, 34 (01):
  • [4] Query-Driven Graph Processing
    Bonifati, Angela
    COMPANION PROCEEDINGS OF THE WEB CONFERENCE 2022, WWW 2022 COMPANION, 2022, : 311 - 312
  • [5] Q-Graph: Preserving Query Locality in Multi-Query Graph Processing
    Mayer, Christian
    Mayer, Ruben
    Grunert, Jonas
    Rothermel, Kurt
    Tariq, Muhammad Adnan
    GRADES-NDA '18: PROCEEDINGS OF THE 1ST ACM SIGMOD JOINT INTERNATIONAL WORKSHOP ON GRAPH DATA MANAGEMENT EXPERIENCES & SYSTEMS (GRADES) AND NETWORK DATA ANALYTICS (NDA) 2018 (GRADES-NDA 2018), 2018,
  • [6] Learned Optimizer for Online Approximate Query Processing in Data Exploration
    Liu, Liyuan
    Zhang, Hanbing
    Jing, Yinan
    He, Zhenying
    Zhang, Kai
    Wang, X. Sean
    IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2024, 36 (08) : 3977 - 3991
  • [7] Fast and Accurate Optimizer for Query Processing over Knowledge Graphs
    Wu, Jingqi
    Chen, Rong
    Xia, Yubin
    PROCEEDINGS OF THE 2021 ACM SYMPOSIUM ON CLOUD COMPUTING (SOCC '21), 2021, : 503 - 517
  • [8] Efficient parallel query processing by graph ranking
    Dereniowski, D
    Kubale, M
    FUNDAMENTA INFORMATICAE, 2006, 69 (03) : 273 - 285
  • [9] Efficient query processing on uncertain graph databases
    School of Computer Science and Technology, Harbin Institute of Technology, Harbin 150001, China
    Jisuanji Xuebao, 2009, 10 (2066-2079): : 2066 - 2079
  • [10] Design and Analysis of Stochastic Query Optimizer for Biobank Databases
    Sharma, Manik
    Singh, Gurvinder
    Singh, Rajinder
    Singh, Jasbir
    2015 15TH INTERNATIONAL CONFERENCE ON COMPUTATIONAL SCIENCE AND ITS APPLICATIONS (ICCSA), 2015, : 47 - 51