fazer no linux, Ansible e gcloud instalados

cd scripts

ansible-playbook vm_com_imagem.yml

gcloud compute ssh --zone "us-west1-b" "projeto-abd" --project "meiuni"

cd ..
cd projetoABD/
cd group-4
cd transactional
mvn package

java -jar target/transactional-1.0-SNAPSHOT.jar -d jdbc:postgresql://localhost:5432/projetoabd -U projetoabd -P 123456789 -W 15 -R 180 -c 16

psql -h localhost -U projetoabd -d projetoabd

• Download the dataset (https://storage.googleapis.com/abd_data/gitbench_data.zip) and extract it.

• Install the requirements:

  • With pip:

    pip3 install -r db/requirements.txt

• Create a PostgreSQL database to store the data.

• Load PostgreSQL:

  # replace 'HOST', 'PORT', 'DBNAME', 'USER', and 'PASSWORD' with the
  # respective connection variables.
  python3 db/load.py --data data -H HOST -P PORT -d DBNAME -u USER -p PASSWORD

• Load DuckDB:

  python3 db/load_duckdb.py --data data
  # database will be stored at 'git.db'

• Install:

cd transactional
mvn package

• Run:

# replace the connection, warmup, runtime, and client variables with the respective values
java -jar target/transactional-1.0-SNAPSHOT.jar -d jdbc:postgresql://HOST:PORT/DBNAME -U USER -P PASSWORD -W WARMUP -R RUNTIME -c CLIENTS
# E.g.:
java -jar target/transactional-1.0-SNAPSHOT.jar -d jdbc:postgresql://localhost:5432/git -U postgres -P postgres -W 15 -R 180 -c 16

The analytical queries can be found in the analytical folder.