- extract constants
- remove unused methods
- extracted database configuration to properties file