{"id":"https://openalex.org/W2160068753","doi":"https://doi.org/10.1145/2452376.2452402","title":"An automatic physical design tool for clustered column-stores","display_name":"An automatic physical design tool for clustered column-stores","publication_year":2013,"publication_date":"2013-03-18","ids":{"openalex":"https://openalex.org/W2160068753","doi":"https://doi.org/10.1145/2452376.2452402","mag":"2160068753"},"language":"en","primary_location":{"id":"doi:10.1145/2452376.2452402","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2452376.2452402","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 16th International Conference on Extending Database Technology","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/A5007690835","display_name":"Alexander Rasin","orcid":"https://orcid.org/0000-0001-7282-5763"},"institutions":[{"id":"https://openalex.org/I118353179","display_name":"DePaul University","ror":"https://ror.org/04xtx5t16","country_code":"US","type":"education","lineage":["https://openalex.org/I118353179"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Alexander Rasin","raw_affiliation_strings":["DePaul University, Chicago, IL"],"affiliations":[{"raw_affiliation_string":"DePaul University, Chicago, IL","institution_ids":["https://openalex.org/I118353179"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5111367666","display_name":"Stan Zdonik","orcid":null},"institutions":[{"id":"https://openalex.org/I27804330","display_name":"Brown University","ror":"https://ror.org/05gq02987","country_code":"US","type":"education","lineage":["https://openalex.org/I27804330"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Stan Zdonik","raw_affiliation_strings":["Brown University, Providence, RI"],"affiliations":[{"raw_affiliation_string":"Brown University, Providence, RI","institution_ids":["https://openalex.org/I27804330"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5007690835"],"corresponding_institution_ids":["https://openalex.org/I118353179"],"apc_list":null,"apc_paid":null,"fwci":2.1747,"has_fulltext":false,"cited_by_count":19,"citation_normalized_percentile":{"value":0.89441792,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"203","last_page":"214"},"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.9973999857902527,"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/T10742","display_name":"Peer-to-Peer Network Technologies","score":0.9925000071525574,"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/computer-science","display_name":"Computer science","score":0.7941069602966309},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.7228915095329285},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6160537600517273},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.5696817636489868},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.5038244128227234},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.49356091022491455},{"id":"https://openalex.org/keywords/physical-design","display_name":"Physical design","score":0.4692791700363159},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.4319024085998535},{"id":"https://openalex.org/keywords/process-design","display_name":"Process design","score":0.41533392667770386},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.4152563512325287},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.3617158532142639},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.32232242822647095},{"id":"https://openalex.org/keywords/work-in-process","display_name":"Work in process","score":0.2494506537914276},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.21553531289100647},{"id":"https://openalex.org/keywords/embedded-system","display_name":"Embedded system","score":0.13216882944107056},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.12043449282646179},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.12017267942428589},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.12002211809158325},{"id":"https://openalex.org/keywords/circuit-design","display_name":"Circuit design","score":0.09211206436157227}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7941069602966309},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.7228915095329285},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6160537600517273},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5696817636489868},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5038244128227234},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.49356091022491455},{"id":"https://openalex.org/C188817802","wikidata":"https://www.wikidata.org/wiki/Q13426855","display_name":"Physical design","level":3,"score":0.4692791700363159},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.4319024085998535},{"id":"https://openalex.org/C55396564","wikidata":"https://www.wikidata.org/wiki/Q3084971","display_name":"Process design","level":3,"score":0.41533392667770386},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.4152563512325287},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3617158532142639},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.32232242822647095},{"id":"https://openalex.org/C174998907","wikidata":"https://www.wikidata.org/wiki/Q357662","display_name":"Work in process","level":2,"score":0.2494506537914276},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.21553531289100647},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.13216882944107056},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.12043449282646179},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.12017267942428589},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.12002211809158325},{"id":"https://openalex.org/C190560348","wikidata":"https://www.wikidata.org/wiki/Q3245116","display_name":"Circuit design","level":2,"score":0.09211206436157227},{"id":"https://openalex.org/C126042441","wikidata":"https://www.wikidata.org/wiki/Q1324888","display_name":"Frame (networking)","level":2,"score":0.0},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2452376.2452402","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2452376.2452402","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 16th International Conference on Extending Database Technology","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.5699999928474426}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W1553825122","https://openalex.org/W1576035775","https://openalex.org/W1851390469","https://openalex.org/W2006296837","https://openalex.org/W2017052417","https://openalex.org/W2026427349","https://openalex.org/W2072764742","https://openalex.org/W2083658889","https://openalex.org/W2088398920","https://openalex.org/W2103412498","https://openalex.org/W2107745473","https://openalex.org/W2108883953","https://openalex.org/W2114712170","https://openalex.org/W2122816893","https://openalex.org/W2123686039","https://openalex.org/W2125605956","https://openalex.org/W2140190241","https://openalex.org/W2143401113","https://openalex.org/W2148291485","https://openalex.org/W2296408038","https://openalex.org/W3138367763","https://openalex.org/W6763581396"],"related_works":["https://openalex.org/W2125738398","https://openalex.org/W2038176938","https://openalex.org/W2376402673","https://openalex.org/W2953224074","https://openalex.org/W1606751452","https://openalex.org/W2585331044","https://openalex.org/W2588278736","https://openalex.org/W2114713465","https://openalex.org/W2395940163","https://openalex.org/W1680377312"],"abstract_inverted_index":{"Good":[0],"database":[1,12,59,80],"design":[2,36,60,76,87],"is":[3],"typically":[4],"a":[5,33,48,52,83],"very":[6],"difficult":[7],"and":[8,17,44],"costly":[9],"process.":[10],"As":[11],"systems":[13],"get":[14],"more":[15],"complex":[16],"as":[18],"the":[19,26,65],"amount":[20],"of":[21,35,39,55,67,85],"data":[22],"under":[23],"management":[24],"grows,":[25],"stakes":[27],"increase":[28],"accordingly.":[29],"Past":[30],"research":[31,56],"produced":[32,74],"number":[34],"tools":[37],"capable":[38],"automatically":[40],"selecting":[41],"secondary":[42],"indexes":[43],"materialized":[45],"views":[46],"for":[47],"known":[49],"workload.":[50],"However,":[51],"significant":[53],"bulk":[54],"on":[57],"automated":[58,86],"has":[61,73],"been":[62],"done":[63],"in":[64],"context":[66],"row-store":[68],"DBMSes.":[69],"While":[70],"this":[71],"work":[72],"effective":[75],"tools,":[77],"new":[78],"specialized":[79],"architectures":[81],"demand":[82],"rethinking":[84],"algorithms.":[88]},"counts_by_year":[{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":3},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}