Distributed Data Bases schema simulating an airline.
- In a server running Oracle DB insert the .sh, .sql, .csv and .ctl files.
- Run
sh schema_creation.sh username password continent_id db_name
.
- In a server running Oracle DB insert the .sh, .sql, .csv and .ctl files.
- Set Oracle SID to a different instance other than the ones for the contients DBs.
- Run
sh dwh_creation.sh username password
.
- Create new virtual env with Python 3.
- Run
pip install requirements.txt