{"id":"https://openalex.org/W2100542992","doi":"https://doi.org/10.1109/icde.2008.4497414","title":"Constant-Time Query Processing","display_name":"Constant-Time Query Processing","publication_year":2008,"publication_date":"2008-04-01","ids":{"openalex":"https://openalex.org/W2100542992","doi":"https://doi.org/10.1109/icde.2008.4497414","mag":"2100542992"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2008.4497414","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2008.4497414","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2008 IEEE 24th International Conference on Data Engineering","raw_type":"proceedings-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/A5103997746","display_name":"Vijayshankar Raman","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Vijayshankar Raman","raw_affiliation_strings":["IBM Almaden Research Center, San Jose, CA, USA","[Almaden Res. Center, IBM, San Jose, CA]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA, USA","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"[Almaden Res. Center, IBM, San Jose, CA]","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5002771222","display_name":"Garret Swart","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Garret Swart","raw_affiliation_strings":["IBM Almaden Research Center, San Jose, CA, USA","IBM Almaden Research Center, San Jose, CA, USA. garret@swart.org#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA, USA","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA, USA. garret@swart.org#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5112108963","display_name":"Lin Qiao","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Lin Qiao","raw_affiliation_strings":["IBM Almaden Research Center, San Jose, CA, USA","IBM Almaden Research Center, San Jose, CA, USA. lsqiao@us"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA, USA","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA, USA. lsqiao@us","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5074416632","display_name":"Frederick Reiss","orcid":"https://orcid.org/0009-0002-1254-1798"},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Frederick Reiss","raw_affiliation_strings":["IBM Almaden Research Center, San Jose, CA, USA","IBM Almaden Research Center, San Jose, CA, USA. frreiss@us#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA, USA","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA, USA. frreiss@us#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5085811342","display_name":"Vijay Dialani","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Vijay Dialani","raw_affiliation_strings":["IBM Almaden Research Center, San Jose, CA, USA","IBM Almaden Research Center, San Jose, CA USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA, USA","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA USA","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5111504785","display_name":"Donald Kossmann","orcid":null},"institutions":[{"id":"https://openalex.org/I35440088","display_name":"ETH Zurich","ror":"https://ror.org/05a28rw58","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I35440088"]},{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["CH","US"],"is_corresponding":false,"raw_author_name":"Donald Kossmann","raw_affiliation_strings":["IBM Almaden Research Center, San Jose, CA, USA","ETH Zurich, Zurich, Switzerland. donald.kossmann@inf.ethz.ch"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA, USA","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"ETH Zurich, Zurich, Switzerland. donald.kossmann@inf.ethz.ch","institution_ids":["https://openalex.org/I35440088"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5000041094","display_name":"Inderpal Narang","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Inderpal Narang","raw_affiliation_strings":["IBM Almaden Research Center, San Jose, CA, USA","IBM Almaden Research Center, San Jose, CA, USA. inarang@us"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA, USA","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA, USA. inarang@us","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5028660385","display_name":"Richard Sidle","orcid":"https://orcid.org/0009-0001-7577-8816"},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Richard Sidle","raw_affiliation_strings":["IBM Almaden Research Center, San Jose, CA, USA","IBM Almaden Research Center, San Jose, CA, USA. rsidle@almaden.ibm.com"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA, USA","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA, USA. rsidle@almaden.ibm.com","institution_ids":["https://openalex.org/I1341412227"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":8,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":11.4413,"has_fulltext":false,"cited_by_count":123,"citation_normalized_percentile":{"value":0.98587909,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":91,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"60","last_page":"69"},"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.9998000264167786,"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.9998000264167786,"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.9994000196456909,"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/T11269","display_name":"Algorithms and Data Compression","score":0.9991000294685364,"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.8482128977775574},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.6957510113716125},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5613604187965393},{"id":"https://openalex.org/keywords/hash-function","display_name":"Hash function","score":0.5015034675598145},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5015017986297607},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.48923540115356445},{"id":"https://openalex.org/keywords/hash-table","display_name":"Hash table","score":0.4303259551525116},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.41445210576057434},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.36754271388053894},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.3619224429130554},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3487478196620941},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3439657688140869},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.22577250003814697},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1324584186077118},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.11250773072242737}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8482128977775574},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.6957510113716125},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5613604187965393},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.5015034675598145},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5015017986297607},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.48923540115356445},{"id":"https://openalex.org/C67388219","wikidata":"https://www.wikidata.org/wiki/Q207440","display_name":"Hash table","level":3,"score":0.4303259551525116},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.41445210576057434},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.36754271388053894},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.3619224429130554},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3487478196620941},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3439657688140869},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.22577250003814697},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1324584186077118},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.11250773072242737},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde.2008.4497414","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2008.4497414","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2008 IEEE 24th International Conference on Data Engineering","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","score":0.49000000953674316,"id":"https://metadata.un.org/sdg/16"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":15,"referenced_works":["https://openalex.org/W1547206386","https://openalex.org/W1786193469","https://openalex.org/W1993819379","https://openalex.org/W2018745370","https://openalex.org/W2060108852","https://openalex.org/W2114474644","https://openalex.org/W2132998471","https://openalex.org/W2140136514","https://openalex.org/W2140453381","https://openalex.org/W2146005787","https://openalex.org/W2147011911","https://openalex.org/W2157174514","https://openalex.org/W2912601938","https://openalex.org/W3138367763","https://openalex.org/W6681994082"],"related_works":["https://openalex.org/W2248831950","https://openalex.org/W2349550597","https://openalex.org/W16924853","https://openalex.org/W1999594162","https://openalex.org/W2379847823","https://openalex.org/W2549774162","https://openalex.org/W3156363426","https://openalex.org/W175663584","https://openalex.org/W2942097156","https://openalex.org/W1564408968"],"abstract_inverted_index":{"Query":[0],"performance":[1],"in":[2,21,147],"current":[3],"systems":[4],"depends":[5],"significantly":[6],"on":[7],"tuning:":[8],"how":[9],"well":[10,23],"the":[11,14,97,161],"query":[12,53,82],"matches":[13],"available":[15],"indexes,":[16],"materialized":[17],"views":[18],"etc.":[19],"Even":[20],"a":[22,84,88,106,136,140,168,177],"tuned":[24],"system,":[25],"there":[26],"are":[27],"always":[28],"some":[29],"queries":[30,175,183],"that":[31,52,79,110,181],"take":[32],"much":[33],"longer":[34],"than":[35],"others.":[36],"This":[37],"frustrates":[38],"users":[39],"who":[40],"increasingly":[41],"want":[42],"consistent":[43],"response":[44,60],"times":[45,61],"to":[46,122],"ad":[47],"hoc":[48],"queries.":[49],"We":[50,70,133],"argue":[51],"processors":[54],"should":[55],"instead":[56],"aim":[57],"for":[58,62,138,156],"constant":[59],"all":[63],"queries,":[64],"with":[65,92,167],"no":[66],"assumption":[67],"about":[68],"tuning.":[69],"present":[71,135],"Blink,":[72],"our":[73],"first":[74],"attempt":[75],"at":[76],"this":[77,101],"goal,":[78],"runs":[80,128],"every":[81],"as":[83],"table":[85],"scan":[86,102],"over":[87,150,176],"fully":[89],"denormalized":[90],"database,":[91],"hash":[93],"group-by":[94],"done":[95],"along":[96],"way.":[98],"To":[99],"make":[100],"efficient,":[103],"Blink":[104],"uses":[105],"novel":[107],"compression":[108],"scheme":[109,137],"horizontally":[111],"partitions":[112],"tuples":[113],"by":[114],"frequency,":[115],"thereby":[116],"compressing":[117],"skewed":[118],"data":[119],"almost":[120],"down":[121],"entropy,":[123],"even":[124],"while":[125],"producing":[126],"long":[127],"of":[129,142,170],"fixed-length,":[130],"easily-parseable":[131],"values.":[132],"also":[134],"evaluating":[139],"conjunction":[141],"range":[143],"and":[144,153],"equality":[145],"predicates":[146],"SIMD":[148],"fashion":[149],"compressed":[151],"tuples,":[152],"different":[154],"schemes":[155],"efficient":[157],"hash-based":[158],"aggregation":[159],"within":[160],"L2":[162],"cache.":[163],"A":[164],"experimental":[165],"study":[166],"suite":[169],"arbitrary":[171],"single":[172],"block":[173],"SQL":[174],"TPCH-like":[178],"schema":[179],"suggests":[180],"constant-time":[182],"can":[184],"be":[185],"efficient.":[186]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":5},{"year":2019,"cited_by_count":8},{"year":2018,"cited_by_count":6},{"year":2017,"cited_by_count":7},{"year":2016,"cited_by_count":5},{"year":2015,"cited_by_count":14},{"year":2014,"cited_by_count":12},{"year":2013,"cited_by_count":14},{"year":2012,"cited_by_count":15}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}