Data warehousing process modeling from classical approaches to new trends: Main features and comparisons

A Dhaouadi, K Bousselmi, MM Gammoudi, S Monnet… - Data, 2022 - mdpi.com
The extract, transform, and load (ETL) process is at the core of data warehousing
architectures. As such, the success of data warehouse (DW) projects is essentially based on …

A survey of extract–transform–load technology

P Vassiliadis - International Journal of Data Warehousing and Mining …, 2009 - igi-global.com
The software processes that facilitate the original loading and the periodic refreshment of the
data warehouse contents are commonly known as Extraction-Transformation-Loading (ETL) …

Privacy-preserving cooperative statistical analysis

W Du, MJ Atallah - Seventeenth Annual Computer Security …, 2001 - ieeexplore.ieee.org
The growth of the Internet opens up tremendous opportunities for cooperative computation,
where the answer depends on the private inputs of separate entities. Sometimes these …

Data integration flows for business intelligence

U Dayal, M Castellanos, A Simitsis… - Proceedings of the 12th …, 2009 - dl.acm.org
Business Intelligence (BI) refers to technologies, tools, and practices for collecting,
integrating, analyzing, and presenting large volumes of information to enable better decision …

ETL process modeling conceptual for data warehouses: a systematic mapping study

L Muñoz, JN Mazon, J Trujillo - IEEE Latin America …, 2011 - ieeexplore.ieee.org
BACKGROUND: A data warehouse (DW) is an integrated collection of subject-oriented data
in the support of decision making. Importantly, the integration of data sources is achieved …

Ontology-based conceptual design of ETL processes for both structured and semi-structured data

D Skoutas, A Simitsis - International Journal on Semantic Web and …, 2007 - igi-global.com
One of the main tasks in the early stages of a data warehouse project is the identification of
the appropriate transformations and the specification of inter-schema mappings from the …

From conceptual design to performance optimization of ETL workflows: current state of research and open problems

SMF Ali, R Wrembel - The VLDB Journal, 2017 - Springer
In this paper, we discuss the state of the art and current trends in designing and optimizing
ETL workflows. We explain the existing techniques for:(1) constructing a conceptual and a …

Towards a programmable semantic extract-transform-load framework for semantic data warehouses

RP Deb Nath, K Hose, TB Pedersen - Proceedings of the ACM …, 2015 - dl.acm.org
In order to create better decisions for business analytics, organizations increasingly use
external data, structured, semi-structured and unstructured, in addition to the (mostly …

The semantic data dictionary–an approach for describing and annotating data

SM Rashid, JP McCusker, P Pinheiro, MP Bax… - Data …, 2020 - direct.mit.edu
It is common practice for data providers to include text descriptions for each column when
publishing data sets in the form of data dictionaries. While these documents are useful in …

Defining ETL worfklows using BPMN and BPEL

Z El Akkaoui, E Zimányi - Proceedings of the ACM twelfth international …, 2009 - dl.acm.org
Decisional systems are crucial for enterprise improvement. They allow the consolidation of
heterogeneous data from distributed enterprise data stores into strategic indicators. An …