is responsible for the DAO (Data Access Objects),
or the direct Data-Base access. This model allows
for a transparent persistence of the objects models.
The data persistence allows us to aggregate
several features to the proposed architecture, like the
following: Transitivity persistence; transparent
retrieval of data-objects (on a given object graph);
The purpose of the data-layer is to allow for an
intelligent way to store object-oriented data,
allowing for the convergence of heterogeneous data-
bases.
4 AN E-GOV SYSTEM FOR
CITIES
On this section, we will present a use case for a
complete system for cities management, which can
manage all services, citizen records, processes
management and relevant data for a city’s
administration. The main purpose of this system is to
provide consistent information to the manager to
make the right decisions. From this prerogative,
emerged the SIGM (Integrated System for
Municipal e-Gov).
The application integration under a same domain
was possible with the development of a single data
base, covering, for example, citizens, business,
social data, departments, processes, internal services,
online services, systems users, addresses and others.
Therefore, all data are concentrated and correlated
under the same concept “Citizen Single Data Base”
(BDUC).
Figure 2: SIGM System Modules.
Through this concept, we achieved the
interconnection between different modules of an e-
gov system in an efficient and easy way, as show in
Figure
2. We have adopted the Hibernate
technology for data base communication, which
allows the independence of the DBSM (Data base
System Management).
As this technology works with data object’s
concept, the conventional relational data base BDUC
was created to facilitate the implementation and take
advantage of all of the Hibernate resources.
Therefore, we created a data base under two
perspectives: object-oriented and relational, thus, it
is possible to represent any data evolved with e-gov
and its legacy systems.
This modeling, as in object oriented system,
allows us to reuse data for creation of new tables,
without affecting the system operation.
In particular for this use case, we used the
Microsoft Windows 2003 Server operational system
and the Oracle DBSM, but we can also apply the
same use case to others platforms.
The SIGM can be deployed in any city, even
those that have legacy application in use; since this
kind of integration was planned by the adopted
architecture and can be done in several ways:
- SIGM control the legacy applications through
its functionalities and the BDUC data base.
- The legacy applications are incorporated by the
SIGM.
- The legacy applications can use the business
rules already implemented in the SIGM´s EJB
layer.
After deployment, the SIGM can be accessed
from any computer in any city location, by any
person (citizen or government employee) registered
in the system. These users can request certain
services through the Internet, without the need to
move to the city hall or any other service point.
This architecture also offers the possibility for
application distribution on multiple servers, not only
in the system execution, but also on its development.
By distributing the development of a system of this
magnitude, we obtain independence between the
developer’s teams and we can control more
effectively each module implementation. By
separating the business layer from the web layer, it
is possible that others systems can use its
functionalities without affecting the SIGM´s
operation. This can be done by direct access of the
EJB containers which are on the business layer.
To keep in order with the proposed architecture,
on the web layer we adopted the Struts framework,
which is an open source framework that works on
MVC architecture and provides several control
components to create dynamic Java web applications
(Husted, Dumoulin, Franciscus, Winterfeldt, 2003).
This architecture also provided the development of
an authentication system, which allows the SIGM to
manage the permissions and profile control of the
SIGM´s users and users of any other legacy
ICE-B 2008 - International Conference on e-Business
478