Publications related to Database server

ROSMOSE: A Web-based Optimization Tool to Aid Decision-making for the Design and Operation of Industrial and Urban Energy Systems

François Maréchal, Daniel Alexander Florez Orrego, Meire Ellen Gorete Ribeiro Domingos, Cédric Terrier, Michel Lopez

Energy efficiency is crucial for the sustainable operation of all industrial and urban sectors. However, practicing engineers have seldom access to open-source tools that can readily evaluate and compare scenarios in terms of energy consumption, cost, and ...

2023

Robustness Against Read Committed: A Free Transactional Lunch

Christoph Koch, Bas Ketsman

Transaction processing is a central part of most database applications. While serializability remains the gold standard for desirable transactional semantics, many database systems offer improved transaction throughput at the expense of introducing potenti ...

ASSOC COMPUTING MACHINERY2022

Deep Models and Shortwave Infrared Information to Detect Face Presentation Attacks

Sébastien Marcel, Zohreh Mostaani, Guillaume Heusch

This paper addresses the problem of face presentation attack detection using different image modalities. In particular, the usage of short wave infrared (SWIR) imaging is considered. Face presentation attack detection is performed using recent models based ...

IEEE2020

Contact networks across ages: computational analysis of epidemiological dynamics

Gianrocco Lazzari

For decades mathematical modeling in epidemiology has helped understanding the dynamics of infectious diseases, as well as describe possible intervention scenarios to prevent and control them. However, such models were relying on several assumptions, such ...

EPFL2020

Consolidation of database check constraints

Nikola Obrenovic

Independent modeling of various modules of an information system (IS), and consequently database subschemas, may result in formal or semantic conflicts between the modules being modeled. Such conflicts may cause collisions between the integrated database s ...

2019

PWMScan: a fast tool for scanning entire genomes with a position-specific weight matrix

Giovanna Ambrosini, Philipp Bucher, Romain Fernand Pietro Groux

Transcription factors (TFs) regulate gene expression by binding to specific short DNA sequences of 5 to 20-bp to regulate the rate of transcription of genetic information from DNA to messenger RNA. We present PWMScan, a fast web-based tool to scan server-r ...

2018

Building Efficient Query Engines using High-Level Languages

Ioannis Klonatos

We are currently witnessing a shift towards the use of high-level programming languages for systems development. These approaches collide with the traditional wisdom which calls for using low-level languages for building efficient software systems. This sh ...

EPFL2017

Cytochrome c oxidase barcodes for aquatic oligochaete identification: development of a Swiss reference database

Régis Lionel Vivien

Introduction. Aquatic oligochaetes represent valuable indicators of the quality of sediments of watercourses and lakes, but their difficult identification based on morphological criteria compromises their more common use for eco-diagnostic analyses. This i ...

Peerj Inc2017

How to Architect a Query Compiler

Christoph Koch, Ioannis Klonatos, Amir Shaikhha, Lionel Emile Vincent Parreaux, Mohammad Dashti Rahmat Abadi, Lewis Alexander Brown

This paper studies architecting query compilers. The state of the art in query compiler construction is lagging behind that in the compilers field. We attempt to remedy this by exploring the key causes of technical challenges in need of well founded soluti ...

2016

Integration of outdoor human comfort in a building energy simulation database using CityGML Energy Ade

Jean-Louis Scartezzini, Jérôme Henri Kämpf, Dasaraden Mauree, Silvia Coccolo

Handling data needed by Building Energy Simulation (BES) tools can be a tedious task, especially at the urban scale. Besides BES, users often have different needs (building energy use, human comfort, integration of renewables, urban planning…) in mind when ...

vdf Hochschulverlag AG ETH Zurich2016

Toward timely, predictable and cost-effective data analytics

Renata Borovica-Gajic

Modern industrial, government, and academic organizations are collecting massive amounts of data at an unprecedented scale and pace. The ability to perform timely, predictable and cost-effective analytical processing of such large data sets in order to ext ...

EPFL2016

How to Stop Under-Utilization and Love Multicores

Anastasia Ailamaki, Pinar Tözün, Danica Porobic, Iraklis Psaroudakis, Erietta Liarou

Hardware trends oblige software to overcome three major challenges against systems scalability: (1) taking advantage of the implicit/vertical parallelism within a core that is enabled through the aggressive micro-architectural features, (2) exploiting the ...

2015

The IceProd framework: Distributed data processing for the IceCube neutrino observatory

Shirit Cohen, Mathieu Ribordy, Matthias Wolf, Mark Tobin, Sofia Vallecorsa, Xiaoxia Bai

IceCube is a one-gigaton instrument located at the geographic South Pole, designed to detect cosmic neutrinos, identify the particle nature of dark matter, and study high-energy neutrinos themselves. Simulation of the IceCube detector and processing of dat ...

Academic Press Inc Elsevier Science2015

Ground temperature modelling: The case study of Rue des Maraîchers in Geneva

Jean-Louis Scartezzini, Jérôme Henri Kämpf, Govinda Upadhyay

This paper presents a methodology to approximate the urban heat island effect by using a PostgreSQL database and CitySim software, a simulation tool to evaluate urban energy flows. A ground temperature model has been developed for shallow depths (until 4m) ...

EuroGraphics Digital Library2014

Lightweight Modular Staging: A Pragmatic Approach to Runtime Code Generation and Compiled DSLs

Martin Odersky, Tiark Rompf

Good software engineering practice demands generalization and abstraction, whereas high performance demands specialization and concretization. These goals are at odds, and compilers can only rarely translate expressive high-level programs to modern hardwar ...

2012

Efficient Testing of Recovery Code Using Fault Injection

George Candea, Paul Dan Marinescu

A critical part of developing a reliable software system is testing its recovery code. This code is traditionally difficult to test in the lab, and, in the field, it rarely gets to run; yet, when it does run, it must execute flawlessly in order to recover ...

2011

CITYSIM simulation: the case study of Alt-Wiedikon, a neighbourhood of Zürich City

Jérôme Henri Kämpf, Darren Robinson, Maria Papadopoulou, Diane Perez, Urs Wilke

As research in building energy demand simulation is reaching maturity, there is now a growing interest in the evaluation of the energy need of larger and/or pre-existing urban areas [1, 2, 3], to evaluate the energy performance associated with alternative ...

EPFL2011

Experimental study on condensation heat transfer in vertical minichannels for new refrigerant R1234ze(E) versus R134a and R236fa

John Richard Thome, Lorenzo Consolini, Farzad Vakili Farahani, Jung Eung Park

Experimental condensation heat transfer data for the new refrigerant R1234ze(E), trans-1,3,3,3-tetrafluoropropene, are presented and compared with refrigerants R134a and R236fa for a vertically aligned, aluminum multi-port tube. Local condensation heat tra ...

Elsevier2011

Design and implementation of an efficient data stream processing system

Ali Salehi

In standard database scenarios, an end-user assumes that all data (e.g., sensor readings) is stored in a database. Therefore, one can simply submit any arbitrary complex processing in the form of SQL queries or stored procedures to a database server. Data ...

EPFL2010