Building custom plugin for Kibana to visualise Oracle database audit logs
Supervisors:
Daniel Lanza
Prasanth Kothuri
Student:
Kristina Šatara
july-august 2016
Bigger picture
- Central repository for database audit logs
- Listener and alert logs to be parsed and stored in the central repository
- Performance metrics (AWR) for troubleshooting and capacity planning
- Possibility of Real-time analytics, Offline analytics and visualization
- Reusable open source solution
Architecture
Elastic Stack
Elasticsearch
Logstash
Kibana
Beats
Elasticsearch
- distributed, open source search and analytics engine
Kibana
- open source data visualisation platform
- histogram, geomaps, line and pie charts...
Kibana plugin - goals
- create a new type of visualisation
- possibility of choosing begin and end date
- metric name
- database id
Using
- AngularJS
- D3
Kibana plugin - during the work...
created new Kibana visualization type
created Kibana's simple plugin
plugin + existing Kibana's visualizations
Kibana plugin - during the work...
- so we decided to use D3 library for visualizations
Further work
- extend the plugin to include visualisation for database alert and listener logs
- use machine learning to analyse them
Thank you!
OpenlabTalk
By kristinasatara
