{"id":"https://openalex.org/W2948152464","doi":"https://doi.org/10.1145/3299869.3319904","title":"iQCAR","display_name":"iQCAR","publication_year":2019,"publication_date":"2019-06-18","ids":{"openalex":"https://openalex.org/W2948152464","doi":"https://doi.org/10.1145/3299869.3319904","mag":"2948152464","pmid":"https://pubmed.ncbi.nlm.nih.gov/33840884"},"language":"en","primary_location":{"id":"doi:10.1145/3299869.3319904","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3299869.3319904","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3299869.3319904","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2019 International Conference on Management of Data","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref","pubmed"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3299869.3319904","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5004152513","display_name":"Prajakta Kalmegh","orcid":null},"institutions":[{"id":"https://openalex.org/I170897317","display_name":"Duke University","ror":"https://ror.org/00py81415","country_code":"US","type":"education","lineage":["https://openalex.org/I170897317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Prajakta Kalmegh","raw_affiliation_strings":["Duke University, Durham, NC, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Duke University, Durham, NC, USA","institution_ids":["https://openalex.org/I170897317"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100646227","display_name":"Shivnath Babu","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Shivnath Babu","raw_affiliation_strings":["Unravel Data Systems, Palo Alto, CA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Unravel Data Systems, Palo Alto, CA, USA","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5110322079","display_name":"Sudeepa Roy","orcid":null},"institutions":[{"id":"https://openalex.org/I170897317","display_name":"Duke University","ror":"https://ror.org/00py81415","country_code":"US","type":"education","lineage":["https://openalex.org/I170897317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sudeepa Roy","raw_affiliation_strings":["Duke University, Durham, NC, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Duke University, Durham, NC, USA","institution_ids":["https://openalex.org/I170897317"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.4387,"has_fulltext":true,"cited_by_count":4,"citation_normalized_percentile":{"value":0.58271243,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"2019","issue":null,"first_page":"918","last_page":"935"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T12127","display_name":"Software System Performance and Reliability","score":0.9965000152587891,"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/T12761","display_name":"Data Stream Mining Techniques","score":0.9962999820709229,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8717224597930908},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.6240290999412537},{"id":"https://openalex.org/keywords/resource","display_name":"Resource (disambiguation)","score":0.5899360179901123},{"id":"https://openalex.org/keywords/spark","display_name":"SPARK (programming language)","score":0.5607270002365112},{"id":"https://openalex.org/keywords/web-query-classification","display_name":"Web query classification","score":0.5080697536468506},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.4860444664955139},{"id":"https://openalex.org/keywords/rdf-query-language","display_name":"RDF query language","score":0.450603723526001},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.4356904923915863},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.4355728030204773},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.4293060004711151},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.4287649393081665},{"id":"https://openalex.org/keywords/online-aggregation","display_name":"Online aggregation","score":0.42049965262413025},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.38911211490631104},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.344488263130188},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3279133439064026},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.18482527136802673},{"id":"https://openalex.org/keywords/computer-network","display_name":"Computer network","score":0.11411857604980469},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.09871459007263184}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8717224597930908},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.6240290999412537},{"id":"https://openalex.org/C206345919","wikidata":"https://www.wikidata.org/wiki/Q20380951","display_name":"Resource (disambiguation)","level":2,"score":0.5899360179901123},{"id":"https://openalex.org/C2781215313","wikidata":"https://www.wikidata.org/wiki/Q3493345","display_name":"SPARK (programming language)","level":2,"score":0.5607270002365112},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.5080697536468506},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4860444664955139},{"id":"https://openalex.org/C96956885","wikidata":"https://www.wikidata.org/wiki/Q6138701","display_name":"RDF query language","level":5,"score":0.450603723526001},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.4356904923915863},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.4355728030204773},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4293060004711151},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.4287649393081665},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.42049965262413025},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.38911211490631104},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.344488263130188},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3279133439064026},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.18482527136802673},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.11411857604980469},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.09871459007263184},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/3299869.3319904","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3299869.3319904","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3299869.3319904","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2019 International Conference on Management of Data","raw_type":"proceedings-article"},{"id":"pmid:33840884","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/33840884","pdf_url":null,"source":{"id":"https://openalex.org/S4306525036","display_name":"PubMed","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings. ACM-SIGMOD International Conference on Management of Data","raw_type":null},{"id":"pmh:oai:pubmedcentral.nih.gov:8034287","is_oa":true,"landing_page_url":"https://www.ncbi.nlm.nih.gov/pmc/articles/8034287","pdf_url":null,"source":{"id":"https://openalex.org/S2764455111","display_name":"PubMed Central","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Proc ACM SIGMOD Int Conf Manag Data","raw_type":"Text"}],"best_oa_location":{"id":"doi:10.1145/3299869.3319904","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3299869.3319904","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3299869.3319904","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2019 International Conference on Management of Data","raw_type":"proceedings-article"},"sustainable_development_goals":[{"score":0.4300000071525574,"display_name":"Decent work and economic growth","id":"https://metadata.un.org/sdg/8"}],"awards":[{"id":"https://openalex.org/G104327506","display_name":null,"funder_award_id":"R01 EB025021","funder_id":"https://openalex.org/F4320337363","funder_display_name":"National Institute of Biomedical Imaging and Bioengineering"},{"id":"https://openalex.org/G2855953563","display_name":"III: Small: DBMS+: Management System for the Next-Generation Database","funder_award_id":"1423124","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G3499912885","display_name":"III: Medium: Collaborative Research: A Unified and Declarative Approach to Causal Analysis for Big Data","funder_award_id":"1703431","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G4213323792","display_name":"CAREER: FIREFLY - Rich Explanations for Database Queries","funder_award_id":"1552538","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G7446531716","display_name":"III: Medium: Collaborative Research: From Answering Questions to  Questioning Answers (and Questions)---Perturbation Analysis of  Database Queries","funder_award_id":"1408846","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G8302243993","display_name":"QuBBD: Matching Methods for causaul inference: big data and network","funder_award_id":"1r01eb025021-01","funder_id":"https://openalex.org/F4320332161","funder_display_name":"National Institutes of Health"},{"id":"https://openalex.org/G919057648","display_name":"QuBBD: Matching Methods for causaul inference: big data and network","funder_award_id":"5r01eb025021-03","funder_id":"https://openalex.org/F4320332161","funder_display_name":"National Institutes of Health"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320332161","display_name":"National Institutes of Health","ror":"https://ror.org/01cwqze88"},{"id":"https://openalex.org/F4320337363","display_name":"National Institute of Biomedical Imaging and Bioengineering","ror":"https://ror.org/00372qc85"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2948152464.pdf","grobid_xml":"https://content.openalex.org/works/W2948152464.grobid-xml"},"referenced_works_count":13,"referenced_works":["https://openalex.org/W1520857056","https://openalex.org/W1746258828","https://openalex.org/W1834532152","https://openalex.org/W2074663022","https://openalex.org/W2093941454","https://openalex.org/W2096125134","https://openalex.org/W2097175800","https://openalex.org/W2137726616","https://openalex.org/W2173213060","https://openalex.org/W2189465200","https://openalex.org/W2439673131","https://openalex.org/W2613206411","https://openalex.org/W2798717089"],"related_works":["https://openalex.org/W3125756434","https://openalex.org/W2096359267","https://openalex.org/W4381740310","https://openalex.org/W2013069866","https://openalex.org/W2128834514","https://openalex.org/W2891235283","https://openalex.org/W2740424238","https://openalex.org/W2146885082","https://openalex.org/W2587993932","https://openalex.org/W906795786"],"abstract_inverted_index":{"Resource":[0],"interferences":[1],"caused":[2,58],"by":[3,59],"concurrent":[4,98,118,160],"queries":[5,61,140],"is":[6,28,38,148],"one":[7],"of":[8,53,77,94],"the":[9,49,69,74,92,102],"key":[10],"reasons":[11],"for":[12,91,131],"unpredictable":[13],"performance":[14,79],"and":[15,125],"missed":[16],"workload":[17],"SLAs":[18],"in":[19,30,127],"cluster":[20],"computing":[21],"systems.":[22],"Analyzing":[23],"these":[24],"inter-query":[25],"resource":[26,40,50,103],"interactions":[27],"critical":[29],"order":[31],"to":[32,42,97],"answer":[33],"time-sensitive":[34],"questions":[35],"like":[36],"'who":[37],"creating":[39],"conflicts":[41,104],"my":[43],"query'.":[44],"More":[45],"importantly,":[46],"diagnosing":[47],"whether":[48],"blocked":[51],"times":[52],"a":[54,95,106,132],"'victim'":[55],"query":[56,78,96],"are":[57],"other":[60,64,153],"or":[62],"some":[63],"external":[65],"factor":[66],"can":[67,112],"help":[68,113],"database":[70],"administrator":[71],"narrow":[72],"down":[73],"many":[75],"possibilities":[76],"degradation.":[80],"We":[81],"introduce":[82],"iQCAR,":[83],"an":[84,128],"inter-Query":[85],"Contention":[86],"Analyzer,":[87],"that":[88,111,145],"attributes":[89],"blame":[90],"slowdown":[93],"queries.":[99,161],"iQCAR":[100],"models":[101],"using":[105,138],"multi-level":[107],"directed":[108],"acyclic":[109],"graph":[110],"administrators":[114],"compare":[115],"impacts":[116],"from":[117],"queries,":[119,123],"identify":[120],"most":[121],"contentious":[122],"resources":[124],"hosts":[126],"online":[129],"execution":[130],"selected":[133],"time":[134,158],"window.":[135],"Our":[136],"experiments":[137],"TPCDS":[139],"on":[141,156],"Apache":[142],"Spark":[143],"show":[144],"our":[146],"approach":[147],"substantially":[149],"more":[150],"accurate":[151],"than":[152],"methods":[154],"based":[155],"overlap":[157],"between":[159]},"counts_by_year":[{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1}],"updated_date":"2026-08-06T08:24:18.245995","created_date":"2019-06-14T00:00:00"}