Concept

Extract, transform, load

Related publications (70)

Graph Chatbot

Chat with Graph Search

Ask any question about EPFL courses, lectures, exercises, research, news, etc. or try the example questions below.

DISCLAIMER: The Graph Chatbot is not programmed to provide explicit or categorical answers to your questions. Rather, it transforms your questions into API requests that are distributed across the various IT services officially administered by EPFL. Its purpose is solely to collect and recommend relevant references to content that you can explore to help you answer your questions.

SmartD: Smart Meter Data Analytics Dashboard

Karl Aberer, Tri Kurniawan Wijaya, Matteo Vasirani, Aylin Jarrah Nezhad

The ability of smart meters to communicate energy consumption data in (near) real-time enables data analytics for novel applications, such as pervasive demand response, personalized energy feedback, outage management, and theft detection. Smart meter data ...

2014

Special Section on Social Media as Sensors

Daniel Gatica-Perez, Jie Luo

Social media have transformed the Web into an interactive sharing platform where users upload data and media, comment on, and share this content within their social circles. Each content item is associated with an abundance of metadata and related informat ...

Ieee-Inst Electrical Electronics Engineers Inc2013

Probabilistic Spinning Reserve Provision Model in Multi-Control Zone Power System

Mokhtar Bozorg, Ali Ahmadi Khatir

Inter-zonal trading in multi-area power system (MAPS) improves the market efficiency and the system reliability by sharing the resources (energy and reserve services) across zonal boundaries. Actually, each area can operate with less reserve resources than ...

Ieee-Inst Electrical Electronics Engineers Inc2013

Same Queries, Different Data: Can we Predict Query Performance?

Anastasia Ailamaki, Miguel Sérgio De Oliveira Branco, Adrian Daniel Popescu

We consider MapReduce workloads that are produced by analytics applications. In contrast to ad hoc query workloads, analytics applications are comprised of fixed data flows that are run over newly arriving data sets or on different portions of an existing ...

2012

Quality-aware similarity assessment for entity matching in Web data

Karl Aberer, Zoltán Miklós, Surender Reddy Yerva

One of the key challenges to realize automated processing of the information on the Web, which is the central goal of the Semantic Web, is related to the entity matching problem. There are a number of tools that reliably recognize named entities, such as p ...

Wiley-Blackwell2012

Privacy Decision Making in the Travel Panopticon

Intelligent Transport Systems (ITS) have the potential to increase road-network capacities, reduce congestion and pollution, create shorter and more predictable journey times and significantly improve road-user safety. However, these technologies will also ...

2012

Impact Load Measurements in an Erosive Cavitating Flow

Ayat Karimi, Jean-Pierre Franc

Impact load measurements were carried out in a high-speed cavitation loop by means of a conventional pressure sensor flush-mounted in the region of closure of the cavity where maximum damage was observed. The sensor was dynamically calibrated by the ball d ...

2011

Predictable performance and high query concurrency for data analytics

George Candea

Conventional data warehouses employ the query- at-a-time model, which maps each query to a distinct physical plan. When several queries execute concurrently, this model introduces contention and thrashing, because the physical plans—unaware of each other—c ...

2011

Source-to-source architecture transformation for performance optimization in BIP

Joseph Sifakis

Behavior, Interaction, Priorities (BIP) is a component framework for constructing systems from a set of atomic components by using two kinds of composition operators: interactions and priorities. In this paper, we present a method that transforms the inter ...

2010

A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses

George Candea

Conventional data warehouses employ the query-at-a-time model, which maps each query to a distinct physical plan. When several queries execute concurrently, this model introduces contention, because the physical plans—unaware of each other—compete for acce ...

2009