{"id":"https://openalex.org/W2112735105","doi":"https://doi.org/10.1145/2463676.2465306","title":"Column imprints","display_name":"Column imprints","publication_year":2013,"publication_date":"2013-06-22","ids":{"openalex":"https://openalex.org/W2112735105","doi":"https://doi.org/10.1145/2463676.2465306","mag":"2112735105"},"language":"en","primary_location":{"id":"doi:10.1145/2463676.2465306","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2463676.2465306","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2013 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/A5062962519","display_name":"Lefteris Sidirourgos","orcid":null},"institutions":[{"id":"https://openalex.org/I1341640284","display_name":"Centrum Wiskunde & Informatica","ror":"https://ror.org/00x7ekv49","country_code":"NL","type":"facility","lineage":["https://openalex.org/I1341640284","https://openalex.org/I2800991832"]}],"countries":["NL"],"is_corresponding":true,"raw_author_name":"Lefteris Sidirourgos","raw_affiliation_strings":["CWI, Amsterdam, Netherlands"],"affiliations":[{"raw_affiliation_string":"CWI, Amsterdam, Netherlands","institution_ids":["https://openalex.org/I1341640284"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5108572275","display_name":"Martin Kersten","orcid":null},"institutions":[{"id":"https://openalex.org/I1341640284","display_name":"Centrum Wiskunde & Informatica","ror":"https://ror.org/00x7ekv49","country_code":"NL","type":"facility","lineage":["https://openalex.org/I1341640284","https://openalex.org/I2800991832"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Martin Kersten","raw_affiliation_strings":["CWI, Amsterdam, Netherlands"],"affiliations":[{"raw_affiliation_string":"CWI, Amsterdam, Netherlands","institution_ids":["https://openalex.org/I1341640284"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5062962519"],"corresponding_institution_ids":["https://openalex.org/I1341640284"],"apc_list":null,"apc_paid":null,"fwci":7.9777,"has_fulltext":false,"cited_by_count":64,"citation_normalized_percentile":{"value":0.97724662,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"893","last_page":"904"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9987999796867371,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9987999796867371,"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.9987000226974487,"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.9980000257492065,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/bitmap","display_name":"Bitmap","score":0.8754011392593384},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8136488199234009},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.747208297252655},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.6319501399993896},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.5358916521072388},{"id":"https://openalex.org/keywords/memory-bandwidth","display_name":"Memory bandwidth","score":0.5322808027267456},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.5316857695579529},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.4951130449771881},{"id":"https://openalex.org/keywords/auxiliary-memory","display_name":"Auxiliary memory","score":0.48769626021385193},{"id":"https://openalex.org/keywords/inverted-index","display_name":"Inverted index","score":0.4751669764518738},{"id":"https://openalex.org/keywords/access-time","display_name":"Access time","score":0.44000160694122314},{"id":"https://openalex.org/keywords/cpu-cache","display_name":"CPU cache","score":0.4209912419319153},{"id":"https://openalex.org/keywords/computer-hardware","display_name":"Computer hardware","score":0.2546861469745636},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.18451440334320068},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.13331687450408936},{"id":"https://openalex.org/keywords/computer-graphics","display_name":"Computer graphics (images)","score":0.09015670418739319}],"concepts":[{"id":"https://openalex.org/C3115412","wikidata":"https://www.wikidata.org/wiki/Q1194708","display_name":"Bitmap","level":2,"score":0.8754011392593384},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8136488199234009},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.747208297252655},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.6319501399993896},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.5358916521072388},{"id":"https://openalex.org/C188045654","wikidata":"https://www.wikidata.org/wiki/Q17148339","display_name":"Memory bandwidth","level":2,"score":0.5322808027267456},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.5316857695579529},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.4951130449771881},{"id":"https://openalex.org/C82687282","wikidata":"https://www.wikidata.org/wiki/Q66221","display_name":"Auxiliary memory","level":2,"score":0.48769626021385193},{"id":"https://openalex.org/C130590232","wikidata":"https://www.wikidata.org/wiki/Q1671754","display_name":"Inverted index","level":3,"score":0.4751669764518738},{"id":"https://openalex.org/C194080101","wikidata":"https://www.wikidata.org/wiki/Q46306","display_name":"Access time","level":2,"score":0.44000160694122314},{"id":"https://openalex.org/C189783530","wikidata":"https://www.wikidata.org/wiki/Q352090","display_name":"CPU cache","level":3,"score":0.4209912419319153},{"id":"https://openalex.org/C9390403","wikidata":"https://www.wikidata.org/wiki/Q3966","display_name":"Computer hardware","level":1,"score":0.2546861469745636},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.18451440334320068},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.13331687450408936},{"id":"https://openalex.org/C121684516","wikidata":"https://www.wikidata.org/wiki/Q7600677","display_name":"Computer graphics (images)","level":1,"score":0.09015670418739319},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C126042441","wikidata":"https://www.wikidata.org/wiki/Q1324888","display_name":"Frame (networking)","level":2,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/2463676.2465306","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2463676.2465306","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2013 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},{"id":"pmh:oai:dare.uva.nl:publications/63627534-d70d-4622-b611-008a407c4500","is_oa":false,"landing_page_url":"https://handle.uba.uva.nl/personal/pure/en/publications/column-imprints-a-secondary-index-structure(63627534-d70d-4622-b611-008a407c4500).html","pdf_url":null,"source":{"id":"https://openalex.org/S4306400088","display_name":"UvA-DARE (University of Amsterdam)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I887064364","host_organization_name":"University of Amsterdam","host_organization_lineage":["https://openalex.org/I887064364"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Sidirourgos, L & Kersten, M 2013, Column imprints: a secondary index structure. in SIGMOD/PODS'13: compilation proceedings of the 2013 ACM Symposium on Principles of Database Systems, ACM SIGMOD international conference on management of data, and SIGMOD/PODS 2013 PhD symposium: June 22-27, 2013, New York, New York, USA. New York, pp. 893-904, ACM Symposium on Principles of Database Systems; 32 (New York, NY): 2013.06.22-27, 22/06/13. https://doi.org/10.1145/2463676.2465306","raw_type":"info:eu-repo/semantics/conferenceObject"},{"id":"pmh:uvapub:oai:dare.uva.nl:publications/63627534-d70d-4622-b611-008a407c4500","is_oa":false,"landing_page_url":"https://dare.uva.nl/personal/pure/en/publications/column-imprints-a-secondary-index-structure(63627534-d70d-4622-b611-008a407c4500).html","pdf_url":null,"source":{"id":"https://openalex.org/S4306401843","display_name":"Data Archiving and Networked Services (DANS)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1322597698","host_organization_name":"Royal Netherlands Academy of Arts and Sciences","host_organization_lineage":["https://openalex.org/I1322597698"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"SIGMOD/PODS'13: compilation proceedings of the 2013 ACM Symposium on Principles of Database Systems, ACM SIGMOD international conference on management of data, and SIGMOD/PODS 2013 PhD symposium: June 22-27, 2013, New York, New York, USA, 893 - 904","raw_type":"info:eu-repo/semantics/conferencepaper"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.4000000059604645,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":24,"referenced_works":["https://openalex.org/W67853643","https://openalex.org/W125925666","https://openalex.org/W1501548698","https://openalex.org/W1527137792","https://openalex.org/W1970012304","https://openalex.org/W1971065220","https://openalex.org/W2003421875","https://openalex.org/W2006148350","https://openalex.org/W2071774356","https://openalex.org/W2088398920","https://openalex.org/W2094730131","https://openalex.org/W2101566835","https://openalex.org/W2111967617","https://openalex.org/W2116255287","https://openalex.org/W2117156932","https://openalex.org/W2123845384","https://openalex.org/W2124851765","https://openalex.org/W2140646908","https://openalex.org/W2144839430","https://openalex.org/W2151135734","https://openalex.org/W2159726625","https://openalex.org/W2161644187","https://openalex.org/W3138367763","https://openalex.org/W4206835082"],"related_works":["https://openalex.org/W2154688864","https://openalex.org/W2158911502","https://openalex.org/W2613215397","https://openalex.org/W1976852594","https://openalex.org/W1997546439","https://openalex.org/W1985995549","https://openalex.org/W1982075114","https://openalex.org/W49772301","https://openalex.org/W1529265758","https://openalex.org/W2584670027"],"abstract_inverted_index":{"Large":[0],"scale":[1],"data":[2,75,90,110],"warehouses":[3],"rely":[4],"heavily":[5],"on":[6],"secondary":[7,32,59],"indexes,":[8],"such":[9],"as":[10,118],"bitmaps":[11,208],"and":[12,44,92,104,132,156,207],"b-trees,":[13],"to":[14,17,36,88,152,205],"limit":[15,89],"access":[16,91],"slow":[18],"IO":[19],"devices.":[20],"However,":[21],"with":[22,169,209],"the":[23,39,74,106,122,136,154,157,161,179,182,198,201],"advent":[24],"of":[25,67,77,121,138,160,181,194,200],"large":[26],"main":[27],"memory":[28,43,95],"systems,":[29],"cache":[30,57],"conscious":[31,58],"indexes":[33],"are":[34],"needed":[35],"improve":[37],"also":[38],"transfer":[40],"bandwidth":[41],"between":[42],"cpu.":[45],"In":[46],"this":[47],"paper,":[48],"we":[49],"introduce":[50],"column":[51,62,127,162],"imprint,":[52],"a":[53,65,78,119,175],"simple":[54],"but":[55],"efficient":[56],"index.":[60],"A":[61],"imprint":[63,82,128],"is":[64,83,101,173],"collection":[66],"many":[68],"small":[69],"bit":[70],"vectors,":[71],"each":[72],"indexing":[73],"points":[76],"single":[79],"cacheline.":[80],"An":[81],"used":[84],"during":[85],"query":[86],"evaluation":[87,151,187],"thus":[93],"minimize":[94],"traffic.":[96],"The":[97,164,186],"compression":[98,129],"for":[99,189],"imprints":[100],"cpu":[102],"friendly":[103],"exploits":[105],"empirical":[107],"observation":[108],"that":[109],"often":[111],"exhibits":[112],"local":[113],"clustering":[114],"or":[115],"partial":[116],"ordering":[117],"side-effect":[120],"construction":[123],"process.":[124],"Most":[125],"importantly,":[126],"remains":[130],"effective":[131],"robust":[133],"even":[134],"in":[135],"case":[137],"unclustered":[139],"data,":[140],"while":[141],"other":[142],"state-of-the-art":[143],"solutions":[144],"fail.":[145],"We":[146],"conducted":[147],"an":[148],"extensive":[149],"experimental":[150],"assess":[153],"applicability":[155],"performance":[158],"impact":[159],"imprints.":[163],"storage":[165],"overhead,":[166],"when":[167],"experimenting":[168],"real":[170],"world":[171],"datasets,":[172],"just":[174],"few":[176],"percent":[177],"over":[178,190],"size":[180],"columns":[183],"being":[184],"indexed.":[185],"time":[188],"40000":[191],"range":[192],"queries":[193],"varying":[195],"selectivity":[196],"revealed":[197],"efficiency":[199],"proposed":[202],"index":[203],"compared":[204],"zonemaps":[206],"WAH":[210],"compression.":[211]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":5},{"year":2020,"cited_by_count":6},{"year":2019,"cited_by_count":10},{"year":2018,"cited_by_count":7},{"year":2017,"cited_by_count":6},{"year":2016,"cited_by_count":9},{"year":2015,"cited_by_count":6},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":1}],"updated_date":"2026-03-16T09:10:04.655348","created_date":"2016-06-24T00:00:00"}