{"id":"https://openalex.org/W6925294261","doi":"https://doi.org/10.18420/btw2023-14","title":"PostBOUND: PostgreSQL with Upper Bound SPJ Query Optimization","display_name":"PostBOUND: PostgreSQL with Upper Bound SPJ Query Optimization","publication_year":2023,"publication_date":"2023-01-01","ids":{"openalex":"https://openalex.org/W6925294261","doi":"https://doi.org/10.18420/btw2023-14"},"language":"en","primary_location":{"id":"doi:10.18420/btw2023-14","is_oa":true,"landing_page_url":"https://doi.org/10.18420/btw2023-14","pdf_url":null,"source":{"id":"https://openalex.org/S7407052918","display_name":"Gesellschaft f\u00fcr Informatik (GI)","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article-journal"},"type":"article","indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.18420/btw2023-14","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Bergmann, Rico","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Bergmann, Rico","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":null,"display_name":"Hertzschuch, Axel","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Hertzschuch, Axel","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":null,"display_name":"Hartmann, Claudio","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Hartmann, Claudio","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":null,"display_name":"Habich, Dirk","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Habich, Dirk","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"last","author":{"id":null,"display_name":"Lehner, Wolfgang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Lehner, Wolfgang","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":5,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.4210164,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":true,"primary_topic":{"id":"https://openalex.org/T10290","display_name":"Pregnancy and preeclampsia studies","score":0.14560000598430634,"subfield":{"id":"https://openalex.org/subfields/2729","display_name":"Obstetrics and Gynecology"},"field":{"id":"https://openalex.org/fields/27","display_name":"Medicine"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}},"topics":[{"id":"https://openalex.org/T10290","display_name":"Pregnancy and preeclampsia studies","score":0.14560000598430634,"subfield":{"id":"https://openalex.org/subfields/2729","display_name":"Obstetrics and Gynecology"},"field":{"id":"https://openalex.org/fields/27","display_name":"Medicine"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}},{"id":"https://openalex.org/T11290","display_name":"Preterm Birth and Chorioamnionitis","score":0.13490000367164612,"subfield":{"id":"https://openalex.org/subfields/2713","display_name":"Epidemiology"},"field":{"id":"https://openalex.org/fields/27","display_name":"Medicine"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}},{"id":"https://openalex.org/T10978","display_name":"Prenatal Screening and Diagnostics","score":0.040699999779462814,"subfield":{"id":"https://openalex.org/subfields/2735","display_name":"Pediatrics, Perinatology and Child Health"},"field":{"id":"https://openalex.org/fields/27","display_name":"Medicine"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.7368999719619751},{"id":"https://openalex.org/keywords/upper-and-lower-bounds","display_name":"Upper and lower bounds","score":0.7157999873161316},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.6953999996185303},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.6904000043869019},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.6549999713897705},{"id":"https://openalex.org/keywords/construct","display_name":"Construct (python library)","score":0.4343999922275543},{"id":"https://openalex.org/keywords/class","display_name":"Class (philosophy)","score":0.40720000863075256},{"id":"https://openalex.org/keywords/variety","display_name":"Variety (cybernetics)","score":0.3901999890804291}],"concepts":[{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.7368999719619751},{"id":"https://openalex.org/C77553402","wikidata":"https://www.wikidata.org/wiki/Q13222579","display_name":"Upper and lower bounds","level":2,"score":0.7157999873161316},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.6953999996185303},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.6904000043869019},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6642000079154968},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.6549999713897705},{"id":"https://openalex.org/C2780801425","wikidata":"https://www.wikidata.org/wiki/Q5164392","display_name":"Construct (python library)","level":2,"score":0.4343999922275543},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.42489999532699585},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.40720000863075256},{"id":"https://openalex.org/C136197465","wikidata":"https://www.wikidata.org/wiki/Q1729295","display_name":"Variety (cybernetics)","level":2,"score":0.3901999890804291},{"id":"https://openalex.org/C93693863","wikidata":"https://www.wikidata.org/wiki/Q897659","display_name":"Branch and bound","level":2,"score":0.3686999976634979},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.34279999136924744},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3418000042438507},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.33809998631477356},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.33169999718666077},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.31690001487731934},{"id":"https://openalex.org/C24755975","wikidata":"https://www.wikidata.org/wiki/Q4943354","display_name":"Boolean conjunctive query","level":5,"score":0.28630000352859497},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.28610000014305115},{"id":"https://openalex.org/C137836250","wikidata":"https://www.wikidata.org/wiki/Q984063","display_name":"Optimization problem","level":2,"score":0.28600001335144043},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2824999988079071},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.2750000059604645},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.2615000009536743}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.18420/btw2023-14","is_oa":true,"landing_page_url":"https://doi.org/10.18420/btw2023-14","pdf_url":null,"source":{"id":"https://openalex.org/S7407052918","display_name":"Gesellschaft f\u00fcr Informatik (GI)","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article-journal"}],"best_oa_location":{"id":"doi:10.18420/btw2023-14","is_oa":true,"landing_page_url":"https://doi.org/10.18420/btw2023-14","pdf_url":null,"source":{"id":"https://openalex.org/S7407052918","display_name":"Gesellschaft f\u00fcr Informatik (GI)","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article-journal"},"sustainable_development_goals":[{"display_name":"No poverty","id":"https://metadata.un.org/sdg/1","score":0.7504550814628601}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"A":[0,36],"variety":[1],"of":[2,11,78,130,161],"query":[3,44,96,118],"optimization":[4,45,97],"papers":[5],"have":[6],"shown":[7],"the":[8,16,51,63,128,135,157],"disastrous":[9],"effect":[10],"poor":[12],"cardinality":[13],"estimates":[14],"on":[15,47,163],"overall":[17],"run":[18],"time":[19],"for":[20,28,50,74],"arbitrary":[21,76,108],"select-project-join":[22],"(SPJ)":[23],"queries.Especially,":[24],"underestimating":[25],"join":[26,34,52,125],"cardinalities":[27],"multi-joins":[29],"can":[30],"lead":[31],"to":[32,39,106,111,120,133],"catastrophic":[33],"orderings.":[35],"promising":[37],"solution":[38],"overcome":[40],"this":[41,55,151],"problem":[42],"is":[43,61],"based":[46],"upper":[48,72,93,109,143,179],"bounds":[49],"cardinalities.":[53],"In":[54],"domain,":[56],"our":[57,89,153],"proposed":[58],"UES":[59,145],"concept":[60],"presently":[62],"most":[64],"efficient":[65],"technique":[66],"featuring":[67],"a":[68,98],"simple,":[69],"yet":[70],"effective":[71],"bound":[73,94,144,180],"an":[75,116,123],"number":[77],"joins.":[79],"To":[80],"foster":[81],"research":[82,136],"in":[83,102,150],"that":[84],"direction,":[85],"we":[86,138,155,174],"introduce":[87],"PostBOUND,":[88],"generalized":[90],"framework":[91],"making":[92],"SPJ":[95,117],"first":[99],"class":[100],"citizen":[101],"PostgreSQL.PostBOUND":[103],"provides":[104],"abstractions":[105],"calculate":[107],"bounds,":[110],"model":[112],"joins":[113],"required":[114],"by":[115],"and":[119,132,159],"iteratively":[121],"construct":[122],"optimized":[124],"order.To":[126],"highlight":[127],"extensibility":[129],"PostBOUND":[131,162],"show":[134,156],"potential,":[137],"additionally":[139],"present":[140],"two":[141],"tighter":[142,178],"variants":[146],"using":[147,169],"top-k":[148],"statistics":[149],"paper.In":[152],"evaluation,":[154],"efficiency":[158],"applicability":[160],"different":[164,170],"workloads":[165],"as":[166,168],"well":[167],"PostgreSQL":[171],"versions.":[172],"Additionally,":[173],"evaluate":[175],"both":[176],"presented":[177],"variant":[181],"ideas.":[182]},"counts_by_year":[],"updated_date":"2025-11-06T06:51:31.235846","created_date":"2025-10-10T00:00:00"}