{"id":"https://openalex.org/W2547782634","doi":"https://doi.org/10.14778/3007263.3007273","title":"Hybrid row-column partitioning in teradata <sub>\u00ae</sub>","display_name":"Hybrid row-column partitioning in teradata <sub>\u00ae</sub>","publication_year":2016,"publication_date":"2016-09-01","ids":{"openalex":"https://openalex.org/W2547782634","doi":"https://doi.org/10.14778/3007263.3007273","mag":"2547782634"},"language":"en","primary_location":{"id":"doi:10.14778/3007263.3007273","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3007263.3007273","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-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/A5012231119","display_name":"Mohammed Al-Kateb","orcid":null},"institutions":[{"id":"https://openalex.org/I108650528","display_name":"Teradata (United Kingdom)","ror":"https://ror.org/00gze1672","country_code":"GB","type":"company","lineage":["https://openalex.org/I108650528","https://openalex.org/I4210158714"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Mohammed Al-Kateb","raw_affiliation_strings":["Teradata Labs"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Teradata Labs","institution_ids":["https://openalex.org/I108650528"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5000582349","display_name":"Paul Sinclair","orcid":null},"institutions":[{"id":"https://openalex.org/I108650528","display_name":"Teradata (United Kingdom)","ror":"https://ror.org/00gze1672","country_code":"GB","type":"company","lineage":["https://openalex.org/I108650528","https://openalex.org/I4210158714"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Paul Sinclair","raw_affiliation_strings":["Teradata Labs"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Teradata Labs","institution_ids":["https://openalex.org/I108650528"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5108760137","display_name":"Grace Au","orcid":null},"institutions":[{"id":"https://openalex.org/I108650528","display_name":"Teradata (United Kingdom)","ror":"https://ror.org/00gze1672","country_code":"GB","type":"company","lineage":["https://openalex.org/I108650528","https://openalex.org/I4210158714"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Grace Au","raw_affiliation_strings":["Teradata Labs"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Teradata Labs","institution_ids":["https://openalex.org/I108650528"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5056037203","display_name":"Carrie Ballinger","orcid":null},"institutions":[{"id":"https://openalex.org/I108650528","display_name":"Teradata (United Kingdom)","ror":"https://ror.org/00gze1672","country_code":"GB","type":"company","lineage":["https://openalex.org/I108650528","https://openalex.org/I4210158714"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Carrie Ballinger","raw_affiliation_strings":["Teradata Labs"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Teradata Labs","institution_ids":["https://openalex.org/I108650528"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I108650528"],"apc_list":null,"apc_paid":null,"fwci":1.6998,"has_fulltext":false,"cited_by_count":14,"citation_normalized_percentile":{"value":0.86767991,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":"9","issue":"13","first_page":"1353","last_page":"1364"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9997000098228455,"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.9997000098228455,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994000196456909,"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/T11269","display_name":"Algorithms and Data Compression","score":0.9976000189781189,"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/column","display_name":"Column (typography)","score":0.8106934428215027},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.754898190498352},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.5659159421920776},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.5522916316986084},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.502683162689209},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4756961762905121},{"id":"https://openalex.org/keywords/layer","display_name":"Layer (electronics)","score":0.4735549986362457},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.3279152512550354},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.10931411385536194},{"id":"https://openalex.org/keywords/chemistry","display_name":"Chemistry","score":0.07481762766838074}],"concepts":[{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.8106934428215027},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.754898190498352},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.5659159421920776},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.5522916316986084},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.502683162689209},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4756961762905121},{"id":"https://openalex.org/C2779227376","wikidata":"https://www.wikidata.org/wiki/Q6505497","display_name":"Layer (electronics)","level":2,"score":0.4735549986362457},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.3279152512550354},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.10931411385536194},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.07481762766838074},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C178790620","wikidata":"https://www.wikidata.org/wiki/Q11351","display_name":"Organic chemistry","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":1,"locations":[{"id":"doi:10.14778/3007263.3007273","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3007263.3007273","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":21,"referenced_works":["https://openalex.org/W206955312","https://openalex.org/W1482873624","https://openalex.org/W1519039476","https://openalex.org/W1604760506","https://openalex.org/W1971885140","https://openalex.org/W1997375126","https://openalex.org/W2006296837","https://openalex.org/W2016768048","https://openalex.org/W2040428289","https://openalex.org/W2081495863","https://openalex.org/W2085601491","https://openalex.org/W2105252819","https://openalex.org/W2106867122","https://openalex.org/W2116470353","https://openalex.org/W2123686039","https://openalex.org/W2128912667","https://openalex.org/W2150630976","https://openalex.org/W2159376715","https://openalex.org/W2161694911","https://openalex.org/W2396727930","https://openalex.org/W6679046037"],"related_works":["https://openalex.org/W986318368","https://openalex.org/W2000785801","https://openalex.org/W2384410913","https://openalex.org/W2352878646","https://openalex.org/W2004734601","https://openalex.org/W2130149817","https://openalex.org/W2990194547","https://openalex.org/W1480123525","https://openalex.org/W2620865396","https://openalex.org/W2414054180"],"abstract_inverted_index":{"Data":[0,22],"partitioning":[1,46,63,135],"is":[2,72],"an":[3],"indispensable":[4],"ingredient":[5],"of":[6,44,61,68,110,140],"database":[7,36],"systems":[8,37],"due":[9],"to":[10,17,122],"the":[11,86,91,102,107,138],"performance":[12,129,139],"improvement":[13],"it":[14],"can":[15,23],"bring":[16],"any":[18],"given":[19],"mixed":[20,42],"workload.":[21],"be":[24],"partitioned":[25,123],"horizontally":[26],"or":[27,41,77],"vertically.":[28],"While":[29],"some":[30],"commercial":[31],"proprietary":[32],"and":[33,83,105],"open":[34],"source":[35],"have":[38],"one":[39],"flavor":[40],"flavors":[43],"these":[45,62],"forms,":[47],"Teradata":[48],"Database":[49],"offers":[50],"a":[51,128],"unique":[52],"hybrid":[53,70],"row-column":[54,112],"store":[55],"solution":[56,71],"that":[57,73,131],"seamlessly":[58],"combines":[59],"both":[60],"schemes.":[64],"The":[65],"key":[66],"feature":[67],"this":[69,98],"either":[74],"row,":[75],"column,":[76],"combined":[78],"partitions":[79],"are":[80],"all":[81],"stored":[82],"handled":[84],"in":[85],"same":[87],"way":[88],"internally":[89],"by":[90],"underlying":[92],"file":[93],"system":[94],"storage":[95],"layer.":[96],"In":[97],"paper,":[99],"we":[100,126],"present":[101,127],"main":[103],"characteristics":[104],"explain":[106],"implementation":[108],"approach":[109],"Teradata's":[111],"store.":[113],"We":[114],"also":[115],"discuss":[116],"query":[117],"optimization":[118],"techniques":[119],"applicable":[120],"specifically":[121],"tables.":[124],"Furthermore,":[125],"study":[130],"demonstrates":[132],"how":[133],"different":[134],"options":[136],"impact":[137],"various":[141],"queries.":[142]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2024,"cited_by_count":3},{"year":2022,"cited_by_count":1},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}