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 83
- Downloads 0
Dynamic Evaluation and Visualisation of the Quality and Reliability of Sensor Data Sources
Before using remote data sources, or those from external organisations, it is important to establish if the source is fit for purpose. We have developed an approach to automatic sensor data annotation and visualisation t...
A Calibrating Six-Port Compact Circuit using a New Technique Program
In this paper, a calibration of six-port reflectometer using a new technique program is presented. It has been shown that a calibration procedure is based on explicit method, the method that capturing the output wave for...
EICT BASED DIAGNOSTIC TOOL AND MONITORING SYSTEM FOR EMF RADIATION TO SUSTAIN ENVIRONMENTAL SAFETY
The adverse effects of electromagnetic radiation from mobile phones and communication towers on health issues are being well documented today. However, exact correlation between radiation of communication towers and thei...
A Survey of Environment and Demands Along with a Marketing Communications Plan for WatPutthabucha Market to Promote Agricultural Tourism through Main Media and Online Social Network Media
This study was aimed to examine the current environment and the demands and to make a marketing communications plan for WatPuttabucha Market to promote agricultural tourism through main media and online social network me...
Dynamic Crypto Algorithm for Real-Time Applications DCA-RTA, Key Shifting
The need for fast and attack resistance crypto algorithm is challenging issue in the era of the revolution in the information and communication technologies. The previous works presented by the authors “Dynamic Crypto Al...