The relational model for database management: version 2
The relational model for database management: version 2
Knowledge Management in Environmental Decision Support Systems
AI Communications
Hi-index | 0.00 |
Because air pollution is one of the most serious environmental problems, the need of effective environmental decisions applied to the Metropolitan Valley of Puebla in Mexico (ZMVP), is addressed in this paper. Decision support systems integrate appropriate data with conceptual models that can include simulation, statistical tests and/or optimization. The state of Puebla is the fourth largest in Mexico, and the ZMVP is an important industrial zone with a population over 5 million of people. According to SEMARNAT [6], around 82% of emissions is generated by mobile sources, 15% by area sources and 3% by industry. The contribution of particles is less than 10 micros in 481 tons per year. Using a raw dataset from the most polluted area of the ZMVP (years 2000-2009) and a processed dataset (years 2008-2009) with data from the four different stations in the region into a Relational Object Oriented Design [2] framework, a multidimensional information process was used with OLAP (Online Analytical Processing) [3] using ETL (Extraction, Transformation and Load) to manage the relational data stores.