{"id":"https://openalex.org/W2963734503","doi":"https://doi.org/10.14778/3291264.3291265","title":"Query log compression for workload analytics","display_name":"Query log compression for workload analytics","publication_year":2018,"publication_date":"2018-11-01","ids":{"openalex":"https://openalex.org/W2963734503","doi":"https://doi.org/10.14778/3291264.3291265","mag":"2963734503"},"language":"en","primary_location":{"id":"doi:10.14778/3291264.3291265","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3291264.3291265","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/A5101496580","display_name":"Ting Xie","orcid":"https://orcid.org/0000-0003-0297-8320"},"institutions":[{"id":"https://openalex.org/I63190737","display_name":"University at Buffalo, State University of New York","ror":"https://ror.org/01y64my43","country_code":"US","type":"education","lineage":["https://openalex.org/I63190737"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Ting Xie","raw_affiliation_strings":["University at Buffalo"],"affiliations":[{"raw_affiliation_string":"University at Buffalo","institution_ids":["https://openalex.org/I63190737"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5003851078","display_name":"Varun Chandola","orcid":"https://orcid.org/0000-0001-8990-1398"},"institutions":[{"id":"https://openalex.org/I63190737","display_name":"University at Buffalo, State University of New York","ror":"https://ror.org/01y64my43","country_code":"US","type":"education","lineage":["https://openalex.org/I63190737"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Varun Chandola","raw_affiliation_strings":["University at Buffalo"],"affiliations":[{"raw_affiliation_string":"University at Buffalo","institution_ids":["https://openalex.org/I63190737"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5071259962","display_name":"Oliver Kennedy","orcid":"https://orcid.org/0000-0003-0632-1668"},"institutions":[{"id":"https://openalex.org/I63190737","display_name":"University at Buffalo, State University of New York","ror":"https://ror.org/01y64my43","country_code":"US","type":"education","lineage":["https://openalex.org/I63190737"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Oliver Kennedy","raw_affiliation_strings":["University at Buffalo"],"affiliations":[{"raw_affiliation_string":"University at Buffalo","institution_ids":["https://openalex.org/I63190737"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5101496580"],"corresponding_institution_ids":["https://openalex.org/I63190737"],"apc_list":null,"apc_paid":null,"fwci":0.5536,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.72689601,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"12","issue":"3","first_page":"183","last_page":"196"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994000196456909,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994000196456909,"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"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9977999925613403,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9962000250816345,"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.8173255920410156},{"id":"https://openalex.org/keywords/automatic-summarization","display_name":"Automatic summarization","score":0.7914525270462036},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.6300044655799866},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.5977470874786377},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5528853535652161},{"id":"https://openalex.org/keywords/encoding","display_name":"Encoding (memory)","score":0.5392483472824097},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.5376945734024048},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.5243204832077026},{"id":"https://openalex.org/keywords/lossy-compression","display_name":"Lossy compression","score":0.4779087007045746},{"id":"https://openalex.org/keywords/fidelity","display_name":"Fidelity","score":0.4710882902145386},{"id":"https://openalex.org/keywords/data-compression","display_name":"Data compression","score":0.4266241490840912},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.41938668489456177},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.31375831365585327},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.18501242995262146}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8173255920410156},{"id":"https://openalex.org/C170858558","wikidata":"https://www.wikidata.org/wiki/Q1394144","display_name":"Automatic summarization","level":2,"score":0.7914525270462036},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.6300044655799866},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.5977470874786377},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5528853535652161},{"id":"https://openalex.org/C125411270","wikidata":"https://www.wikidata.org/wiki/Q18653","display_name":"Encoding (memory)","level":2,"score":0.5392483472824097},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.5376945734024048},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5243204832077026},{"id":"https://openalex.org/C165021410","wikidata":"https://www.wikidata.org/wiki/Q55564","display_name":"Lossy compression","level":2,"score":0.4779087007045746},{"id":"https://openalex.org/C2776459999","wikidata":"https://www.wikidata.org/wiki/Q2119376","display_name":"Fidelity","level":2,"score":0.4710882902145386},{"id":"https://openalex.org/C78548338","wikidata":"https://www.wikidata.org/wiki/Q2493","display_name":"Data compression","level":2,"score":0.4266241490840912},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.41938668489456177},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.31375831365585327},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.18501242995262146},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3291264.3291265","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3291264.3291265","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"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":62,"referenced_works":["https://openalex.org/W191231183","https://openalex.org/W1546274087","https://openalex.org/W1561200998","https://openalex.org/W1623444038","https://openalex.org/W1704989917","https://openalex.org/W1851390469","https://openalex.org/W1902027874","https://openalex.org/W2003251288","https://openalex.org/W2011430131","https://openalex.org/W2034331023","https://openalex.org/W2037755852","https://openalex.org/W2047085757","https://openalex.org/W2060108852","https://openalex.org/W2080224812","https://openalex.org/W2082276182","https://openalex.org/W2101234009","https://openalex.org/W2101566835","https://openalex.org/W2107745473","https://openalex.org/W2108883953","https://openalex.org/W2110893883","https://openalex.org/W2118178958","https://openalex.org/W2120108467","https://openalex.org/W2122816893","https://openalex.org/W2122962290","https://openalex.org/W2123686039","https://openalex.org/W2133182690","https://openalex.org/W2138662031","https://openalex.org/W2157890480","https://openalex.org/W2158791970","https://openalex.org/W2160484851","https://openalex.org/W2163345053","https://openalex.org/W2167232041","https://openalex.org/W2168410847","https://openalex.org/W2174706414","https://openalex.org/W2288174618","https://openalex.org/W2294604761","https://openalex.org/W2296319761","https://openalex.org/W2402668406","https://openalex.org/W2403952154","https://openalex.org/W2405294958","https://openalex.org/W2492576631","https://openalex.org/W2508283490","https://openalex.org/W2561675875","https://openalex.org/W2584555500","https://openalex.org/W2593286162","https://openalex.org/W2613995098","https://openalex.org/W2801426799","https://openalex.org/W2805506144","https://openalex.org/W2890393220","https://openalex.org/W2911978475","https://openalex.org/W2963071948","https://openalex.org/W2997591727","https://openalex.org/W3121180423","https://openalex.org/W4230511558","https://openalex.org/W4249186015","https://openalex.org/W4285719527","https://openalex.org/W4298082496","https://openalex.org/W6607430213","https://openalex.org/W6633644953","https://openalex.org/W6723072248","https://openalex.org/W6733403177","https://openalex.org/W6754330350"],"related_works":["https://openalex.org/W2547124190","https://openalex.org/W2385628723","https://openalex.org/W2552401318","https://openalex.org/W3180760233","https://openalex.org/W108076602","https://openalex.org/W4384342390","https://openalex.org/W3035703949","https://openalex.org/W1033938421","https://openalex.org/W4247601675","https://openalex.org/W3195278163"],"abstract_inverted_index":{"Analyzing":[0],"database":[1,18],"access":[2],"logs":[3,39],"is":[4,23],"a":[5,81,112,131],"key":[6],"part":[7],"of":[8,111,115,133],"performance":[9],"tuning,":[10],"intrusion":[11],"detection,":[12],"benchmark":[13],"development,":[14],"and":[15,58,103,117,153],"many":[16,90],"other":[17],"administration":[19],"tasks.":[20],"Unfortunately,":[21],"it":[22],"common":[24],"for":[25,87,98],"production":[26],"databases":[27],"to":[28,122],"deal":[29],"with":[30,146],"millions":[31],"or":[32],"more":[33],"queries":[34],"each":[35],"day,":[36],"so":[37],"these":[38],"must":[40],"be":[41,46,142],"summarized":[42],"before":[43],"they":[44],"can":[45,141],"used.":[47],"Designing":[48],"an":[49],"appropriate":[50],"summary":[51],"encoding":[52],"requires":[53],"trading":[54],"off":[55],"between":[56],"conciseness":[57],"information":[59],"content.":[60],"For":[61],"example:":[62],"simple":[63],"workload":[64],"sampling":[65],"may":[66],"miss":[67],"rare,":[68],"but":[69],"high":[70],"impact":[71],"queries.":[72],"In":[73],"this":[74],"paper,":[75],"we":[76],"present":[77],"L":[78,124,136],"OG":[79,125,137],"R,":[80],"lossy":[82],"log":[83,92,120,156],"compression":[84],"scheme":[85],"suitable":[86],"use":[88],"in":[89,108],"automated":[91],"analytics":[93],"tools,":[94],"as":[95,97],"well":[96],"human":[99],"inspection.":[100],"We":[101,128],"formalize":[102],"analyze":[104],"the":[105,109],"space/fidelity":[106],"trade-off":[107],"context":[110],"broader":[113],"family":[114],"\"pattern\"":[116],"\"pattern":[118],"mixture\"":[119],"encodings":[121,140],"which":[123],"R":[126,138],"belongs.":[127],"show":[129],"through":[130],"series":[132],"experiments":[134],"that":[135],"compressed":[139],"created":[143],"efficiently,":[144],"come":[145],"provable":[147],"information-theoretic":[148],"bounds":[149],"on":[150],"their":[151],"accuracy,":[152],"outperform":[154],"state-of-art":[155],"summarization":[157],"strategies.":[158]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}