Building the data warehouse (2nd ed.)
Building the data warehouse (2nd ed.)
Accountant's Handbook of Information Technology
Accountant's Handbook of Information Technology
Data Warehouse: From Architecture to Implementation
Data Warehouse: From Architecture to Implementation
New Trends in Data Warehousing and Data Analysis
New Trends in Data Warehousing and Data Analysis
| Hi-index | 0.00 |
The following work shows a solution for high complexity problems, with the commissioning of a Data Warehouse System applied to historical databases, which delivers useful information for decision making support in environmental situations, oriented to resolve atmospheric pollutions problems generated by particulate material (PM10). In this work, a hardware-software platform is deployed, wich allows the use of OLAP cubes for the resolution of problems with big volume databases. In this case, the particulate material (PM10) of the city of Santiago, Chile, between the years 1997-2005, logged by the National Environment Commission (CONAMA). For the following work, we use the software f-cube Factory, developed by Carlos Molina Fernandez PhD in his doctoral thesis, "imprecision and uncertainty in the multidimensional model: data mining applied" (DECSAI, Universidad de Granada, Span, 2005). The software F-Cube Factory is an OLAP (Online Analytical Processing) system, wich allows the definition, construction and query of data cubes (fuzzy and crisp). All realized from tables stored in a relational database. The reports generated by this software can be seen in table or graphic format, according with the researcher's choice. The first part of the works, describes the current situation of the Santiago's basin, current predictive model used to decree environmental warnings and a multidimensional model proposition. The second part consist in the creation of a Data Warehouse the can be used for the F-cube Factory tool to store the information relative to the atmospheric pollution in the city of Santiago de Chile, and so, get views and interesting dimensions generated from the stored data.