{"id":"https://openalex.org/W1988782852","doi":"https://doi.org/10.1145/1353343.1353367","title":"Load distribution of analytical query workloads for database cluster architectures","display_name":"Load distribution of analytical query workloads for database cluster architectures","publication_year":2008,"publication_date":"2008-03-25","ids":{"openalex":"https://openalex.org/W1988782852","doi":"https://doi.org/10.1145/1353343.1353367","mag":"1988782852"},"language":"en","primary_location":{"id":"doi:10.1145/1353343.1353367","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1353343.1353367","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 11th international conference on Extending database technology: Advances in 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/A5113481947","display_name":"Thomas Phan","orcid":null},"institutions":[{"id":"https://openalex.org/I4210134091","display_name":"Yahoo (United States)","ror":"https://ror.org/040dkzz12","country_code":"US","type":"company","lineage":["https://openalex.org/I4210134091"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Thomas Phan","raw_affiliation_strings":["Yahoo!, Inc., Sunnyvale, CA"],"affiliations":[{"raw_affiliation_string":"Yahoo!, Inc., Sunnyvale, CA","institution_ids":["https://openalex.org/I4210134091"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5018226361","display_name":"Wen\u2010Syan Li","orcid":null},"institutions":[{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Wen-Syan Li","raw_affiliation_strings":["IBM Almaden Research Center, San Jose, CA","IBM Almaden Research Center San Jose , CA"],"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center San Jose , CA","institution_ids":["https://openalex.org/I4210085935"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5113481947"],"corresponding_institution_ids":["https://openalex.org/I4210134091"],"apc_list":null,"apc_paid":null,"fwci":3.4987,"has_fulltext":true,"cited_by_count":7,"citation_normalized_percentile":{"value":0.93253452,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"169","last_page":"180"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9997000098228455,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9997000098228455,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9995999932289124,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9987999796867371,"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.8655400276184082},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.7324067950248718},{"id":"https://openalex.org/keywords/server","display_name":"Server","score":0.6555722951889038},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.6416293978691101},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6135029792785645},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.49418380856513977},{"id":"https://openalex.org/keywords/pooling","display_name":"Pooling","score":0.4418484568595886},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.4321303367614746},{"id":"https://openalex.org/keywords/online-aggregation","display_name":"Online aggregation","score":0.41725248098373413},{"id":"https://openalex.org/keywords/scheduling","display_name":"Scheduling (production processes)","score":0.4145013988018036},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.41009122133255005},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.3816326856613159},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.35065826773643494},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.24491074681282043},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.21937981247901917},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.16576489806175232},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.16118130087852478},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.11161017417907715}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8655400276184082},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.7324067950248718},{"id":"https://openalex.org/C93996380","wikidata":"https://www.wikidata.org/wiki/Q44127","display_name":"Server","level":2,"score":0.6555722951889038},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.6416293978691101},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6135029792785645},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.49418380856513977},{"id":"https://openalex.org/C70437156","wikidata":"https://www.wikidata.org/wiki/Q7228652","display_name":"Pooling","level":2,"score":0.4418484568595886},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.4321303367614746},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.41725248098373413},{"id":"https://openalex.org/C206729178","wikidata":"https://www.wikidata.org/wiki/Q2271896","display_name":"Scheduling (production processes)","level":2,"score":0.4145013988018036},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.41009122133255005},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.3816326856613159},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.35065826773643494},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.24491074681282043},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.21937981247901917},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.16576489806175232},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.16118130087852478},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.11161017417907715},{"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/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1353343.1353367","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1353343.1353367","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 11th international conference on Extending database technology: Advances in database technology","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.332.4078","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.332.4078","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.edbt.org/Proceedings/2008-Nantes/papers/p169-Phan.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.550000011920929,"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":40,"referenced_works":["https://openalex.org/W99733817","https://openalex.org/W1480446516","https://openalex.org/W1507363803","https://openalex.org/W1508419498","https://openalex.org/W1510589943","https://openalex.org/W1512383952","https://openalex.org/W1553825122","https://openalex.org/W1575315738","https://openalex.org/W1639032689","https://openalex.org/W1659842140","https://openalex.org/W1867342743","https://openalex.org/W1989532930","https://openalex.org/W2007178619","https://openalex.org/W2025397485","https://openalex.org/W2026102701","https://openalex.org/W2033195458","https://openalex.org/W2034091599","https://openalex.org/W2036034762","https://openalex.org/W2094806030","https://openalex.org/W2096674153","https://openalex.org/W2099918651","https://openalex.org/W2104549760","https://openalex.org/W2105252819","https://openalex.org/W2122816893","https://openalex.org/W2126321570","https://openalex.org/W2146438496","https://openalex.org/W2151037077","https://openalex.org/W2152150600","https://openalex.org/W2157841445","https://openalex.org/W2160770337","https://openalex.org/W2168853665","https://openalex.org/W2330374543","https://openalex.org/W3023540311","https://openalex.org/W4214597316","https://openalex.org/W4238925974","https://openalex.org/W4285719527","https://openalex.org/W6604080727","https://openalex.org/W6630399596","https://openalex.org/W6659251782","https://openalex.org/W6683569312"],"related_works":["https://openalex.org/W2554271401","https://openalex.org/W2889903446","https://openalex.org/W2382405670","https://openalex.org/W2992414350","https://openalex.org/W3125756434","https://openalex.org/W2150741898","https://openalex.org/W3087188470","https://openalex.org/W4281289408","https://openalex.org/W1564408968","https://openalex.org/W2942097156"],"abstract_inverted_index":{"Enterprises":[0],"may":[1],"have":[2],"multiple":[3],"database":[4,57,75],"systems":[5],"spread":[6],"across":[7,25,73],"the":[8,53,91,95,98,103,107,112,122,125,138,144,150,164,212,253],"organization":[9],"for":[10,13,28,66,227],"redundancy":[11],"or":[12,34],"serving":[14],"different":[15,26],"applications.":[16],"In":[17,59],"such":[18],"systems,":[19],"query":[20,71,99],"workloads":[21,72],"can":[22,47,109,140],"be":[23,48,141],"distributed":[24],"servers":[27],"better":[29,221,250],"performance.":[30],"A":[31],"materialized":[32],"view,":[33],"Materialized":[35],"Query":[36],"Table":[37],"(MQT),":[38],"is":[39,83,161,245],"an":[40,187,196,216,259],"auxiliary":[41],"table":[42],"with":[43,77,156,195],"pre-computed":[44],"data":[45],"that":[46,137,160,177],"used":[49],"to":[50,88,93,258],"significantly":[51],"improve":[52],"performance":[54],"of":[55,69,102,124,134,166,182,211,236,264],"a":[56,64,74,132,153,157,173,179,234,239],"query.":[58],"this":[60],"paper,":[61],"we":[62,86],"propose":[63],"framework":[65],"coordinating":[67],"execution":[68,100],"OLAP":[70],"cluster":[76],"shared":[78],"nothing":[79],"architecture.":[80],"Such":[81],"coordination":[82],"complex":[84],"since":[85],"need":[87],"consider":[89],"(1)":[90],"time":[92,146,190],"build":[94],"MQTs,":[96,104,168],"(2)":[97],"impact":[101],"(3)":[105],"whether":[106],"MQTs":[108],"fit":[110],"in":[111,130,143,163],"disk":[113,243],"space":[114,159,244],"limitation,":[115],"(4)":[116],"server":[117],"computation":[118],"power,":[119],"and":[120,127,169,184,191,199,219,230],"(5)":[121],"effectiveness":[123],"scheduling":[126],"placement":[128],"algorithms":[129,226],"deriving":[131],"combination":[133],"configurations":[135],"so":[136],"workload":[139],"completed":[142],"shortest":[145],"period.":[147],"We":[148,171],"frame":[149],"problem":[151,155],"as":[152],"combinatorial":[154],"solution":[158,194],"exponential":[162],"number":[165],"queries,":[167],"servers.":[170],"provide":[172],"stochastic":[174],"search":[175,198,205,218],"heuristic":[176],"finds":[178],"near-optimal":[180],"mapping":[181],"queries-to-servers":[183],"MQTs-to-servers":[185],"within":[186,209],"arbitrarily":[188],"bounded":[189],"compare":[192],"our":[193],"exhaustive":[197,217],"three":[200],"standard":[201],"greedy":[202,225],"algorithms.":[203],"Our":[204],"implementation":[206],"produced":[207,220,248],"schedules":[208],"9%":[210],"optimal":[213],"found":[214],"through":[215],"solutions":[222],"than":[223,252],"typical":[224],"both":[228],"TPC-H":[229],"synthetic":[231],"benchmarks":[232],"under":[233],"variety":[235],"experiments.":[237],"For":[238],"key":[240],"trial":[241],"where":[242],"limited,":[246],"it":[247],"15%":[249],"results":[251],"next":[254],"best":[255],"competitor,":[256],"corresponding":[257],"absolute":[260],"wall":[261],"clock":[262],"advantage":[263],"over":[265],"10":[266],"hours.":[267]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}