EcoProD Documentation¶

Ecological and Predictive Query Optimizer Design (EcoProD) is an energy-aware query optimizer framework. This framework leverages the PostgreSQL query optimizer by integrating energy dimension.

Requirements¶

• Operating System: Ubuntu Version 14.04 LTS or higher, Windows 7 or higher
• Compiler: gcc version 4.8 or higher
• Library: Qt
• Watts Up? Pro power meter driver: Optional

Download¶

All EcoProD project files can be downloaded here: http://www.lias-lab.fr/forge/projects/ecoprod/files

The archive file (ecoprod.tar.gz) contains:

• postgresql-9.4.5: Our modified version of the PostgreSQL DBMS with the energy dimension
• ecoprod-0.1: The GUI developed to interact the users with the system

• wattsup.tar.gz: Contains the driver of Watts Up? Pro for both Linux and Windows

• ecoprod-0.1-demo.mp4: Is a demonstration video of EcoPorD framework

Build and Install¶

• To build and install PostgreSQL, please the official documentation: http://www.postgresql.org/docs/9.4/interactive/installation.html
• To build EcoProd simply use Qt Creator IDE

Publications¶

• Amine Roukh, Ladjel Bellatreche: Eco-Processing of OLAP Complex Queries. DaWaK 2015
• Amine Roukh, Ladjel Bellatreche, Ahcène Boukorca, Selma Bouarar: Eco-DMW: Eco-Design Methodology for Data warehouses. DOLAP 2015
• Amine Roukh: Estimating Power Consumption of Batch Query Workloads. MEDI 2015