A domain-specific language for ETL patterns specification in Data Warehousing Systems

During the last few years many research efforts have been done to improve the design of ETL (Extract-Transform-Load) systems. ETL systems are considered very time-consuming, error-prone and complex involving several participants from different knowledge domains. ETL processes are one of the most important components of a data warehousing system that are strongly influenced by the complexity of business requirements, their changing and evolution. These aspects influence not only the structure of a data warehouse but also the structures of the data sources involved with. To minimize the negative impact of such variables, we propose the use of ETL patterns to build specific ETL packages. In this paper, we formalize this approach using BPMN (Business Process Modelling Language) for modelling more conceptual ETL workflows, mapping them to real execution primitives through the use of a domain-specific language that allows for the generation of specific instances that can be executed in an ETL commercial tool.

Using relational algebra on the specification of real world ETL processes

Modeling Extract-Transform-Load (ETL) processes of a Data Warehousing System has always been a challenge. The heterogeneity of the sources, the quality of the data obtained and the conciliation process are some of the issues that must be addressed in the design phase of this critical component. Commercial ETL tools often provide proprietary diagrammatic components and modeling languages that are not standard, thus not providing the ideal separation between a modeling platform and an execution platform. This separation in conjunction with the use of standard notations and languages is critical in a system that tends to evolve through time and which cannot be undermined by a normally expensive tool that becomes an unsatisfactory component. In this paper we demonstrate the application of Relational Algebra as a modeling language of an ETL system as an effort to standardize operations and provide a basis for uncommon ETL execution platforms.

Aging and Alzheimer's disease: Searching for novel molecular cues

Tese de Doutoramento em Ciências da Saúde

Specification and testing of multiplicative time-varying GARCH models with applications

In this article, we develop a specification technique for building multiplicative time-varying GARCH models of Amado and Teräsvirta (2008, 2013). The variance is decomposed into an unconditional and a conditional component such that the unconditional variance component is allowed to evolve smoothly over time. This nonstationary component is defined as a linear combination of logistic transition functions with time as the transition variable. The appropriate number of transition functions is determined by a sequence of specification tests. For that purpose, a coherent modelling strategy based on statistical inference is presented. It is heavily dependent on Lagrange multiplier type misspecification tests. The tests are easily implemented as they are entirely based on auxiliary regressions. Finite-sample properties of the strategy and tests are examined by simulation. The modelling strategy is illustrated in practice with two real examples: an empirical application to daily exchange rate returns and another one to daily coffee futures returns.

Searching for therapeutic strategies in a mouse modelo of Machado-Joseph disease: targeting proteostases

Tese de Doutoramento em Ciências da Saúde

Prevalence of thyroiditis and immunohistochemistry study searching for a morphologic consensus in morphology of autoimmune thyroiditis in a 4613 autopsies series

We sought to verify the prevalence of lymphocytic thyroiditis (LT) and Hashimoto's thyroiditis (HT) in autopsy materials. Cases examined between 2003 and 2007 at the Department of Pathology of Faculty of Medicine of São Paulo University were studied. Immunohistochemical analyses were conducted in selected cases to characterize the type of infiltrating mononuclear cells; in addition, we evaluated the frequency of apoptosis by TUNEL assay technique and caspase-3 immunostaining. Significant increase in overall thyroiditis frequency was observed in the present series when compared with the previous report (2.2978% vs. 0.0392%). Thyroiditis was more prevalent among older people. Selected cases of LT and HT (5 cases each) had their infiltrating lymphocytes characterized by immunohistochemical analyses. Both LT and HT showed similar immunostaining patterns for CD4, CD8, CD68, thus supporting a common pathophysiology mechanism and indicating that LT and HT should be considered different presentations of a same condition, that is, autoimmune thyroiditis. Moreover, apoptosis markers strongly evidenced that apoptosis was present in all studied cases. Our results demonstrated an impressive increase in the prevalence of thyroiditis during recent years and our data support that the terminology of autoimmune thyroiditis should be used to designate both LT and HT. This classification would facilitate comparison of prevalence data from different series and studies.

Transformando o espaço educativo numa comunidade de aprendizagem

Relatório de estágio de mestrado em Educação Pré-Escolar e Ensino do 1º Ciclo do Ensino Básico

A proactive intelligent decision support system for predicting the popularity of online news

"Lecture notes in computer science series, ISSN 0302-9743, vol. 9273"

Controlo da qualidade de betões

Dissertação de mestrado em Construção e Reabilitação Sustentáveis

Sensorimotor synchronization when walking side by side with a point light walker

[Excerpt] Synchronization of periodic movements like side-by-side walking [7] is frequently modeled by coupled oscillators [5] and the coupling strength is defined quantitatively [3]. In contrast, in most studies on sensorimotor synchronization (SMS), simple movements like finger taps are synchronized with simple stimuli like metronomes [4]. While the latter paradigm simplifies matters and allows for the assessment of the relative weights of sensory modalities through systematic variation of the stimuli [1], it might lack ecological validity. Conversely, using more complex movements and stimuli might complicate the specification of mechanisms underlying coupling. We merged the positive aspects of both approaches to study the contribution of auditory and visual information on synchronization during side-by-side walking. As stimuli, we used Point Light Walkers (PLWs) and auralized steps sound; both were constructed from previously captured walking individuals [2][6]. PLWs were retro-projected on a screen and matched according to gender, hip height, and velocity. The participant walked for 7.20m side by side with 1) a PLW, 2) steps sound, or 3) both displayed in temporal congruence. Instruction to participants was to synchronize with the available stimuli. [...]

A delinquência juvenil em Cabo Verde: da caracterização do fenómeno à contextualização sociocultural

Tese de Doutoramento em Psicologia Aplicada.

Strategies to regulate myopia progression with contact lenses: a review

Purpose: Higher myopic refractive errors are associated with serious ocular complications that can put visual function at risk. There is respective interest in slowing and if possible stopping myopia progression before it reaches a level associated with increased risk of secondary pathology. The purpose of this report was to review our understanding of the rationale(s) and success of contact lenses (CLs) used to reduce myopia progression. Methods: A review commenced by searching the PubMed database. The inclusion criteria stipulated publications of clinical trials evaluating the efficacy of CLs in regulating myopia progression based on the primary endpoint of changes in axial length measurements and published in peerreviewed journals. Other publications from conference proceedings or patents were exceptionally considered when no peer-review articles were available. Results: The mechanisms that presently support myopia regulation with CLs are based on the change of relative peripheral defocus and changing the foveal image quality signal to potentially interfere with the accommodative system. Ten clinical trials addressing myopia regulation with CLs were reviewed, including corneal refractive therapy (orthokeratology), peripheral gradient lenses, and bifocal (dual-focus) and multifocal lenses. Conclusions: CLs were reported to be well accepted, consistent, and safe methods to address myopia regulation in children. Corneal refractive therapy (orthokeratology) is so far the method with the largest demonstrated efficacy in myopia regulation across different ethnic groups. However, factors such as patient convenience, the degree of initial myopia, and non-CL treatments may also be considered. The combination of different strategies (i.e., central defocus, peripheral defocus, spectral filters, pharmaceutical delivery, and active lens-borne illumination) in a single device will present further testable hypotheses exploring how different mechanisms can reinforce or compete with each other to improve or reduce myopia regulation with CLs.

Reconfiguração e novas funcionalidades para um servidor REST ONVIF: serviço de IO e configuração de descoberta

Dissertação de mestrado em Engenharia de Telecomunicações e Informática

Gestão de fluxos de pessoas num serviço hospitalar

Dissertação de mestrado em Engenharia Industrial (área de especialização em Gestão Industrial)

Desenvolvimento de um modelo de rotatividade numa indútria do setor Metalomecânico

Dissertação de mestrado em Engenharia Humana