{"id":"https://openalex.org/W2093821541","doi":"https://doi.org/10.1109/icde.2014.6816664","title":"In-RDBMS inverted indexes revisited","display_name":"In-RDBMS inverted indexes revisited","publication_year":2014,"publication_date":"2014-03-01","ids":{"openalex":"https://openalex.org/W2093821541","doi":"https://doi.org/10.1109/icde.2014.6816664","mag":"2093821541"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2014.6816664","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2014.6816664","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2014 IEEE 30th 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/A5057702950","display_name":"Ian Rae","orcid":"https://orcid.org/0000-0001-8790-1925"},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ian Rae","raw_affiliation_strings":["Department of Computer Sciences, University of Wisconsin-Madison, Madison, WI, USA","Department of Computer Sciences, University of Wisconsin-Madison, 1210 W. Dayton St., 53706, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Sciences, University of Wisconsin-Madison, Madison, WI, USA","institution_ids":["https://openalex.org/I135310074"]},{"raw_affiliation_string":"Department of Computer Sciences, University of Wisconsin-Madison, 1210 W. Dayton St., 53706, USA","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5011716507","display_name":"Alan Halverson","orcid":"https://orcid.org/0009-0003-0460-0580"},"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":false,"raw_author_name":"Alan Halverson","raw_affiliation_strings":["Microsoft Corporation, Madison, WI, USA","Microsoft Corporation, 634 W. Main St., Ste. 400, Madison, WI 53703, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Corporation, Madison, WI, USA","institution_ids":["https://openalex.org/I1290206253"]},{"raw_affiliation_string":"Microsoft Corporation, 634 W. Main St., Ste. 400, Madison, WI 53703, USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5017678555","display_name":"Jeffrey F. Naughton","orcid":"https://orcid.org/0000-0002-3710-8096"},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jeffrey F. Naughton","raw_affiliation_strings":["Department of Computer Sciences, University of Wisconsin-Madison, Madison, WI, USA","Department of Computer Sciences, University of Wisconsin-Madison, 1210 W. Dayton St., 53706, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Sciences, University of Wisconsin-Madison, Madison, WI, USA","institution_ids":["https://openalex.org/I135310074"]},{"raw_affiliation_string":"Department of Computer Sciences, University of Wisconsin-Madison, 1210 W. Dayton St., 53706, USA","institution_ids":["https://openalex.org/I135310074"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.7198,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.76832947,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"352","last_page":"363"},"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.9995999932289124,"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.9995999932289124,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9933000206947327,"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.8054675459861755},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.7875562906265259},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.674576997756958},{"id":"https://openalex.org/keywords/inverted-index","display_name":"Inverted index","score":0.5879539847373962},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.5753005146980286},{"id":"https://openalex.org/keywords/merge","display_name":"Merge (version control)","score":0.5012762546539307},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.49823784828186035},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.48907214403152466},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.4469633102416992},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.42864301800727844},{"id":"https://openalex.org/keywords/relational-calculus","display_name":"Relational calculus","score":0.42363452911376953},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.4037456810474396},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.21027988195419312}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8054675459861755},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.7875562906265259},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.674576997756958},{"id":"https://openalex.org/C130590232","wikidata":"https://www.wikidata.org/wiki/Q1671754","display_name":"Inverted index","level":3,"score":0.5879539847373962},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.5753005146980286},{"id":"https://openalex.org/C197129107","wikidata":"https://www.wikidata.org/wiki/Q1921621","display_name":"Merge (version control)","level":2,"score":0.5012762546539307},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.49823784828186035},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.48907214403152466},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.4469633102416992},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.42864301800727844},{"id":"https://openalex.org/C99436015","wikidata":"https://www.wikidata.org/wiki/Q1722436","display_name":"Relational calculus","level":4,"score":0.42363452911376953},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.4037456810474396},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.21027988195419312}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde.2014.6816664","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2014.6816664","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2014 IEEE 30th International Conference on Data Engineering","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":45,"referenced_works":["https://openalex.org/W77904627","https://openalex.org/W95284390","https://openalex.org/W166877056","https://openalex.org/W339752665","https://openalex.org/W1529063404","https://openalex.org/W1556741196","https://openalex.org/W1589496614","https://openalex.org/W1605782097","https://openalex.org/W1681204582","https://openalex.org/W1791987072","https://openalex.org/W1975489634","https://openalex.org/W1982558719","https://openalex.org/W1984614894","https://openalex.org/W1994694191","https://openalex.org/W2000569270","https://openalex.org/W2006296837","https://openalex.org/W2025578095","https://openalex.org/W2053550438","https://openalex.org/W2065472179","https://openalex.org/W2078739211","https://openalex.org/W2087361130","https://openalex.org/W2094154930","https://openalex.org/W2129554248","https://openalex.org/W2138662031","https://openalex.org/W2140453381","https://openalex.org/W2141922908","https://openalex.org/W2143110746","https://openalex.org/W2162753082","https://openalex.org/W2165167056","https://openalex.org/W2168410847","https://openalex.org/W2170016254","https://openalex.org/W2404326078","https://openalex.org/W3031968991","https://openalex.org/W3102704970","https://openalex.org/W3138367763","https://openalex.org/W4236536123","https://openalex.org/W4242141871","https://openalex.org/W6606844161","https://openalex.org/W6611599856","https://openalex.org/W6631743725","https://openalex.org/W6635512999","https://openalex.org/W6638231387","https://openalex.org/W6663889151","https://openalex.org/W6680870207","https://openalex.org/W6684162700"],"related_works":["https://openalex.org/W2085988990","https://openalex.org/W2089781037","https://openalex.org/W1855322793","https://openalex.org/W2243465518","https://openalex.org/W2005835473","https://openalex.org/W3022423983","https://openalex.org/W3174970460","https://openalex.org/W206482712","https://openalex.org/W79051208","https://openalex.org/W1842425231"],"abstract_inverted_index":{"Every":[0],"major":[1],"open-source":[2],"and":[3,69,79,102,122,152,159,170,182,208,222],"commercial":[4],"RDBMS":[5,138],"offers":[6],"some":[7,21],"form":[8],"of":[9,104,145],"support":[10],"for":[11,108,157],"full-text":[12],"search":[13],"using":[14,175],"inverted":[15,56,111,187],"indexes.":[16],"When":[17],"providing":[18],"this":[19,165],"support,":[20],"developers":[22],"have":[23,44,86,213],"implemented":[24],"specialized":[25,77,132,195],"indexes":[26,188],"that":[27,130,173],"adapt":[28],"techniques":[29],"from":[30],"the":[31,49,66,92,98,137,150,203,220,229],"Information":[32],"Retrieval":[33],"(IR)":[34],"community":[35],"to":[36,46,54,179,193,202,227],"work":[37,96],"in":[38,91,100,211],"a":[39,76,80,117,123,131,194],"database":[40],"setting,":[41],"while":[42],"others":[43],"opted":[45],"rely":[47],"on":[48,216],"standard":[50],"relational":[51,81,119,125,154,186],"query":[52,120,126,155,184],"engine":[53,134,198],"process":[55],"index":[57,78,209],"lookups.":[58],"This":[59],"choice":[60],"is":[61,167],"an":[62,109,113,143],"important":[63],"one,":[64],"since":[65],"storage":[67,205],"formats":[68],"algorithms":[70],"used":[71],"can":[72,139,189],"vary":[73],"greatly":[74],"between":[75],"index,":[82],"but":[83],"these":[84],"alternatives":[85],"not":[87],"been":[88],"thoroughly":[89],"compared":[90],"same":[93],"system.":[94],"Our":[95],"explores":[97],"differences":[99],"implementation":[101],"performance":[103,191],"three":[105],"representative":[106],"environments":[107],"in-RDBMS":[110,114,196],"index:":[112],"IR":[115,133,197,221],"engine,":[116,121,231],"row-oriented":[118,230],"column-oriented":[124,153,223],"engine.":[127],"We":[128],"found":[129],"integrated":[135],"into":[136],"provide":[140,190],"more":[141,214],"than":[142],"order":[144],"magnitude":[146],"speedup":[147],"over":[148],"both":[149],"row-":[151],"engines":[156,224],"conjunctive":[158,181],"phrase":[160,183],"queries.":[161],"For":[162],"warm":[163],"queries,":[164,218],"advantage":[166],"largely":[168],"algorithmic,":[169],"we":[171],"show":[172],"by":[174],"ZigZag":[176,234],"merge":[177,235],"join":[178],"accelerate":[180],"processing,":[185],"comparable":[192],"with":[199,233],"no":[200],"change":[201],"underlying":[204],"format.":[206],"Compression":[207],"format,":[210],"contrast,":[212],"impact":[215],"cold":[217],"where":[219],"are":[225],"able":[226],"outperform":[228],"even":[232],"join.":[236]},"counts_by_year":[{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}