WebSchemaVisualizer is a web application that visualizes the schema evolution of relational Dbs.
It utilizes the functionalities provided by the ParmenidianTruth tool to compute a set of statistics related to evolution and also to visualize the schema history as well as four evolution-related patterns.
It consists of 2 submodules, namely ParmenidianTruth-API and WebParmenidianTruth projects. The former is responsible for providing the main functionalities of the ParmenidianTruth tool to the latter one. The latter is responsible for implementing the following functionalities:
- Create a new project via uploading a set of DD files that contain the history of schema evolution
- Load a project from the server
- Visualize Diachronic Graph(nodes:set of DB's tables, edges:set of FK constraints)/schema versions
- Visualize evolution-related patterns
- Compute evolution-related statistics
- In a git bash, type
<git clone https://github.com/kdimolikas/WebSchemaVisualizer.git>
- From the project folder (WebSchemaVisualizer) in the bash, type
<git submodule init>
- Type
<git submodule update>
- Select File->Import
- Select Git->Projects from Git
- Select Existing local repository
- Choose Next until the import process is finished
- Right click on WebSchemaVisualizer project, then select Maven -> Update Project
- Right click on WebSchemaVisualizer project, then select Run As -> Maven clean
- Right click on WebSchemaVisualizer project, then select Run As -> Maven install (in case you have installed Maven as standalone tool, you can merge steps 2 and 3 by typing in a terminal (from the WebSchemaVisualizer folder)
<mvn clean install>
)
- In case you have not installed Maven as standalone tool, the recommended steps are:
- Right click on the WebParmenidianTruth project, then select Run As -> Run Configurations
- In the text field Goals, type
<jetty:run>
and then select Run - In any browser, type
<localhost:8080>
- Otherwise, you can merge steps 1 and 2 via typing in a terminal (from the WebParmenidianTruth folder)
<mvn jetty:run-war>