{"id":"https://openalex.org/W2089795257","doi":"https://doi.org/10.1145/2076623.2076628","title":"A predictable storage model for scalable parallel DW","display_name":"A predictable storage model for scalable parallel DW","publication_year":2011,"publication_date":"2011-01-01","ids":{"openalex":"https://openalex.org/W2089795257","doi":"https://doi.org/10.1145/2076623.2076628","mag":"2089795257"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/2076623.2076628","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"proceedings-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/A5114375573","display_name":"Jo\u00e3o Pedro Costa","orcid":"https://orcid.org/0000-0003-2423-5181"},"institutions":[{"id":"https://openalex.org/I4210143597","display_name":"Instituto Superior de Educa\u00e7\u00e3o e Ci\u00eancias","ror":"https://ror.org/042vq9b25","country_code":"PT","type":"education","lineage":["https://openalex.org/I4210143597"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Jo\u00e3o Pedro Costa","raw_affiliation_strings":["ISEC-IPC, Rua Pedro Nunes, Coimbra, Portugal"],"affiliations":[{"raw_affiliation_string":"ISEC-IPC, Rua Pedro Nunes, Coimbra, Portugal","institution_ids":["https://openalex.org/I4210143597"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5007948994","display_name":"Jos\u00e9 Cec\u00edlio","orcid":"https://orcid.org/0000-0002-5351-5580"},"institutions":[{"id":"https://openalex.org/I76903346","display_name":"University of Coimbra","ror":"https://ror.org/04z8k9a98","country_code":"PT","type":"education","lineage":["https://openalex.org/I76903346"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Jos\u00e9 Cecilio","raw_affiliation_strings":["university of coimbra, coimbra, Portugal"],"affiliations":[{"raw_affiliation_string":"university of coimbra, coimbra, Portugal","institution_ids":["https://openalex.org/I76903346"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101805191","display_name":"Pedro Martins","orcid":"https://orcid.org/0000-0001-8984-4506"},"institutions":[{"id":"https://openalex.org/I76903346","display_name":"University of Coimbra","ror":"https://ror.org/04z8k9a98","country_code":"PT","type":"education","lineage":["https://openalex.org/I76903346"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Pedro Martins","raw_affiliation_strings":["university of coimbra, coimbra, Portugal"],"affiliations":[{"raw_affiliation_string":"university of coimbra, coimbra, Portugal","institution_ids":["https://openalex.org/I76903346"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5049382757","display_name":"Pedro Furtado","orcid":"https://orcid.org/0000-0001-6054-637X"},"institutions":[{"id":"https://openalex.org/I76903346","display_name":"University of Coimbra","ror":"https://ror.org/04z8k9a98","country_code":"PT","type":"education","lineage":["https://openalex.org/I76903346"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Pedro Furtado","raw_affiliation_strings":["university of coimbra, coimbra, Portugal"],"affiliations":[{"raw_affiliation_string":"university of coimbra, coimbra, Portugal","institution_ids":["https://openalex.org/I76903346"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.001,"has_fulltext":true,"fulltext_origin":"ngrams","cited_by_count":5,"citation_normalized_percentile":{"value":0.61635,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":80,"max":81},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9993,"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.9993,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9993,"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/T11106","display_name":"Data Management and Algorithms","score":0.996,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.536518},{"id":"https://openalex.org/keywords/storage-efficiency","display_name":"Storage efficiency","score":0.5169253},{"id":"https://openalex.org/keywords/column-oriented-database-systems","display_name":"Column-oriented Database Systems","score":0.507323},{"id":"https://openalex.org/keywords/storage-model","display_name":"Storage model","score":0.4965325},{"id":"https://openalex.org/keywords/storage-management","display_name":"Storage management","score":0.43488923},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.4331355},{"id":"https://openalex.org/keywords/data-striping","display_name":"Data striping","score":0.4268768}],"concepts":[{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.7897029},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7835631},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.54605126},{"id":"https://openalex.org/C121838778","wikidata":"https://www.wikidata.org/wiki/Q7619924","display_name":"Storage efficiency","level":2,"score":0.5169253},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.5136551},{"id":"https://openalex.org/C2779659223","wikidata":"https://www.wikidata.org/wiki/Q7619926","display_name":"Storage model","level":2,"score":0.4965325},{"id":"https://openalex.org/C2984984529","wikidata":"https://www.wikidata.org/wiki/Q7619925","display_name":"Storage management","level":2,"score":0.43488923},{"id":"https://openalex.org/C93996380","wikidata":"https://www.wikidata.org/wiki/Q44127","display_name":"Server","level":2,"score":0.43475938},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.4331355},{"id":"https://openalex.org/C33676613","wikidata":"https://www.wikidata.org/wiki/Q13415176","display_name":"Dimension (graph theory)","level":2,"score":0.42868835},{"id":"https://openalex.org/C83489325","wikidata":"https://www.wikidata.org/wiki/Q1332256","display_name":"Data striping","level":2,"score":0.4268768},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.42383084},{"id":"https://openalex.org/C194739806","wikidata":"https://www.wikidata.org/wiki/Q66221","display_name":"Computer data storage","level":2,"score":0.41362795},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.33164233},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.2132746},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.18971127},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.09192106},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/2076623.2076628","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[],"grants":[],"datasets":[],"versions":[],"referenced_works_count":14,"referenced_works":["https://openalex.org/W146226588","https://openalex.org/W148693950","https://openalex.org/W1510220247","https://openalex.org/W1549778201","https://openalex.org/W1576757369","https://openalex.org/W1578512165","https://openalex.org/W1800149304","https://openalex.org/W2035095545","https://openalex.org/W2043934800","https://openalex.org/W2080527146","https://openalex.org/W2104704499","https://openalex.org/W2114303224","https://openalex.org/W2132003106","https://openalex.org/W2167357284"],"related_works":["https://openalex.org/W2973989512","https://openalex.org/W2891918584","https://openalex.org/W2385404674","https://openalex.org/W2158302790","https://openalex.org/W2152692947","https://openalex.org/W2138634686","https://openalex.org/W2050153367","https://openalex.org/W2048333296","https://openalex.org/W2044519672","https://openalex.org/W1982302726"],"abstract_inverted_index":{"Star":[0],"schema":[1],"model,":[2,105],"has":[3],"been":[4],"widely":[5],"used":[6],"as":[7],"the":[8,71,80,89,122,127,132],"facto":[9],"DW":[10,103],"storage":[11,36,43,104],"organization":[12,37],"on":[13],"RDBMS.":[14],"Business":[15],"measures":[16],"are":[17],"stored":[18],"in":[19,54,58],"a":[20,26,39,48,55,101],"central":[21],"fact":[22,63],"table":[23],"along":[24],"with":[25,117],"set":[27],"of":[28,91,131],"foreign":[29],"keys":[30],"referencing":[31],"dimension":[32],"tables.":[33],"While":[34],"this":[35,95],"offers":[38],"good":[40],"trade-off":[41],"between":[42],"size":[44,82],"and":[45,84,99,110,114,129],"performance":[46],"for":[47],"single":[49],"node,":[50],"it":[51],"doesn't":[52,73],"scale":[53],"predictable":[56],"manner":[57],"shared-nothing":[59],"parallel":[60,92,102],"architectures.":[61],"Although":[62],"tables":[64],"can":[65],"be":[66],"linearly":[67],"partitioned":[68],"among":[69],"nodes,":[70],"same":[72],"apply":[74],"to":[75,88,125],"dimensions,":[76],"which":[77],"unbalances":[78],"(increases)":[79],"dimensions/fact_table":[81],"ratio,":[83],"consequently":[85],"introduces":[86],"limits":[87],"number":[90],"nodes.":[93],"In":[94],"paper":[96],"we":[97],"propose":[98],"evaluate":[100,126],"that":[106],"overcomes":[107],"these":[108],"limitations":[109],"deliver":[111],"optimal":[112],"speed-up":[113],"scale-up":[115],"capabilities":[116],"top":[118],"efficiency.":[119],"We":[120],"use":[121],"TPC-H":[123],"benchmark":[124],"scalability":[128],"efficiency":[130],"proposed":[133],"model.":[134]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2089795257","counts_by_year":[{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":1}],"updated_date":"2024-12-05T00:53:01.454653","created_date":"2016-06-24"}
