{"id":"https://openalex.org/W2055961446","doi":"https://doi.org/10.1109/icde.2014.6816725","title":"DBDesigner: A customizable physical design tool for Vertica Analytic Database","display_name":"DBDesigner: A customizable physical design tool for Vertica Analytic Database","publication_year":2014,"publication_date":"2014-03-01","ids":{"openalex":"https://openalex.org/W2055961446","doi":"https://doi.org/10.1109/icde.2014.6816725","mag":"2055961446"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2014.6816725","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2014.6816725","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/A5002810936","display_name":"Ramakrishna Varadarajan","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ramakrishna Varadarajan","raw_affiliation_strings":["Vertica Systems an HP Company, Cambridge, MA, USA","Vertica Systems, an HP Company, 150 Cambridge Park Dr, MA 02140, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Vertica Systems an HP Company, Cambridge, MA, USA","institution_ids":[]},{"raw_affiliation_string":"Vertica Systems, an HP Company, 150 Cambridge Park Dr, MA 02140, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5049046541","display_name":"Vivek Bharathan","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Vivek Bharathan","raw_affiliation_strings":["Vertica Systems an HP Company, Cambridge, MA, USA","Vertica Systems, an HP Company, 150 Cambridge Park Dr, MA 02140, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Vertica Systems an HP Company, Cambridge, MA, USA","institution_ids":[]},{"raw_affiliation_string":"Vertica Systems, an HP Company, 150 Cambridge Park Dr, MA 02140, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5079213222","display_name":"Ariel Cary","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ariel Cary","raw_affiliation_strings":["Vertica Systems an HP Company, Cambridge, MA, USA","Vertica Systems, an HP Company, 150 Cambridge Park Dr, MA 02140, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Vertica Systems an HP Company, Cambridge, MA, USA","institution_ids":[]},{"raw_affiliation_string":"Vertica Systems, an HP Company, 150 Cambridge Park Dr, MA 02140, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5050665640","display_name":"Jaimin Dave","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jaimin Dave","raw_affiliation_strings":["Vertica Systems an HP Company, Cambridge, MA, USA","Vertica Systems, an HP Company, 150 Cambridge Park Dr, MA 02140, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Vertica Systems an HP Company, Cambridge, MA, USA","institution_ids":[]},{"raw_affiliation_string":"Vertica Systems, an HP Company, 150 Cambridge Park Dr, MA 02140, USA","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5083195789","display_name":"Sreenath Bodagala","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Sreenath Bodagala","raw_affiliation_strings":["Vertica Systems an HP Company, Cambridge, MA, USA","Vertica Systems, an HP Company, 150 Cambridge Park Dr, MA 02140, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Vertica Systems an HP Company, Cambridge, MA, USA","institution_ids":[]},{"raw_affiliation_string":"Vertica Systems, an HP Company, 150 Cambridge Park Dr, MA 02140, USA","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":5,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.6537,"has_fulltext":false,"cited_by_count":21,"citation_normalized_percentile":{"value":0.90530281,"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":"1084","last_page":"1095"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9993000030517578,"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.9993000030517578,"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.9983999729156494,"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/T11478","display_name":"Caching and Content Delivery","score":0.9944999814033508,"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.8331825733184814},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.5399918556213379},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.5363157391548157},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.48933762311935425},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4751298725605011},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.47384506464004517},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.46471747756004333},{"id":"https://openalex.org/keywords/projection","display_name":"Projection (relational algebra)","score":0.45766761898994446},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.4488511383533478},{"id":"https://openalex.org/keywords/physical-design","display_name":"Physical design","score":0.42419254779815674},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.39962857961654663},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.21783417463302612},{"id":"https://openalex.org/keywords/computer-network","display_name":"Computer network","score":0.10380858182907104},{"id":"https://openalex.org/keywords/embedded-system","display_name":"Embedded system","score":0.1011393666267395}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8331825733184814},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.5399918556213379},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.5363157391548157},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.48933762311935425},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4751298725605011},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.47384506464004517},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.46471747756004333},{"id":"https://openalex.org/C57493831","wikidata":"https://www.wikidata.org/wiki/Q3134666","display_name":"Projection (relational algebra)","level":2,"score":0.45766761898994446},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4488511383533478},{"id":"https://openalex.org/C188817802","wikidata":"https://www.wikidata.org/wiki/Q13426855","display_name":"Physical design","level":3,"score":0.42419254779815674},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.39962857961654663},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.21783417463302612},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.10380858182907104},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.1011393666267395},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0},{"id":"https://openalex.org/C190560348","wikidata":"https://www.wikidata.org/wiki/Q3245116","display_name":"Circuit design","level":2,"score":0.0},{"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/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde.2014.6816725","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2014.6816725","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":[{"score":0.4099999964237213,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":26,"referenced_works":["https://openalex.org/W180056467","https://openalex.org/W1496130826","https://openalex.org/W1497285001","https://openalex.org/W1553825122","https://openalex.org/W1851390469","https://openalex.org/W1969450725","https://openalex.org/W1997375126","https://openalex.org/W1999883293","https://openalex.org/W2006296837","https://openalex.org/W2017052417","https://openalex.org/W2017782374","https://openalex.org/W2033980616","https://openalex.org/W2108094106","https://openalex.org/W2108883953","https://openalex.org/W2122816893","https://openalex.org/W2123686039","https://openalex.org/W2125605956","https://openalex.org/W2160068753","https://openalex.org/W3011998105","https://openalex.org/W3021961968","https://openalex.org/W3138367763","https://openalex.org/W6607320512","https://openalex.org/W6629870147","https://openalex.org/W6638231387","https://openalex.org/W6638867933","https://openalex.org/W6678597633"],"related_works":["https://openalex.org/W2000785801","https://openalex.org/W986318368","https://openalex.org/W4245395944","https://openalex.org/W2384410913","https://openalex.org/W2143551613","https://openalex.org/W2352878646","https://openalex.org/W1979740464","https://openalex.org/W2004734601","https://openalex.org/W2130149817","https://openalex.org/W2990194547"],"abstract_inverted_index":{"In":[0,172],"this":[1],"paper,":[2],"we":[3],"present":[4,195],"Vertica's":[5],"customizable":[6],"physical":[7,34,198,226],"design":[8,35,97,127,170,182,199],"tool,":[9],"called":[10],"the":[11,113,140,150,189,196],"DBDesigner":[12],"(DBD),":[13],"that":[14,36,59,82,158,222,228],"produces":[15,224],"designs":[16,227],"optimized":[17,147],"for":[18],"various":[19],"scenarios":[20],"and":[21,27,44,108,119,145,168,191,210,215],"applications.":[22],"For":[23],"a":[24,33,53,166,230],"given":[25],"workload":[26],"space":[28],"budget,":[29],"DBD":[30,122,162,174,223],"automatically":[31],"recommends":[32],"optimizes":[37],"query":[38,117,156,192],"performance,":[39],"storage":[40,120],"footprint,":[41,121],"fault":[42],"tolerance":[43],"recovery":[45],"to":[46,148,155],"meet":[47],"different":[48,126],"customer":[49,233],"requirements.":[50],"Vertica":[51],"is":[52],"distributed,":[54],"massively":[55],"parallel":[56],"columnar":[57],"database":[58],"physically":[60],"organizes":[61],"data":[62,106,190],"into":[63],"projections.":[64],"Projections":[65],"are":[66,83,98,207],"attribute":[67],"subsets":[68],"from":[69],"one":[70,78],"or":[71,79,85,133],"more":[72,80],"tables":[73],"with":[74],"tuples":[75],"sorted":[76],"by":[77],"attributes,":[81],"replicated":[84],"segmented":[86],"(distributed)":[87],"on":[88,184],"cluster":[89,105],"nodes.":[90],"The":[91],"key":[92],"challenges":[93],"involved":[94],"in":[95,165,202],"projection":[96,181,205],"picking":[99],"appropriate":[100],"column":[101,109],"sets,":[102],"sort":[103],"orders,":[104],"distributions":[107],"encodings.":[110],"To":[111,153],"achieve":[112,149],"desired":[114,151],"trade-off":[115],"between":[116],"performance":[118],"operates":[123,164],"under":[124],"three":[125],"policies:":[128],"(a)":[129],"load-optimized,":[130],"(b)":[131],"query-optimized":[132],"(c)":[134],"balanced.":[135],"These":[136],"policies":[137],"indirectly":[138],"control":[139],"number":[141],"of":[142,180,232],"projections":[143],"proposed":[144],"queries":[146],"balance.":[152],"cater":[154],"workloads":[157],"evolve":[159],"over":[160],"time,":[161],"also":[163],"comprehensive":[167],"incremental":[169],"mode.":[171],"addition,":[173],"lets":[175],"users":[176],"override":[177],"specific":[178],"features":[179],"based":[183],"their":[185],"intimate":[186],"knowledge":[187],"about":[188],"workloads.":[193],"We":[194],"complete":[197],"algorithm,":[200],"describing":[201],"detail":[203],"how":[204],"candidates":[206],"efficiently":[208],"explored":[209],"evaluated":[211],"using":[212],"optimizer's":[213],"cost":[214],"benefit":[216],"model.":[217],"Our":[218],"experimental":[219],"results":[220],"show":[221],"good":[225],"satisfy":[229],"variety":[231],"use":[234],"cases.":[235]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":3},{"year":2016,"cited_by_count":4},{"year":2015,"cited_by_count":2}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}