castle amber

Database maintenance

As part of an advanced online energy usage analysing application a database application was developed using the Java programming language (with JDBC) and the open source database MySQL. The Java application lets the user enter information about the buildings that are monitored in order to obtain the usage patterns. Information about each monitoring device, the type of sensors used, etc. can be specified. Buildings can be grouped and managed as a group.

Additional information like address, contact person, email, phone, etc. can also be added as well as notes.

The administrator of the Java application can also control settings for the rendering of some information on the website and manage the users of the Java database maintenance application.

The application supports concurrent usage by multiple users.