/DBJoules

Primary LanguagePython

DBJoules

Towards Energy Efficient Databases

Description

DBJoules measures the energy consumption of queries written in various databases. This tool can be serves as a valuable resource for developers and practitioners seeking to develop energy-aware application.

System Requirements

  1. Windows Operating System
  2. Have Python, MySQL, PostgreSQL, MongoDB, Couchbase installed in your system.
  3. It is recommended to download couchbase-server of version 7.0.2

Steps to run

  1. Clone the repository: '''git clone https://github.com/rishalab/DBJoules.git'''
  2. Run "setup.py" file to install necessary dependencies: '''python setup.py'''
  3. Run "stop_background_processes.py" file to stop all the currently running background processes '''python stop_background_processes.py'''
  4. Command to start the tool '''python main_app.py'''

Usage

  1. Measuring energy consumption due to query execution in four databases: MySQL, PostgreSQL, MongoDB, Couchbase.
  2. Comparing energy consumption among these databases.

Important Links

  1. Demonstration Video
  2. Tool Website

Tool Demo:

DBJoules_Output