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 131
- Downloads 0
A Review of Text Messaging (SMS) as a Communication Tool for Higher Education
Since 2011, The Limerick Institute of Technology (School of Applied Science Engineering & Technology) has actively engaged in a course of research to determine if SMS can be used to (1) increase student’s preparation...
A Survey of Unstructured Text Summarization Techniques
Due to the explosive amounts of text data being created and organizations increased desire to leverage their data corpora, especially with the availability of Big Data platforms, there is not usually enough time to read...
Finite Elements Modeling of Linear Motor for Automatic Sliding Door Application
In this paper, a linear switched reluctance motor is designed and investigated to be used as a sliding door drive system. A non linear two dimensions finite model is built to predict the performance of the designed motor...
Moving Object Detection in Highly Corrupted Noise using Analysis of Variance
This paper implements three-way nested design to mark moving objects in a sequence of images. Algorithm performs object detection in the image motion analysis. The inter-frame changes (level-A) are marked as temporal con...
Hadoop MapReduce for Parallel Genetic Algorithm to Solve Traveling Salesman Problem
Achieving an optimal solution for NP-complete problems is a big challenge nowadays. The paper deals with the Traveling Salesman Problem (TSP) one of the most important combinatorial optimization problems in this class. W...