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.

Ontologies for reusing data cleaning knowledge

The emergence of new business models, namely, the establishment of partnerships between organizations, the chance that companies have of adding existing data on the web, especially in the semantic web, to their information, led to the emphasis on some problems existing in databases, particularly related to data quality. Poor data can result in loss of competitiveness of the organizations holding these data, and may even lead to their disappearance, since many of their decision-making processes are based on these data. For this reason, data cleaning is essential. Current approaches to solve these problems are closely linked to database schemas and specific domains. In order that data cleaning can be used in different repositories, it is necessary for computer systems to understand these data, i.e., an associated semantic is needed. The solution presented in this paper includes the use of ontologies: (i) for the specification of data cleaning operations and, (ii) as a way of solving the semantic heterogeneity problems of data stored in different sources. With data cleaning operations defined at a conceptual level and existing mappings between domain ontologies and an ontology that results from a database, they may be instantiated and proposed to the expert/specialist to be executed over that database, thus enabling their interoperability.

Osteometria radiográfica de fetos: contributo para a estimativa da idade à data da morte

A estimativa da idade gestacional em restos cadavéricos de fetos é importante em contextos forenses. Para esse efeito, os especialistas forenses recorrem à avaliação do padrão de calcificação dentária e/ou ao estudo do esqueleto. Neste último, o comprimento das diáfises de ossos longos é um dos métodos mais utilizados, sendo utilizadas tabelas e equações de regressão de obras pouco actuais ou baseadas em dados ecográficos, cujas medições diferem das efectuadas directamente no osso. Este trabalho tem como objectivo principal a construção de tabelas e equações de regressão para a população Portuguesa, com base na medição das diáfises de fémur, tíbia e úmero, utilizando radiografias post-mortem, que não diferem muito das medições em osso. Pretende-se também determinar qual dos três ossos é mais credível e se existem diferenças significativas entre fetos de género feminino e de género masculino.

Cluster Analysis of Business Data

This journal provides immediate open access to its content on the principle that making research freely available to the public supports a greater global exchange of knowledge.

Superefficiency and Multiplier Adjustment in Data Envelopment Analysis

Copyright © 2013 Springer Netherlands.

Multiplier adjustment in data envelopment analysis

V Congreso de Eficiencia y Productividad EFIUCO, Córdoba, 19-20 Mayo 2011.

Caracterização da pescaria do peixe-espada preto nos Açores de 2008 a 2012

Dissertação de Mestrado, Estudos Integrados dos Oceanos, 13 de Fevereiro de 2014, Universidade dos Açores.

Optoelectronic Digital Capture Device Based on Si/C Multilayer Heterostructures

Combined tunable WDM converters based on SiC multilayer photonic active filters are analyzed. The operation combines the properties of active long-pass and short-pass wavelength filter sections into a capacitive active band-pass filter. The sensor element is a multilayered heterostructure produced by PE-CVD. The configuration includes two stacked SiC p-i-n structures sandwiched between two transparent contacts. Transfer function characteristics are studied both theoretically and experimentally. Results show that optical bias activated photonic device combines the demultiplexing operation with the simultaneous photodetection and self amplification of an optical signal acting the device as an integrated photonic filter in the visible range. Depending on the wavelength of the external background and irradiation side, the device acts either as a short- or a long-pass band filter or as a band-stop filter. The output waveform presents a nonlinear amplitude-dependent response to the wavelengths of the input channels. A numerical simulation and two building-blocks active circuit is presented and gives insight into the physics of the device.

Análise de Resultados de Simulações não Estacionárias Aperiódicas e Cíclicas

Tese de Doutoramento, Matemática (Investigação Operacional), 23 de Setembro de 2006, Universidade dos Açores.

O uso do smartphone na avaliação do risco de queda associado ao envelhecimento

Introdução: O declínio do equilíbrio, da força dos membros inferiores e o medo de cair são fatores de risco de queda associados ao envelhecimento e a sua avaliação pode ser realizada pelo teste One Leg Standing (OLS), Sit to Stand (STS) e pela Falls Eficacy Scale (FES), respetivamente. As aplicações para smartphone constituem uma alternativa para a avaliação dos fatores de risco de queda no envelhecimento. Objetivo: Analisar a capacidade de uma aplicação para smartphone na avaliação dos testes STS, OLS e FES. Metodologia: Realizou-se um estudo analítico numa amostra de 27 voluntários com idade ≥ 60 anos. Realizaram-se os testes STS, OLS e a FES (versão iconográfica, apresentada no smartphone). Os dados foram recolhidos simultaneamente por um smartphone e pelo Qualisys Motion Capture Systems associado a uma plataforma de forças. Foi utilizado o r de Pearson ou Spearman para analisar as possíveis correlações. Resultados: No STS obteve-se uma correlação muito forte (rp=0.97) no número de repetições de ciclos Sit Stand Sit (SLS) e forte na duração média do SLS (rp=0.85) e das subfases Sit to Stand (rp=0.69) e Stand to Sit (rp=0.778), com p<0.001. As medidas de inclinação do tronco apresentaram correlações fortes, com exceção do ângulo inicial (p≥0.05). No OLS, verificou-se uma correlação moderada entre o deslocamento do centro de pressão peak to peak médio-lateral (rs=0.45; p=0.017) e antero-posterior (rs=0.39; p=0.046), root mean square médio-lateral (rs=0.39; p=0.046) e antero-posterior (rs=0.46; p=0.017) e área do estatocinesiograma (rs=0.45; p=0.018). Na FES obteve-se uma correlação moderada em três categorias: ‘tomar banho/duche’ (rs=0.49; p=0.010), ‘deitar/levantar da cama (rs=0.43; p=0.024) e ‘chegar aos armários’ (rs=0.38; p=0.050). Conclusão: A aplicação para smartphone parece avaliar corretamente os ciclos e a variação da inclinação do tronco no STS, porém parece necessitar de ser reajustada na FES e na velocidade do deslocamento do centro de pressão, no OLS.

Modelling the distribution of cetaceans using opportunistic presence-only data in S. Miguel Island (Azores)

25th Annual Conference of the European Cetacean Society, Cadiz, Spain 21-23 March 2011.

Analysis of residence patterns of Sperm whales (Physeter macrocephalus) in Azores Islands using opportunistic data

27th Annual Conference of the European Cetacean Society. Setúbal, Portugal, 8-10 April 2013.

Interpretation of gravity data to delineate structural features connected to low-temperature geothermal resources at Northeastern Portugal

A great number of low-temperature geothermal fields occur in Northern-Portugal related to fractured rocks. The most important superficial manifestations of these hydrothermal systems appear in pull-apart tectonic basins and are strongly conditioned by the orientation of the main fault systems in the region. This work presents the interpretation of gravity gradient maps and 3D inversion model produced from a regional gravity survey. The horizontal gradients reveal a complex fault system. The obtained 3D model of density contrast puts into evidence the main fault zone in the region and the depth distribution of the granitic bodies. Their relationship with the hydrothermal systems supports the conceptual models elaborated from hydrochemical and isotopic water analyses. This work emphasizes the importance of the role of the gravity method and analysis to better understand the connection between hydrothermal systems and the fractured rock pattern and surrounding geology. (c) 2013 Elsevier B.V. All rights reserved.

Classification and staging of chronic liver disease from multimodal data

Chronic liver disease (CLD) is most of the time an asymptomatic, progressive, and ultimately potentially fatal disease. In this study, an automatic hierarchical procedure to stage CLD using ultrasound images, laboratory tests, and clinical records are described. The first stage of the proposed method, called clinical based classifier (CBC), discriminates healthy from pathologic conditions. When nonhealthy conditions are detected, the method refines the results in three exclusive pathologies in a hierarchical basis: 1) chronic hepatitis; 2) compensated cirrhosis; and 3) decompensated cirrhosis. The features used as well as the classifiers (Bayes, Parzen, support vector machine, and k-nearest neighbor) are optimally selected for each stage. A large multimodal feature database was specifically built for this study containing 30 chronic hepatitis cases, 34 compensated cirrhosis cases, and 36 decompensated cirrhosis cases, all validated after histopathologic analysis by liver biopsy. The CBC classification scheme outperformed the nonhierachical one against all scheme, achieving an overall accuracy of 98.67% for the normal detector, 87.45% for the chronic hepatitis detector, and 95.71% for the cirrhosis detector.

Data mining framework for fatty liver disease classification in ultrasound: a hybrid feature extraction paradigm

PURPOSE: Fatty liver disease (FLD) is an increasing prevalent disease that can be reversed if detected early. Ultrasound is the safest and ubiquitous method for identifying FLD. Since expert sonographers are required to accurately interpret the liver ultrasound images, lack of the same will result in interobserver variability. For more objective interpretation, high accuracy, and quick second opinions, computer aided diagnostic (CAD) techniques may be exploited. The purpose of this work is to develop one such CAD technique for accurate classification of normal livers and abnormal livers affected by FLD. METHODS: In this paper, the authors present a CAD technique (called Symtosis) that uses a novel combination of significant features based on the texture, wavelet transform, and higher order spectra of the liver ultrasound images in various supervised learning-based classifiers in order to determine parameters that classify normal and FLD-affected abnormal livers. RESULTS: On evaluating the proposed technique on a database of 58 abnormal and 42 normal liver ultrasound images, the authors were able to achieve a high classification accuracy of 93.3% using the decision tree classifier. CONCLUSIONS: This high accuracy added to the completely automated classification procedure makes the authors' proposed technique highly suitable for clinical deployment and usage.