{"id":"https://openalex.org/W2063764042","doi":"https://doi.org/10.1142/s0219622013500351","title":"AN AUTOMATIC METHOD FOR THE DESIGN OF MULTIDIMENSIONAL SCHEMAS FROM OBJECT ORIENTED DATABASES","display_name":"AN AUTOMATIC METHOD FOR THE DESIGN OF MULTIDIMENSIONAL SCHEMAS FROM OBJECT ORIENTED DATABASES","publication_year":2013,"publication_date":"2013-11-01","ids":{"openalex":"https://openalex.org/W2063764042","doi":"https://doi.org/10.1142/s0219622013500351","mag":"2063764042"},"language":"en","primary_location":{"id":"doi:10.1142/s0219622013500351","is_oa":false,"landing_page_url":"https://doi.org/10.1142/s0219622013500351","pdf_url":null,"source":{"id":"https://openalex.org/S207089700","display_name":"International Journal of Information Technology & Decision Making","issn_l":"0219-6220","issn":["0219-6220","1793-6845"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319815","host_organization_name":"World Scientific","host_organization_lineage":["https://openalex.org/P4310319815"],"host_organization_lineage_names":["World Scientific"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Information Technology & Decision Making","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/A5048231304","display_name":"Yasser Hachaichi","orcid":null},"institutions":[{"id":"https://openalex.org/I142899784","display_name":"University of Sfax","ror":"https://ror.org/04d4sd432","country_code":"TN","type":"education","lineage":["https://openalex.org/I142899784"]}],"countries":["TN"],"is_corresponding":false,"raw_author_name":"YASSER HACHAICHI","raw_affiliation_strings":["Multimedia, InfoRmation Systems and Advanced, Computing Laboratory, University of Sfax, Higher Institute of Business Administration, BP 1013, Sfax, 3018, Tunisia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Multimedia, InfoRmation Systems and Advanced, Computing Laboratory, University of Sfax, Higher Institute of Business Administration, BP 1013, Sfax, 3018, Tunisia","institution_ids":["https://openalex.org/I142899784"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5047095963","display_name":"Jamel Feki","orcid":"https://orcid.org/0000-0002-0253-3607"},"institutions":[{"id":"https://openalex.org/I142899784","display_name":"University of Sfax","ror":"https://ror.org/04d4sd432","country_code":"TN","type":"education","lineage":["https://openalex.org/I142899784"]}],"countries":["TN"],"is_corresponding":false,"raw_author_name":"JAMEL FEKI","raw_affiliation_strings":["Multimedia, InfoRmation Systems and Advanced, Computing Laboratory, University of Sfax, Faculty of Economics and Management, BP 1018, Sfax, 3018, Tunisia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Multimedia, InfoRmation Systems and Advanced, Computing Laboratory, University of Sfax, Faculty of Economics and Management, BP 1018, Sfax, 3018, Tunisia","institution_ids":["https://openalex.org/I142899784"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I142899784"],"apc_list":null,"apc_paid":null,"fwci":3.6601,"has_fulltext":false,"cited_by_count":18,"citation_normalized_percentile":{"value":0.93635593,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":"12","issue":"06","first_page":"1223","last_page":"1259"},"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.9997000098228455,"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.9997000098228455,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9976999759674072,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.9976000189781189,"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/computer-science","display_name":"Computer science","score":0.8352186679840088},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.630042314529419},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.546007513999939},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5441786050796509},{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.5360901951789856},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.5334821939468384},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5098966360092163},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5005857944488525},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.48731908202171326},{"id":"https://openalex.org/keywords/dimensional-modeling","display_name":"Dimensional modeling","score":0.47230982780456543},{"id":"https://openalex.org/keywords/unified-modeling-language","display_name":"Unified Modeling Language","score":0.45598816871643066},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.4400753676891327},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.42232269048690796},{"id":"https://openalex.org/keywords/class-diagram","display_name":"Class diagram","score":0.41740667819976807},{"id":"https://openalex.org/keywords/domain-model","display_name":"Domain model","score":0.41380515694618225},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3870876431465149},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.24698412418365479},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.24589014053344727},{"id":"https://openalex.org/keywords/domain-knowledge","display_name":"Domain knowledge","score":0.1719687283039093},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.13757741451263428}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8352186679840088},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.630042314529419},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.546007513999939},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5441786050796509},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.5360901951789856},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.5334821939468384},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5098966360092163},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5005857944488525},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.48731908202171326},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.47230982780456543},{"id":"https://openalex.org/C145644426","wikidata":"https://www.wikidata.org/wiki/Q169411","display_name":"Unified Modeling Language","level":3,"score":0.45598816871643066},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.4400753676891327},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.42232269048690796},{"id":"https://openalex.org/C202446494","wikidata":"https://www.wikidata.org/wiki/Q664166","display_name":"Class diagram","level":4,"score":0.41740667819976807},{"id":"https://openalex.org/C92548554","wikidata":"https://www.wikidata.org/wiki/Q2262868","display_name":"Domain model","level":3,"score":0.41380515694618225},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3870876431465149},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.24698412418365479},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.24589014053344727},{"id":"https://openalex.org/C207685749","wikidata":"https://www.wikidata.org/wiki/Q2088941","display_name":"Domain knowledge","level":2,"score":0.1719687283039093},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.13757741451263428}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1142/s0219622013500351","is_oa":false,"landing_page_url":"https://doi.org/10.1142/s0219622013500351","pdf_url":null,"source":{"id":"https://openalex.org/S207089700","display_name":"International Journal of Information Technology & Decision Making","issn_l":"0219-6220","issn":["0219-6220","1793-6845"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319815","host_organization_name":"World Scientific","host_organization_lineage":["https://openalex.org/P4310319815"],"host_organization_lineage_names":["World Scientific"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Information Technology & Decision Making","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:wsi:ijitdm:v:12:y:2013:i:06:n:s0219622013500351","is_oa":false,"landing_page_url":"http://www.worldscientific.com/doi/abs/10.1142/S0219622013500351","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"},{"id":"pmh:oai:RePEc:wsi:ijitdm:v:12:y:2013:i:06:p:1223-1259","is_oa":false,"landing_page_url":"http://www.worldscinet.com/cgi-bin/details.cgi?type=html&id=pii:S0219622013500351","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":"","raw_type":"article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.7699999809265137,"display_name":"Peace, Justice and strong institutions","id":"https://metadata.un.org/sdg/16"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":51,"referenced_works":["https://openalex.org/W56165858","https://openalex.org/W87057539","https://openalex.org/W143919613","https://openalex.org/W191531475","https://openalex.org/W332208005","https://openalex.org/W1510220247","https://openalex.org/W1517106012","https://openalex.org/W1519931530","https://openalex.org/W1530537858","https://openalex.org/W1543681337","https://openalex.org/W1544010218","https://openalex.org/W1560531653","https://openalex.org/W1591136003","https://openalex.org/W1594635486","https://openalex.org/W1600521412","https://openalex.org/W1810998667","https://openalex.org/W1971323001","https://openalex.org/W1972241288","https://openalex.org/W1987244489","https://openalex.org/W1988156201","https://openalex.org/W2008120802","https://openalex.org/W2010911644","https://openalex.org/W2014383901","https://openalex.org/W2016257365","https://openalex.org/W2017012227","https://openalex.org/W2036619835","https://openalex.org/W2043938620","https://openalex.org/W2075595440","https://openalex.org/W2085434314","https://openalex.org/W2090300806","https://openalex.org/W2108971776","https://openalex.org/W2114887408","https://openalex.org/W2118774139","https://openalex.org/W2131229871","https://openalex.org/W2134217480","https://openalex.org/W2135203905","https://openalex.org/W2139088695","https://openalex.org/W2140037779","https://openalex.org/W2146636670","https://openalex.org/W2148007729","https://openalex.org/W2166709107","https://openalex.org/W2170235279","https://openalex.org/W2335724064","https://openalex.org/W2431933493","https://openalex.org/W2477262363","https://openalex.org/W2480460059","https://openalex.org/W2613062015","https://openalex.org/W3014527441","https://openalex.org/W3110305020","https://openalex.org/W4235798735","https://openalex.org/W4238718600"],"related_works":["https://openalex.org/W2092058806","https://openalex.org/W2103472145","https://openalex.org/W2153512431","https://openalex.org/W166845585","https://openalex.org/W2093134728","https://openalex.org/W1512552654","https://openalex.org/W1591654213","https://openalex.org/W1992271858","https://openalex.org/W2042840812","https://openalex.org/W4238907651"],"abstract_inverted_index":{"A":[0],"data":[1,7,32,53,58,67,74],"warehouse":[2],"(DW)":[3],"is":[4,89,167,234],"a":[5,18,83,113,152,237],"large":[6],"repository":[8],"system":[9],"designed":[10],"for":[11,169,182,242],"decision-making":[12],"purposes.":[13],"Its":[14],"design":[15,41,138],"relies":[16],"on":[17],"specific":[19],"model":[20,25,54,68,173],"called":[21],"multidimensional.":[22],"This":[23,149],"multidimensional":[24,47,159],"supports":[26],"analyses":[27],"of":[28,31,72,95,108,154,195,198,246],"huge":[29],"volumes":[30],"that":[33,63,239],"trace":[34],"the":[35,51,56,65,70,73,96,109,118,123,170,193,199,216,221,226,243,247,256],"enterprise's":[36],"activities":[37],"over":[38],"time.":[39],"Several":[40],"methods":[42],"were":[43],"proposed":[44],"to":[45,92,157,162,209,254],"build":[46],"schemas":[48,206,224],"from":[49,141],"either":[50,81],"relational":[52],"or":[55,88],"entity-relationship":[57],"model.":[59],"Almost":[60],"all":[61],"proposals":[62,102],"treated":[64],"object-oriented":[66],"assume":[69],"presence":[71],"source":[75],"UML":[76],"class-diagram.":[77],"However,":[78],"in":[79,117,122,219],"practice,":[80],"such":[82],"diagram":[84],"does":[85],"not":[86],"exist":[87],"obsolete":[90],"due":[91],"multiple":[93],"changes/evolutions":[94],"information":[97],"system.":[98],"Furthermore,":[99,202],"these":[100,129],"few":[101],"require":[103],"an":[104,134,142],"intense":[105],"manual":[106],"intervention":[107],"designer,":[110],"which":[111],"requires":[112],"high":[114],"expertise":[115],"both":[116],"DW":[119,136,217],"domain":[120,200],"and":[121,146,161,250],"object":[124,143,184],"database":[125,144,185],"domain.":[126],"To":[127],"overcome":[128],"disadvantages,":[130],"this":[131,213],"work":[132],"proposes":[133],"automatic":[135,244],"schema":[137],"method":[139,150,233],"starting":[140],"(schema":[145],"its":[147,189],"instances).":[148],"applies":[151],"set":[153],"extraction":[155,190],"rules":[156,191],"identify":[158],"concepts":[160],"generate":[163,205],"star":[164],"schemas.":[165],"It":[166],"defined":[168],"standard":[171],"ODMG":[172],"and,":[174],"thus,":[175],"can":[176],"be":[177],"adapted":[178],"with":[179],"slight":[180],"changes":[181],"other":[183],"models.":[186],"In":[187],"addition,":[188],"have":[192],"merit":[194],"being":[196,230],"independent":[197],"semantics.":[201],"they":[203],"automatically":[204],"classified":[207],"according":[208],"their":[210],"analytical":[211],"potential;":[212],"classification":[214],"helps":[215],"designer":[218],"selecting":[220],"most":[222],"relevant":[223],"among":[225],"generated":[227],"ones.":[228],"Finally,":[229],"automatic,":[231],"our":[232],"supported":[235],"by":[236],"toolset":[238],"also":[240],"prepares":[241],"generation":[245],"Extract":[248],"Transform":[249],"Load":[251],"procedures":[252],"used":[253],"load":[255],"DW.":[257]},"counts_by_year":[{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":4},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":3}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}