{"id":"https://openalex.org/W2002131042","doi":"https://doi.org/10.1145/1142473.1142592","title":"COLT","display_name":"COLT","publication_year":2006,"publication_date":"2006-06-27","ids":{"openalex":"https://openalex.org/W2002131042","doi":"https://doi.org/10.1145/1142473.1142592","mag":"2002131042"},"language":"en","primary_location":{"id":"doi:10.1145/1142473.1142592","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1142473.1142592","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2006 ACM SIGMOD international conference on Management of data","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/A5072157136","display_name":"Karl Schnaitter","orcid":null},"institutions":[{"id":"https://openalex.org/I185103710","display_name":"University of California, Santa Cruz","ror":"https://ror.org/03s65by71","country_code":"US","type":"education","lineage":["https://openalex.org/I185103710"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Karl Schnaitter","raw_affiliation_strings":["UC Santa Cruz","[UC Santa Cruz.]"],"affiliations":[{"raw_affiliation_string":"UC Santa Cruz","institution_ids":["https://openalex.org/I185103710"]},{"raw_affiliation_string":"[UC Santa Cruz.]","institution_ids":["https://openalex.org/I185103710"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5109033942","display_name":"Serge Abiteboul","orcid":null},"institutions":[{"id":"https://openalex.org/I1326498283","display_name":"Institut national de recherche en informatique et en automatique","ror":"https://ror.org/02kvxyf05","country_code":"FR","type":"funder","lineage":["https://openalex.org/I1326498283"]},{"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":"Serge Abiteboul","raw_affiliation_strings":["INRIA and Univ. Paris 11"],"affiliations":[{"raw_affiliation_string":"INRIA and Univ. Paris 11","institution_ids":["https://openalex.org/I277688954","https://openalex.org/I1326498283"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5110095410","display_name":"Tova Milo","orcid":null},"institutions":[{"id":"https://openalex.org/I16391192","display_name":"Tel Aviv University","ror":"https://ror.org/04mhzgx49","country_code":"IL","type":"education","lineage":["https://openalex.org/I16391192"]}],"countries":["IL"],"is_corresponding":false,"raw_author_name":"Tova Milo","raw_affiliation_strings":["Tel Aviv University","Tel-Aviv University"],"affiliations":[{"raw_affiliation_string":"Tel Aviv University","institution_ids":["https://openalex.org/I16391192"]},{"raw_affiliation_string":"Tel-Aviv University","institution_ids":["https://openalex.org/I16391192"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5010950113","display_name":"Neoklis Polyzotis","orcid":"https://orcid.org/0000-0002-2694-8591"},"institutions":[{"id":"https://openalex.org/I185103710","display_name":"University of California, Santa Cruz","ror":"https://ror.org/03s65by71","country_code":"US","type":"education","lineage":["https://openalex.org/I185103710"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Neoklis Polyzotis","raw_affiliation_strings":["UC Santa Cruz","[UC Santa Cruz.]"],"affiliations":[{"raw_affiliation_string":"UC Santa Cruz","institution_ids":["https://openalex.org/I185103710"]},{"raw_affiliation_string":"[UC Santa Cruz.]","institution_ids":["https://openalex.org/I185103710"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5072157136"],"corresponding_institution_ids":["https://openalex.org/I185103710"],"apc_list":null,"apc_paid":null,"fwci":4.8285,"has_fulltext":false,"cited_by_count":88,"citation_normalized_percentile":{"value":0.95309031,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"793","last_page":"795"},"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.9998999834060669,"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.9998999834060669,"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.9995999932289124,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9965000152587891,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8510429859161377},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.6745847463607788},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.5737322568893433},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5062905550003052},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.466953843832016},{"id":"https://openalex.org/keywords/profiling","display_name":"Profiling (computer programming)","score":0.449797123670578},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.4496951699256897},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.4315722584724426},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.42400458455085754},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.32729655504226685},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.3075600862503052},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.24918702244758606},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.1537247598171234},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.13981357216835022}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8510429859161377},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.6745847463607788},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.5737322568893433},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5062905550003052},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.466953843832016},{"id":"https://openalex.org/C187191949","wikidata":"https://www.wikidata.org/wiki/Q1138496","display_name":"Profiling (computer programming)","level":2,"score":0.449797123670578},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.4496951699256897},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.4315722584724426},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.42400458455085754},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.32729655504226685},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.3075600862503052},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.24918702244758606},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.1537247598171234},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.13981357216835022}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1142473.1142592","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1142473.1142592","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2006 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":9,"referenced_works":["https://openalex.org/W1538267625","https://openalex.org/W1553825122","https://openalex.org/W1851390469","https://openalex.org/W1972072126","https://openalex.org/W2108883953","https://openalex.org/W2113888164","https://openalex.org/W2117874549","https://openalex.org/W2122816893","https://openalex.org/W2148291485"],"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":{"The":[0,53,99],"physical":[1,22],"schema":[2],"of":[3,27,49,112,164,170,175,189,202,208,216],"a":[4,7,14,40,47,78,162],"database":[5,196],"plays":[6],"critical":[8],"role":[9],"in":[10,34,64,93,193],"performance.":[11,98],"Self-tuning":[12],"is":[13,44,104,142],"cost-effective":[15],"and":[16,88,114,144,152,204],"elegant":[17],"solution":[18],"to":[19,46,69,95,105,115,120,131,156,166],"optimize":[20],"the":[21,25,28,50,65,70,85,90,121,140,149,158,167,179,194,199,205,213,217],"configuration":[23,42,92],"for":[24,178],"characteristics":[26],"query":[29,51,97,181,214],"load.":[30,52,182],"Existing":[31],"techniques":[32],"operate":[33],"an":[35,172,187],"off-line":[36],"fashion,":[37],"by":[38],"choosing":[39],"fixed":[41],"that":[43,61,82],"tailored":[45],"subset":[48],"generated":[54],"configurations":[55],"therefore":[56],"ignore":[57],"any":[58],"temporal":[59],"patterns":[60],"may":[62],"exist":[63],"actual":[66],"load":[67,215],"submitted":[68],"system.This":[71],"demonstration":[72,184],"introduces":[73],"COLT":[74,103,127,165,203],"(Continuous":[75],"On-Line":[76],"Tuning),":[77],"novel":[79],"self-tuning":[80],"framework":[81,192],"continuously":[83],"monitors":[84],"incoming":[86],"queries":[87],"adjusts":[89],"system":[91,141],"order":[94],"maximize":[96],"key":[100],"idea":[101],"behind":[102],"gather":[106],"performance":[107],"statistics":[108],"at":[109],"different":[110],"levels":[111],"detail":[113],"carefully":[116],"allocate":[117],"profiling":[118],"resources":[119],"most":[122],"promising":[123],"candidate":[124],"configurations.":[125],"Moreover,":[126],"uses":[128],"effective":[129,173],"heuristics":[130],"regulate":[132],"its":[133,137],"own":[134],"performance,":[135],"lowering":[136],"overhead":[138],"when":[139,148],"well-tuned,":[143],"being":[145],"more":[146],"aggressive":[147],"workload":[150],"shifts":[151],"it":[153],"becomes":[154],"necessary":[155],"re-tune":[157],"system.":[159],"We":[160],"present":[161],"specialization":[163],"important":[168],"problem":[169],"selecting":[171],"set":[174],"relational":[176],"indices":[177,209],"current":[180],"Our":[183],"will":[185],"use":[186],"implementation":[188],"our":[190],"proposed":[191],"PostgreSQL":[195],"system,":[197],"showing":[198],"internal":[200],"operation":[201],"adaptive":[206],"selection":[207],"as":[210],"we":[211],"vary":[212],"server.":[218]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":3},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":9},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":6},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":4},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":16}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2016-06-24T00:00:00"}