文章基本信息

标题：Heuristic Based Approach for Automating Multidimensional Schemas Construction
本地全文：下载
作者：Elhaj Elamin ; Abdulrahman Altalhi ; Jamel Feki 等
期刊名称：International Journal of Computer and Information Technology
印刷版ISSN：2279-0764
出版年度：2017
卷号：6
期号：6
页码：286-295
出版社：International Journal of Computer and Information Technology
摘要：In recent years, the automation process for extracting the elements of the multidimensional schema from operational data sources became the solution to facilitate this complex and time-consuming task. In this paper, we propose a semiautomatic heuristic-based approach for generating star schemas from the transactional relational database of the organization. Our approach encompasses three main phases: i) Database model extraction, ii) Reverse engineering process, and iii) Multidimensional schema generation. The distinctive feature of the reverse engineering phase is it classifies the relational tables of the source database into three types namely i) Strong entity, ii) Weak entity and iii) Relationship. For this proposed approach, we have defined a set of heuristic rules we applied on examples of the literature; the obtained results show that our rules are helpful for the Data warehouse designer in generating star schemas.
关键词：Heuristic rules; star schema; relational data source; conceptual design