SmartClean: an incremental data cleaning tool

This paper presents the SmartClean tool. The purpose of this tool is to detect and correct the data quality problems (DQPs). Compared with existing tools, SmartClean has the following main advantage: the user does not need to specify the execution sequence of the data cleaning operations. For that, an execution sequence was developed. The problems are manipulated (i.e., detected and corrected) following that sequence. The sequence also supports the incremental execution of the operations. In this paper, the underlying architecture of the tool is presented and its components are described in detail. The tool's validity and, consequently, of the architecture is demonstrated through the presentation of a case study. Although SmartClean has cleaning capabilities in all other levels, in this paper are only described those related with the attribute value level.

A influência da idade nos parâmetros metabólicos durante a marcha com andarilho

Introdução: Estruturalmente, a marcha é modificada de acordo com as características de cada individuo, sua natureza morfológica, tipo de atividade, idade e a presença de determinadas doenças, entre outros fatores. Devidas as alterações fisiológicas de envelhecimento, o custo energético da marcha normal por si só é superior nos idosos comparativamente com os jovens. Objetivo: Analisar a influência do uso de andarilho com rodas e fixo nos parâmetros metabólicos de indivíduos com mais de 60 anos e em jovens. Metodologia: realizou-se um estudo analítico transversal numa amostra de 21 voluntários, sendo 11adultos jovens (idade compreendida entre 18 e 25 anos) e 10 são adultos com idade superior a 60 anos. Utilizou-se o sistema K4b2 COSMED de forma a recolher os dados relativos ao consumo energético, quociente respiratório e volume de CO2 produzido. Os participantes realizaram os diferentes tipos de marcha (marcha normal, a três pontos com andarilho fixo, a três pontos modificada com andarilho fixo, a três pontos com andarilho com rodas e a três pontos modificada com andarilho com rodas) durante 10 minutos num percurso rectilíneo de 20 metros. Para a análise estatística recorreu-se ao software IBM SPSS Statistics v20 com um nível de significância de 0,05. Resultados: observou-se que á exceção da marcha normal em todos os outros tipos de marcha com andarilho, os participantes com mais de 60 anos, apresentam valores significativamente superiores aos dos jovens, nomeadamente nas marchas com andarilho fixo, a 3 pontos e a 3 pontos modificada e com andarilho de rodas, na marcha a 3ponto modificada. Verificaram-se diferenças apenas no grupo dos jovens, pois a marcha normal apresentou valores significativamente maiores que as restantes. Conclusão: A idade influenciou os parâmetros metabólicos da marcha normal e com andarilhos fixo e móvel apresentando os idosos um maior gasto energético, bem como os METS utilizados.

Ecotoxicological aspects related to the presence of pharmaceuticals in the aquatic environment

Pharmaceuticals are biologically active and persistent substances which have been recognized as a continuing threat to environmental stability. Chronic ecotoxicity data as well as information on the current distribution levels in different environmental compartments continue to be sparse and are focused on those therapeutic classes that are more frequently prescribed and consumed. Nevertheless, they indicate the negative impact that these chemical contaminants may have on living organisms, ecosystems and ultimately, public health. This article reviews the different contamination sources as well as fate and both acute and chronic effects on non-target organisms. An extensive review of existing data in the form of tables, encompassing many therapeutic classes is presented.

Energy efficient scheduling for cluster-tree wireless sensor networks with time-bounded data flows: application to IEEE 802.15.4/ZigBee

Cluster scheduling and collision avoidance are crucial issues in large-scale cluster-tree Wireless Sensor Networks (WSNs). The paper presents a methodology that provides a Time Division Cluster Scheduling (TDCS) mechanism based on the cyclic extension of RCPS/TC (Resource Constrained Project Scheduling with Temporal Constraints) problem for a cluster-tree WSN, assuming bounded communication errors. The objective is to meet all end-to-end deadlines of a predefined set of time-bounded data flows while minimizing the energy consumption of the nodes by setting the TDCS period as long as possible. Sinceeach cluster is active only once during the period, the end-to-end delay of a given flow may span over several periods when there are the flows with opposite direction. The scheduling tool enables system designers to efficiently configure all required parameters of the IEEE 802.15.4/ZigBee beaconenabled cluster-tree WSNs in the network design time. The performance evaluation of thescheduling tool shows that the problems with dozens of nodes can be solved while using optimal solvers.

How a cyber-physical system can efficiently obtain a snapshot of physical information even in the presence of sensor faults

We present a distributed algorithm for cyber-physical systems to obtain a snapshot of sensor data. The snapshot is an approximate representation of sensor data; it is an interpolation as a function of space coordinates. The new algorithm exploits a prioritized medium access control (MAC) protocol to efficiently transmit information of the sensor data. It scales to a very large number of sensors and it is able to operate in the presence of sensor faults.

Optimization of River Water Quality Surveys by Multivariate Analysis of Physicochemical, Bacteriological and Ecotoxicological Data

This study aims to optimize the water quality monitoring of a polluted watercourse (Leça River, Portugal) through the principal component analysis (PCA) and cluster analysis (CA). These statistical methodologies were applied to physicochemical, bacteriological and ecotoxicological data (with the marine bacterium Vibrio fischeri and the green alga Chlorella vulgaris) obtained with the analysis of water samples monthly collected at seven monitoring sites and during five campaigns (February, May, June, August, and September 2006). The results of some variables were assigned to water quality classes according to national guidelines. Chemical and bacteriological quality data led to classify Leça River water quality as “bad” or “very bad”. PCA and CA identified monitoring sites with similar pollution pattern, giving to site 1 (located in the upstream stretch of the river) a distinct feature from all other sampling sites downstream. Ecotoxicity results corroborated this classification thus revealing differences in space and time. The present study includes not only physical, chemical and bacteriological but also ecotoxicological parameters, which broadens new perspectives in river water characterization. Moreover, the application of PCA and CA is very useful to optimize water quality monitoring networks, defining the minimum number of sites and their location. Thus, these tools can support appropriate management decisions.

Persistent organic pollutant levels in human visceral and subcutaneous adipose tissue in obese individuals - Depot differences and dysmetabolism implications

Background: The role of persistent organic pollutants (POPs) with endocrine disrupting activity in the aetiology of obesity and other metabolic dysfunctions has been recently highlighted. Adipose tissue (AT) is a common site of POPs accumulation where they can induce adverse effects on human health. Objectives: To evaluate the presence of POPs in human visceral (vAT) and subcutaneous (scAT) adipose tissue in a sample of Portuguese obese patients that underwent bariatric surgery, and assess their putative association with metabolic disruption preoperatively, as well as with subsequent body mass index (BMI) reduction. Methods: AT samples (n=189) from obese patients (BMI ≥35) were collected and the levels of 13 POPs were determined by gas chromatography with electron-capture detection (GC-ECD). Anthropometric and biochemical data were collected at the time of surgery. BMI variation was evaluated after 12 months and adipocyte size was measured in AT samples. Results: Our data confirm that POPs are pervasive in this obese population (96.3% of detection on both tissues), their abundance increasing with age (RS=0.310, p<0.01) and duration of obesity (RS=0.170, p<0.05). We observed a difference in AT depot POPs storage capability, with higher levels of ΣPOPs in vAT (213.9±204.2 compared to 155.1±147.4 ng/g of fat, p<0.001), extremely relevant when evaluating their metabolic impact. Furthermore, there was a positive correlation between POP levels and the presence of metabolic syndrome components, namely dysglycaemia and hypertension, and more importantly with cardiovascular risk (RS=0.277, p<0.01), with relevance for vAT (RS=0.315, p<0.01). Finally, we observed an interesting relation of higher POP levels with lower weight loss in older patients. Conclusion: Our sample of obese subjects allowed us to highlight the importance of POPs stored in AT on the development of metabolic dysfunction in a context of obesity, shifting the focus to their metabolic effects and not only for their recognition as environmental obesogens.

TURTLE: Systems and technologies for deep ocean long term presence

This paper describes the TURTLE project that aim to develop sub-systems with the capability of deep-sea long-term presence. Our motivation is to produce new robotic ascend and descend energy efficient technologies to be incorporated in robotic vehicles used by civil and military stakeholders for underwater operations. TURTLE contribute to the sustainable presence and operations in the sea bottom. Long term presence on sea bottom, increased awareness and operation capabilities in underwater sea and in particular on benthic deeps can only be achieved through the use of advanced technologies, leading to automation of operation, reducing operational costs and increasing efficiency of human activity.