Proposal for GSoC : ADJ dashboard (Administration related software)

*

Project Title*: ADJ Dashboard
Name : Erdinc AKKAYA
Email: erdinc(dot)akkaya(at)gmail(dot)com

*Synopsis*
AnyDBJSP is a database monitoring and reporting solution with a browser
based
interface. ADJ dashboard mainly will be written for database admins(DBA).
This tool will have pre-defined sql queries. In addition to these, DBA can
write his/her own sql query and report structure easy. Similar projects are,
EnterpiseDB's dashboard, cybertec's pgwatch (www.cybertec.at).

*Benefits to the PostgreSQL Community*
All the sql queries are stored in xml files. these xml files can be updated
easy, with contribution of community this xml file can grow easyly and at
the end
community will have a strong database monitoring tool. Query xml files will
be
published on web(like wiki pages) and everyone can easy design his/her own
monitoring tool easyly.

Other adventage is, after a time, community will have a strong sql queries
that
monitors databases so if someone wants to study on postgresql database
administration
ADJ dashboard will be a good tool to start.

*Quantifiable results*

Easy,understandable and growing sql monitoring tool.

*Project Details*

Project will be written in JAVA and will run on apache tomcat application
server. ADJ
dashboard don't need any alternative database to store data. All the
statistics will be
created on the fly. If someone wants to store it to anywhere, dashboard will
export results in
XML, PDF, XLS formats(these can be more). Also Dashboard can work as a
webservice that exporting
XML outputs. So tool can be used on any webpage to show statistics about
database.

Dashboard will create flash charts also. There are common database
statistics like, unused indexes,
total transactions(commiteds,rollbacks...) this dashboard should create more
and more statistics about
database (like database bloats..). On start I will prepare more than 30
statistics and charts. After
project getting its shape everyone on the comminity can add more by him/her
self.

Project have a nice interface with small css,javascripts, easy,
understandable,tidy and clean.

*Inch-Stones*

Collecting the information from community. What DBA's needs? What they
prefer to see?
First implementation with amount of queries.
Prepare tool for concurrent connections to more than one database.
Scheduled mail configuration.
Documentation, Testing, Commit.

*Project Schedule*

before 1st of June
Collect sqls and ideas from DBA's at community
1-15 June
Start coding for first prototype
15-17
Test first prototype. Ask feedback from community
17 June - 1st July
Develope 2. prototype with scheduled mail system included.
1-20 July
Prepare data outputs.(adj should work also as a web-service)
20 July-1 August
Prepare FrontEnd and get feedback from community.

1-15 August
Refactoring, add or remove features according to feedbacks.
Test and commit project.

*Completeness Criteria*

ADJ dashboard is ready. Tested on all common linux distributions. Committed
and installation guide is ready.

*Bio*
Birth:1986-July-01
4th Year Computer systems and information technologies
student at Bilkent University / Turkey.
Working as a software developer on a private firm for 4 years.
Github: hzroot
Twitter: hzroot
FreenodeIrc: hzroot