Query Optimization of Distributed Pattern Matching

被引:0
|
作者
Huang, Jiewen [1 ]
Venkatraman, Kartik [1 ]
Abadi, Daniel J. [1 ]
机构
[1] Yale Univ, New Haven, CT 06520 USA
关键词
D O I
暂无
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
Greedy algorithms for subgraph pattern matching operations are often sufficient when the graph data set can be held in memory on a single machine. However, as graph data sets increasingly expand and require external storage and partitioning across a cluster of machines, more sophisticated query optimization techniques become critical to avoid explosions in query latency. In this paper, we introduce several query optimization techniques for distributed graph pattern matching. These techniques include (1) a System-R style dynamic programming-based optimization algorithm that considers both linear and bushy plans, (2) a cycle detection-based algorithm that leverages cycles to reduce intermediate result set sizes, and (3) a computation reusing technique that eliminates redundant query execution and data transfer over the network. Experimental results show that these algorithms can lead to an order of magnitude improvement in query performance.
引用
收藏
页码:64 / 75
页数:12
相关论文
共 50 条
  • [1] Distributed query optimization by query trading
    Pentaris, F
    Ioannidis, Y
    [J]. ADVANCES IN DATABASE TECHNOLOGY - EDBT 2004, PROCEEDINGS, 2004, 2992 : 532 - 550
  • [2] A distributed hierarchical genetic algorithm for efficient optimization and pattern matching
    Garai, Gautam
    Chaudhuri, B. B.
    [J]. PATTERN RECOGNITION, 2007, 40 (01) : 212 - 228
  • [3] On the complexity of distributed query optimization
    Wang, CP
    Chen, MS
    [J]. IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 1996, 8 (04) : 650 - 662
  • [4] STRATEGIES FOR DISTRIBUTED QUERY OPTIMIZATION
    SEGEV, A
    [J]. INFORMATION SCIENCES, 1991, 54 (1-2) : 67 - 88
  • [5] SWMQ: Secure wildcard pattern matching with query
    Xu, Lin
    Wei, Xiaochao
    Cai, Guopeng
    Li, Yao
    Wang, Hao
    [J]. INTERNATIONAL JOURNAL OF INTELLIGENT SYSTEMS, 2022, 37 (09) : 6262 - 6282
  • [6] STOCHASTIC QUERY OPTIMIZATION IN DISTRIBUTED DATABASES
    DRENICK, PE
    SMITH, EJ
    [J]. ACM TRANSACTIONS ON DATABASE SYSTEMS, 1993, 18 (02): : 262 - 288
  • [7] Study on Query Optimization of Distributed Database
    Yao, Meng
    [J]. MODERN TENDENCIES IN ENGINEERING SCIENCES, 2014, 533 : 448 - 451
  • [8] A PERF solution for distributed query optimization
    Haraty, RA
    Fany, R
    [J]. COMPUTERS AND THEIR APPLICATIONS, 2000, : 150 - 153
  • [9] Query Optimization in Distributed Relational Databases
    Ribeiro C.C.
    Ribeiro C.D.
    Lanzelotte R.S.G.
    [J]. Journal of Heuristics, 1997, 3 (1) : 5 - 23
  • [10] SEMANTIC QUERY OPTIMIZATION IN DISTRIBUTED DATABASES
    VANKUIJK, HJA
    PIJPERS, FHE
    APERS, PMG
    [J]. LECTURE NOTES IN COMPUTER SCIENCE, 1990, 468 : 295 - 303