Data Visualisation based on Conceptual Modelling: Relevant Code
This is the codebase for the MSc Advanced Computing project.
====
Prerequisite
- Installed Node.js runtime;
- Installed PostgreSQL RDBMS. Make sure the database service is running;
- Terminal tools. At least two concurrent terminal windows will be used.
Running the instance
- Using any valid database management tool or command line instructions, import the MONDIAL database dumps in the
db
folder for the MONDIAL database as a PostgreSQL instance. Import the SQL files in the following order:mondial-postgres-schema.sql
,mondial-postgres-inputs.sql
,mondial-postgres-fk.sql
. - Go to
backend/
folder and executenpm install
. - Create a file called
pg-connections.yaml
in the folderbackend/
, and fill the following information into this file:
user: < username of the mondial instance >
host: < host URL of the database instance. If the instance is located on the same device, this should be localhost >
database:< name of the database instance >
password: < password, if any, for the database instance >
port: < port address of the database instance. By default, this is 5432 >
- Make sure the postgresql service is running, then start the backend server by executing
npm start
. - In another terminal window, go to
frontend/
and executenpm install
, thennpm build
. Start frontend software by executingnpm start
.