{"id":"https:\/\/openalex.org\/W2775352277","doi":"https:\/\/doi.org\/10.14778\/3149193.3149197","title":"Approximately counting triangles in large graph streams including edge duplicates with a fixed memory usage","display_name":"Approximately counting triangles in large graph streams including edge duplicates with a fixed memory usage","publication_year":2017,"publication_date":"2017-10-01","ids":{"openalex":"https:\/\/openalex.org\/W2775352277","doi":"https:\/\/doi.org\/10.14778\/3149193.3149197","mag":"2775352277"},"language":"en","primary_location":{"id":"doi:10.14778\/3149193.3149197","is_oa":false,"landing_page_url":"https:\/\/doi.org\/10.14778\/3149193.3149197","pdf_url":null,"source":{"id":"https:\/\/openalex.org\/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https:\/\/openalex.org\/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https:\/\/openalex.org\/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https:\/\/openalex.org\/A5022240408","display_name":"Pinghui Wang","orcid":"https:\/\/orcid.org\/0000-0001-5779-6108"},"institutions":[{"id":"https:\/\/openalex.org\/I87445476","display_name":"Xi'an Jiaotong University","ror":"https:\/\/ror.org\/017zhmm22","country_code":"CN","type":"education","lineage":["https:\/\/openalex.org\/I87445476"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Pinghui Wang","raw_affiliation_strings":["Xi'an Jiaotong University, China and Shenzhen Research Institute of Xi'an Jiaotong University, Shenzhen, China"],"affiliations":[{"raw_affiliation_string":"Xi'an Jiaotong University, China and Shenzhen Research Institute of Xi'an Jiaotong University, Shenzhen, China","institution_ids":["https:\/\/openalex.org\/I87445476"]}]},{"author_position":"middle","author":{"id":"https:\/\/openalex.org\/A5056609151","display_name":"Yiyan Qi","orcid":"https:\/\/orcid.org\/0000-0002-8078-5834"},"institutions":[{"id":"https:\/\/openalex.org\/I87445476","display_name":"Xi'an Jiaotong University","ror":"https:\/\/ror.org\/017zhmm22","country_code":"CN","type":"education","lineage":["https:\/\/openalex.org\/I87445476"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yiyan Qi","raw_affiliation_strings":["Xi'an Jiaotong University, China"],"affiliations":[{"raw_affiliation_string":"Xi'an Jiaotong University, China","institution_ids":["https:\/\/openalex.org\/I87445476"]}]},{"author_position":"middle","author":{"id":"https:\/\/openalex.org\/A5054891261","display_name":"Yu Sun","orcid":"https:\/\/orcid.org\/0000-0002-3363-761X"},"institutions":[{"id":"https:\/\/openalex.org\/I87445476","display_name":"Xi'an Jiaotong University","ror":"https:\/\/ror.org\/017zhmm22","country_code":"CN","type":"education","lineage":["https:\/\/openalex.org\/I87445476"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yu Sun","raw_affiliation_strings":["Xi'an Jiaotong University, China"],"affiliations":[{"raw_affiliation_string":"Xi'an Jiaotong University, China","institution_ids":["https:\/\/openalex.org\/I87445476"]}]},{"author_position":"middle","author":{"id":"https:\/\/openalex.org\/A5000755750","display_name":"Xiangliang Zhang","orcid":"https:\/\/orcid.org\/0000-0002-3574-5665"},"institutions":[{"id":"https:\/\/openalex.org\/I71920554","display_name":"King Abdullah University of Science and Technology","ror":"https:\/\/ror.org\/01q3tbs38","country_code":"SA","type":"education","lineage":["https:\/\/openalex.org\/I71920554"]}],"countries":["SA"],"is_corresponding":false,"raw_author_name":"Xiangliang Zhang","raw_affiliation_strings":["King Abdullah University of Science and Technology, Thuwal, SA"],"affiliations":[{"raw_affiliation_string":"King Abdullah University of Science and Technology, Thuwal, SA","institution_ids":["https:\/\/openalex.org\/I71920554"]}]},{"author_position":"middle","author":{"id":"https:\/\/openalex.org\/A5101516220","display_name":"Jing Tao","orcid":"https:\/\/orcid.org\/0009-0009-3911-4260"},"institutions":[{"id":"https:\/\/openalex.org\/I87445476","display_name":"Xi'an Jiaotong University","ror":"https:\/\/ror.org\/017zhmm22","country_code":"CN","type":"education","lineage":["https:\/\/openalex.org\/I87445476"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jing Tao","raw_affiliation_strings":["Xi'an Jiaotong University, China"],"affiliations":[{"raw_affiliation_string":"Xi'an Jiaotong University, China","institution_ids":["https:\/\/openalex.org\/I87445476"]}]},{"author_position":"last","author":{"id":"https:\/\/openalex.org\/A5075845093","display_name":"Xiaohong Guan","orcid":"https:\/\/orcid.org\/0000-0002-8826-0362"},"institutions":[{"id":"https:\/\/openalex.org\/I99065089","display_name":"Tsinghua University","ror":"https:\/\/ror.org\/03cve4549","country_code":"CN","type":"education","lineage":["https:\/\/openalex.org\/I99065089"]},{"id":"https:\/\/openalex.org\/I87445476","display_name":"Xi'an Jiaotong University","ror":"https:\/\/ror.org\/017zhmm22","country_code":"CN","type":"education","lineage":["https:\/\/openalex.org\/I87445476"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xiaohong Guan","raw_affiliation_strings":["Xi'an Jiaotong University, China and Tsinghua University, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Xi'an Jiaotong University, China and Tsinghua University, Beijing, China","institution_ids":["https:\/\/openalex.org\/I99065089","https:\/\/openalex.org\/I87445476"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":6,"corresponding_author_ids":["https:\/\/openalex.org\/A5022240408"],"corresponding_institution_ids":["https:\/\/openalex.org\/I87445476"],"apc_list":null,"apc_paid":null,"fwci":3.5104,"has_fulltext":false,"cited_by_count":51,"citation_normalized_percentile":{"value":0.94366526,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":99},"biblio":{"volume":"11","issue":"2","first_page":"162","last_page":"175"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https:\/\/openalex.org\/T11598","display_name":"Internet Traffic Analysis and Secure E-voting","score":0.9993000030517578,"subfield":{"id":"https:\/\/openalex.org\/subfields\/1702","display_name":"Artificial Intelligence"},"field":{"id":"https:\/\/openalex.org\/fields\/17","display_name":"Computer Science"},"domain":{"id":"https:\/\/openalex.org\/domains\/3","display_name":"Physical Sciences"}},"topics":[{"id":"https:\/\/openalex.org\/T11598","display_name":"Internet Traffic Analysis and Secure E-voting","score":0.9993000030517578,"subfield":{"id":"https:\/\/openalex.org\/subfields\/1702","display_name":"Artificial Intelligence"},"field":{"id":"https:\/\/openalex.org\/fields\/17","display_name":"Computer Science"},"domain":{"id":"https:\/\/openalex.org\/domains\/3","display_name":"Physical Sciences"}},{"id":"https:\/\/openalex.org\/T10064","display_name":"Complex Network Analysis Techniques","score":0.9987999796867371,"subfield":{"id":"https:\/\/openalex.org\/subfields\/3109","display_name":"Statistical and Nonlinear Physics"},"field":{"id":"https:\/\/openalex.org\/fields\/31","display_name":"Physics and Astronomy"},"domain":{"id":"https:\/\/openalex.org\/domains\/3","display_name":"Physical Sciences"}},{"id":"https:\/\/openalex.org\/T11478","display_name":"Caching and Content Delivery","score":0.9984999895095825,"subfield":{"id":"https:\/\/openalex.org\/subfields\/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https:\/\/openalex.org\/fields\/17","display_name":"Computer Science"},"domain":{"id":"https:\/\/openalex.org\/domains\/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https:\/\/openalex.org\/keywords\/computer-science","display_name":"Computer science","score":0.7471315860748291},{"id":"https:\/\/openalex.org\/keywords\/bloom-filter","display_name":"Bloom filter","score":0.7332321405410767},{"id":"https:\/\/openalex.org\/keywords\/streaming-algorithm","display_name":"Streaming algorithm","score":0.6572761535644531},{"id":"https:\/\/openalex.org\/keywords\/graph","display_name":"Graph","score":0.5346758961677551},{"id":"https:\/\/openalex.org\/keywords\/hash-function","display_name":"Hash function","score":0.532188892364502},{"id":"https:\/\/openalex.org\/keywords\/sampling","display_name":"Sampling (signal processing)","score":0.49606260657310486},{"id":"https:\/\/openalex.org\/keywords\/algorithm","display_name":"Algorithm","score":0.4804653525352478},{"id":"https:\/\/openalex.org\/keywords\/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4347415566444397},{"id":"https:\/\/openalex.org\/keywords\/filter","display_name":"Filter (signal processing)","score":0.25733089447021484},{"id":"https:\/\/openalex.org\/keywords\/mathematics","display_name":"Mathematics","score":0.18444624543190002},{"id":"https:\/\/openalex.org\/keywords\/upper-and-lower-bounds","display_name":"Upper and lower bounds","score":0.09182766079902649}],"concepts":[{"id":"https:\/\/openalex.org\/C41008148","wikidata":"https:\/\/www.wikidata.org\/wiki\/Q21198","display_name":"Computer science","level":0,"score":0.7471315860748291},{"id":"https:\/\/openalex.org\/C147224247","wikidata":"https:\/\/www.wikidata.org\/wiki\/Q885373","display_name":"Bloom filter","level":2,"score":0.7332321405410767},{"id":"https:\/\/openalex.org\/C187166803","wikidata":"https:\/\/www.wikidata.org\/wiki\/Q2835831","display_name":"Streaming algorithm","level":3,"score":0.6572761535644531},{"id":"https:\/\/openalex.org\/C132525143","wikidata":"https:\/\/www.wikidata.org\/wiki\/Q141488","display_name":"Graph","level":2,"score":0.5346758961677551},{"id":"https:\/\/openalex.org\/C99138194","wikidata":"https:\/\/www.wikidata.org\/wiki\/Q183427","display_name":"Hash function","level":2,"score":0.532188892364502},{"id":"https:\/\/openalex.org\/C140779682","wikidata":"https:\/\/www.wikidata.org\/wiki\/Q210868","display_name":"Sampling (signal processing)","level":3,"score":0.49606260657310486},{"id":"https:\/\/openalex.org\/C11413529","wikidata":"https:\/\/www.wikidata.org\/wiki\/Q8366","display_name":"Algorithm","level":1,"score":0.4804653525352478},{"id":"https:\/\/openalex.org\/C80444323","wikidata":"https:\/\/www.wikidata.org\/wiki\/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4347415566444397},{"id":"https:\/\/openalex.org\/C106131492","wikidata":"https:\/\/www.wikidata.org\/wiki\/Q3072260","display_name":"Filter (signal processing)","level":2,"score":0.25733089447021484},{"id":"https:\/\/openalex.org\/C33923547","wikidata":"https:\/\/www.wikidata.org\/wiki\/Q395","display_name":"Mathematics","level":0,"score":0.18444624543190002},{"id":"https:\/\/openalex.org\/C77553402","wikidata":"https:\/\/www.wikidata.org\/wiki\/Q13222579","display_name":"Upper and lower bounds","level":2,"score":0.09182766079902649},{"id":"https:\/\/openalex.org\/C31972630","wikidata":"https:\/\/www.wikidata.org\/wiki\/Q844240","display_name":"Computer vision","level":1,"score":0},{"id":"https:\/\/openalex.org\/C134306372","wikidata":"https:\/\/www.wikidata.org\/wiki\/Q7754","display_name":"Mathematical analysis","level":1,"score":0},{"id":"https:\/\/openalex.org\/C38652104","wikidata":"https:\/\/www.wikidata.org\/wiki\/Q3510521","display_name":"Computer security","level":1,"score":0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.14778\/3149193.3149197","is_oa":false,"landing_page_url":"https:\/\/doi.org\/10.14778\/3149193.3149197","pdf_url":null,"source":{"id":"https:\/\/openalex.org\/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https:\/\/openalex.org\/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https:\/\/openalex.org\/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},{"id":"pmh:oai:repository.kaust.edu.sa:10754\/668645","is_oa":false,"landing_page_url":"http:\/\/hdl.handle.net\/10754\/668645","pdf_url":null,"source":{"id":"https:\/\/openalex.org\/S4306401596","display_name":"King Abdullah University of Science and Technology Repository (King Abdullah University of Science and Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https:\/\/openalex.org\/I71920554","host_organization_name":"King Abdullah University of Science and Technology","host_organization_lineage":["https:\/\/openalex.org\/I71920554"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","score":0.7900000214576721,"id":"https:\/\/metadata.un.org\/sdg\/16"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":60,"referenced_works":["https:\/\/openalex.org\/W131619556","https:\/\/openalex.org\/W1489509891","https:\/\/openalex.org\/W1501161035","https:\/\/openalex.org\/W1535612131","https:\/\/openalex.org\/W1551652843","https:\/\/openalex.org\/W1595409123","https:\/\/openalex.org\/W1700158983","https:\/\/openalex.org\/W1785933978","https:\/\/openalex.org\/W1965996575","https:\/\/openalex.org\/W1967022297","https:\/\/openalex.org\/W1967066104","https:\/\/openalex.org\/W1974121232","https:\/\/openalex.org\/W1986745018","https:\/\/openalex.org\/W2002203222","https:\/\/openalex.org\/W2002231822","https:\/\/openalex.org\/W2002576896","https:\/\/openalex.org\/W2010347674","https:\/\/openalex.org\/W2011267080","https:\/\/openalex.org\/W2015960500","https:\/\/openalex.org\/W2016311778","https:\/\/openalex.org\/W2025051251","https:\/\/openalex.org\/W2031082424","https:\/\/openalex.org\/W2037774459","https:\/\/openalex.org\/W2073415627","https:\/\/openalex.org\/W2090885171","https:\/\/openalex.org\/W2090914728","https:\/\/openalex.org\/W2092277251","https:\/\/openalex.org\/W2094308804","https:\/\/openalex.org\/W2094631006","https:\/\/openalex.org\/W2101196063","https:\/\/openalex.org\/W2102260665","https:\/\/openalex.org\/W2110395882","https:\/\/openalex.org\/W2110814195","https:\/\/openalex.org\/W2115022330","https:\/\/openalex.org\/W2117071406","https:\/\/openalex.org\/W2119885577","https:\/\/openalex.org\/W2123845384","https:\/\/openalex.org\/W2124450885","https:\/\/openalex.org\/W2124793767","https:\/\/openalex.org\/W2127386213","https:\/\/openalex.org\/W2129898896","https:\/\/openalex.org\/W2140591663","https:\/\/openalex.org\/W2144982963","https:\/\/openalex.org\/W2153624566","https:\/\/openalex.org\/W2154191591","https:\/\/openalex.org\/W2158432527","https:\/\/openalex.org\/W2278390984","https:\/\/openalex.org\/W2295981143","https:\/\/openalex.org\/W2338645642","https:\/\/openalex.org\/W2366253925","https:\/\/openalex.org\/W2585082167","https:\/\/openalex.org\/W2588458088","https:\/\/openalex.org\/W2950763147","https:\/\/openalex.org\/W2963938117","https:\/\/openalex.org\/W3098475836","https:\/\/openalex.org\/W3111526966","https:\/\/openalex.org\/W3145128584","https:\/\/openalex.org\/W4285719527","https:\/\/openalex.org\/W6637957267","https:\/\/openalex.org\/W7029321148"],"related_works":["https:\/\/openalex.org\/W2227807207","https:\/\/openalex.org\/W2370014100","https:\/\/openalex.org\/W3137108924","https:\/\/openalex.org\/W1852009617","https:\/\/openalex.org\/W4287264924","https:\/\/openalex.org\/W2042819006","https:\/\/openalex.org\/W2170165007","https:\/\/openalex.org\/W1979110442","https:\/\/openalex.org\/W2156660460","https:\/\/openalex.org\/W2362866566"],"abstract_inverted_index":{"Counting":[0],"triangles":[1,37,206],"in":[2,38,87,207],"a":[3,39,44,49,55,105,136,146,196,217],"large":[4,40,106,221],"graph":[5,41,75,90,210],"is":[6,30,168,230],"important":[7],"for":[8,140],"detecting":[9],"network":[10],"anomalies":[11],"such":[12,123],"as":[13,43,124],"spam":[14],"web":[15],"pages":[16],"and":[17,22,127,223,235],"suspicious":[18],"accounts":[19],"(e.g.,":[20,92],"fraudsters":[21],"advertisers)":[23],"on":[24,191,216],"online":[25],"social":[26],"networks.":[27],"However,":[28,71],"it":[29],"challenging":[31],"to":[32,67,115,150,181,201],"compute":[33],"the":[34,74,156,169,177,203,208,224,241],"number":[35,171,204],"of":[36,46,77,172,205,219],"represented":[42],"stream":[45,76],"edges":[47,119,144,174],"with":[48,117,240],"low":[50],"computational":[51,110],"cost":[52,111,158],"when":[53,113],"given":[54],"limited":[56],"memory.":[57],"Recently,":[58],"several":[59,231],"effective":[60],"sampling-based":[61],"approximation":[62],"methods":[63,103,239],"have":[64],"been":[65],"developed":[66],"solve":[68,131],"this":[69,97,132],"problem.":[70],"they":[72],"assume":[73],"interest":[78],"contains":[79],"no":[80],"duplicate":[81,118],"edges,":[82,193],"which":[83],"does":[84],"not":[85],"hold":[86],"many":[88],"real-world":[89,220],"streams":[91],"phone":[93],"calling":[94],"networks).":[95],"In":[96],"paper,":[98],"we":[99,134,194],"observe":[100],"that":[101,227],"these":[102],"exhibit":[104],"estimation":[107],"error":[108],"or":[109],"even":[112],"modified":[114],"deal":[116],"using":[120,185],"deduplication":[121],"techniques":[122],"Bloom":[125],"filter":[126],"hash-based":[128],"sampling.":[129],"To":[130],"challenge,":[133],"design":[135],"one-pass":[137],"streaming":[138],"algorithm":[139,154],"uniformly":[141],"sampling":[142,157],"distinct":[143],"at":[145],"high":[147],"speed.":[148],"Compared":[149],"state-of-the-art":[151,238],"algorithms,":[152],"our":[153,228],"reduces":[155],"per":[159],"edge":[160],"from":[161],"O":[162,182],"(log":[163],"k":[164,167],")":[165],"(":[166],"maximum":[170],"sampled":[173,192],"determined":[175],"by":[176],"available":[178],"memory":[179,188,243],"space)":[180],"(1)":[183],"without":[184],"any":[186],"additional":[187],"space.":[189],"Based":[190],"develop":[195],"simple":[197],"yet":[198],"accurate":[199,234],"method":[200,229],"infer":[202],"original":[209],"stream.":[211],"We":[212],"conduct":[213],"extensive":[214],"experiments":[215],"variety":[218],"graphs,":[222],"results":[225],"demonstrate":[226],"times":[232],"more":[233],"faster":[236],"than":[237],"same":[242],"usage.":[244]},"counts_by_year":[{"year":2025,"cited_by_count":10},{"year":2024,"cited_by_count":6},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":4},{"year":2021,"cited_by_count":8},{"year":2020,"cited_by_count":8},{"year":2019,"cited_by_count":7},{"year":2018,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}