Publications associées à Extract-transform-load

Datafication of audiovisual archives: from practice mapping to a thinking model

Purpose Recent archiving and curatorial practices took advantage of the advancement in digital technologies, creating immersive and interactive experiences to emphasize the plurality of memory materials, encourage personalized sense-making and extract, man ...

Emerald Group Publishing Ltd2024

Hybrid Simulator for Capturing Dynamics of Synthetic Populations

Michel Bierlaire, Marija Kukic

This paper presents a novel hybrid framework for generating and updating a synthetic population. We call it hybrid because it combines model-based and data-driven approaches. Existing generators produce a snapshot of synthetic data that becomes outdated ov ...

IEEE2024

Optimizing Data Processing for Nanodiamond Based Relaxometry

Mayeul Sylvain Chipaux

The nitrogen-vacancy (NV) center in diamond is a powerful and versatile quantum sensor for diverse quantities. In particular, relaxometry (or T1), can be used to detect magnetic noise at the nanoscale. For experiments with single NV centers the analysis of ...

WILEY2023

E-Scan: Consuming Contextual Data with Model Plugins

Anastasia Ailamaki, Viktor Sanca

Extracting value and insights from increasingly heterogeneous data sources involves multiple systems combining and consuming the data. With multi-modal and context-rich data such as strings, text, videos, or images, the problem of standardizing the data mo ...

2023

Interactive-time Exploration, Querying, and Analysis of Large High-dimensional Datasets

Sachin Basil John

In the current era of big data, aggregation queries on high-dimensional datasets are frequently utilized to uncover hidden patterns, trends, and correlations critical for effective business decision-making. Data cubes facilitate such queries by employing p ...

EPFL2023

A chance-constraint approach for optimizing Social Engagement-based services

Michel Bierlaire, Edoardo Fadda

Social Engagement is a novel business model transforming final users of a service from passive into active components. In this framework, people are contacted by a company and they are asked to perform tasks in exchange for a reward. This arises the compli ...

IEEE2022

Leveraging topology, geometry, and symmetries for efficient Machine Learning

Michaël Defferrard

When learning from data, leveraging the symmetries of the domain the data lies on is a principled way to combat the curse of dimensionality: it constrains the set of functions to learn from. It is more data efficient than augmentation and gives a generaliz ...

EPFL2022

Digitised Newspapers – A New Eldorado for Historians? Reflections on Tools, Methods and Epistemology

Maud Ehrmann, Frédéric Clavert

The application of digital technologies to historical newspapers has changed the research landscape historians were used to. An Eldorado? Despite undeniable advantages, the new digital affordance of historical newspapers also transforms research practices ...

De Gruyter2022

Data transformer apparatus

Babak Falsafi, Christoph Koch, Siddharth Gupta, Mario Paulo Drumond Lages De Oliveira, Mark Johnathon Sutherland, Arash Pourhabibi Zarandi, Zilu Tian, Hussein Kassir

Data transformer apparatus comprising at least a dispatcher module (D), a reader module (R), a converter module (C) and a writer module (W). The dispatcher module (D) is configured to: receive a data transformation request (DTR) including: a first informat ...

2021

ROXANNE Research Platform: Automate criminal investigations

Petr Motlicek, Maël Fabien, Aravind Krishnan

Criminal investigations require manual intervention of several investigators and translators. However, the amount and the diversity of the data collected raises many challenges, and cross-border investigations against organized crime can quickly impossible ...

ISCA-INT SPEECH COMMUNICATION ASSOC2021

Scalable Multi-Query Execution using Reinforcement Learning

Anastasia Ailamaki, Panagiotis Sioulas

The growing demand for data-intensive decision support and the migration to multi-tenant infrastructures put databases under the stress of high analytical query load. The requirement for high throughput contradicts the traditional design of query-at-a-time ...

Association for Computing Machinery2021

Pollution Detection Algorithm (PDA)

Julia Schmale, Andrea Baccarini, Ivo Fabio Beck, Hélène Paule Angot

The Pollution Detection Algorithm (PDA) is an algorithm to identify and flag periods of primary polluted data in remote atmospheric time series in five steps. The first and most important step identifies polluted periods based on the gradient (time-derivat ...

Zenodo2021

Optimal CAM Computation of Kaplan Turbines Accounting for Wear and Tear Originated by Frequency Control

Mario Paolone, Elena Vagnoni, Francesco Gerini, Sidi-Rachid Cherkaoui

Nowadays, the importance of providing frequency stability to power systems with hydropower units is significantly increasing due to the growing proportion of volatile renewable energy sources. However, the provision of such services, as frequency containme ...

IEEE2021

Learning Analytics for Adaptive and Self-Improving Learning Environments for Inductive Teaching

Louis Pierre Faucon

The emergence of digital technology is changing education in many ways. A particularly interesting aspect of this transformation is the development of learning environments that can automatically adapt to individual students and can collect data in order t ...

EPFL2021

Fatigue examination of reinforced-concrete bridge slabs using acoustic emission and strain monitoring data

Imane Bayane

The examination of bridges under service loading is key for understanding their condition and thus for their sustainable and efficient use. The need to extend the service duration of existing bridges is increasing, and therefore, efficient tools for examin ...

EPFL2021

Feedback and Common Information: Bounds and Capacity for Gaussian Networks

Erixhen Sula

Network information theory studies the communication of information in a network and considers its fundamental limits. Motivating from the extensive presence of the networks in the daily life, the thesis studies the fundamental limits of particular network ...

EPFL2021

Adaptive partitioning and indexing for in situ query processing

Anastasia Ailamaki, Manolis Karpathiotakis, Ioannis Alagiannis, Manoussos Gavriil Athanassoulis, Matthaios Alexandros Olma

The constant flux of data and queries alike has been pushing the boundaries of data analysis systems. The increasing size of raw data files has made data loading an expensive operation that delays the data-to-insight time. To alleviate the loading cost, in ...

SPRINGER2020

Stream Solutes and Particulates Export Regimes: A New Framework to Optimize Their Monitoring

Camille Roland Marie Minaudo

The quantification of solute and sediment export from drainage basins is challenging. A large proportion of annual or decadal loads of most constituents is exported during relatively short periods of time, a “hot moment,” which vary between constituents an ...

2020

OdiEnCorp 2.0: Odia-English Parallel Corpus for Machine Translation

Petr Motlicek

The preparation of parallel corpora is a challenging task, particularly for languages that suffer from under-representation in the digital world. In a multi-lingual country like India, the need for such parallel corpora is stringent for several low-resourc ...

European Language Resources Association (ELRA)2020

Steel column stability and implications in the seismic assessment of steel structures according to Eurocode 8 Part 3

Dimitrios Lignos, Alexander Riley Hartloper

Seismic performance assessment of new and existing steel structures based on nonlinear static (pushover) analysis necessitates the use of engineering‐oriented models that trace the nonlinear response of structural steel elements under static and cyclic loa ...

2020