Integrating the development of data mining and data warehouses via model-driven engineering

Data mining is one of the most important analysis techniques to automatically extract knowledge from large amount of data. Nowadays, data mining is based on low-level specifications of the employed techniques typically bounded to a specific analysis platform. Therefore, data mining lacks a modelling architecture that allows analysts to consider it as a truly software-engineering process. Bearing in mind this situation, we propose a model-driven approach which is based on (i) a conceptual modelling framework for data mining, and (ii) a set of model transformations to automatically generate both the data under analysis (that is deployed via data-warehousing technology) and the analysis models for data mining (tailored to a specific platform). Thus, analysts can concentrate on understanding the analysis problem via conceptual data-mining models instead of wasting efforts on low-level programming tasks related to the underlying-platform technical details. These time consuming tasks are now entrusted to the model-transformations scaffolding. The feasibility of our approach is shown by means of a hypothetical data-mining scenario where a time series analysis is required.

Intérprete y portavoz: la figura del diputado en las elecciones de 1854 en España

Las elecciones de 1854 en España se desarrollaron en un contexto político que favoreció la participación en el marco del sufragio censitario. Un número significativo de candidatos publicaron manifiestos en la prensa, a través de los cuales es posible delinear varios rasgos de los modelos representativos existentes en la cultura política de la época. El análisis de los manifiestos constituye el núcleo central de este texto, donde apuntamos los elementos que conforman la figura del diputado a Cortes.

Spatiotemporal characteristics of the Huangtupo landslide in the Three Gorges region (China) constrained by radar interferometry

The Huangtupo landslide is one of the largest in the Three Gorges region, China. The county-seat town of Badong, located on the south shore between the Xiling and Wu gorges of the Yangtze River, was moved to this unstable slope prior to the construction of the Three Gorges Project, since the new Three Gorges reservoir completely submerged the location of the old city. The instability of the slope is affecting the new town by causing residential safety problems. The Huangtupo landslide provides scientists an opportunity to understand landslide response to fluctuating river water level and heavy rainfall episodes, which is essential to decide upon appropriate remediation measures. Interferometric Synthetic Aperture Radar (InSAR) techniques provide a very useful tool for the study of superficial and spatially variable displacement phenomena. In this paper, three sets of radar data have been processed to investigate the Huangtupo landslide. Results show that maximum displacements are affecting the northwest zone of the slope corresponding to Riverside slumping mass I#. The other main landslide bodies (i.e. Riverside slumping mass II#, Substation landslide and Garden Spot landslide) exhibit a stable behaviour in agreement with in situ data, although some active areas have been recognized in the foot of the Substation landslide and Garden Spot landslide. InSAR has allowed us to study the kinematic behaviour of the landslide and to identify its active boundaries. Furthermore, the analysis of the InSAR displacement time-series has helped recognize the different displacement patterns on the slope and their relationships with various triggering factors. For those persistent scatterers, which exhibit long-term displacements, they can be decomposed into a creep model (controlled by geological conditions) and a superimposed recoverable term (dependent on external factors), which appears closely correlated with reservoir water level changes close to the river's edge. These results, combined with in situ data, provide a comprehensive analysis of the Huangtupo landslide, which is essential for its management.

El impacto de la crisis económica sobre la movilidad internacional de los residentes extranjeros en la provincia de Alicante

Introducción: En este estudio se investigan los efectos de la crisis económica en los flujos migratorios internacionales. Específicamente, se realiza un análisis comparado sobre los comportamientos en la movilidad residencial de los principales grupos de residentes a partir de las Estadísticas de Variaciones Residenciales (EVR) de 2005 a 2010 en Alicante. Método: Se analizan los microdatos de las EVR para comparar las entradas y salidas de inmigrantes procedentes de los países que aglutinan a las personas que se trasladan orientadas por motivos más cercanos a la esfera del ocio que a la del trabajo, con el grupo de nacionalidades que concentra a la mayoría de los inmigrantes laborales que llegaron atraídos por las ofertas de empleo generadas con la expansión del sector inmobiliario. Resultados: Entre los años 2007 y 2009 se redujeron mucho las variaciones residenciales de entrada en la provincia Alicante desde el extranjero, mientras que se incrementaron las variaciones relacionadas con las salidas. Aunque existen diferencias en el balance de entradas y salidas según la zona de la provincia, la nacionalidad y la edad de los migrantes, la crisis parece asociarse con una tendencia a la reducción del número de residentes extranjeros en general. Discusión o Conclusión: Se concluye que la crisis no sólo ha generado un éxodo de los ciudadanos con menos recursos económicos, también ha provocado la salida masiva de aquellos otros inmigrantes cuya presencia en España se asocia con el consumo.

Economic crisis and tourism competitiveness in Spain: permanent effects or transitory shocks?

This paper considers the influence of business cycles and economic crises on Spain's tourism competitiveness. This competitiveness is measured by its share in world tourism. Analysing the presence of unit roots in the market share series from 1958 to 2010, the permanent effects of economic crises on competitiveness are evaluated. The evidence from standard linear unit root tests indicates that crises on Spanish market shares are highly persistent. When we account for endogenously determined structural breaks, we obtain greater support for stationarity, but breakpoints are identified with major economic crises. Therefore the main conclusion obtained is that the effects of the economic shocks are not neutral on competitiveness, with the negative effects being more persistent in highly intensive crises. These crises reinforce a natural downward trend of the Spanish world tourism market share caused by the natural emergence of new competing destinations and by the maturity of the Spain's principal tourism product.

Trends in mortality due to motor vehicle traffic accident injuries between 1987 and 2011 in a Spanish region (Comunitat Valenciana)

Objective: To analyse the time evolution of the rates of mortality due to motor vehicle traffic accidents (MVTA) injuries that occurred among the general population of Comunitat Valenciana between 1987 and 2011, as well as to identify trend changes by sex and age group. Methods: An observational study of annual mortality trends between 1987 and 2011. We studied all deaths due to MVTA injuries that occurred during this period of time among the non-institutionalised population residing in Comunitat Valenciana (a Spanish Mediterranean region that had a population of 5,117,190 inhabitants in 2011). The rates of mortality due to MVTA injuries were calculated for each sex and year studied. These rates were standardised by age for the total population and for specific age groups using the direct method (age-standardised rate – ASR). Joinpoint regression models were used in order to detect significant trend changes. Additionally, the annual percentage change (APC) of the ASRs was calculated for each trend segment, which is reflected in statistically significant joinpoints. Results: For all ages, ASRs decrease greatly in both men and women (70% decrease between 1990 and 2011). In 1990 and 2011, men have rates of 36.5 and 5.2 per 100,000 men/year, respectively. In the same years, women have rates of 8.0 and 0.9 per 100,000 women/year, respectively. This decrease reaches up to 90% in the age group 15–34 years in both men and women. ASR ratios for men and women increased over time for all ages: this ratio was 3.9 in 1987; 4.6 in 1990; and 5.8 in 2011. For both men and women, there is a first significant segment (p < 0.05) with an increasing trend between 1987 and 1989–1990. After 1990, there are 3 segments with a significant decreasing APC (1990–1993, 1993–2005 and 2005–2011, in the case of men; and 1989–1996, 1999–2007 and 2007–2011, in the case of women). Conclusion: The risk of death due to motor vehicle traffic accidents injuries has decreased significantly, especially in the case of women, for the last 25 years in Comunitat Valenciana, mainly as of 2006. This may be a consequence of the road-safety measures that have been implemented in Spain and in Comunitat Valenciana since 2004. The economic crisis that this country has undergone since 2008 may have also been a contributing factor to this decrease. Despite the decrease, ASR ratios for men and women increased over time and it is still a high-risk cause of death among young men. It is thus important that the measures that helped decrease the risk of death are maintained and improved over time.

Software for video-based multi-point frequency measuring and mapping

Complementary programs

Methods and algorithms for video-based multi-point frequency measuring and mapping

Software for video-based multi-point frequency measuring and mapping: http://hdl.handle.net/10045/53429

Electrochemical Characterization of Shape-Controlled Pt Nanoparticles in Different Supporting Electrolytes

The voltammetric profile of preferentially shaped platinum nanoparticles has been used to analyze the different sites present on the surface. For the first time, this analysis has been made in NaOH solutions and revisited in sulfuric and perchloric acid media. The comparison with the voltammetric profiles of the model surfaces, that is, single-crystal electrodes, allows assigning the different signals appearing in the voltammograms of the nanoparticle to specific sites on the surface. A good correlation between the shape of the nanoparticle determined by TEM and the voltammetric profile is obtained. For the nanoparticles characterized in alkaline media, the adsorbed species on the surface have been characterized, and three major regions can be identified. Below 0.2 V, the major contribution is due to hydrogen adsorption, whereas above 0.6 V, adsorbed OH is the main species on the surface. Between those values, the signals are due to the competitive adsorption/desorption process of OH/H. New criteria for determining the active area in NaOH solutions has been proposed. In this medium, the total charge density measured between 0.06 and 0.90 V stands for 390 μC cm–2. The areas measured are in perfect agreement with those measured in acid media. Once the nanoparticles have been characterized, the behavior of the nanoparticles toward CO oxidation is analyzed and compared with that observed for single-crystal electrodes.

SCAPHOID AND LUNATE CARPAL MECHANICS OVER THE SPECTRUM OF HEALTHY FUNCTION

When ligaments within the wrist are damaged, the resulting loss in range of motion and grip strength can lead to reduced earning potential and restricted ability to perform important activities of daily living. Left untreated, ligament injuries ultimately lead to arthritis and chronic pain. Surgical repair can mitigate these issues but current procedures are often non-anatomic and unable to completely restore the wrist’s complex network of ligaments. An inability to quantitatively assess wrist function clinically, both before and after surgery, limits the ability to assess the response to clinical intervention. Previous work has shown that bones within the wrist move in a similar pattern across people, but these patterns remain challenging to predict and model. In an effort to quantify and further develop the understanding of normal carpal mechanics, we performed two studies using 3D in vivo carpal bone motion analysis techniques. For the first study, we measured wrist laxity and performed CT scans of the wrist to evaluate 3D carpal bone positions. We found that through mid-range radial-ulnar deviation range of motion the scaphoid and lunate primarily flexed and extended; however, there was a significant relationship between wrist laxity and row-column behaviour. We also found that there was a significant relationship between scaphoid flexion and active radial deviation range of motion. For the second study, an analysis was performed on a publicly available database. We evaluated scapholunate relative motion over a full range of wrist positions, and found that there was a significant amount of variation in the location and orientation of the rotation axis between the two bones. Together the findings from the two studies illustrate the complexity and subject specificity of normal carpal mechanics, and should provide insights that can guide the development of anatomical wrist ligament repair surgeries that restore normal function.

Effects of climate change on fisheries : from a global to a regional perspective

Tese de doutoramento, Biologia (Biologia Marinha e Aquacultura), Universidade de Lisboa, Faculdade de Ciências, 2016

The dynamics of leniency application and the knock-on effect of cartel enforcement. Bruegel Working Paper 2016/02, February 2016

The authors study the timing of leniency applications using a novel application of multi-spell discrete-time survival analysis for a sample of cartels prosecuted by the European Commission between 1996 and 2014. The start of a Commission investigation does not affect the rate by which conspirators apply for leniency in the market investigated, but increases the rate of application in separate markets in which a conspirator in the investigated market also engaged in collusion. The revision of the Commission’s leniency programme in 2002 increased the rate of pre-investigation applications. Our results shed light on enforcement efforts against cartels and other forms of

Direct electrospinning of 3D auricle-shaped scaffolds for tissue engineering applications.

Thirty-two poly(ε)caprolactone (PCL) scaffolds have been produced by electrospinning directly into an auricle-shaped mould and seeded with articular chondrocytes harvested from bovine ankle joints. After seeding, the auricle shaped constructs were cultured in vitro and analysed at days 1, 7, 14 and 21 for regional differences in total DNA, glycosaminoglycan (GAG) and collagen (COL) content as well as the expression of aggrecan (AGG), collagen type I and type II (COL1/2) and matrix metalloproteinase 3 and 13 (MMP3/13). Stress-relaxation indentation testing was performed to investigate regional mechanical properties of the electrospun constructs. Electrospinning into a conductive mould yielded stable 3D constructs both initially and for the whole in vitro culture period, with an equilibrium modulus in the MPa range. Rapid cell proliferation and COL accumulation was observed until week 3. Quantitative real time PCR analysis showed an initial increase in AGG, no change in COL2, a persistent increase in COL1, and only a slight decrease initially for MMP3. Electrospinning of fibrous scaffolds directly into an auricle-shape represents a promising option for auricular tissue engineering, as it can reduce the steps needed to achieve an implantable structure.

Caractérisation tridimensionnelle de l’amplitude articulaire de l’épaule

L’épaule est l’articulation la plus mobile et la plus instable du corps humain dû à la faible quantité de contraintes osseuses et au rôle des tissus mous qui lui confèrent au moins une dizaine de degrés de liberté. La mobilité de l’épaule est un facteur de performance dans plusieurs sports. Mais son instabilité engendre des troubles musculo-squelettiques, dont les déchirures de la coiffe des rotateurs sont fréquentes et les plus handicapantes. L’évaluation de l’amplitude articulaire est un indice commun de la fonction de l’épaule, toutefois elle est souvent limitée à quelques mesures planaires pour lesquelles les degrés de liberté varient indépendamment les uns des autres. Ces valeurs utilisées dans les modèles de simulation musculo-squelettiques peuvent amener à des solutions non physiologiques. L’objectif de cette thèse était de développer des outils pour la caractérisation de la mobilité articulaire tri-dimensionnelle de l’épaule, en passant par i) fournir une méthode et son approche expérimentale pour évaluer l’amplitude articulaire tridimensionnelle de l’épaule incluant des interactions entre les degrés de liberté ; ii) proposer une représentation permettant d’interpréter les données tri-dimensionnelles obtenues; iii) présenter des amplitudes articulaires normalisées, iv) implémenter une amplitude articulaire tridimensionnelle au sein d’un modèle de simulation numérique afin de générer des mouvements sportifs optimaux plus réalistes; v) prédire des amplitudes articulaires sécuritaires et vi) des exercices de rééducation sécuritaires pour des patients ayant subi une réparation de la coiffe des rotateurs. i) Seize sujets ont été réalisé séries de mouvements d’amplitudes maximales actifs avec des combinaisons entre les différents degrés de liberté de l’épaule. Un système d’analyse du mouvement couplé à un modèle cinématique du membre supérieur a été utilisé pour estimer les cinématiques articulaires tridimensionnelles. ii) L’ensemble des orientations définies par une séquence de trois angles a été inclus dans un polyèdre non convexe représentant l’espace de mobilité articulaire prenant en compte les interactions entre les degrés de liberté. La combinaison des séries d’élévation et de rotation est recommandée pour évaluer l’amplitude articulaire complète de l’épaule. iii) Un espace de mobilité normalisé a également été défini en englobant les positions atteintes par au moins 50% des sujets et de volume moyen. iv) Cet espace moyen, définissant la mobilité physiologiques, a été utilisé au sein d’un modèle de simulation cinématique utilisé pour optimiser la technique d’un élément acrobatique de lâcher de barres réalisée par des gymnastes. Avec l’utilisation régulière de limites articulaires planaires pour contraindre la mobilité de l’épaule, seulement 17% des solutions optimales sont physiologiques. En plus, d’assurer le réalisme des solutions, notre contrainte articulaire tridimensionnelle n’a pas affecté le coût de calculs de l’optimisation. v) et vi) Les seize participants ont également réalisé des séries d’amplitudes articulaires passives et des exercices de rééducation passifs. La contrainte dans l’ensemble des muscles de la coiffe des rotateurs au cours de ces mouvements a été estimée à l’aide d’un modèle musculo-squelettique reproduisant différents types et tailles de déchirures. Des seuils de contrainte sécuritaires ont été utilisés pour distinguer les amplitudes de mouvements risquées ou non pour l’intégrité de la réparation chirurgicale. Une taille de déchirure plus grande ainsi que les déchirures affectant plusieurs muscles ont contribué à réduire l’espace de mobilité articulaire sécuritaire. Principalement les élévations gléno-humérales inférieures à 38° et supérieures à 65°, ou réalisées avec le bras maintenu en rotation interne engendrent des contraintes excessives pour la plupart des types et des tailles de blessure lors de mouvements d’abduction, de scaption ou de flexion. Cette thèse a développé une représentation innovante de la mobilité de l’épaule, qui tient compte des interactions entre les degrés de liberté. Grâce à cette représentation, l’évaluation clinique pourra être plus exhaustive et donc élargir les possibilités de diagnostiquer les troubles de l’épaule. La simulation de mouvement peut maintenant être plus réaliste. Finalement, nous avons montré l’importance de personnaliser la rééducation des patients en termes d’amplitude articulaire, puisque des exercices passifs de rééducation précoces peuvent contribuer à une re-déchirure à cause d’une contrainte trop importante qu’ils imposent aux tendons.