Performance and usability enhancements for continuous subgraph matching queries on graph-structured data

Choudhury, Sutanay; Chin, George; Agarwal, Khushbu; Beus, Sherman J.

Title: Performance and usability enhancements for continuous subgraph matching queries on graph-structured data

Patent · Tue Oct 20 00:00:00 EDT 2020

OSTI ID:1771538

Choudhury, Sutanay; Chin, George; Agarwal, Khushbu; Beus, Sherman J.

A query graph, which includes vertices and edges, represents a query on graph-structured data. The query graph is decomposed into query subgraphs. A network analysis tool performs continuous subgraph matching queries to facilitate analysis of computer network traffic, social media events, or other streams of data represented as a dynamic data graph (graph-structured data). This can help identify emerging trends in the data. Some features of the network analysis tool enhance performance by effectively utilizing distributed computing resources (including processing cores and memory at different nodes of a cluster) to speed up the process of updating the dynamic data graph and detecting matches of query subgraphs. Features of a query graph building tool enhance usability by providing intuitive ways to specify query graphs and their subgraphs. Features of a results visualization tool enhance usability by providing an intuitive way to present the results of continuous subgraph matching queries.

View Patent

Cite

Export

Save

Research Organization:: Pacific Northwest National Laboratory (PNNL), Richland, WA (United States)

Sponsoring Organization:: USDOE

DOE Contract Number:: AC05-76RL01830

Assignee:: Battelle Memorial Institute (Richland, WA)

Patent Number(s):: 10,810,210

Application Number:: 15/594,376

OSTI ID:: 1771538

Resource Relation:: Patent File Date: 05/12/2017

Country of Publication:: United States

Language:: English

References (64)

Safety guarantee of continuous join queries over punctuated data streams Chen, Songting; Li, Hua-Gang; Tatemura, Junichi https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/20070294217 US Patent Application 11/691640; 20070294217	patent-application	December 2007
Continuous pattern detection over billion-edge graph using distributed framework Gao, Jun; Zhou, Chang; Zhou, Jiashuai 2014 IEEE 30th International Conference on Data Engineering (ICDE) https://doi.org/10.1109/ICDE.2014.6816681	conference	March 2014
TALE: A Tool for Approximate Large Graph Matching Tian, Yuanyuan; Patel, Jignesh M. 2008 IEEE 24th International Conference on Data Engineering (ICDE 2008) https://doi.org/10.1109/ICDE.2008.4497505	conference	April 2008
Productivity and performance using partitioned global address space languages Yelick, Katherine; Husbands, Parry; Iancu, Costin Proceedings of the 2007 international workshop on Parallel symbolic computation - PASCO '07 https://doi.org/10.1145/1278177.1278183	conference	January 2007
gSketch: on query estimation in graph streams Zhao, Peixiang; Aggarwal, Charu C.; Wang, Min Proceedings of the VLDB Endowment, Vol. 5, Issue 3 https://doi.org/10.14778/2078331.2078335	journal	November 2011
A Model of Computation for MapReduce Karloff, Howard; Suri, Siddharth; Vassilvitskii, Sergei Proceedings of the Twenty-First Annual ACM-SIAM Symposium on Discrete Algorithms https://doi.org/10.1137/1.9781611973075.76	conference	December 2013
NiagaraCQ: a scalable continuous query system for Internet databases Chen, Jianjun; DeWitt, David J.; Tian, Feng ACM SIGMOD Record, Vol. 29, Issue 2 https://doi.org/10.1145/335191.335432	journal	June 2000
Mechanisms for searching enterprise data graphs Raghavan, Nikhil; Murthy, Ravi; Naimat, Aman https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/20130218899 US Patent Application 13/398794; 20130218899	patent-application	August 2013
Systems and methods to create continuous queries via a semantic layer Naibo, Alexis; Marinescu, Dan Cristian; Bolf, Didier https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/20100017379 US Patent Application 12/173979; 20100017379	patent-application	January 2010
TelegraphCQ: continuous dataflow processing Chandrasekaran, Sirish; Shah, Mehul A.; Cooper, Owen Proceedings of the 2003 ACM SIGMOD international conference on on Management of data - SIGMOD '03 https://doi.org/10.1145/872757.872857	conference	January 2003
EAGr: supporting continuous ego-centric aggregate queries over large dynamic graphs Mondal, Jayanta; Deshpande, Amol SIGMOD/PODS'14: International Conference on Management of Data, Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data https://doi.org/10.1145/2588555.2612182	conference	June 2014
Localized Visual Graph Filters for Complex Graph Queries Rossi, Ryan A.; Zhou, Rong https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/20170351406 US Patent Application 15/175751; 20170351406	patent-application	December 2017
An Algorithm for Subgraph Isomorphism Ullmann, J. R. Journal of the ACM, Vol. 23, Issue 1 https://doi.org/10.1145/321921.321925	journal	January 1976
Efficient Method for Subgraph Pattern Matching Kim, Jinha; Van Rset, Oskar; Hong, Sungpak https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/20170169133 US Patent Application 14/969789; 20170169133	patent-application
Interface providing continuous feedback on task progress in a computer operating system Ording, Bas https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/20010055017 US Patent Application 09/754052; 20010055017	patent-application	December 2001
Counting triangles and the curse of the last reducer Suri, Siddharth; Vassilvitskii, Sergei Proceedings of the 20th international conference on World wide web - WWW '11 https://doi.org/10.1145/1963405.1963491	conference	January 2011
Method and tool for network vulnerability analysis Swiler, Laura Painton; Phillips, Cynthia A. https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/7013395 US Patent Document 7,013,395	patent	March 2006
A (sub)graph isomorphism algorithm for matching large graphs Cordella, L. P.; Foggia, P.; Sansone, C. IEEE Transactions on Pattern Analysis and Machine Intelligence, Vol. 26, Issue 10 https://doi.org/10.1109/TPAMI.2004.75	journal	October 2004
A space efficient streaming algorithm for triangle counting using the birthday paradox Jha, Madhav; Seshadhri, C.; Pinar, Ali Proceedings of the 19th ACM SIGKDD international conference on Knowledge discovery and data mining - KDD '13 https://doi.org/10.1145/2487575.2487678	conference	January 2013
Predicting and detecting emerging cyberattack patterns using StreamWorks Chin, George; Choudhury, Sutanay; Feo, John Proceedings of the 9th Annual Cyber and Information Security Research Conference on - CISR '14 https://doi.org/10.1145/2602087.2602111	conference	January 2014
Scaling Irregular Applications through Data Aggregation and Software Multithreading Morari, Alessandro; Tumeo, Antonino; Chavarria-Miranda, Daniel 2014 IEEE International Parallel & Distributed Processing Symposium (IPDPS), 2014 IEEE 28th International Parallel and Distributed Processing Symposium https://doi.org/10.1109/IPDPS.2014.117	conference	May 2014
Incremental graph pattern matching Fan, Wenfei; Wang, Xin; Wu, Yinghui ACM Transactions on Database Systems, Vol. 38, Issue 3 https://doi.org/10.1145/2508020.2489791	journal	August 2013
CASQD: continuous detection of activity-based subgraph pattern queries on dynamic graphs Mondal, Jayanta; Deshpande, Amol DEBS '16: The 10th ACM International Conference on Distributed and Event-based Systems, Proceedings of the 10th ACM International Conference on Distributed and Event-based Systems https://doi.org/10.1145/2933267.2933316	conference	June 2016
Distributed Graph Databases that Facilitate Streaming Data Insertion and Queries by Efficient Throughput Edge Addition Chen, Chun-Fu; Crawford, JAson L.; Lin, Ching-Yung https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/20180039710 US Patent Application 15/230054; 20180039710	patent-application	February 2018
Predicate migration: optimizing queries with expensive predicates Hellerstein, Joseph M.; Stonebraker, Michael ACM SIGMOD Record, Vol. 22, Issue 2 https://doi.org/10.1145/170036.170078	journal	June 1993
Thirty Years of Graph Matching in Pattern Recognition Conte, D.; Foggia, P.; Sansone, C. International Journal of Pattern Recognition and Artificial Intelligence, Vol. 18, Issue 03 https://doi.org/10.1142/S0218001404003228	journal	May 2004
Efficient subgraph matching on billion node graphs Sun, Zhao; Wang, Hongzhi; Wang, Haixun Proceedings of the VLDB Endowment, Vol. 5, Issue 9 https://doi.org/10.14778/2311906.2311907	journal	May 2012
Parallel processing of continuous queries on data streams Jimenez Peris, Ricardo; Patino Martinez, Marta https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/20110314019 US Patent Application 13/112628; 20110314019	patent-application	December 2011
Appliance for accelerating graph database management and analytics systems Jacob, Arpith C.; Rivers, Jude A. https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/20140136555 US Patent Application 13/687751; 20140136555	patent-application	May 2014
Eldorado Feo, John; Harper, David; Kahan, Simon Proceedings of the 2nd conference on Computing frontiers - CF '05 https://doi.org/10.1145/1062261.1062268	conference	January 2005
Generating continuous query notifications Vemuri, Srinivas S.; Sinha, Bipul; Ganesh, Amit https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/20100036831 US Patent Application 12/189078; 20100036831	patent-application	February 2010
Aurora: a new model and architecture for data stream management Abadi, Daniel J.; Carney, Don; �etintemel, Ugur The VLDB Journal The International Journal on Very Large Data Bases, Vol. 12, Issue 2 https://doi.org/10.1007/s00778-003-0095-z	journal	August 2003
Neighborhood based fast graph search in large networks Khan, Arijit; Li, Nan; Yan, Xifeng Proceedings of the 2011 international conference on Management of data - SIGMOD '11 https://doi.org/10.1145/1989323.1989418	conference	January 2011
On graph query optimization in large networks Zhao, Peixiang; Han, Jiawei Proceedings of the VLDB Endowment, Vol. 3, Issue 1-2 https://doi.org/10.14778/1920841.1920887	journal	September 2010
Skip graphs Aspnes, James; Shah, Gauri ACM Transactions on Algorithms, Vol. 3, Issue 4 https://doi.org/10.1145/1290672.1290674	journal	November 2007
Incremental graph pattern matching Fan, Wenfei; Li, Jianzhong; Luo, Jizhou Proceedings of the 2011 international conference on Management of data - SIGMOD '11 https://doi.org/10.1145/1989323.1989420	conference	January 2011
Optimizing joins in a map-reduce environment Afrati, Foto N.; Ullman, Jeffrey D. Proceedings of the 13th International Conference on Extending Database Technology - EDBT '10 https://doi.org/10.1145/1739041.1739056	conference	January 2010
Scaling Semantic Graph Databases in Size and Performance Morari, Alessandro; Castellana, Vito Giovanni; Villa, Oreste IEEE Micro, Vol. 34, Issue 4 https://doi.org/10.1109/MM.2014.39	journal	July 2014
Turbo _iso: towards ultrafast and robust subgraph isomorphism search in large graph databases Han, Wook-Shin; Lee, Jinsoo; Lee, Jeong-Hoon Proceedings of the 2013 international conference on Management of data - SIGMOD '13 https://doi.org/10.1145/2463676.2465300	conference	January 2013
Continuous Subgraph Pattern Search over Certain and Uncertain Graph Streams Chen, Lei; Wang, Changliang IEEE Transactions on Knowledge and Data Engineering, Vol. 22, Issue 8 https://doi.org/10.1109/TKDE.2010.67	journal	August 2010
Massive scale cyber traffic analysis: a driver for graph database research Joslyn, Cliff; Choudhury, Sutanay; Haglin, David SIGMOD/PODS'13: International Conference on Management of Data, First International Workshop on Graph Data Management Experiences and Systems https://doi.org/10.1145/2484425.2484428	conference	June 2013
System and method for optimizing pattern query searches on a graph database Sargeant, Daniel; Hollinger, Morgan https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/20110119245 US Patent Application 12/950582; 20110119245	patent-application	May 2011
Method and system for behavior query construction in temporal graphs using discriminative sub-trace mining Li, Zhichun; Xiao, Xusheng; Wu, Zhenyu https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/20160125094 US Patent Application 14/932799; 20160125094	patent-application	May 2016
Streaming Algorithms for Robust, Real-Time Detection of DDoS Attacks Ganguly, Sumit; Garofalakis, Minos; Rastogi, Rajeev 27th International Conference on Distributed Computing Systems (ICDCS '07) https://doi.org/10.1109/ICDCS.2007.142	conference	June 2007
Skip lists: a probabilistic alternative to balanced trees Pugh, William Communications of the ACM, Vol. 33, Issue 6 https://doi.org/10.1145/78973.78977	journal	June 1990
Graph querying, graph motif mining and the discovery of clusters Singh, Ambuj Kumar; He, Huahai https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/7933915 US Patent Document 7,933,915	patent	April 2011
Fast search for dynamic multi-relational graphs Choudhury, Sutanay; Holder, Lawrence; Feo, John Proceedings of the Workshop on Dynamic Networks Management and Mining - DyNetMM '13 https://doi.org/10.1145/2489247.2489251	conference	January 2013
System, method, and computer program product for performing graph matching Cohen, Jonathan Michael; Castonguay, Patrice https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/20130297632 US Patent Application 13/462757; 20130297632	patent-application	November 2013
DOULION: counting triangles in massive graphs with a coin Tsourakakis, Charalampos E.; Kang, U.; Miller, Gary L. Proceedings of the 15th ACM SIGKDD international conference on Knowledge discovery and data mining - KDD '09 https://doi.org/10.1145/1557019.1557111	conference	January 2009
Publish and subscribe capable continuous query processor for real-time data streams Tsimelzon, Mark; Sanin, Aleksey; Motwani, Rajeev https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/7383253 US Patent Document 7,383,253	patent	June 2008
Graph Visualization Tools With Summary Visualization For Very Large Labeled Graphs Kindelsberger, Julia; Langerenken, Daniel; Schmid, Korbinian https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/20180137667 US Patent Application 15/469674; 20180137667	patent-application	May 2018
Change Monitoring Spanning Graph Queries Heen, Peter Dahle; Eidesen, DAg Steinnes; Johansen, Amund Kronen https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/20180121482 US Patent Application 15/338290; 20180121482	patent-application	May 2018
Accelerating semantic graph databases on commodity clusters Morari, Alessandro; Castellana, Vito Giovanni; Haglin, David 2013 IEEE International Conference on Big Data https://doi.org/10.1109/BigData.2013.6691650	conference	October 2013
StreamWorks: a system for dynamic graph search Choudhury, Sutanay; Holder, Lawrence; Chin, George Proceedings of the 2013 international conference on Management of data - SIGMOD '13 https://doi.org/10.1145/2463676.2463697	conference	January 2013
Enabling Real-Time Querying of Live and Historical Stream Data Reiss, Frederick; Stockinger, Kurt; Wu, Kesheng 19th International Conference on Scientific and Statistical Database Management (SSDBM 2007) https://doi.org/10.1109/SSDBM.2007.34	conference	July 2007
Matching a Building Automation Algorithm to a Building Automation System Dibowski, Henrik; Holub, Ondrej; Rojicek, Jiri https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/20170308045 US Patent Application 15/134787; 20170308045	patent-application	October 2017
Addition and processing of continuous SQL queries in a streaming relational database management system Krishnamurthy, Saileshwar; Thombre, Neil; Conway, Neil https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/20090228434 US Patent Application 12/398944; 20090228434	patent-application	September 2009
System and Method for Graph Pattern Analysis Patil, Dhanurjay A. S.; Jastrebski, Grahame Andrew; Miller, Allison E. https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/20160125300 US Patent Application 14/994519; 20160125300	patent-application	May 2016
Search around visual queries Potter, Jordan; Ackner, Nir; Cohen, David https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/20140074888 US Patent Application 13/608864; 20140074888	patent-application	March 2014
Fast best-effort pattern matching in large attributed graphs Tong, Hanghang; Faloutsos, Christos; Gallagher, Brian Proceedings of the 13th ACM SIGKDD international conference on Knowledge discovery and data mining - KDD '07 https://doi.org/10.1145/1281192.1281271	conference	January 2007
Parasol: An Architecture for Cross-Cloud Federated Graph Querying Lieberman, Michael D.; Choudhury, Sutanay; Hughes, Marisa Proceedings of Workshop on Data analytics in the Cloud - DanaC'14 https://doi.org/10.1145/2627770.2627771	conference	January 2014
Intelligent intrusion detection system utilizing enhanced graph-matching of network activity with context data Coffman, Thayne Richard https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/20070209074 US Patent Application 11/367943; 20070209074	patent-application	September 2007
Apparatuses, systems, and methods for efficient graph pattern matching and querying Charboneau, David P. https://doi.org/https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/8533182 US Patent Document 8,533,182	patent	September 2013
Streaming graph partitioning for large distributed graphs Stanton, Isabelle; Kliot, Gabriel Proceedings of the 18th ACM SIGKDD international conference on Knowledge discovery and data mining - KDD '12 https://doi.org/10.1145/2339530.2339722	conference	January 2012

Similar Records

Large-Scale Continuous Subgraph Queries on Streams

Conference · Wed Nov 30 00:00:00 EST 2011 · OSTI ID:1771538

Choudhury, Sutanay; Holder, Larry; Chin, George; +1 more

QLiG: Query Like a Graph For Subgraph Matching

Conference · Fri Dec 31 00:00:00 EST 2021 · OSTI ID:1771538

Purohit, Sumit; Mackey, Patrick S.; Zucker, Jeremy D.; +3 more

Scalable Pattern Matching in Metadata Graphs via Constraint Checking

Journal Article · Mon Jan 04 00:00:00 EST 2021 · ACM Transactions on Parallel Computing · OSTI ID:1771538

Reza, Tahsin; Halawa, Hassan; Ripeanu, Matei; +2 more

Title: Performance and usability enhancements for continuous subgraph matching queries on graph-structured data

Citation Formats

References (64)

Similar Records

Related Subjects