# DatabaseInsights
A project to visualize Database.

this project belongs a part of [my coursework](https://github.com/ankanch/cuit-CS-project-practice).

*We may use pictures subject to copyright , contact us ASAP (kanch@ieee.org).*

#### Development Environment
	NetBeans IDE 8.2
	JDK 1.8.0_161 64 bit
	Apache Tomcat 8.0
	Oracle Database 12c
	Python 3.6 (For Localization Support)

# Third Party Libaries

* [ECharts](http://echarts.baidu.com/index.html)
* [SnedGrid](https://sendgrid.com)
* [JQuery](http://jquery.com)
* [Bootstrap Material Design](https://fezvrasta.github.io/bootstrap-material-design/docs/4.0/bootstrap-components/card/)
* [Material Design Icons](https://material.io/tools/icons/?style=baseline)

# How To Use

*Currently only support Oracle Database 12c as the host database of Database Insights.*

* Step 1. Setting up the host database.([DatabaseInsights\docs\database-config.pdf](https://github.com/ankanch/DatabaseInsights/blob/master/docs/database-config.pdf)).
* Step 2. Deploy the website to Apache Tomcat.
* Step 3. Open the website just deployed, create a account, log into console.
* Step 4. Add database in Credentials section (Only MySQL and Oracle Database Supported). 
* Step 5. Start analyzing.


# Examples


![自动化分析](https://raw.githubusercontent.com/ankanch/DatabaseInsights/master/docs/images/p1.png)

![添加数据库](https://raw.githubusercontent.com/ankanch/DatabaseInsights/master/docs/images/p2.png)

![跨表分析结果报告](https://raw.githubusercontent.com/ankanch/DatabaseInsights/master/docs/images/p3.png)

![跨表分析](https://raw.githubusercontent.com/ankanch/DatabaseInsights/master/docs/images/p4.png)

![查看完整报告](https://raw.githubusercontent.com/ankanch/DatabaseInsights/master/docs/images/p5.png)

![查看分析报告信息](https://raw.githubusercontent.com/ankanch/DatabaseInsights/master/docs/images/p6.png)

![分析报告列表](https://raw.githubusercontent.com/ankanch/DatabaseInsights/master/docs/images/p7.png)

# License
MIT License


