Information Technology Reference
In-Depth Information
4.2
Architecture for Business Intelligence Platform
The architecture incorporates the different concepts presented by Teixeira et al., [24],
where it is possible to simply identify the layers that make the BI architecture
implemented in the Town Hall. This architecture is presented in Figure 1. This wide-
ranging architecture satisfies not only the needs of this local government, but also
allows it to adjust other local governments.
Fig. 1.
Implemented architecture for Business Intelligence platform for the local government
As can be seen in the table 1, each layer of the architecture also presents particular
non-functional requirements to be taken into account in order to guarantee the success
of the BI solution. Table 2 discriminates the tools used on the solution development.
Table 1.
Architecture requirement application by layer
Layer
Architecture requirement application
“Data Sources”
Information reliability.
Performance; efficiency, real-time data warehousing;
scalability; information reliability; simplicity, clarity;
robustness; real-time.
“Data Movement streaming
engines”
Performance; efficiency; scalability; information reliability;
simplicity, clarity; integrity.
“Data Warehouse Servers”
“Mied-tier”
Usability; modifiability; maintainability; precision.
“Front-end applications”
Usability; user-friendliness; intuitive.
Table 2.
Application used by layer
Layer
Application
Description
Microsoft SQL
Server 2008
“Data Sources”
Database management systems, responsible for
the ETL process automation, DW storage and
OLAP cubes creation.
“Data Movement
streaming engines”
Microsoft SQL
Server 2008
“Data Warehouse
Servers”
Microsoft SQL
Server 2008
“Mied-tier”
QlikView
Responsible for analytical processing and for the
front-end or user interface
“Front-end
applications”
QlikView
Search WWH ::
Custom Search