Data mining applications in power systems - case-studies and future trends

Presently power system operation produces huge volumes of data that is still treated in a very limited way. Knowledge discovery and machine learning can make use of these data resulting in relevant knowledge with very positive impact. In the context of competitive electricity markets these data is of even higher value making clear the trend to make data mining techniques application in power systems more relevant. This paper presents two cases based on real data, showing the importance of the use of data mining for supporting demand response and for supporting player strategic behavior.

Investigação em curso no Centro de Investigação de Recursos Naturais (CIRN)

Jornadas "Ciência nos Açores – que futuro? Tema Ciências Naturais e Ambiente", Ponta Delgada, 7-8 de Junho de 2013.

Habitat predictive modelling of demersal fish species in the Azores

Dissertação de Mestrado, Estudos Integrados dos Oceanos, 25 de Março de 2013, Universidade dos Açores.

QuEChERS: a new sample preparation approach for the determination of ibuprofen and its metabolites in soils

Ibuprofen is one of the most used active pharmaceutical ingredients worldwide. A new method for the analysis of ibuprofen and its metabolites, hydroxyibuprofen and carboxyibuprofen, in soils is presented. The extraction of these compounds from the soil matrices was performed by using a modified quick, easy, cheap, effective, rugged, and safe (QuEChERS) method. The method involves a single extraction of the investigated compounds with purified water (acidified at pH 2.5 with hydrochloric acid), and a slow and continuous addition of the QuEChERS content, followed by the addition of acidified acetonitrile (1% acetic acid), prior to the determination by liquid chromatography coupled with fluorescence detection (LC–FLD). Validation studies were carried out using soil samples with a range of organic carbon contents. Recoveries of the fortified samples ranged from 79.5% to 101%. Relative standard deviations for all matrix–compound combinations did not exceed 3%. The method quantification limits were ≤22.4 μg kg−1 in all cases. The developed method was applied to the analysis of sixteen real samples.

Direcção de obra – obras de arte auto-estrada Transmontana – área 3

Este relatório diz respeito ao trabalho desenvolvido em ambiente de estágio académico numa Empreitada compreendendo Obras de Arte Correntes e Obras de Arte Especiais inseridas em traçado actual do IP4 que está a ser transformado em Auto-Estrada. As Obras de Arte Correntes compreendem Passagens Superiores, Passagens Inferiores e Passagens superiores de Nó. As Obras de Arte Especiais compreendem duas Pontes com vãos distintos. Todas as Obras de Arte referidas neste relatório contemplam uma solução mista de betão armado “in situ” e tabuleiros com vigas e pré-lajes em betão pré-fabricado. Além da descrição de todas as actividades realizadas em betão armado “in situ”, desde as fundações até ao tabuleiro, descreve também a execução dos diversos tipos de trabalhos de acabamentos. Além das actividades de construção civil, é efectuada uma descrição das actividades a cujo processo de realização estão associados trabalhos de concepção e desenvolvimento, como é o caso dos cimbres. Este relatório faz uma descrição abrangente das funções da Direcção de Obra numa Empreitada de Obras de Arte, que para além da execução da obra, com todas as actividades que lhe são inerentes, compreende várias áreas funcionais que fazem parte de uma empresa de construção civil, como a área comercial, financeira, planeamento, aprovisionamento, controlo orçamental, gestão contratual, gestão de subempreitadas e gestão da qualidade, ambiente e segurança.

Exploração de dados de uma solução mobile wallet usando as técnicas de data mining

A descoberta de conhecimento em dados hoje em dia é um ponto forte para as empresas. Atualmente a CardMobili não dispõe de qualquer sistema de mineração de dados, sendo a existência deste uma mais-valia para as suas operações de marketing diárias, nomeadamente no lançamento de cupões a um grupo restrito de clientes com uma elevada probabilidade que os mesmos os utilizem. Para isso foi analisada a base de dados da aplicação tentando extrair o maior número de dados e aplicadas as transformações necessárias para posteriormente serem processados pelos algoritmos de mineração de dados. Durante a etapa de mineração de dados foram aplicadas as técnicas de associação e classificação, sendo que os melhores resultados foram obtidos com técnicas de associação. Desta maneira pretende-se que os resultados obtidos auxiliem o decisor na sua tomada de decisões.

Monitoring of ochratoxin a exposure of the Portuguese population through a nationwide urine survey — winter 2007

Ochratoxin A (OTA) is a mycotoxin produced by a variety of fungi, such as Penicillium verrucosum and Aspergillium spp., which has been found to have a wide number of potentially deadly toxic effects, and can enter the human organism through a variety of means. It then finds its way into the bloodstream and, after a lengthy process, is eventually excreted through the urine. It can thus be detected in its original form not only in blood samples but also in this biological medium. As such, and in an attempt to evaluate the exposure of the Portuguese population to this mycotoxin, morning urine samples were collected during the Winter of 2007, from each of five geographically distinct Portuguese locations — Bragança, Porto, Coimbra, Alentejo, and Algarve — and subjected to extraction by immunoaffinity columns and to OTA quantification through liquid chromatography coupled with fluorescence detection. Prevalent incidence was higher than 95% with Coimbra being the exception (incidence of 73.3%). In nearly all locations, the OTA content of most samples was found to be above the limit of quantification (LOQ) of 0.008 ng/ml. Indeed, excluding Coimbra, with an OTA content level of 0.014 ng/ml, all regions featured content values over 0.021 ng/ml.

Green production of zero-valent iron nanoparticles using tree leaf extracts

The interest in zero-valent iron nanoparticles has been increasing significantly since the development of a green production method in which extracts from natural products or wastes are used. However, this field of application is yet poorly studied and lacks knowledge that allows the full understanding of the production and application processes. The aim of the present work was to evaluate the viability of the utilization of several tree leaves to produce extracts which are capable of reducing iron(III) in aqueous solution to form nZVIs. The quality of the extracts was evaluated concerning their antioxidant capacity. The results show that: i) dried leaves produce extracts with higher antioxidant capacities than non-dried leaves, ii) the most favorable extraction conditions (temperature, contact time, and volume:mass ratio) were identified for each leaf, iii) with the aim of developing a green, but also low-cost,method waterwas chosen as solvent, iv) the extracts can be classified in three categories according to their antioxidant capacity (expressed as Fe(II) concentration): >40 mmol L−1; 20–40 mmol L−1; and 2–10 mmol L−1; with oak, pomegranate and green tea leaves producing the richest extracts, and v) TEManalysis proves that nZVIs (d=10–20 nm) can be produced using the tree leaf extracts.

Contribution of hospital effluents to the load of pharmaceuticals in urban wastewaters: Identification of ecologically relevant pharmaceuticals

The impact of effluent wastewaters from four different hospitals: a university (1456 beds), a general (350 beds), a pediatric (110 beds) and a maternity hospital (96 beds), which are conveyed to the same wastewater treatment plant (WWTP), was evaluated in the receiving urban wastewaters. The occurrence of 78 pharmaceuticals belonging to several therapeutic classes was assessed in hospital effluents and WWTP wastewaters (influent and effluent) as well as the contribution of each hospital in WWTP influent in terms of pharmaceutical load. Results indicate that pharmaceuticals are widespread pollutants in both hospital and urban wastewaters. The contribution of hospitals to the input of pharmaceuticals in urban wastewaters widely varies, according to their dimension. The estimated total mass loadings were 306 g d− 1 for the university hospital, 155 g d− 1 for the general one, 14 g d− 1 for the pediatric hospital and 1.5 g d− 1 for the maternity hospital, showing that the biggest hospitals have a greater contribution to the total mass load of pharmaceuticals. Furthermore, analysis of individual contributions of each therapeutic group showed that NSAIDs, analgesics and antibiotics are among the groups with the highest inputs. Removal efficiency can go from over 90% for pharmaceuticals like acetaminophen and ibuprofen to not removal for β-blockers and salbutamol. Total mass load of pharmaceuticals into receiving surface waters was estimated between 5 and 14 g/d/1000 inhabitants. Finally, the environmental risk posed by pharmaceuticals detected in hospital and WWTP effluents was assessed by means of hazard quotients toward different trophic levels (algae, daphnids and fish). Several pharmaceuticals present in the different matrices were identified as potentially hazardous to aquatic organisms, showing that especial attention should be paid to antibiotics such as ciprofloxacin, ofloxacin, sulfamethoxazole, azithromycin and clarithromycin, since their hazard quotients in WWTP effluent revealed that they could pose an ecotoxicological risk to algae.

Application of green zero-valent iron nanoparticles to the remediation of soils contaminated with ibuprofen

Zero-valent iron nanoparticles (nZVIs) are often used in environmental remediation. Their high surface area that is associated with their high reactivity makes them an excellent agent capable of transforming/degrading contaminants in soils and waters. Due to the recent development of green methods for the production of nZVIs, the use of this material became even more attractive. However, the knowledge of its capacity to degrade distinct types of contaminants is still scarce. The present work describes the study of the application of green nZVIs to the remediation of soils contaminated with a common anti-inflammatory drug, ibuprofen. The main objectives of this work were to produce nZVIs using extracts of grape marc, black tea and vine leaves, to verify the degradation of ibuprofen in aqueous solutions by the nZVIs, to study the remediation process of a sandy soil contaminated with ibuprofen using the nZVIs, and to compare the experiments with other common chemical oxidants. The produced nZVIs had nanometric sizes and were able to degrade ibuprofen (54 to 66% of the initial amount) in aqueous solutions. Similar remediation efficiencies were obtained in sandy soils. In this case the remediation could be enhanced (achieving degradation efficiencies above 95%) through the complementation of the process with a catalyzed nZVI Fenton-like reaction. These results indicate that this remediation technology represents a good alternative to traditional and more aggressive technologies.

Use of negative information in positioning and tracking algorithms

To avoid additional hardware deployment, indoor localization systems have to be designed in such a way that they rely on existing infrastructure only. Besides the processing of measurements between nodes, localization procedure can include the information of all available environment information. In order to enhance the performance of Wi-Fi based localization systems, the innovative solution presented in this paper considers also the negative information. An indoor tracking method inspired by Kalman filtering is also proposed.

Mining protein structure data

The principal topic of this work is the application of data mining techniques, in particular of machine learning, to the discovery of knowledge in a protein database. In the first chapter a general background is presented. Namely, in section 1.1 we overview the methodology of a Data Mining project and its main algorithms. In section 1.2 an introduction to the proteins and its supporting file formats is outlined. This chapter is concluded with section 1.3 which defines that main problem we pretend to address with this work: determine if an amino acid is exposed or buried in a protein, in a discrete way (i.e.: not continuous), for five exposition levels: 2%, 10%, 20%, 25% and 30%. In the second chapter, following closely the CRISP-DM methodology, whole the process of construction the database that supported this work is presented. Namely, it is described the process of loading data from the Protein Data Bank, DSSP and SCOP. Then an initial data exploration is performed and a simple prediction model (baseline) of the relative solvent accessibility of an amino acid is introduced. It is also introduced the Data Mining Table Creator, a program developed to produce the data mining tables required for this problem. In the third chapter the results obtained are analyzed with statistical significance tests. Initially the several used classifiers (Neural Networks, C5.0, CART and Chaid) are compared and it is concluded that C5.0 is the most suitable for the problem at stake. It is also compared the influence of parameters like the amino acid information level, the amino acid window size and the SCOP class type in the accuracy of the predictive models. The fourth chapter starts with a brief revision of the literature about amino acid relative solvent accessibility. Then, we overview the main results achieved and finally discuss about possible future work. The fifth and last chapter consists of appendices. Appendix A has the schema of the database that supported this thesis. Appendix B has a set of tables with additional information. Appendix C describes the software provided in the DVD accompanying this thesis that allows the reconstruction of the present work.

Technical and economic assessment of energy from Tidal Currents

The present work aims to study the feasibility of deploying a farm of sea current turbines for electricity generation in Portugal. An approach to the tides, which are they, how they are formed, its prediction, is held. It is also conducted a study about the energy of sea currents and it is presented some technology about ocean currents too. A model of tidal height and velocity of the currents it is also developed. The energy produced by a hypothetical park, built in Sines (Portugal), is calculated and afterwards, an economical assessment is performed for two possible scenarios and a sensitivity analysis of NVP (Net Present Value) and LCOE (Levelized Cost of Energy) is figured. The conclusions about the feasibility of the projects are also presented. Despite being desired due to its predictability, this energy source is not yet economically viable as it is in an initial state of development. To push investment in this technology a feed-in tariff of, at least €200/MWh, should be considered.

Improving quality-of-service in wireless sensor networks by mitigating “Hidden-Node Collisions”

Wireless sensor networks (WSNs) emerge as underlying infrastructures for new classes of large-scale networked embedded systems. However, WSNs system designers must fulfill the quality-of-service (QoS) requirements imposed by the applications (and users). Very harsh and dynamic physical environments and extremely limited energy/computing/memory/communication node resources are major obstacles for satisfying QoS metrics such as reliability, timeliness, and system lifetime. The limited communication range of WSN nodes, link asymmetry, and the characteristics of the physical environment lead to a major source of QoS degradation in WSNs-the ldquohidden node problem.rdquo In wireless contention-based medium access control (MAC) protocols, when two nodes that are not visible to each other transmit to a third node that is visible to the former, there will be a collision-called hidden-node or blind collision. This problem greatly impacts network throughput, energy-efficiency and message transfer delays, and the problem dramatically increases with the number of nodes. This paper proposes H-NAMe, a very simple yet extremely efficient hidden-node avoidance mechanism for WSNs. H-NAMe relies on a grouping strategy that splits each cluster of a WSN into disjoint groups of non-hidden nodes that scales to multiple clusters via a cluster grouping strategy that guarantees no interference between overlapping clusters. Importantly, H-NAMe is instantiated in IEEE 802.15.4/ZigBee, which currently are the most widespread communication technologies for WSNs, with only minor add-ons and ensuring backward compatibility with their protocols standards. H-NAMe was implemented and exhaustively tested using an experimental test-bed based on ldquooff-the-shelfrdquo technology, showing that it increases network throughput and transmission success probability up to twice the values obtained without H-NAMe. H-NAMe effectiveness was also demonstrated in a target tracking application with mobile robots - over a WSN deployment.

Data mining languages for business intelligence

Doctoral Thesis in Information Systems and Technologies Area of Engineering and Manag ement Information Systems