{"id":"https://openalex.org/W2296408038","doi":"https://doi.org/10.1109/icde.1999.754945","title":"Index merging","display_name":"Index merging","publication_year":1999,"publication_date":"1999-01-01","ids":{"openalex":"https://openalex.org/W2296408038","doi":"https://doi.org/10.1109/icde.1999.754945","mag":"2296408038"},"language":"en","primary_location":{"id":"doi:10.1109/icde.1999.754945","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.1999.754945","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings 15th International Conference on Data Engineering (Cat. No.99CB36337)","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/A5038037154","display_name":"Surajit Chaudhuri","orcid":"https://orcid.org/0000-0001-8252-5270"},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"S. Chaudhuri","raw_affiliation_strings":["Microsoft Research, Redmond, USA"],"affiliations":[{"raw_affiliation_string":"Microsoft Research, Redmond, USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5063257827","display_name":"Vivek Narasayya","orcid":"https://orcid.org/0000-0001-7011-7886"},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]},{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"V. Narasayya","raw_affiliation_strings":["Computer Science and Engineering Department, University of Washington, Redmond, USA","Microsoft Research, Redmond, USA"],"affiliations":[{"raw_affiliation_string":"Computer Science and Engineering Department, University of Washington, Redmond, USA","institution_ids":["https://openalex.org/I201448701"]},{"raw_affiliation_string":"Microsoft Research, Redmond, USA","institution_ids":["https://openalex.org/I1290206253"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5038037154"],"corresponding_institution_ids":["https://openalex.org/I1290206253"],"apc_list":null,"apc_paid":null,"fwci":2.6027,"has_fulltext":false,"cited_by_count":57,"citation_normalized_percentile":{"value":0.90260205,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"296","last_page":"303"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9994999766349792,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9994999766349792,"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/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/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.9697999954223633,"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.8291334509849548},{"id":"https://openalex.org/keywords/index","display_name":"Index (typography)","score":0.7622997760772705},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.7185407876968384},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.6860597133636475},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5734976530075073},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5624905228614807},{"id":"https://openalex.org/keywords/sql-server","display_name":"Sql server","score":0.5617978572845459},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4280211627483368},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3373762369155884},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.07591065764427185}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8291334509849548},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.7622997760772705},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.7185407876968384},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.6860597133636475},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5734976530075073},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5624905228614807},{"id":"https://openalex.org/C2984286706","wikidata":"https://www.wikidata.org/wiki/Q400708","display_name":"Sql server","level":2,"score":0.5617978572845459},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4280211627483368},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3373762369155884},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.07591065764427185},{"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/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde.1999.754945","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.1999.754945","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings 15th International Conference on Data Engineering (Cat. No.99CB36337)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.6200000047683716,"id":"https://metadata.un.org/sdg/16","display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W1556422040","https://openalex.org/W1559052653","https://openalex.org/W1562318351","https://openalex.org/W1583332480","https://openalex.org/W1851390469","https://openalex.org/W2029763499","https://openalex.org/W2039795745","https://openalex.org/W2047085757","https://openalex.org/W2064523382","https://openalex.org/W2098506386","https://openalex.org/W2102099561","https://openalex.org/W2113888164","https://openalex.org/W2114679600","https://openalex.org/W2117300033","https://openalex.org/W2118229812","https://openalex.org/W2144811294","https://openalex.org/W2148291485","https://openalex.org/W6633296311","https://openalex.org/W6634714640","https://openalex.org/W6638867933","https://openalex.org/W6677281642","https://openalex.org/W6681914700"],"related_works":["https://openalex.org/W2000785801","https://openalex.org/W986318368","https://openalex.org/W2384410913","https://openalex.org/W2352878646","https://openalex.org/W2004734601","https://openalex.org/W2130149817","https://openalex.org/W2990194547","https://openalex.org/W1480123525","https://openalex.org/W2620865396","https://openalex.org/W2414054180"],"abstract_inverted_index":{"Indexes":[0],"play":[1],"a":[2,49,62,72,88,118],"vital":[3],"role":[4],"in":[5,41,68,76,113,155],"decision":[6],"support":[7],"systems":[8],"by":[9,26,32],"reducing":[10],"the":[11,42,57,65,96,114,134,138],"cost":[12],"of":[13,51,106,121,137,141],"answering":[14],"complex":[15],"queries.":[16],"A":[17],"popular":[18],"methodology":[19],"for":[20,45,110,148],"choosing":[21],"indexes":[22,53,67,107,122],"that":[23,54],"is":[24],"adopted":[25],"database":[27],"administrators":[28],"as":[29,31],"well":[30],"automatic":[33],"tools":[34],"is:":[35],"(a)":[36],"consider":[37],"poorly":[38],"performing":[39],"queries":[40,112],"workload;":[43],"(b)":[44],"each":[46],"query,":[47],"propose":[48],"set":[50,105,120,140],"candidate":[52,66],"potentially":[55],"benefits":[56,136],"query;":[58],"and":[59,79,116,127,151,158],"(c)":[60],"choose":[61],"subset":[63],"from":[64],"(b).":[69],"Unfortunately,":[70],"such":[71],"strategy":[73],"can":[74,101],"result":[75],"significant":[77,153],"storage":[78,126,157],"index":[80,92,149,156],"maintenance":[81,128,159],"costs.":[82],"In":[83],"this":[84],"paper,":[85],"we":[86],"present":[87,144],"novel":[89],"technique,":[90],"called":[91],"merging,":[93],"to":[94],"address":[95],"above":[97],"shortcoming.":[98],"Index":[99],"merging":[100,150],"take":[102],"an":[103,145],"existing":[104],"(perhaps":[108],"optimized":[109],"individual":[111],"workload)":[115],"produce":[117],"new":[119],"with":[123],"significantly":[124],"lower":[125],"overheads,":[129],"while":[130],"retaining":[131],"almost":[132],"all":[133],"querying":[135],"initial":[139],"indexes.":[142],"We":[143],"efficient":[146],"algorithm":[147],"demonstrate":[152],"savings":[154],"through":[160],"experiments":[161],"on":[162],"Microsoft":[163],"SQL":[164],"Server":[165],"7.0.":[166]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":2},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":4},{"year":2012,"cited_by_count":2}],"updated_date":"2026-03-09T08:58:05.943551","created_date":"2016-06-24T00:00:00"}