added useful sql views
Corrected javadoc