{"id":"https://openalex.org/W2153109267","doi":"https://doi.org/10.1145/2396761.2398604","title":"A new tool for multi-level partitioning in teradata","display_name":"A new tool for multi-level partitioning in teradata","publication_year":2012,"publication_date":"2012-10-29","ids":{"openalex":"https://openalex.org/W2153109267","doi":"https://doi.org/10.1145/2396761.2398604","mag":"2153109267"},"language":"en","primary_location":{"id":"doi:10.1145/2396761.2398604","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2396761.2398604","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 21st ACM international conference on Information and knowledge management","raw_type":"proceedings-article"},"type":"conference-paper","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/A5101626811","display_name":"Young\u2010Kyoon Suh","orcid":"https://orcid.org/0000-0003-3124-2566"},"institutions":[{"id":"https://openalex.org/I138006243","display_name":"University of Arizona","ror":"https://ror.org/03m2x1q45","country_code":"US","type":"education","lineage":["https://openalex.org/I138006243"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Young-Kyoon Suh","raw_affiliation_strings":["University of Arizona, Tucson, AZ, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Arizona, Tucson, AZ, USA","institution_ids":["https://openalex.org/I138006243"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5111758876","display_name":"Ahmad Ghazal","orcid":null},"institutions":[{"id":"https://openalex.org/I4210158714","display_name":"Teradata (United States)","ror":"https://ror.org/04vkkat38","country_code":"US","type":"company","lineage":["https://openalex.org/I4210158714"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ahmad Ghazal","raw_affiliation_strings":["Teradata Corporation, El Segundo, CA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Teradata Corporation, El Segundo, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5041372923","display_name":"Alain Crolotte","orcid":null},"institutions":[{"id":"https://openalex.org/I4210158714","display_name":"Teradata (United States)","ror":"https://ror.org/04vkkat38","country_code":"US","type":"company","lineage":["https://openalex.org/I4210158714"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Alain Crolotte","raw_affiliation_strings":["Teradata Corporation, El Segundo, CA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Teradata Corporation, El Segundo, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5049019411","display_name":"Pekka Kostamaa","orcid":"https://orcid.org/0000-0001-8224-6220"},"institutions":[{"id":"https://openalex.org/I4210158714","display_name":"Teradata (United States)","ror":"https://ror.org/04vkkat38","country_code":"US","type":"company","lineage":["https://openalex.org/I4210158714"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Pekka Kostamaa","raw_affiliation_strings":["Teradata Corporation, El Segundo, CA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Teradata Corporation, El Segundo, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.283,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.52032122,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"2214","last_page":"2218"},"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.9993000030517578,"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.9993000030517578,"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.9991999864578247,"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/T12292","display_name":"Graph Theory and Algorithms","score":0.9894000291824341,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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.8282392621040344},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.7001777291297913},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.6189898252487183},{"id":"https://openalex.org/keywords/partition","display_name":"Partition (number theory)","score":0.5931872725486755},{"id":"https://openalex.org/keywords/cluster-analysis","display_name":"Cluster analysis","score":0.5162310600280762},{"id":"https://openalex.org/keywords/predicate","display_name":"Predicate (mathematical logic)","score":0.4945981204509735},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.46345254778862},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.44662365317344666},{"id":"https://openalex.org/keywords/scheme","display_name":"Scheme (mathematics)","score":0.43166959285736084},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3788636326789856},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3323504328727722},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.24115818738937378},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.18269336223602295},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.14476892352104187},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.08952882885932922}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8282392621040344},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.7001777291297913},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.6189898252487183},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.5931872725486755},{"id":"https://openalex.org/C73555534","wikidata":"https://www.wikidata.org/wiki/Q622825","display_name":"Cluster analysis","level":2,"score":0.5162310600280762},{"id":"https://openalex.org/C140146324","wikidata":"https://www.wikidata.org/wiki/Q1144319","display_name":"Predicate (mathematical logic)","level":2,"score":0.4945981204509735},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.46345254778862},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.44662365317344666},{"id":"https://openalex.org/C77618280","wikidata":"https://www.wikidata.org/wiki/Q1155772","display_name":"Scheme (mathematics)","level":2,"score":0.43166959285736084},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3788636326789856},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3323504328727722},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.24115818738937378},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.18269336223602295},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.14476892352104187},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.08952882885932922},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2396761.2398604","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2396761.2398604","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 21st ACM international conference on Information and knowledge management","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":5,"referenced_works":["https://openalex.org/W1521464082","https://openalex.org/W1997375126","https://openalex.org/W2140342613","https://openalex.org/W2148291485","https://openalex.org/W3011998105"],"related_works":["https://openalex.org/W2000785801","https://openalex.org/W986318368","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":{"This":[0,52],"paper":[1],"introduces":[2],"a":[3,19,32,36,66,103,183,195],"new":[4,33],"tool":[5,30,85,107,157,193],"that":[6,124,188,202],"recommends":[7],"an":[8],"optimized":[9],"partitioning":[10,169],"solution":[11,204],"called":[12],"Multi-Level":[13],"Partitioned":[14],"Primary":[15],"Index":[16],"(MLPPI)":[17],"for":[18,39,76,101],"fact":[20,141,217],"table":[21,142],"based":[22,64,87,171],"on":[23,65,88,110,172],"the":[24,27,50,57,84,89,98,111,115,135,149,156,189,192,203,209,213,216],"queries":[25],"in":[26,49,83],"workload.":[28],"The":[29,43,79,106,129,151,198],"implements":[31],"technique":[34,53],"using":[35,69],"greedy":[37],"algorithm":[38],"search":[40,99],"space":[41,44,100],"enumeration.":[42],"is":[45,63,86,94,158,205],"driven":[46],"by":[47,155],"predicates":[48,143],"queries.":[51],"fits":[54],"very":[55],"well":[56],"Teradata":[58,90],"MLPPI":[59],"scheme,":[60],"as":[61,119],"it":[62,93,161],"general":[67,70],"framework":[68],"expressions,":[71],"ranges":[72],"and":[73,92,113,138,144,160,212],"case":[74],"expressions":[75,175],"partition":[77],"definitions.":[78],"cost":[80],"model":[81],"implemented":[82,154],"optimizer,":[91],"used":[95,132],"to":[96,121,133,139,147,165],"prune":[97],"reaching":[102],"final":[104],"solution.":[105],"resides":[108],"completely":[109],"client,":[112],"interfaces":[114],"database":[116],"through":[117],"APIs":[118,130],"opposed":[120],"previous":[122],"work":[123],"requires":[125],"optimizer":[126],"code":[127],"extension.":[128],"are":[131],"simplify":[134],"workload":[136,185,210],"queries,":[137],"capture":[140],"costs":[145],"necessary":[146],"make":[148],"recommendation.":[150],"predicate-driven":[152],"method":[153],"general,":[159],"can":[162],"be":[163],"applied":[164],"any":[166],"clustering":[167],"or":[168,176],"scheme":[170],"simple":[173],"field":[174],"complex":[177],"SQL":[178],"predicates.":[179],"Experimental":[180],"results":[181],"given":[182],"particular":[184],"will":[186],"show":[187,201],"recommendation":[190],"from":[191],"outperforms":[194],"human":[196],"expert.":[197],"experiments":[199],"also":[200],"scalable":[206],"both":[207],"with":[208],"complexity":[211],"size":[214],"of":[215],"table.":[218]},"counts_by_year":[{"year":2018,"cited_by_count":1},{"year":2014,"cited_by_count":1}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}