{"id":"https://openalex.org/W2405078217","doi":"https://doi.org/10.3233/978-1-61499-105-2-1211","title":"MMDW: A Multi-dimensional and Multi-granular Schema for Data Warehousing","display_name":"MMDW: A Multi-dimensional and Multi-granular Schema for Data Warehousing","publication_year":2012,"publication_date":"2012-01-01","ids":{"openalex":"https://openalex.org/W2405078217","doi":"https://doi.org/10.3233/978-1-61499-105-2-1211","mag":"2405078217"},"language":"en","primary_location":{"id":"doi:10.3233/978-1-61499-105-2-1211","is_oa":false,"landing_page_url":"https://doi.org/10.3233/978-1-61499-105-2-1211","pdf_url":null,"source":{"id":"https://openalex.org/S4210201731","display_name":"Frontiers in artificial intelligence and applications","issn_l":"0922-6389","issn":["0922-6389","1879-8314"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Frontiers in Artificial Intelligence and Applications","raw_type":"book-chapter"},"type":"book-chapter","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/A5080204571","display_name":"Nadeem Iftikhar","orcid":"https://orcid.org/0000-0003-4872-8546"},"institutions":[{"id":"https://openalex.org/I4210095464","display_name":"Universit\u00e9 Chr\u00e9tienne du Nord d\u2019Ha\u00efti","ror":"https://ror.org/00x835z16","country_code":"HT","type":"education","lineage":["https://openalex.org/I4210095464"]}],"countries":["HT"],"is_corresponding":true,"raw_author_name":"Iftikhar Nadeem","raw_affiliation_strings":["Professionsh\u00f8jskolen UCN, UCN Direktion, UCN Erhverv, IT-uddannelserne, DK"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Professionsh\u00f8jskolen UCN, UCN Direktion, UCN Erhverv, IT-uddannelserne, DK","institution_ids":["https://openalex.org/I4210095464"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5080204571"],"corresponding_institution_ids":["https://openalex.org/I4210095464"],"apc_list":null,"apc_paid":null,"fwci":0.6097,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.73292374,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"1211","last_page":"1220"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9969000220298767,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9969000220298767,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9966999888420105,"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/T11719","display_name":"Data Quality and Management","score":0.9958000183105469,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/granularity","display_name":"Granularity","score":0.8773995637893677},{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.8734089136123657},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.8190042972564697},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.8121408820152283},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.756609320640564},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5735396146774292},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.476267546415329},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.444904625415802},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.4341869354248047},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.42084455490112305},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.36445897817611694},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.1580042541027069},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.11722144484519958},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.0751025378704071}],"concepts":[{"id":"https://openalex.org/C177774035","wikidata":"https://www.wikidata.org/wiki/Q1246948","display_name":"Granularity","level":2,"score":0.8773995637893677},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.8734089136123657},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.8190042972564697},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8121408820152283},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.756609320640564},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5735396146774292},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.476267546415329},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.444904625415802},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.4341869354248047},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.42084455490112305},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.36445897817611694},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.1580042541027069},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.11722144484519958},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0751025378704071}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.3233/978-1-61499-105-2-1211","is_oa":false,"landing_page_url":"https://doi.org/10.3233/978-1-61499-105-2-1211","pdf_url":null,"source":{"id":"https://openalex.org/S4210201731","display_name":"Frontiers in artificial intelligence and applications","issn_l":"0922-6389","issn":["0922-6389","1879-8314"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Frontiers in Artificial Intelligence and Applications","raw_type":"book-chapter"},{"id":"mag:2405078217","is_oa":false,"landing_page_url":"https://dblp.uni-trier.de/db/conf/kes/kes2012.html#Iftikhar12","pdf_url":null,"source":{"id":"https://openalex.org/S4306517382","display_name":"KES","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":"KES","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.4399999976158142,"display_name":"Decent work and economic growth","id":"https://metadata.un.org/sdg/8"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2378213774","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/W2872228342","https://openalex.org/W2357522326"],"abstract_inverted_index":{"With":[0],"the":[1,7,30,46],"emergence":[2],"of":[3,9,19,59,94,110,115,137],"modern":[4],"database":[5],"technologies,":[6],"concept":[8],"multi-granular":[10,69],"data":[11,15,32,54,70,91,111],"warehousing,":[12],"which":[13],"stores":[14],"at":[16,55,112],"multiple":[17,113],"levels":[18,114],"granularity":[20],"has":[21],"become":[22],"important.":[23],"In":[24,61,99],"order":[25],"to":[26,42,52,85,101],"store":[27,53],"multigranular":[28],"data,":[29],"existing":[31],"warehousing":[33,71],"schemas,":[34],"such":[35],"as":[36,144,146],"star":[37,97,154],"and":[38,68,81,88,108,128,149],"snowflake":[39],"are":[40,50],"unable":[41],"provide":[43],"support,":[44],"for":[45],"reason":[47],"that":[48,131],"they":[49],"designed":[51],"a":[56,66,83,123],"single":[57],"level":[58],"granularity.":[60,116],"this":[62],"paper,":[63],"we":[64],"present":[65],"multi-dimensional":[67],"schema":[72],"(MMDW).":[73],"MMDW":[74,104,118,132],"is":[75,119],"based":[76,121],"on":[77,122],"Relational":[78],"OLAP":[79],"(ROLAP)":[80],"uses":[82],"RDBMS":[84],"manage":[86],"new":[87],"old":[89],"(aggregated)":[90],"by":[92],"means":[93],"an":[95],"extended":[96],"schema.":[98,155],"contrast":[100],"traditional":[102],"ROLAP,":[103],"also":[105],"allows":[106],"pre-computation":[107],"storage":[109,147],"Furthermore,":[117],"evaluated":[120],"real":[124],"world":[125],"case":[126],"study":[127],"results":[129],"show":[130],"performs":[133],"well":[134,145],"in":[135],"terms":[136],"aggregation":[138,141],"query":[139,142],"speed,":[140],"complexity":[143],"used":[148],"compares":[150],"favorably":[151],"with":[152],"standard":[153]},"counts_by_year":[{"year":2017,"cited_by_count":1},{"year":2014,"cited_by_count":1}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2016-06-24T00:00:00"}