|
Online system for collecting and managing of energy data.
This project was developed for a company, headquartered in Germany, that offers a set of products which help to manage energy data. Usualy, for measuring of consuming of electricity is used a counter. The software we developed allows to manage through a Web-based interface amount of energy that has gone through a counter located in certain place and store statistics of such usage of the counter.
Electricity counters are installed on consumer's point and can be connected to energy producer's data center through modem, electrical lines or even wireless connection - GPS for example (standard for cellular phones), periodically report about electrical traffic through these devices.
In 1999, in Germany were accepted a law that allows energy market liberalization, which means that different company's or private persons may act as participants of the market process on energy market. This caused a growth of activity on energy market and was a reason for development of complex market infrastructure.
These data are collected in a central (Oracle) database. EMS is a Web-based software (written in JSP) which allows useful management of these data. Using this software, all types of customers of this system can login (using browser) into the system and execute necessary for them actions:
- Energy Producer (for example big electricity producing company) can manage all its customers, which can be as end consumers, so also re-sellers and third-party interested participants. Software allows users make purchases of necessary amount of energy for certain period of time.
- Energy Consumers can see their expenses and statistics, also can do purchases and plan their expenses. For example, it is possible to setup a configuration, where a small shop as a consumer, which doesn't require energy in summer on weekends, just doesn't purchase it.
- Energy Re-sellers can effectively manage their purchases and sells, which also can be easily done online.
All of the users can see data that go through their electricity counters online, as well as statistical reports of it and summary of consuming.
A well developed market model for the customer's structure allows to represent data grouped by customer and its role on the market.
System completely covers all of necessary functionalities, allowing set-up of new users, their access rights, logging of their activities. The incoming information is online updated and collected from different sources. It is possible to manage data sources, administrate user rights and set the rules for data calculating.
We used in this project our Java applets:
- map, it displays online updated information about the town you have selected;
- tree-table, it combines tree hierarchical structure with table columns data representation, you can even sort and resize its columns;
- chart, it displays the data from database making some aggregation calculations.
Used tools and technologies:
Database-driven actions are stored in stored procedures and are simply called from JSP templates.
On the client-side, intensively are used Java applets, allowing to implement more advanced GUI functionality.
User Interface: HTML, DHTML, XML/XSL, JavaScript and Java applets
Server-side: servlets, JSP/Jasper, JDBC
Web-servers: Apache 1.3 (with mod_jserv), Netscape Enterprise Server 3.5
Database: Oracle 8i, Informix 7, MS Access 97
OS: Windows NT 4.0, Linux RedHat, Solaris 7
Time spent:
10 developers were working 14 months = 140 man-months.
|
