Two-ETL Phases for Data Warehouse Creation: Design and Implementation

Author(s):  
Ahlem Nabli ◽  
Senda Bouaziz ◽  
Rania Yangui ◽  
Faiez Gargouri
2014 ◽  
Vol 496-500 ◽  
pp. 2108-2111
Author(s):  
Jian Hu Zhang ◽  
Lei Lei ◽  
Xin You Cui ◽  
Yong Wu ◽  
Lin Tao Li

Through in-depth understanding of the domain knowledge of insurance and the study of the technology of data warehouse, the paper illustrate the application of data mining technology and data warehouse technology in the insurance clients analysis, and from the basic flow of, discusse the application of data warehouse technology in the field of insurance industry. Then, from the concept of data warehouse, describe the design and implementation of data warehouse concept model and logical model.


2018 ◽  
Vol 147 (3) ◽  
pp. 45-53
Author(s):  
Simon G. Cornejo ◽  
Karina Caro ◽  
Luis-Felipe Rodriguez ◽  
Roberto Aguilar A. ◽  
Cynthia B. Perez ◽  
...  

Author(s):  
Sandro Bimonte ◽  
Omar Boussaid ◽  
Michel Schneider ◽  
Fabien Ruelle

In the era of Big Data, more and more stream data is available. In the same way, Decision Support Systems (DSS) tools, such as data warehouses and alert systems, become more and more sophisticated, and conceptual modeling tools are consequently mandatory for successfully DSS projects. Formalisms such as UML and ER have been widely used in the context of classical information and data warehouse systems, but they have not been investigated yet for stream data warehouses to deal with alert systems. Therefore, in this article, the authors introduce the notion of Active Stream Data Warehouse (ASDW) and this article proposes a UML profile for designing Active Stream Data Warehouses. Indeed, this article extends the ICSOLAP profile to take into account continuous and window OLAP queries. Moreover, this article studies the duality of the stream and OLAP decision-making process and the authors propose a set of ECA rules to automatically trigger OLAP operators. The UML profile is implemented in a new OLAP architecture, and it is validated using an environmental case study concerning the wind monitoring.


2014 ◽  
Vol 598 ◽  
pp. 424-427
Author(s):  
Guang Hui Yuan ◽  
Chong Jun Fan ◽  
Yun Peng Yang ◽  
Wu Jun Liu ◽  
Xiang Lai Ran

This article explored the design and implementation problems of Sustainability Assessment Data Warehouse for Shanghai Airport. According to the characteristics of Shanghai airport, the airport data collection platform layer and six theme databases were designed in this paper. This paper also designed the operator assessment models and the user evaluation models, which strong guaranteed and supported the validity of the evaluation of sustainable development at the airport.


Sign in / Sign up

Export Citation Format

Share Document