skip to main content
10.1145/2588555.2612182acmconferencesArticle/Chapter ViewAbstractPublication PagesmodConference Proceedingsconference-collections
research-article

EAGr: supporting continuous ego-centric aggregate queries over large dynamic graphs

Published: 18 June 2014 Publication History

Abstract

In this paper, we present EAGr, a system for supporting large numbers of continuous neighborhood-based ("ego-centric") aggregate queries over large, highly dynamic, rapidly evolving graphs. Examples of such queries include computation of personalized, tailored trends in social networks, anomaly or event detection in communication or financial transaction networks, local search and alerts in spatio-temporal networks, to name a few. Key challenges in supporting such continuous queries include very high update rates typically seen in these situations, large numbers of queries that need to be executed simultaneously, stringent low latency requirements. In this paper, we propose a flexible, general, extensible in-memory framework for executing different types of ego-centric aggregate queries over large dynamic graphs with low latencies. Our framework is built around the notion of an aggregation overlay graph, a pre-compiled data structure that encodes the computations to be performed when an update or a query is received. The overlay graph enables sharing of partial aggregates across different ego centric queries (corresponding to different nodes in the graph), also allows partial pre-computation of the aggregates to minimize the query latencies. We present several highly scalable techniques for constructing an overlay graph given an aggregation function, also design incremental algorithms for handling changes to the structure of the underlying graph itself, that may result in significant changes to the neighborhoods on which queries are posed. We also present an optimal, polynomial-time algorithm for making the pre-computation decisions given an overlay graph. Although our approach is naturally parallelizable, we focus on a single-machine deployment in this paper and show that our techniques can easily handle graphs of size up to 320 million nodes and edges, achieve update and query throughputs of over 500,000/s using a single, powerful machine.

References

[1]
F. Abel, Q. Gao, G.-J. Houben, and K. Tao. Analyzing user modeling on twitter for personalized news recommendations. In UMAP. 2011.
[2]
L. Akoglu, M. McGlohon, and C. Faloutsos. Oddball: Spotting anomalies in weighted graphs. In KDD. Springer, 2010.
[3]
L. Al Moakar. Class-Based Continuous Query Scheduling in Data Stream Management Systems. PhD thesis, Univ. of Pittsburgh, 2013.
[4]
D. Anicic, P. Fodor, S. Rudolph, N. Stojanovic. EP-SPARQL: a unified language for event processing and stream reasoning. WWW, 2011.
[5]
A. Arasu, S. Babu, and J. Widom. The CQL continuous query language: semantic foundations and query execution. VLDB, 2006.
[6]
A. Arasu and J. Widom. Resource sharing in continuous sliding-window aggregates. In VLDB, 2004.
[7]
B. Babcock, M. Datar, and R. Motwani. Load Shedding for Aggregation Queries over Data Streams. In ICDE, 2004.
[8]
D. F. Barbieri, D. Braga, S. Ceri, and M. Grossniklaus. An execution environment for C-SPARQL queries. In EDBT, 2010.
[9]
L. Breslau, P. Cao, L. Fan, G. Phillips, S. Shenker. Web caching and Zipf-like distributions: Evidence and implications. INFOCOM, 1999.
[10]
G. Buehrer and K. Chellapilla. A scalable pattern mining approach to web graph compression with communities. In WSDM, 2008.
[11]
Z. Cai, D. Logothetis, and G. Siganos. Facilitating real-time graph mining. In CloudDB, 2012.
[12]
R. Cheng et al. %, J. Hong, A. Kyrola, Y. Miao, X. Weng, M. Wu, F. Yang, L. Zhou, F. Zhao, and E. Chen. Kineograph: taking the pulse of a fast-changing and connected world. In EUROSYS, 2012.
[13]
F. Chierichetti, R. Kumar, S. Lattanzi, M. Mitzenmacher, A. Pan- conesi, P. Raghavan. On compressing social networks. SIGKDD, 2009.
[14]
E. Cohen et al. %, M. Datar, S. Fujiwara, A. Gionis, P. Indyk, R. Motwani, J. D. Ullman, and C. Yang. Finding Interesting Associations without Support Pruning. In ICDE, 2000.
[15]
M. Everett and S. Borgatti. Ego network betweenness. Social networks, 2005.
[16]
T. Feder and R. Motwani. Clique partitions, graph compression and speeding-up algorithms. In STOC, 1991.
[17]
I. Guy, N. Zwerdling, I. Ronen, D. Carmel, and E. Uziel. Social media recommendation based on people and tags. In SIGIR, 2010.
[18]
J. Han, J. Pei, and Y. Yin. Mining frequent patterns without candidate generation. In SIGMOD, 2000.
[19]
%J. M. Hellerstein, C. Ré, F. Schoppmann, D. Z. Wang, E. Fratkin, A. Gorajek, K. S. Ng, C. Welton, X. Feng, K. Li, et al.J. M. Hellerstein et al. The MADlib analytics library: or MAD skills, the SQL. VLDB, 2012.
[20]
A. Inokuchi, T. Washio, and H. Motoda. An Apriori-Based Algorithm for Mining Frequent Substructures from Graph Data. In PKDD, 2000.
[21]
J. M. Kleinberg, S. Suri, E. Tardos, and T. Wexler. Strategic network formation with structural holes. SIGecom, 2008.
[22]
S. Krishnamurthy, C. Wu, and M. J. Franklin. On-the-fly sharing for streamed aggregation. In SIGMOD, 2006.
[23]
X. Liu, J. Li, and L. Wang. Quasi-bicliques: Complexity and binding pairs. In Computing and Combinatorics. Springer, 2008.
[24]
S. Madden, M. J. Franklin, J. M. Hellerstein, W. Hong. TAG: a Tiny Aggregation service for Ad-Hoc sensor networks. In OSDI, 2002.
[25]
J. J. McAuley and J. Leskovec. Learning to discover social circles in ego networks. In NIPS, 2012.
[26]
J. Mondal and A. Deshapnde. EAGr: Supporting Continuous Ego-centric Aggregate Queries over Large Dynamic Graphs. arXiv preprint arXiv:1404.6570, 2014.
[27]
J. Mondal and A. Deshpande. Managing large dynamic graphs efficiently. In SIGMOD, 2012.
[28]
W. E. Moustafa, A. Deshpande, and L. Getoor. Ego-centric graph pattern census. In ICDE, 2012.
[29]
B. A. Prakash et al. %, N. Valler, D. Andersen, M. Faloutsos, and C. Faloutsos. BGP-Lens: Patterns and anomalies in internet routing updates. In SIGKDD, 2009.
[30]
A. Silberstein, J. Terrace, B. F. Cooper, R. Ramakrishnan. Feeding frenzy: selectively materializing users' event feeds. SIGMOD, 2010.
[31]
A. Silberstein and J. Yang. Many-to-Many Aggregation for Sensor Networks. In ICDE, 2007.
[32]
N. Trigoni, Y. Yao, A. J. Demers, J. Gehrke, and R. Rajaraman. Multi-query Optimization for Sensor Networks. In DCOSS, 2005.
[33]
C. Wang and L. Chen. Continuous subgraph pattern search over graph streams. In ICDE, 2009.
[34]
O. Wolfson, S. Jajodia, and Y. Huang. An adaptive data replication algorithm. TODS, 1997.
[35]
X. Yan, B. He, F. Zhu, and J. Han. Top-K aggregation queries over large networks. In ICDE, 2010.
[36]
Y. Yu, P. K. Gunda, and M. Isard. Distributed aggregation for data-pa- rallel computing: interfaces and implementations. In SIGOPS, 2009.

Cited By

View all
  • (2024)A Universal Sketch for Estimating Heavy Hitters and Per-Element Frequency Moments in Data Streams with Bounded DeletionsProceedings of the ACM on Management of Data10.1145/36987992:6(1-28)Online publication date: 20-Dec-2024
  • (2024)MWP: Multi-Window Parallel Evaluation of Regular Path Queries on Streaming GraphsProceedings of the ACM on Management of Data10.1145/36392602:1(1-26)Online publication date: 26-Mar-2024
  • (2023)GraphMedia: Communication-balanced Graph Searching for Billion-scale Social Media AccessProceedings of the 31st ACM International Conference on Multimedia10.1145/3581783.3613828(8984-8993)Online publication date: 26-Oct-2023
  • Show More Cited By

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
SIGMOD '14: Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data
June 2014
1645 pages
ISBN:9781450323765
DOI:10.1145/2588555
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: 18 June 2014

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. aggregates
  2. continuous queries
  3. data streams
  4. ego-centric analysis
  5. graph compression
  6. graph databases
  7. social networks

Qualifiers

  • Research-article

Conference

SIGMOD/PODS'14
Sponsor:

Acceptance Rates

SIGMOD '14 Paper Acceptance Rate 107 of 421 submissions, 25%;
Overall Acceptance Rate 785 of 4,003 submissions, 20%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)14
  • Downloads (Last 6 weeks)1
Reflects downloads up to 02 Mar 2025

Other Metrics

Citations

Cited By

View all
  • (2024)A Universal Sketch for Estimating Heavy Hitters and Per-Element Frequency Moments in Data Streams with Bounded DeletionsProceedings of the ACM on Management of Data10.1145/36987992:6(1-28)Online publication date: 20-Dec-2024
  • (2024)MWP: Multi-Window Parallel Evaluation of Regular Path Queries on Streaming GraphsProceedings of the ACM on Management of Data10.1145/36392602:1(1-26)Online publication date: 26-Mar-2024
  • (2023)GraphMedia: Communication-balanced Graph Searching for Billion-scale Social Media AccessProceedings of the 31st ACM International Conference on Multimedia10.1145/3581783.3613828(8984-8993)Online publication date: 26-Oct-2023
  • (2023)FT-topo: Architecture-Driven Folded-Triangle Partitioning for Communication-efficient Graph ProcessingProceedings of the 37th International Conference on Supercomputing10.1145/3577193.3593729(240-250)Online publication date: 21-Jun-2023
  • (2022)XTree: Traversal-Based Partitioning for Extreme-Scale Graph Processing on Supercomputers2022 IEEE 38th International Conference on Data Engineering (ICDE)10.1109/ICDE53745.2022.00199(2046-2059)Online publication date: May-2022
  • (2021)Symmetric continuous subgraph matching with bidirectional dynamic programmingProceedings of the VLDB Endowment10.14778/3457390.345739514:8(1298-1310)Online publication date: 21-Oct-2021
  • (2020)An Efficient Approach to Finding Dense Temporal SubgraphsIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2019.289160432:4(645-658)Online publication date: 1-Apr-2020
  • (2020)A survey of typical attributed graph queriesWorld Wide Web10.1007/s11280-020-00849-024:1(297-346)Online publication date: 20-Nov-2020
  • (2019)Location-Centric View Selection in a Location-Based Feed-Following SystemProceedings of the 13th ACM International Conference on Distributed and Event-based Systems10.1145/3328905.3329512(67-78)Online publication date: 24-Jun-2019
  • (2019)Piggyback Game: Efficient Event Stream Dissemination in Online Social Network SystemsIEEE Transactions on Parallel and Distributed Systems10.1109/TPDS.2018.286624230:3(692-709)Online publication date: 1-Mar-2019
  • Show More Cited By

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media