DataWarehouse-for-Retail-using-MeshJoin

Data loading from database using Mesh Join and OLAP Queries for a retail store

Steps to run MeshJoin on Eclipse using Java SE 8
Step 1:
Run createDW.sql in mySQL - this creates a schema 'dwh' if it doesnt already exist and creates the fact and dimension tables within it
Step 2:
Select import projects in Eclipse
Step 3:
Under Maven, select Existing Maven projects
Step 4:
Choose the project folder as root directory and click finish
Step 5:
Set the compiler version to Java SE 8 in case another version is selected
Step 6:
Adjust mySQl database credentials if needed in lines 27-30 of MeshJoin.java which can be found in the src folder
Current credentials set as follows:
username: "root" (line 27)
password: "1234" (line 28)
source schema for fetching data: "projectsource" (line 29)
target schema for dwh: "dwh" (line 30)
Step 7 may be required only if the error that "main class MeshJoin not found" is displayed when pressing run
Step 7:
Select "Run Configurations" from the drop down menu next to the "Run" button
Click on the "New Launch Configuration" button if the current project is not enlisted under "Java Application" on the right
If the new configuration does not populate the project automatically, click on Browse and select "DWHMeshJoin" as the project
Click on search and select "MeshJoin" as the main class
Press Apply and close
Step 8:
Click on "Run" to execute