{"id":"https://openalex.org/W3176959138","doi":"https://doi.org/10.1145/3448016.3457311","title":"HADAD: A Lightweight Approach for Optimizing Hybrid Complex Analytics Queries","display_name":"HADAD: A Lightweight Approach for Optimizing Hybrid Complex Analytics Queries","publication_year":2021,"publication_date":"2021-06-09","ids":{"openalex":"https://openalex.org/W3176959138","doi":"https://doi.org/10.1145/3448016.3457311","mag":"3176959138"},"language":"en","primary_location":{"id":"doi:10.1145/3448016.3457311","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3448016.3457311","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3448016.3457311","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2021 International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3448016.3457311","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5072649296","display_name":"Rana Alotaibi","orcid":"https://orcid.org/0009-0005-0457-8429"},"institutions":[{"id":"https://openalex.org/I36258959","display_name":"University of California, San Diego","ror":"https://ror.org/0168r3w48","country_code":"US","type":"education","lineage":["https://openalex.org/I36258959"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Rana Alotaibi","raw_affiliation_strings":["University of California, San Diego, San Diego, CA, USA"],"affiliations":[{"raw_affiliation_string":"University of California, San Diego, San Diego, CA, USA","institution_ids":["https://openalex.org/I36258959"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5070592874","display_name":"Bogdan Cautis","orcid":"https://orcid.org/0000-0003-3497-042X"},"institutions":[{"id":"https://openalex.org/I277688954","display_name":"Universit\u00e9 Paris-Saclay","ror":"https://ror.org/03xjwb503","country_code":"FR","type":"education","lineage":["https://openalex.org/I277688954"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Bogdan Cautis","raw_affiliation_strings":["University of Paris-Saclay, Paris, France"],"affiliations":[{"raw_affiliation_string":"University of Paris-Saclay, Paris, France","institution_ids":["https://openalex.org/I277688954"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038619283","display_name":"Alin Deutsch","orcid":null},"institutions":[{"id":"https://openalex.org/I36258959","display_name":"University of California, San Diego","ror":"https://ror.org/0168r3w48","country_code":"US","type":"education","lineage":["https://openalex.org/I36258959"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Alin Deutsch","raw_affiliation_strings":["University of California, San Diego, San Diego, CA, USA"],"affiliations":[{"raw_affiliation_string":"University of California, San Diego, San Diego, CA, USA","institution_ids":["https://openalex.org/I36258959"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5056968239","display_name":"Ioana Manolescu","orcid":"https://orcid.org/0000-0002-0425-2462"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ioana Manolescu","raw_affiliation_strings":["Inria & Institut Polytechnique de Paris, Paris, France"],"affiliations":[{"raw_affiliation_string":"Inria & Institut Polytechnique de Paris, Paris, France","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5072649296"],"corresponding_institution_ids":["https://openalex.org/I36258959"],"apc_list":null,"apc_paid":null,"fwci":0.6113,"has_fulltext":true,"cited_by_count":4,"citation_normalized_percentile":{"value":0.69375115,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"23","last_page":"35"},"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.9955999851226807,"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/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9907000064849854,"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.8498406410217285},{"id":"https://openalex.org/keywords/exploit","display_name":"Exploit","score":0.8496060967445374},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.7339583039283752},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.6821979284286499},{"id":"https://openalex.org/keywords/relational-algebra","display_name":"Relational algebra","score":0.4944929778575897},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4697473645210266},{"id":"https://openalex.org/keywords/focus","display_name":"Focus (optics)","score":0.4274478554725647},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.42424264550209045},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.41692161560058594},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.2993485629558563},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.21190503239631653}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8498406410217285},{"id":"https://openalex.org/C165696696","wikidata":"https://www.wikidata.org/wiki/Q11287","display_name":"Exploit","level":2,"score":0.8496060967445374},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.7339583039283752},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.6821979284286499},{"id":"https://openalex.org/C95916125","wikidata":"https://www.wikidata.org/wiki/Q840540","display_name":"Relational algebra","level":3,"score":0.4944929778575897},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4697473645210266},{"id":"https://openalex.org/C192209626","wikidata":"https://www.wikidata.org/wiki/Q190909","display_name":"Focus (optics)","level":2,"score":0.4274478554725647},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.42424264550209045},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.41692161560058594},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2993485629558563},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.21190503239631653},{"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/C120665830","wikidata":"https://www.wikidata.org/wiki/Q14620","display_name":"Optics","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3448016.3457311","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3448016.3457311","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3448016.3457311","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2021 International Conference on Management of Data","raw_type":"proceedings-article"},{"id":"pmh:oai:HAL:hal-03347677v1","is_oa":true,"landing_page_url":"https://inria.hal.science/hal-03347677","pdf_url":null,"source":{"id":"https://openalex.org/S4306402512","display_name":"HAL (Le Centre pour la Communication Scientifique Directe)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1294671590","host_organization_name":"Centre National de la Recherche Scientifique","host_organization_lineage":["https://openalex.org/I1294671590"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"ACM SIGMOD 2021 - International Conference on Management of Data, Jun 2021, Xi'an / Online, China. pp.23-35, ⟨10.1145/3448016.3457311⟩","raw_type":"Conference papers"}],"best_oa_location":{"id":"doi:10.1145/3448016.3457311","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3448016.3457311","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3448016.3457311","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2021 International Conference on Management of Data","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320322997","display_name":"King Abdulaziz City for Science and Technology","ror":"https://ror.org/05tdz6m39"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3176959138.pdf","grobid_xml":"https://content.openalex.org/works/W3176959138.grobid-xml"},"referenced_works_count":31,"referenced_works":["https://openalex.org/W1553372930","https://openalex.org/W1558832481","https://openalex.org/W1979514837","https://openalex.org/W2074702228","https://openalex.org/W2076421732","https://openalex.org/W2127218421","https://openalex.org/W2189162242","https://openalex.org/W2292198035","https://openalex.org/W2299467264","https://openalex.org/W2357449897","https://openalex.org/W2479223973","https://openalex.org/W2563724055","https://openalex.org/W2612139288","https://openalex.org/W2753069234","https://openalex.org/W2780517008","https://openalex.org/W2889897289","https://openalex.org/W2897128047","https://openalex.org/W2901851917","https://openalex.org/W2944730199","https://openalex.org/W2948827545","https://openalex.org/W2953384591","https://openalex.org/W2964054286","https://openalex.org/W2971290973","https://openalex.org/W2974937486","https://openalex.org/W2980953914","https://openalex.org/W3007236544","https://openalex.org/W3082570516","https://openalex.org/W3084489972","https://openalex.org/W4286447301","https://openalex.org/W6697424724","https://openalex.org/W6744582164"],"related_works":["https://openalex.org/W2085988990","https://openalex.org/W2056340443","https://openalex.org/W2143485006","https://openalex.org/W2005835473","https://openalex.org/W3174970460","https://openalex.org/W2950556518","https://openalex.org/W2376710457","https://openalex.org/W4383617113","https://openalex.org/W1979093255","https://openalex.org/W197205525"],"abstract_inverted_index":{"Hybrid":[0],"complex":[1,23,82],"analytics":[2,24],"workloads":[3,38],"typically":[4],"include":[5],"(i)":[6],"data":[7,79],"management":[8,80],"tasks":[9,25,59,83],"(joins,":[10],"selections,":[11],"etc.":[12],"),":[13],"easily":[14],"expressed":[15,31],"using":[16],"relational":[17,66],"algebra":[18,34],"(RA)-based":[19],"languages,":[20],"and":[21,50,81],"(ii)":[22],"(regressions,":[26],"matrix":[27],"decompositions,":[28],"etc.),":[29],"mostly":[30],"in":[32,41],"linear":[33],"(LA)":[35],"expressions.":[36],"Such":[37],"are":[39,109],"common":[40],"many":[42],"application":[43],"areas,":[44],"including":[45],"scientific":[46],"computing,":[47],"web":[48],"analytics,":[49],"business":[51],"recommendation.":[52],"Existing":[53],"solutions":[54],"for":[55],"evaluating":[56],"hybrid":[57,74],"analytical":[58],"-":[60,76],"ranging":[61],"from":[62],"LA-oriented":[63],"systems,":[64],"to":[65,69,73,112,117],"systems":[67,75],"(extended":[68],"handle":[70],"LA":[71],"operations),":[72],"either":[77],"optimize":[78],"separately,":[84],"exploit":[85,113],"RA":[86],"properties":[87],"only":[88],"while":[89],"leaving":[90,101],"LA-specific":[91],"optimization":[92,104],"opportunities":[93,105],"unexploited,":[94],"or":[95],"focus":[96],"heavily":[97],"on":[98],"physical":[99],"optimization,":[100],"semantic":[102],"query":[103],"unexplored.":[106],"Additionally,":[107],"they":[108],"not":[110],"able":[111],"precomputed":[114],"(materialized)":[115],"results":[116],"avoid":[118],"recomputing":[119],"(part":[120],"of)":[121],"a":[122],"given":[123],"mixed":[124],"(RA":[125],"and/or":[126],"LA)":[127],"computation.":[128]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}