Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
skip to main content
10.1145/3183713.3196902acmconferencesArticle/Chapter ViewAbstractPublication PagesmodConference Proceedingsconference-collections
research-article

BOOMER: Blending Visual Formulation and Processing of P -Homomorphic Queries on Large Networks

Published: 27 May 2018 Publication History

Abstract

Visual graph query interfaces (a.k.a GUI) make it easy for non-expert users to query graphs. Recent research has laid out and implemented a vision of a novel subgraph query processing paradigm where the latency offered by the GUI is exploited to blend visual query construction and processing by generating and refining candidate result matches iteratively during query formulation. This paradigm brings in several potential benefits such as superior system response time (srt) and opportunities to enhance usability of graph databases. However, these early efforts focused on subgraph isomorphism-based graph queries where blending is performed by iterative edge-to-edge mapping. In this paper, we explore how this vision can be realized for more generic but complex 1-1 p-homomorphic p-hom) queries introduced by Fan et al. A 1-1 p-hom query maps an edge of the query to paths in the data graph. We present a novel framework called BOOMER for blending bounded 1-1 p-hom (bph ) queries, a variant of 1-1 p-hom where the length of the path is bounded instead of arbitrary length. Our framework is based on a novel online, adaptive indexing scheme called cap index. We present two strategies for CAP index construction, immediate and deferment-based, and show how they can be utilized to facilitate judicious interleaving of visual bph query formulation and query processing. BOOMER is also amenable to modifications to a bph query during visual formulation. Experiments on real-world datasets demonstrate both efficiency and effectiveness of Boomer for realizing the visual querying paradigm on an important type of graph query.

References

[1]
T. Akiba, Y. Iwata, Y. Yoshida. Fast exact shortest-path distance queries on large networks by pruned landmark labeling. In SIGMOD, 2013.
[2]
S. S. Bhowmick, B. Choi, C. Li. Graph Querying Meets HCI: State of the Art and Future Directions. In SIGMOD, 2017.
[3]
S.S. Bhowmick, H.-E. Chua, B. Choi, C. Dyreson. textscViSual: Simulation of Visual Subgraph Query Formulation To Enable Automated Performance Benchmarking. In TKDE, 29(8), 2017.
[4]
F. Bi, L. Chang, X. Lin, L. Q, W. Zhang. Efficient subgraph matching by postponing cartesian products. In SIGMOD, 2016.
[5]
A. Bonifati, W. Martens, T. Timm. An Analytical Study of Large SPARQL Query Logs. In VLDB, 2017.
[6]
N. Buchan and R. Croson. The boundaries of trust: own and others actions in the US and china. Journal of Economic Behavior and Organization, 55(4):485--504, 2004.
[7]
D.H. Chau, C. Faloutsos, H. Tong, J.I. Hong, B. Gallagher, T. Eliassi-Rad. GRAPHITE: A visual query system for large graphs. ICDM Workshop, 2008.
[8]
R.Cohen, S. Havlin. Scale free networks are ultrasmall. Phys.Rev. Lett. 90, 2003.
[9]
C.V. Dang, E.P. Reddy, K.M. Shokat, L. Soucek. Drugging the `Undruggable' Cancer Targets. Nat. Rev. Cancer, 17:502--508, 2017.
[10]
C. Demetrescu, D. Eppstein, Z. Galil, G. F. Italiano. Dynamic Graph Algorithms. In Algorithms and theory of computation handbook. Chapman &Hall/CRC, 2010.
[11]
W. Fan, C. Hu, C. Tian. Incremental Graph Computations: Doable and Undoable. In SIGMOD, 2017.
[12]
W. Fan, X. Wang, Y. Wu. Incremental Graph Pattern Matching. TODS, 38(3), 2013.
[13]
W. Fan, J. Li, S. Ma, H. Wang, Y. Wu. Graph homomorphism revisited for graph matching. In VLDB, 2010.
[14]
W. Fan, J. Li, S. Ma, N. Tang, Y. Wu, Y. Wu. Graph pattern matching: from intractable to polynomial time. In VLDB, 2010.
[15]
W. Fan, J. Li, S. Ma, N. Tang, Y. Wu. Adding regular expressions to graph reachability and pattern queries. In ICDE, 2011.
[16]
L. Laura Faulkner. Beyond the five-user assumption: Benefits of increased sample sizes in usability testing. Behavior Research Methods, Instruments, &Computers, 35(3), 2003.
[17]
F. Haag, S. Lohmann, S. Bold, T. Ertl. Visual SPARQL Querying based on Extended Filter/flow Graphs. In AVI, 2014.
[18]
W.-S. Han, J. Lee, J.-H. Lee. TurboISO: towards ultrafast and robust subgraph isomorphism search in large graph databases. In SIGMOD, 2013.
[19]
K. Huang, S. S. Bhowmick, S. Zhou, B. Choi.PICASSO: Exploratory Search of Connected Subgraph Substructures in Graph Databases. PVLDB, 10(12): 1861--1864, 2017.
[20]
H. H. Hung, S. S. Bhowmick, B. Q. Truong, B. Choi, S. Zhou.QUBLE: Towards Blending Interactive Visual Subgraph Search Queries on Large Networks. VLDB J. 23(3), 2014.
[21]
C. Jin, S. S. Bhowmick, X. Xiao, J. Cheng, and B. Choi. Gblender: towards blending visual query formulation and query processing in graph databases. In ACM SIGMOD, 2010.
[22]
C. Jin, S. S. Bhowmick, B. Choi, S. Zhou. textscprague: A Practical Framework for Blending Visual Subgraph Query Formulation and Query Processing. In ICDE, 2012.
[23]
J. Lazar, J. H. Feng, H. Hochheiser. Research Methods in Human-Computer Interaction. John Wiley &Sons, 2010.
[24]
R. Pienta, A. Tamersoy, A. Endert, S. Navathe, H. Tong, D. H.Chau. VISAGE: Interactive Visual Graph Querying. In AVI, 2016.
[25]
R. Pienta, F. Hohman, A. Tamersoy, A. Endert, S. B. Navathe, H. Tong, D. H. Chau.Visual Graph Query Construction and Refinement. In SIGMOD, 2017.
[26]
R.L. Perlman. Mouse Models of Human Disease: An Evolutionary Perspective. Evol. Med. Public Health 2016(1):170--176, 2016.
[27]
D.D. Shaye, I. Greenwald. OrthoList: a compendium of C. elegans genes with human orthologs. PloS one 6(5):e20085, 2011.
[28]
B, Schröder. Ordered Sets: An Introduction with Connections from Combinatorics to Topology. Springer International Publishing, 2016.
[29]
Y. Song, H. E. Chua, S. S. Bhowmick, B. Choi, S. Zhou. BOOMER: Blending Visual Formulation and Processing of P -Homomorphic Queries on Large Networks. Technical Report, 2017. Available at http://www.ntu.edu.sg/home/assourav/TechReports/boomer-TR.pdf.
[30]
F.W. Takes and W.A. Kosters. Determining the diameter of small world networks. In CIKM, 2011.
[31]
C. Ware, P. Mitchell. Visualizing Graphs in Three Dimensions. ACM Transactions on Applied Perception (TAP), 5(1), 2008.
[32]
S. Yang, Y. Xie, Y. Wu, T. Wu, H. Sun, J. Wu, X. Yan. SLQ: A User-friendly Graph Querying System. In SIGMOD, 2014.
[33]
M.A. Yldrm, K.I. Goh, M.E. Cusick, A.L. Barabási, M. Vidal. Drug-target Network. Nat. Biotechnol., 25(10):1119--1126, 2007.
[34]
H. Yu, N.M. Luscombe, H.X. Lu, X. Zhu, Y. Xia, J.D.J. Han, N. Bertin, S. Chung, M. Vidal, M. Gerstein. Annotation transfer between genomes: protein-protein interologs and protein-DNA regulogs. Genome Res., 14(6):1107--1118, 2004.
[35]
X. Zhang, L. Chen, M. Wang. Efficient parallel processing of distance join queries over distributed graphs. TKDE, 27(3): 740--754, 2015.
[36]
P. Zhao, J. Han. On graph query optimization in large networks. In VLDB, 2010.
[37]
G. Zhu, X. Lin, K. Zhu et al. TreeSpan: Efficiently Computing Similarity All-Matching. In SIGMOD, 2012.
[38]
L. Zou, L. Chen, M.T. Özsu. Distance-join: Pattern match query in a large graph database. In VLDB, 2009.

Cited By

View all
  • (2023)A Framework for Privacy Preserving Localized Graph Pattern Query ProcessingProceedings of the ACM on Management of Data10.1145/35892741:2(1-27)Online publication date: 20-Jun-2023
  • (2023)The Future is Democratized GraphsPlug-and-Play Visual Subgraph Query Interfaces10.1007/978-3-031-16162-9_1(1-14)Online publication date: 14-Mar-2023
  • (2022)Answering Why-Questions for Subgraph QueriesIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2020.304643634:10(4636-4649)Online publication date: 1-Oct-2022
  • Show More Cited By

Index Terms

  1. BOOMER: Blending Visual Formulation and Processing of P -Homomorphic Queries on Large Networks

    Recommendations

    Comments

    Information & Contributors

    Information

    Published In

    cover image ACM Conferences
    SIGMOD '18: Proceedings of the 2018 International Conference on Management of Data
    May 2018
    1874 pages
    ISBN:9781450347037
    DOI:10.1145/3183713
    Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

    Sponsors

    Publisher

    Association for Computing Machinery

    New York, NY, United States

    Publication History

    Published: 27 May 2018

    Permissions

    Request permissions for this article.

    Check for updates

    Author Tags

    1. adaptive index
    2. blender
    3. deferment-based evaluation
    4. immediate evaluation
    5. large networks
    6. p-homomorphic query
    7. visual graph query interface

    Qualifiers

    • Research-article

    Funding Sources

    • National Natural Science Foundation of China (NSFC)
    • Singapore-MOE
    • HK-RGC General Research Funds (GRFs)

    Conference

    SIGMOD/PODS '18
    Sponsor:

    Acceptance Rates

    SIGMOD '18 Paper Acceptance Rate 90 of 461 submissions, 20%;
    Overall Acceptance Rate 785 of 4,003 submissions, 20%

    Contributors

    Other Metrics

    Bibliometrics & Citations

    Bibliometrics

    Article Metrics

    • Downloads (Last 12 months)12
    • Downloads (Last 6 weeks)1
    Reflects downloads up to 30 Aug 2024

    Other Metrics

    Citations

    Cited By

    View all
    • (2023)A Framework for Privacy Preserving Localized Graph Pattern Query ProcessingProceedings of the ACM on Management of Data10.1145/35892741:2(1-27)Online publication date: 20-Jun-2023
    • (2023)The Future is Democratized GraphsPlug-and-Play Visual Subgraph Query Interfaces10.1007/978-3-031-16162-9_1(1-14)Online publication date: 14-Mar-2023
    • (2022)Answering Why-Questions for Subgraph QueriesIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2020.304643634:10(4636-4649)Online publication date: 1-Oct-2022
    • (2022)Data Exploration Using Example-Based MethodsundefinedOnline publication date: 25-Feb-2022
    • (2022)Human Interaction with GraphsundefinedOnline publication date: 25-Feb-2022
    • (2020)FERRARI: an efficient framework for visual exploratory subgraph search in graph databasesThe VLDB Journal10.1007/s00778-020-00601-029:5(973-998)Online publication date: 30-Jan-2020
    • (2019)Answering Why-questions by Exemplars in Attributed GraphsProceedings of the 2019 International Conference on Management of Data10.1145/3299869.3319890(1481-1498)Online publication date: 25-Jun-2019
    • (2019)Answering Why-Questions for Subgraph Queries in Multi-attributed Graphs2019 IEEE 35th International Conference on Data Engineering (ICDE)10.1109/ICDE.2019.00013(40-51)Online publication date: Apr-2019
    • (2018)Data Exploration Using Example-Based MethodsSynthesis Lectures on Data Management10.2200/S00881ED1V01Y201810DTM05310:4(1-164)Online publication date: 27-Nov-2018
    • (2018)Human Interaction with Graphs: A Visual Querying PerspectiveSynthesis Lectures on Data Management10.2200/S00855ED1V01Y201805DTM04710:2(1-208)Online publication date: 8-Aug-2018
    • Show More Cited By

    View Options

    Get Access

    Login options

    View options

    PDF

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader

    Media

    Figures

    Other

    Tables

    Share

    Share

    Share this Publication link

    Share on social media