Merge of X-ETL and XCube towards a Standard Hybrid Method for Designing Data Warehouses
Journal Title: International Journal of Advanced Computer Science & Applications - Year 2019, Vol 10, Issue 10
Abstract
There is no doubt that the hybrid approach is the best paradigm for designing effective multidimensional schemas. Its strength lies in its ability to combine the top-down and bottom-up approaches, thus exploiting the advantages of both approaches. In this paper, the authors try to identify and analyze the different hybrid methods developed for building data warehouses. The analysis revealed that the existing methods are too complicated and time consuming in the deployment phase. In order to solve this problem, the authors introduced a new hybrid method that is easy to use and saves a huge amount of deployment time. This new method consists of two main steps: the first data driven step allows an analysis of the source models by using the X-ETL method and gives rise to star models. The second requirements driven step performs a semantic analysis of the needs expressed in natural language by using the XCube Assist method. This analysis allows to improve the quality of star models generated by the X-ETL method without the intervention of a designer.
Authors and Affiliations
Nawfal El Moukhi, Ikram El Azami, Abdelaaziz Mouloudi, Abdelali Elmounadi
Keywords
Related Articles
- EP ID EP665042
- DOI 10.14569/IJACSA.2019.0101019
- Views 121
- Downloads 0
A Robust Method for Diagnostic Energetic System with Bond Graph
Surveillance and supervision systems have a major role in insuring the safety and availability of industrial equipments and installations. Default detection and diagnosis is highly important to facilitate the planning an...
Dynamic Service Adaptation Architecture
This paper proposes a software architecture for dynamical service adaptation. The services are constituted by reusable software components. The adaptation’s goal is to optimize the service function of their execution con...
A study on Security within public transit vehicles
In public transit vehicles, security is the major concern for the passengers. Surveillance Systems provide the security by providing surveillance cameras in the vehicles and a storage that maintains the data. The applica...
Modeling and simulation of the effects of landslide on circulation of transports on the mountain roads
Landslides, as one of the major natural hazards, account each year for enormous property damage in terms of both direct and indirect costs. Mountain roads where probability of land sliding is the highest, causes hurdles...
Proposal for Scrambled Method based on NTRU
Scrambling is widely used to protect the security of data files such as text, image, video or audio files; however, it is not the most efficient method to protect the security of the data files. This article uses NTRU pu...