Information Technology Reference
In-Depth Information
4.3
Data Warehouse Model
A Data Warehouse (DW) can be defined as a relational database, designed for query and
analysis instead of transactional processing databases usually used on organizations.
Used to store a large number of different data sources, current and historical, directed to
the subject, a dimensional or standardized, allowing selective analysis of data in order to
assist managers and others end users in organizational decision making process [4], [8],
[9], [21] and [25]. The multidimensional model of the data warehouse is represented in
the Figure 2. This model is a fact constellation schema, composed by two fact tables, the
FACT_REQUEST and the FACT_WORKFLOW, and nine dimension tables. The two
fact tables share the dimensions DIM_TIME and DIM_AREA.
Fig. 2.
Data warehouse model
In table 3 it is possible to observe some of the local government main goals within
each of the dimensions.
Table 3.
Main goals within each of the dimensions
Dimension
Main Goals
TYPE REQUEST
Provide helps to identify patterns on type of requests entry
Provide helps to identify patterns on type of contact used for the
citizens and companies
TYPE CONTACT
Provide performance indicators (identifies slower requests
and bottlenecks in the workflow)
WORKFLOW MOVE
LOCATION
Trend analysis related with type of requests per location
TIME
Helps related analysis with time
CIRCUIT
Trend analysis related with type of circuit used.
ORGANIC UNIT
Statistical indicators related to performance of organization
USER
Statistical indicators related to performance of organization
AREA
Trend analysis related with type of area used in requests
Search WWH ::
Custom Search