This project aims to add semi-automatic index tuning to postgresql (9.1.4 version) as described in http://arxiv.org/pdf/1004.1249v6.pdf We need hypothetical indexes for the process and are using code base from http://www.inf.puc-rio.br/~postgresql/index.php?lan=en as base. References: * Semi-Automatic Index Tuning: Keeping DBAs in the Loop http://arxiv.org/pdf/1004.1249v6.pdf ------------------------------------------------------------------------------------------ 1. Setup postgresql(patched) (Location: postgresql-9.1.4) according to instructions in http://www.cse.iitb.ac.in/dbms/Data/Courses/CS631/PostgreSQL-Resources/pgsql_demo.txt 2. Create user postgres with password postgres and assign superuser role 3. Import dellstore2-normal-1.0.sql into a database named dellstore2 Note: Other database dumps can also be used. Corresponding changes are needed to be made in 'PostgreSQL_index_tuning/src/in/ac/iitb/cse/dbms/pg_indextuning/AdminDB.java' 4. Import the project present in PostgreSQL_index_tuning into eclipse. Add external_jars as External project jars 5. Run the main function in AdminDB.java More details about file structure is in report -----------------------------------------------------------------------------------------