{"id":"https://openalex.org/W2748080133","doi":"https://doi.org/10.3233/ida-160035","title":"Multidimensional benchmarking in data warehouses","display_name":"Multidimensional benchmarking in data warehouses","publication_year":2017,"publication_date":"2017-08-19","ids":{"openalex":"https://openalex.org/W2748080133","doi":"https://doi.org/10.3233/ida-160035","mag":"2748080133"},"language":"en","primary_location":{"id":"doi:10.3233/ida-160035","is_oa":false,"landing_page_url":"https://doi.org/10.3233/ida-160035","pdf_url":null,"source":{"id":"https://openalex.org/S2498839158","display_name":"Intelligent Data Analysis","issn_l":"1088-467X","issn":["1088-467X","1571-4128"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Intelligent Data Analysis","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/A5030349719","display_name":"Akiko Campbell","orcid":null},"institutions":[{"id":"https://openalex.org/I18014758","display_name":"Simon Fraser University","ror":"https://ror.org/0213rcc28","country_code":"CA","type":"education","lineage":["https://openalex.org/I18014758"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Akiko Campbell","raw_affiliation_strings":["LifeLabs Medical Laboratories, Burnaby, BC, Canada","Simon Fraser University, Burnaby, BC, Canada"],"affiliations":[{"raw_affiliation_string":"LifeLabs Medical Laboratories, Burnaby, BC, Canada","institution_ids":[]},{"raw_affiliation_string":"Simon Fraser University, Burnaby, BC, Canada","institution_ids":["https://openalex.org/I18014758"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5050423386","display_name":"Xiangbo Mao","orcid":null},"institutions":[{"id":"https://openalex.org/I18014758","display_name":"Simon Fraser University","ror":"https://ror.org/0213rcc28","country_code":"CA","type":"education","lineage":["https://openalex.org/I18014758"]},{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CA","CN"],"is_corresponding":true,"raw_author_name":"Xiangbo Mao","raw_affiliation_strings":["Simon Fraser University, Burnaby, BC, Canada","Zhejiang University, Hangzhou, Zhejiang, China"],"affiliations":[{"raw_affiliation_string":"Simon Fraser University, Burnaby, BC, Canada","institution_ids":["https://openalex.org/I18014758"]},{"raw_affiliation_string":"Zhejiang University, Hangzhou, Zhejiang, China","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5062247330","display_name":"Jian Pei","orcid":"https://orcid.org/0000-0002-2200-8711"},"institutions":[{"id":"https://openalex.org/I18014758","display_name":"Simon Fraser University","ror":"https://ror.org/0213rcc28","country_code":"CA","type":"education","lineage":["https://openalex.org/I18014758"]},{"id":"https://openalex.org/I185163786","display_name":"King Abdulaziz University","ror":"https://ror.org/02ma4wv74","country_code":"SA","type":"education","lineage":["https://openalex.org/I185163786"]}],"countries":["CA","SA"],"is_corresponding":false,"raw_author_name":"Jian Pei","raw_affiliation_strings":["King Abdulaziz University, Jeddah, Saudi Arabia","Simon Fraser University, Burnaby, BC, Canada"],"affiliations":[{"raw_affiliation_string":"King Abdulaziz University, Jeddah, Saudi Arabia","institution_ids":["https://openalex.org/I185163786"]},{"raw_affiliation_string":"Simon Fraser University, Burnaby, BC, Canada","institution_ids":["https://openalex.org/I18014758"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5038170475","display_name":"Abdullah Al-Barakati","orcid":"https://orcid.org/0000-0002-6784-3278"},"institutions":[{"id":"https://openalex.org/I185163786","display_name":"King Abdulaziz University","ror":"https://ror.org/02ma4wv74","country_code":"SA","type":"education","lineage":["https://openalex.org/I185163786"]}],"countries":["SA"],"is_corresponding":false,"raw_author_name":"Abdullah Al-Barakati","raw_affiliation_strings":["King Abdulaziz University, Jeddah, Saudi Arabia","E-mail:"],"affiliations":[{"raw_affiliation_string":"King Abdulaziz University, Jeddah, Saudi Arabia","institution_ids":["https://openalex.org/I185163786"]},{"raw_affiliation_string":"E-mail:","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5050423386"],"corresponding_institution_ids":["https://openalex.org/I18014758","https://openalex.org/I76130692"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.13486883,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"21","issue":"4","first_page":"781","last_page":"801"},"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.9998999834060669,"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.9998999834060669,"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.9998999834060669,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9993000030517578,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/benchmarking","display_name":"Benchmarking","score":0.9611930847167969},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.8206716179847717},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.8168320655822754},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7329961061477661},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.6961074471473694},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.6042059659957886},{"id":"https://openalex.org/keywords/business-intelligence","display_name":"Business intelligence","score":0.602108895778656},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.6020867228507996},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.5704030990600586},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.5036584734916687},{"id":"https://openalex.org/keywords/data-cube","display_name":"Data cube","score":0.4993586540222168},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.48043227195739746},{"id":"https://openalex.org/keywords/cube","display_name":"Cube (algebra)","score":0.41693806648254395},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3869231641292572},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3387755751609802},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.11095800995826721},{"id":"https://openalex.org/keywords/business","display_name":"Business","score":0.07464271783828735},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.07384029030799866}],"concepts":[{"id":"https://openalex.org/C86251818","wikidata":"https://www.wikidata.org/wiki/Q816754","display_name":"Benchmarking","level":2,"score":0.9611930847167969},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8206716179847717},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.8168320655822754},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7329961061477661},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.6961074471473694},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.6042059659957886},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.602108895778656},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.6020867228507996},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.5704030990600586},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.5036584734916687},{"id":"https://openalex.org/C78168278","wikidata":"https://www.wikidata.org/wiki/Q5227269","display_name":"Data cube","level":2,"score":0.4993586540222168},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.48043227195739746},{"id":"https://openalex.org/C53051483","wikidata":"https://www.wikidata.org/wiki/Q861555","display_name":"Cube (algebra)","level":2,"score":0.41693806648254395},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3869231641292572},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3387755751609802},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.11095800995826721},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.07464271783828735},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.07384029030799866},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","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/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"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/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.3233/ida-160035","is_oa":false,"landing_page_url":"https://doi.org/10.3233/ida-160035","pdf_url":null,"source":{"id":"https://openalex.org/S2498839158","display_name":"Intelligent Data Analysis","issn_l":"1088-467X","issn":["1088-467X","1571-4128"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Intelligent Data Analysis","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320334593","display_name":"Natural Sciences and Engineering Research Council of Canada","ror":"https://ror.org/01h531d29"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W1523901438","https://openalex.org/W1538519997","https://openalex.org/W1565838812","https://openalex.org/W1590183325","https://openalex.org/W1992628046","https://openalex.org/W2003262311","https://openalex.org/W2010173932","https://openalex.org/W2080133348","https://openalex.org/W2092103580","https://openalex.org/W2103201239","https://openalex.org/W2113101421","https://openalex.org/W2117247700","https://openalex.org/W2133443743","https://openalex.org/W2147785283","https://openalex.org/W2149846061","https://openalex.org/W2168849769","https://openalex.org/W2771220651","https://openalex.org/W4230230708","https://openalex.org/W4245210711","https://openalex.org/W6601519247","https://openalex.org/W6608022464","https://openalex.org/W6746588508"],"related_works":["https://openalex.org/W208715492","https://openalex.org/W2366586806","https://openalex.org/W2198278743","https://openalex.org/W2359610078","https://openalex.org/W23190051","https://openalex.org/W1561366042","https://openalex.org/W4243836966","https://openalex.org/W2381646725","https://openalex.org/W1535822977","https://openalex.org/W2168477359"],"abstract_inverted_index":{"Benchmarking":[0],"is":[1],"among":[2],"the":[3,13,41,66,74,90,93,98,101],"most":[4],"widely":[5],"adopted":[6],"practices":[7],"in":[8,21,40],"business":[9,48],"today.":[10],"However,":[11],"to":[12,53,72,81],"best":[14],"of":[15,76,103],"our":[16,104],"knowledge,":[17],"conducting":[18],"multidimensional":[19],"benchmarking":[20],"data":[22,45,68,95],"warehouses":[23],"has":[24],"not":[25],"been":[26],"explored":[27],"from":[28],"a":[29,61],"technical":[30],"efficiency":[31,99],"perspective.":[32],"In":[33],"this":[34],"paper,":[35],"we":[36],"formulate":[37],"benchmark":[38,55],"queries":[39,56],"context":[42],"o":[43],"f":[44],"warehousing":[46],"and":[47,50,65,84,92,100],"intelligence,":[49],"develop":[51],"algorithms":[52],"answer":[54],"efficiently.":[57],"Our":[58],"methods":[59],"employ":[60],"few":[62],"interesting":[63],"ideas":[64],"state-of-the-art":[67],"cube":[69],"computation":[70],"techniques":[71],"reduce":[73],"number":[75],"aggregate":[77],"cells":[78],"that":[79],"need":[80],"be":[82],"computed":[83],"indexed.":[85],"An":[86],"empirical":[87],"study":[88],"using":[89],"TPC-H":[91],"Weather":[94],"sets":[96],"demonstrates":[97],"scalability":[102],"methods.":[105]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}