{"id":"https://openalex.org/W1997375126","doi":"https://doi.org/10.1145/1007568.1007609","title":"Integrating vertical and horizontal partitioning into automated physical database design","display_name":"Integrating vertical and horizontal partitioning into automated physical database design","publication_year":2004,"publication_date":"2004-06-13","ids":{"openalex":"https://openalex.org/W1997375126","doi":"https://doi.org/10.1145/1007568.1007609","mag":"1997375126"},"language":"en","primary_location":{"id":"doi:10.1145/1007568.1007609","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1007568.1007609","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2004 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/A5026778292","display_name":"Sanjay Agrawal","orcid":"https://orcid.org/0000-0003-2963-6662"},"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"]},{"id":"https://openalex.org/I4210164937","display_name":"Microsoft Research (United Kingdom)","ror":"https://ror.org/05k87vq12","country_code":"GB","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210164937"]}],"countries":["GB","US"],"is_corresponding":false,"raw_author_name":"Sanjay Agrawal","raw_affiliation_strings":["Microsoft Research","Microsoft research#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Research","institution_ids":["https://openalex.org/I4210164937"]},{"raw_affiliation_string":"Microsoft research#TAB#","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063257827","display_name":"Vivek Narasayya","orcid":"https://orcid.org/0000-0001-7011-7886"},"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"]},{"id":"https://openalex.org/I4210164937","display_name":"Microsoft Research (United Kingdom)","ror":"https://ror.org/05k87vq12","country_code":"GB","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210164937"]}],"countries":["GB","US"],"is_corresponding":false,"raw_author_name":"Vivek Narasayya","raw_affiliation_strings":["Microsoft Research","Microsoft research#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Research","institution_ids":["https://openalex.org/I4210164937"]},{"raw_affiliation_string":"Microsoft research#TAB#","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5102091012","display_name":"Beverly Yang","orcid":null},"institutions":[{"id":"https://openalex.org/I97018004","display_name":"Stanford University","ror":"https://ror.org/00f54p054","country_code":"US","type":"education","lineage":["https://openalex.org/I97018004"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Beverly Yang","raw_affiliation_strings":["Stanford University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Stanford University","institution_ids":["https://openalex.org/I97018004"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":8.7333,"has_fulltext":false,"cited_by_count":403,"citation_normalized_percentile":{"value":0.97761625,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":94,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"359","last_page":"370"},"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.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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9973999857902527,"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.7094258666038513},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5513102412223816},{"id":"https://openalex.org/keywords/horizontal-and-vertical","display_name":"Horizontal and vertical","score":0.4770488142967224},{"id":"https://openalex.org/keywords/physical-design","display_name":"Physical design","score":0.47645142674446106},{"id":"https://openalex.org/keywords/geology","display_name":"Geology","score":0.23889771103858948},{"id":"https://openalex.org/keywords/embedded-system","display_name":"Embedded system","score":0.16604873538017273},{"id":"https://openalex.org/keywords/geodesy","display_name":"Geodesy","score":0.09299319982528687},{"id":"https://openalex.org/keywords/circuit-design","display_name":"Circuit design","score":0.07591459155082703}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7094258666038513},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5513102412223816},{"id":"https://openalex.org/C59218005","wikidata":"https://www.wikidata.org/wiki/Q17027571","display_name":"Horizontal and vertical","level":2,"score":0.4770488142967224},{"id":"https://openalex.org/C188817802","wikidata":"https://www.wikidata.org/wiki/Q13426855","display_name":"Physical design","level":3,"score":0.47645142674446106},{"id":"https://openalex.org/C127313418","wikidata":"https://www.wikidata.org/wiki/Q1069","display_name":"Geology","level":0,"score":0.23889771103858948},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.16604873538017273},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.09299319982528687},{"id":"https://openalex.org/C190560348","wikidata":"https://www.wikidata.org/wiki/Q3245116","display_name":"Circuit design","level":2,"score":0.07591459155082703}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1007568.1007609","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1007568.1007609","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2004 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.94.8455","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.94.8455","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.brown.edu/courses/cs227/Papers/AutoAdmin/partitioning.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W102249687","https://openalex.org/W1506285740","https://openalex.org/W1528326260","https://openalex.org/W1851390469","https://openalex.org/W1987995589","https://openalex.org/W2055468282","https://openalex.org/W2063601856","https://openalex.org/W2064523382","https://openalex.org/W2103412498","https://openalex.org/W2105252819","https://openalex.org/W2113888164","https://openalex.org/W2114679600","https://openalex.org/W2122816893","https://openalex.org/W2128941761","https://openalex.org/W2130642985","https://openalex.org/W2148291485","https://openalex.org/W2168503413","https://openalex.org/W2296408038","https://openalex.org/W4245927080","https://openalex.org/W6604094656","https://openalex.org/W6679817081","https://openalex.org/W6697509846"],"related_works":["https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2374348909","https://openalex.org/W2317981192","https://openalex.org/W2376987262","https://openalex.org/W4210556059","https://openalex.org/W2111632484","https://openalex.org/W4385780992","https://openalex.org/W1965641473","https://openalex.org/W2380525008"],"abstract_inverted_index":{"In":[0,105],"addition":[1],"to":[2,44,117,154],"indexes":[3,35,79],"and":[4,8,36,80,127,136,158],"materialized":[5,81],"views,":[6],"horizontal":[7],"vertical":[9],"partitioning":[10,27,53,57,72],"are":[11],"important":[12],"aspects":[13],"of":[14,61,71,78,88,149,162],"physical":[15,63,89,120,156],"design":[16,64,90,121,157],"in":[17],"a":[18,99,114],"relational":[19],"database":[20,31],"system":[21],"that":[22,123],"significantly":[23],"impact":[24],"performance.":[25],"Horizontal":[26],"also":[28],"provides":[29],"manageability;":[30],"administrators":[32],"often":[33],"require":[34],"their":[37],"underlying":[38],"tables":[39],"partitioned":[40],"identically":[41],"so":[42],"as":[43,49],"make":[45],"common":[46],"operations":[47],"such":[48],"backup/restore":[50],"easier.":[51],"While":[52],"is":[54],"important,":[55],"incorporating":[56],"makes":[58],"the":[59,103,147,160],"problem":[60,122],"automating":[62],"much":[65],"harder":[66],"since:":[67],"(a)":[68,146],"The":[69],"choices":[70,77],"can":[73],"strongly":[74],"interact":[75],"with":[76],"views.":[82],"(b)":[83,159],"A":[84],"large":[85],"new":[86,100],"space":[87],"alternatives":[91],"must":[92],"be":[93],"considered.":[94],"(c)":[95],"Manageability":[96],"requirements":[97],"impose":[98],"constraint":[101],"on":[102,139],"problem.":[104],"this":[106,118],"paper,":[107],"we":[108],"present":[109],"novel":[110],"techniques":[111,135],"for":[112],"designing":[113],"scalable":[115],"solution":[116],"integrated":[119,152],"takes":[124],"both":[125],"performance":[126],"manageability":[128],"into":[129],"account.":[130],"We":[131],"have":[132],"implemented":[133],"our":[134,163],"evaluated":[137],"it":[138],"Microsoft":[140],"SQL":[141],"Server.":[142],"Our":[143],"experiments":[144],"highlight:":[145],"importance":[148],"taking":[150],"an":[151],"approach":[153],"automated":[155],"scalability":[161],"techniques.":[164],"1.":[165]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":5},{"year":2023,"cited_by_count":7},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":19},{"year":2020,"cited_by_count":12},{"year":2019,"cited_by_count":35},{"year":2018,"cited_by_count":27},{"year":2017,"cited_by_count":30},{"year":2016,"cited_by_count":20},{"year":2015,"cited_by_count":20},{"year":2014,"cited_by_count":25},{"year":2013,"cited_by_count":31},{"year":2012,"cited_by_count":33}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}