Projekt

Obecné

Profil

« Předchozí | Další » 

Revize 126d3637

Přidáno uživatelem Ondřej Váně před téměř 3 roky(ů)

#9 Split SQL scripts

- all queries in the files are split into separate queries
- each AP has a list of all the queries it needs to evaluate
- all queries from the file are loaded at application startup
- mineor changes in PositiveNUmber formating
- minor fix

Zobrazit rozdíly:

README.md
1
# AntiPatternDetectionApp
2
This application was created as part of the thesis. It is used for analysis and detection of anti-patterns in project data.
1
# ReliSA - SPADe-Web-GUI
2
This application was is used for analysis and detection of anti-patterns in project data.
3 3

  
4
## Thesis abstract
5
The goal of this thesis is to analyze and automatically detect anti-patterns in the data of project management tools using SPADe tools. The SPADe tool is used to collect data from ALM tools and search for bad practices (anti-patterns) in project data. In order to develop this thesis, an analysis of the available anti-patterns was performed and then a subset was selected for further investigation. In the next part, the detection of the analyzed anti-patterns was implemented using SQL queries and Java programming language was used to process the results of these queries. As an extra feature of this thesis, going beyond the scope of the original assignment, a support web application for running the detection process of implemented anti-patters and results presentation was also developed. Furthermore, an experiment was performed on a selected sets of anti-patterns and project data. The success of the detection was verified by comparing the results to those from a manual anti-pattern detection in project data from the source ALM tools. Detection success was successful at 93.65 % compared to manual control.
6

  
7
## Analyzed Anti-Patterns
8 4
In version 1.0.0 of this application, the detection of the following Anti-Patterns is implemented:
9 5
* Business As Usual
10 6
* Long Or Non-Existant Feedback Loops
......
14 10
* Too Long Sprint
15 11
* Varying Sprint Length
16 12

  
17
## Run
18
### Tools to run
19
It will need the following tools to run the application:
20
* Docker
21
* Docker Compose
22
### Run application
23
The following list describes the steps to run (you will need):
24
1. Open terminal.
25
2. Move to the root folder of this project (AntiPatternDetectionApp).
26
3. Build docker images with command `docker-compose build`.
27
4. Create and run all containers with command `docker-compose run`.
28
5. Open phpMyAdmin on docker address on port 8082.
29
6. Create database with name spade using command `CREATE DATABASE spade;`.
30
7. Restore database from file `db_dump.sql` located in project root folder.
31
8. Run all commands from file `config.sql` located in project root folder.
13
# Basic architecture of app
14

  
15
# Installation guide
16

  
17
# Add new Anti-Pattern
18

  
19
# User guide
20
## Analyze projects
21
1) On home page select project to analyze (you can use check box for select/deselect all projects)
22
TODO obrázek
23
2) Select Anti-Patterns to analyze (you can use check box for select/deselect all Anti-Patterns)
24
TODO obrázek
25
3) Click to button Analyze
26
TODO obrázek
27
4) Table with detections result
28
TODO obrázek
29
5) Show details of detection
30
6) Show detail of Anti-Pattern
31

  
32
## Configuration of Anti-Patterns
33
1) Go to Configuration page
34
TODO obrázek
35
2) Change corresponding threshold values
36
TODO obrázek
37
3) Click button Save or press Enter
38
TODO obrázek
39
4) If the values ​​are set correctly, a message is displayed stating that the values ​​were saved successfully
40
TODO obrázek
41
5) If the values ​​are set incorrectly, a error message is displayed and the corresponding values ​​are highlighted in red with error message
42
TODO obrázek
43

  
44
## Show Anti-Pattern detail
45
1) Go to Anti-Pattern detail page
46
    1) On Home page click on anchor Show next to corresponding Anti-Pattern
47
    2) On result page slick on Anti-Pattern name and anchor Detail
48
2) Anti-Pattern detail page is shown (name, description, anchor to catalogue, configuration values)
49
3) Configuration values can be updated also in this page
50
    1) Change corresponding threshold values
51
    2) Click button Save or press Enter
52
4) If the values ​​are set correctly, a message is displayed stating that the values ​​were saved successfully
53
TODO obrázek
54
5) If the values ​​are set incorrectly, a error message is displayed and the corresponding values ​​are highlighted in red with error message
55
TODO obrázek
56

  
57
## Show project detail
58
1) On home page click on anchor Show, next to corresponding project
59
TODO obrázek
60
2) Project details is shown (project id, name, description) 
61
TODO obrázek
62

  
32 63

  

Také k dispozici: Unified diff