Development of Multi-Componential Decision Support System in Dynamically Changing Application Domain of Environment Protection - Efficient Decision Support Systems: Practice and Challenges from Current to Future - page 419

5.2 DW1 client application
For the WRMIS VANMON database a special client application has been developed, that
enables the users to update the central WRMIS VANMON database by use of the Internet.
The application makes it possible for the staffs both in the Regional departments and in
offices of EPD to work with the common data.
The application can be downloaded from the WRMIS portal and installed on a local PC. The
use of this application is managed by the WRMIS VANMON database administrator, who
grants user rights to all users.
The client application, the portal SOAP server, and the database SOAP servers have all been
developed by use of Delphi. The server applications run on the Internet Information Server,
while the client application can run in a Windows environment on the local PCs.
5.3 Point source database (DW2)
A second data warehouse similar to the surface water data warehouse was established on
top of the point source (emissions) database. The system gives access to information on
outlets from point sources. The database was made up by redesigning and integrating
separate annual FoxPro databases into one common database.
The functionality of the Point Source database and the corresponding Web Service is rather
similar to that of the Surface Water database.
5.4.Ground water database (DW3)
The third data warehouse has been found in the Geological Survey of Lithuania (GS). The
WRMIS staff in GS has elaborated this data warehouse in the Java environment. Web
Services that give access to information stored in the GS Oracle Ground water database have
been developed and made available on the Internet.
The technology used: (1) Programming language [lgt.* classes]; Java JSDK 1.4 API; (2) SOAP
server [SOAP Servlet], Apache SOAP v2.3.1; (3) Servlet Container [Web server], Apache
Tomcat 4.04; (4) Database [geological dataset], Oracle8 Enterprise Edition Release 8.0.6.2.0;
(5) Link to Database, Oracle JDBC Thin JDBC Driver; (6) Server Operating System, SunOS
5.8 [Solaris 8] Generic_108528-17 sun4u sparc SUNW, UltraAX-i2; (7) Server Platform
[hardware], Sun Fire V120 Server, 650 MHz UltraSPARC-IIi.
The WRMIS prototype has a wide use of digital maps in the GUI both for presentation and
administration purposes. All digital maps are stored either in ArcSDE, or in shape files. The
system uses maps for selecting data. Two map servers have been developed, making it
possible for the users to receive information in a map and to compose their own maps on
request. The first solution has been developed by means of the MapServer (hosted in EPA)
and shape files.
The MapServer is an open source development environment 1 ; MapServer functionality is
easy to integrate in Internet-based GIS applications. Another solution has been achieved by
use of ArcIMS and ArcSDE (hosted in the Ministry of Environment).
A meta-database with information on the digital maps used in the Map tools has been
formed. The meta-database holds information described as mandatory in the ISO 19115
standard 2 .
1 http://mapserver.gis.umn.edu/
2 http://www.isotc211.org/scope.htm#19115 , http://www.isotc211.org/publications.htm