{"id":"https://openalex.org/W2037192958","doi":"https://doi.org/10.1145/2588555.2595629","title":"Exploiting ordered dictionaries to efficiently construct histograms with q-error guarantees in SAP HANA","display_name":"Exploiting ordered dictionaries to efficiently construct histograms with q-error guarantees in SAP HANA","publication_year":2014,"publication_date":"2014-06-18","ids":{"openalex":"https://openalex.org/W2037192958","doi":"https://doi.org/10.1145/2588555.2595629","mag":"2037192958"},"language":"en","primary_location":{"id":"doi:10.1145/2588555.2595629","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2588555.2595629","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},"type":"conference-paper","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/A5025678292","display_name":"Guido Moerkotte","orcid":null},"institutions":[{"id":"https://openalex.org/I177802217","display_name":"University of Mannheim","ror":"https://ror.org/031bsb921","country_code":"DE","type":"education","lineage":["https://openalex.org/I177802217"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Guido Moerkotte","raw_affiliation_strings":["University of Mannheim, Mannheim, Germany","University of Mannheim , Mannheim, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Mannheim, Mannheim, Germany","institution_ids":["https://openalex.org/I177802217"]},{"raw_affiliation_string":"University of Mannheim , Mannheim, Germany","institution_ids":["https://openalex.org/I177802217"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5036781808","display_name":"David DeHaan","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"David DeHaan","raw_affiliation_strings":["SAP AG, Waterloo, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SAP AG, Waterloo, Canada","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5040281275","display_name":"Norman May","orcid":"https://orcid.org/0000-0001-9671-0856"},"institutions":[{"id":"https://openalex.org/I4210132444","display_name":"Systems, Applications & Products in Data Processing (Germany)","ror":"https://ror.org/03dsc8d33","country_code":"DE","type":"company","lineage":["https://openalex.org/I4210132444"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Norman May","raw_affiliation_strings":["SAP AG, Walldorf, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SAP AG, Walldorf, Germany","institution_ids":["https://openalex.org/I4210132444"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5109865053","display_name":"Anisoara Nica","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Anisoara Nica","raw_affiliation_strings":["SAP AG, Waterloo, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SAP AG, Waterloo, Canada","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5088262249","display_name":"Alexander Boehm","orcid":null},"institutions":[{"id":"https://openalex.org/I4210132444","display_name":"Systems, Applications & Products in Data Processing (Germany)","ror":"https://ror.org/03dsc8d33","country_code":"DE","type":"company","lineage":["https://openalex.org/I4210132444"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Alexander Boehm","raw_affiliation_strings":["SAP AG, Walldorf, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SAP AG, Walldorf, Germany","institution_ids":["https://openalex.org/I4210132444"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":19,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"361","last_page":"372"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12072","display_name":"Machine Learning and Algorithms","score":0.9990000128746033,"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/T12072","display_name":"Machine Learning and Algorithms","score":0.9990000128746033,"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/T11269","display_name":"Algorithms and Data Compression","score":0.9941999912261963,"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/T11697","display_name":"Numerical Methods and Algorithms","score":0.9937999844551086,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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/histogram","display_name":"Histogram","score":0.8528164625167847},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.7666857242584229},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6497396230697632},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.5576145052909851},{"id":"https://openalex.org/keywords/bounded-function","display_name":"Bounded function","score":0.5542652606964111},{"id":"https://openalex.org/keywords/multiplicative-function","display_name":"Multiplicative function","score":0.5185797214508057},{"id":"https://openalex.org/keywords/construct","display_name":"Construct (python library)","score":0.4610445201396942},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.37147170305252075},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.2390548288822174},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.21634748578071594},{"id":"https://openalex.org/keywords/image","display_name":"Image (mathematics)","score":0.1700446605682373}],"concepts":[{"id":"https://openalex.org/C53533937","wikidata":"https://www.wikidata.org/wiki/Q185020","display_name":"Histogram","level":3,"score":0.8528164625167847},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.7666857242584229},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6497396230697632},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.5576145052909851},{"id":"https://openalex.org/C34388435","wikidata":"https://www.wikidata.org/wiki/Q2267362","display_name":"Bounded function","level":2,"score":0.5542652606964111},{"id":"https://openalex.org/C42747912","wikidata":"https://www.wikidata.org/wiki/Q1048447","display_name":"Multiplicative function","level":2,"score":0.5185797214508057},{"id":"https://openalex.org/C2780801425","wikidata":"https://www.wikidata.org/wiki/Q5164392","display_name":"Construct (python library)","level":2,"score":0.4610445201396942},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.37147170305252075},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.2390548288822174},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.21634748578071594},{"id":"https://openalex.org/C115961682","wikidata":"https://www.wikidata.org/wiki/Q860623","display_name":"Image (mathematics)","level":2,"score":0.1700446605682373},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/2588555.2595629","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2588555.2595629","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.645.6678","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.645.6678","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://pi3.informatik.uni-mannheim.de/~norman/Moerkotte_HistogramsHANA_SIGMOD2014.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","score":0.5,"display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":16,"referenced_works":["https://openalex.org/W47455834","https://openalex.org/W1529715724","https://openalex.org/W1967601791","https://openalex.org/W2020463726","https://openalex.org/W2022858489","https://openalex.org/W2058991275","https://openalex.org/W2059877472","https://openalex.org/W2064710146","https://openalex.org/W2107591011","https://openalex.org/W2132823934","https://openalex.org/W2134786002","https://openalex.org/W2139422440","https://openalex.org/W2151310484","https://openalex.org/W2166332856","https://openalex.org/W2396727930","https://openalex.org/W2398254416"],"related_works":["https://openalex.org/W2366107444","https://openalex.org/W4388145910","https://openalex.org/W2381570729","https://openalex.org/W1976205134","https://openalex.org/W4248336175","https://openalex.org/W2031260042","https://openalex.org/W2391445434","https://openalex.org/W2002177687","https://openalex.org/W2485961789","https://openalex.org/W1813751874"],"abstract_inverted_index":{"Histograms":[0],"that":[1],"guarantee":[2],"a":[3,43],"maximum":[4,26],"multiplicative":[5],"error":[6],"(q-error)":[7],"for":[8,23,31,77,84],"estimates":[9],"may":[10],"significantly":[11],"improve":[12],"the":[13,20,59,90,111,127,146],"plan":[14],"quality":[15],"of":[16,94,102,142],"query":[17],"optimizers.":[18],"However,":[19],"construction":[21,75,112],"time":[22],"histograms":[24,78,103,114,128],"with":[25,42,79],"q-error":[27,60],"was":[28],"too":[29],"high":[30],"practical":[32],"use":[33],"cases.":[34],"In":[35,123],"this":[36,40,100],"paper":[37],"we":[38,54,62,108],"extend":[39],"concept":[41],"threshold,":[44],"i.e.,":[45],"an":[46],"estimate":[47],"or":[48],"true":[49],"cardinality":[50],"\u03b8,":[51,85],"below":[52],"which":[53],"do":[55],"not":[56],"care":[57],"about":[58],"because":[61],"still":[63],"expect":[64],"optimal":[65],"plans.":[66],"This":[67],"allows":[68],"us":[69],"to":[70,145],"develop":[71],"far":[72,133],"more":[73],"efficient":[74],"algorithms":[76],"bounded":[80],"error.":[81],"The":[82],"test":[83],"q-acceptability":[86],"developed":[87],"also":[88],"exploits":[89],"order-preserving":[91],"dictionary":[92],"encoding":[93],"SAP":[95,105],"HANA.":[96],"We":[97],"have":[98],"integrated":[99],"family":[101],"into":[104],"HANA,":[106],"and":[107,116],"report":[109],"on":[110,119],"time,":[113],"size,":[115],"estimation":[117],"errors":[118],"real-world":[120],"data":[121],"sets.":[122],"virtually":[124],"all":[125],"cases":[126],"can":[129],"be":[130],"constructed":[131],"in":[132],"less":[134,139],"than":[135,140],"one":[136],"second,":[137],"requiring":[138],"5%":[141],"space":[143],"compared":[144],"original":[147],"compressed":[148],"data.":[149]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":4},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}