{"id":"https://openalex.org/W2035165235","doi":"https://doi.org/10.4018/jdm.2012100102","title":"Effectively and Efficiently Designing and Querying Parallel Relational Data Warehouses on Heterogeneous Database Clusters","display_name":"Effectively and Efficiently Designing and Querying Parallel Relational Data Warehouses on Heterogeneous Database Clusters","publication_year":2012,"publication_date":"2012-10-01","ids":{"openalex":"https://openalex.org/W2035165235","doi":"https://doi.org/10.4018/jdm.2012100102","mag":"2035165235"},"language":"en","primary_location":{"id":"doi:10.4018/jdm.2012100102","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdm.2012100102","pdf_url":null,"source":{"id":"https://openalex.org/S73024538","display_name":"Journal of Database Management","issn_l":"1063-8016","issn":["1063-8016","1533-8010"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Database Management","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/A5006507514","display_name":"Ladjel Bellatreche","orcid":"https://orcid.org/0000-0001-9968-0066"},"institutions":[{"id":"https://openalex.org/I171246369","display_name":"\u00c9cole Nationale Sup\u00e9rieure de M\u00e9canique et d'A\u00e9rotechnique","ror":"https://ror.org/04jx68594","country_code":"FR","type":"facility","lineage":["https://openalex.org/I171246369"]},{"id":"https://openalex.org/I4210116740","display_name":"Laboratoire d'Informatique et d'Automatique pour les Syst\u00e8mes","ror":"https://ror.org/02b5vq778","country_code":"FR","type":"facility","lineage":["https://openalex.org/I171246369","https://openalex.org/I32881790","https://openalex.org/I4210116740"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Ladjel Bellatreche","raw_affiliation_strings":["LIAS/ENSMA, Poitiers University, Futuroscope Chasseneuil Cedex, France","IDD - Ing\u00e9nierie des Donn\u00e9es et des moD\u00e8les (Laboratoire LIAS - ENSIP B\u00e2timent B25 - 2 rue Pierre Brousse TSA 41105 86073 Poitiers Cedex 9 France \r\nLaboratoire LIAS - ISAE-ENSMA T\u00e9l\u00e9port 2 - 1 avenue Cl\u00e9ment Ader BP 40109 86961 Chasseneuil France  - France)","LIAS [Poitiers] - Laboratoire d'informatique et d'automatique pour les syst\u00e8mes [EA 6315] (LISI-ENSMA T\u00e9l\u00e9port 2 \u2013 1 avenue Cl\u00e9ment Ader \u2013 BP 40109 \u2013 86961 Futuroscope Chasseneuil cedex \u2013 france - France)"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"LIAS/ENSMA, Poitiers University, Futuroscope Chasseneuil Cedex, France","institution_ids":["https://openalex.org/I171246369"]},{"raw_affiliation_string":"IDD - Ing\u00e9nierie des Donn\u00e9es et des moD\u00e8les (Laboratoire LIAS - ENSIP B\u00e2timent B25 - 2 rue Pierre Brousse TSA 41105 86073 Poitiers Cedex 9 France \r\nLaboratoire LIAS - ISAE-ENSMA T\u00e9l\u00e9port 2 - 1 avenue Cl\u00e9ment Ader BP 40109 86961 Chasseneuil France  - France)","institution_ids":["https://openalex.org/I171246369"]},{"raw_affiliation_string":"LIAS [Poitiers] - Laboratoire d'informatique et d'automatique pour les syst\u00e8mes [EA 6315] (LISI-ENSMA T\u00e9l\u00e9port 2 \u2013 1 avenue Cl\u00e9ment Ader \u2013 BP 40109 \u2013 86961 Futuroscope Chasseneuil cedex \u2013 france - France)","institution_ids":["https://openalex.org/I171246369","https://openalex.org/I4210116740"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5053225136","display_name":"Alfredo Cuzzocrea","orcid":"https://orcid.org/0000-0002-7104-6415"},"institutions":[{"id":"https://openalex.org/I45204951","display_name":"University of Calabria","ror":"https://ror.org/02rc97e94","country_code":"IT","type":"education","lineage":["https://openalex.org/I45204951"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Alfredo Cuzzocrea","raw_affiliation_strings":["ICAR-CNR, ItalyF&AUniversity of Calabria, Renede, Italy"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"ICAR-CNR, ItalyF&AUniversity of Calabria, Renede, Italy","institution_ids":["https://openalex.org/I45204951"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5062934077","display_name":"Soumia Benkrid","orcid":null},"institutions":[{"id":"https://openalex.org/I171246369","display_name":"\u00c9cole Nationale Sup\u00e9rieure de M\u00e9canique et d'A\u00e9rotechnique","ror":"https://ror.org/04jx68594","country_code":"FR","type":"facility","lineage":["https://openalex.org/I171246369"]},{"id":"https://openalex.org/I4210116740","display_name":"Laboratoire d'Informatique et d'Automatique pour les Syst\u00e8mes","ror":"https://ror.org/02b5vq778","country_code":"FR","type":"facility","lineage":["https://openalex.org/I171246369","https://openalex.org/I32881790","https://openalex.org/I4210116740"]},{"id":"https://openalex.org/I4210149016","display_name":"\u00c9cole Nationale Sup\u00e9rieure d'Informatique","ror":"https://ror.org/04dj1dn66","country_code":"DZ","type":"education","lineage":["https://openalex.org/I4210149016"]}],"countries":["DZ","FR"],"is_corresponding":false,"raw_author_name":"Soumia Benkrid","raw_affiliation_strings":["National High School for Computer Science (ESI), Algiers, Algeria","IDD - Ing\u00e9nierie des Donn\u00e9es et des moD\u00e8les (Laboratoire LIAS - ENSIP B\u00e2timent B25 - 2 rue Pierre Brousse TSA 41105 86073 Poitiers Cedex 9 France \r\nLaboratoire LIAS - ISAE-ENSMA T\u00e9l\u00e9port 2 - 1 avenue Cl\u00e9ment Ader BP 40109 86961 Chasseneuil France  - France)","LIAS [Poitiers] - Laboratoire d'informatique et d'automatique pour les syst\u00e8mes [EA 6315] (LISI-ENSMA T\u00e9l\u00e9port 2 \u2013 1 avenue Cl\u00e9ment Ader \u2013 BP 40109 \u2013 86961 Futuroscope Chasseneuil cedex \u2013 france - France)"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"National High School for Computer Science (ESI), Algiers, Algeria","institution_ids":["https://openalex.org/I4210149016"]},{"raw_affiliation_string":"IDD - Ing\u00e9nierie des Donn\u00e9es et des moD\u00e8les (Laboratoire LIAS - ENSIP B\u00e2timent B25 - 2 rue Pierre Brousse TSA 41105 86073 Poitiers Cedex 9 France \r\nLaboratoire LIAS - ISAE-ENSMA T\u00e9l\u00e9port 2 - 1 avenue Cl\u00e9ment Ader BP 40109 86961 Chasseneuil France  - France)","institution_ids":["https://openalex.org/I171246369"]},{"raw_affiliation_string":"LIAS [Poitiers] - Laboratoire d'informatique et d'automatique pour les syst\u00e8mes [EA 6315] (LISI-ENSMA T\u00e9l\u00e9port 2 \u2013 1 avenue Cl\u00e9ment Ader \u2013 BP 40109 \u2013 86961 Futuroscope Chasseneuil cedex \u2013 france - France)","institution_ids":["https://openalex.org/I171246369","https://openalex.org/I4210116740"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":4,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.303,"has_fulltext":false,"cited_by_count":24,"citation_normalized_percentile":{"value":0.92144075,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":"23","issue":"4","first_page":"17","last_page":"51"},"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.9991999864578247,"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.9991999864578247,"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.9990000128746033,"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.9988999962806702,"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/computer-science","display_name":"Computer science","score":0.7195833921432495},{"id":"https://openalex.org/keywords/fragmentation","display_name":"Fragmentation (computing)","score":0.6265567541122437},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.5077670812606812},{"id":"https://openalex.org/keywords/formalism","display_name":"Formalism (music)","score":0.48409855365753174},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.45765671133995056},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.4374251961708069},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.4264678359031677},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4264237582683563},{"id":"https://openalex.org/keywords/cluster-analysis","display_name":"Cluster analysis","score":0.41679757833480835},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.36920201778411865},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.33526498079299927},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.11126399040222168}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7195833921432495},{"id":"https://openalex.org/C191015642","wikidata":"https://www.wikidata.org/wiki/Q1132459","display_name":"Fragmentation (computing)","level":2,"score":0.6265567541122437},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.5077670812606812},{"id":"https://openalex.org/C73301696","wikidata":"https://www.wikidata.org/wiki/Q5469984","display_name":"Formalism (music)","level":3,"score":0.48409855365753174},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.45765671133995056},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.4374251961708069},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.4264678359031677},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4264237582683563},{"id":"https://openalex.org/C73555534","wikidata":"https://www.wikidata.org/wiki/Q622825","display_name":"Cluster analysis","level":2,"score":0.41679757833480835},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.36920201778411865},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.33526498079299927},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.11126399040222168},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","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},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0},{"id":"https://openalex.org/C558565934","wikidata":"https://www.wikidata.org/wiki/Q2743","display_name":"Musical","level":2,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.4018/jdm.2012100102","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdm.2012100102","pdf_url":null,"source":{"id":"https://openalex.org/S73024538","display_name":"Journal of Database Management","issn_l":"1063-8016","issn":["1063-8016","1533-8010"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Database Management","raw_type":"journal-article"},{"id":"pmh:oai:HAL:hal-03206569v1","is_oa":false,"landing_page_url":"https://hal.science/hal-03206569","pdf_url":null,"source":{"id":"https://openalex.org/S4306402512","display_name":"HAL (Le Centre pour la Communication Scientifique Directe)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1294671590","host_organization_name":"Centre National de la Recherche Scientifique","host_organization_lineage":["https://openalex.org/I1294671590"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Journal of Database Management, 2012, 23 (4), ⟨10.4018/jdm.2012100102⟩","raw_type":"info:eu-repo/semantics/article"},{"id":"pmh:oai:RePEc:igg:jdm000:v:23:y:2012:i:4:p:17-51","is_oa":false,"landing_page_url":"http://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/jdm.2012100102","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.49000000953674316,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":42,"referenced_works":["https://openalex.org/W42654547","https://openalex.org/W123776386","https://openalex.org/W188023883","https://openalex.org/W633094915","https://openalex.org/W1497256448","https://openalex.org/W1526177690","https://openalex.org/W1528326260","https://openalex.org/W1545406293","https://openalex.org/W1550128192","https://openalex.org/W1562836666","https://openalex.org/W1565472858","https://openalex.org/W1594783524","https://openalex.org/W1607470293","https://openalex.org/W1775738142","https://openalex.org/W1793365533","https://openalex.org/W1837672397","https://openalex.org/W1964144121","https://openalex.org/W1978220611","https://openalex.org/W1982525351","https://openalex.org/W1987995589","https://openalex.org/W1997020216","https://openalex.org/W1997375126","https://openalex.org/W2008772536","https://openalex.org/W2015081999","https://openalex.org/W2024060531","https://openalex.org/W2039795745","https://openalex.org/W2053851337","https://openalex.org/W2054230827","https://openalex.org/W2055737158","https://openalex.org/W2074029633","https://openalex.org/W2088553860","https://openalex.org/W2091959875","https://openalex.org/W2114030777","https://openalex.org/W2114679600","https://openalex.org/W2121060479","https://openalex.org/W2127218421","https://openalex.org/W2128472672","https://openalex.org/W2128931995","https://openalex.org/W2140592274","https://openalex.org/W2154010459","https://openalex.org/W3122328011","https://openalex.org/W4236752279"],"related_works":["https://openalex.org/W2378213774","https://openalex.org/W2357522326","https://openalex.org/W6138692","https://openalex.org/W2363019959","https://openalex.org/W1535822977","https://openalex.org/W23190051","https://openalex.org/W2367419170","https://openalex.org/W2377387014","https://openalex.org/W2382180329","https://openalex.org/W2375394542"],"abstract_inverted_index":{"In":[0,62],"this":[1],"paper,":[2],"a":[3,59,184],"comprehensive":[4],"methodology":[5,97],"for":[6],"designing":[7],"and":[8,35,51,53,74,88,119,173,183,196],"querying":[9],"Parallel":[10],"Rational":[11],"Data":[12],"Warehouses":[13],"(PRDW)":[14],"over":[15,133],"database":[16,135],"clusters,":[17,136],"called":[18,188],"Fragmentation":[19],"&":[20],"Allocation":[21],"(F&A)":[22],"is":[23,102,193],"proposed.":[24],"F&A":[25,78,96,110,158],"assumes":[26],"that":[27,43,45,85],"cluster":[28,46,174],"nodes":[29,47],"are":[30,48,56,69,140],"heterogeneous":[31,134,147],"in":[32,58],"processing":[33],"power":[34],"storage":[36],"capacity,":[37],"contrary":[38],"to":[39,71,94,127],"traditional":[40],"design":[41,131],"approaches":[42],"assume":[44],"instead":[49],"homogeneous,":[50],"fragmentation":[52,73,87,108],"allocation":[54,89,100,156,180],"phases":[55],"performed":[57],"simultaneous":[60],"manner.":[61],"classical":[63],"approaches,":[64],"two":[65,112],"different":[66],"cost":[67,83],"models":[68],"used":[70],"perform":[72],"allocation,":[75],"separately,":[76],"whereas":[77],"makes":[79],"use":[80],"of":[81,142,149,165],"one":[82],"model":[84],"considers":[86],"parameters":[90],"simultaneously.":[91],"Therefore,":[92],"according":[93],"the":[95,99,107,124,128,146,150,155,167,178,199],"proposed,":[98],"phase/decision":[101],"done":[103],"at":[104],"fragmentation.":[105],"At":[106,154],"phase,":[109,157],"uses":[111],"well-known":[113],"algorithms,":[114],"namely":[115],"Hill":[116],"Climbing":[117],"(HC)":[118],"Genetic":[120],"Algorithm":[121],"(GA),":[122],"which":[123],"authors":[125],"adapt":[126],"main":[129],"PRDW":[130],"problem":[132],"as":[137],"these":[138],"algorithms":[139],"capable":[141,164],"taking":[143],"into":[144],"account":[145],"characteristics":[148],"reference":[151],"application":[152],"scenario.":[153],"introduces":[159],"an":[160],"innovative":[161],"matrix-based":[162],"formalism":[163],"capturing":[166],"interactions":[168],"among":[169],"fragments,":[170],"input":[171],"queries,":[172],"node":[175],"characteristics,":[176],"driving":[177],"data":[179,201],"task":[181],"accordingly,":[182],"related":[185],"affinity-based":[186],"algorithm,":[187],"F&A-ALLOC.":[189],"Finally,":[190],"their":[191],"proposal":[192],"experimentally":[194],"assessed":[195],"validated":[197],"against":[198],"widely-known":[200],"warehouse":[202],"benchmark":[203],"APB-1":[204],"release":[205],"II.":[206]},"counts_by_year":[{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":5}],"updated_date":"2026-08-27T14:10:00.468798","created_date":"2016-06-24T00:00:00"}