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.

Pervasive business intelligence platform to improve the quality of decision process in primary and secondary education – A Portuguese case study

Business Intelligence (BI) can be seen as a method that gathers information and data from information systems in order to help companies to be more accurate in their decision-making process. Traditionally BI systems were associated with the use of Data Warehouses (DW). The prime purpose of DW is to serve as a repository that stores all the relevant information required for making the correct decision. The necessity to integrate streaming data became crucial with the need to improve the efficiency and effectiveness of the decision process. In primary and secondary education, there is a lack of BI solutions. Due to the schools reality the main purpose of this study is to provide a Pervasive BI solution able to monitoring the schools and student data anywhere and anytime in real-time as well as disseminating the information through ubiquitous devices. The first task consisted in gathering data regarding the different choices made by the student since his enrolment in a certain school year until the end of it. Thereafter a dimensional model was developed in order to be possible building a BI platform. This paper presents the dimensional model, a set of pre-defined indicators, the Pervasive Business Intelligence characteristics and the prototype designed. The main contribution of this study was to offer to the schools a tool that could help them to make accurate decisions in real-time. Data dissemination was achieved through a localized application that can be accessed anywhere and anytime.

Step towards a patient timeline in intensive care units

In Intensive Medicine, the presentation of medical information is done in many ways, depending on the type of data collected and stored. The way in which the information is presented can make it difficult for intensivists to quickly understand the patient's condition. When there is the need to cross between several types of clinical data sources the situation is even worse. This research seeks to explore a new way of presenting information about patients, based on the timeframe in which events occur. By developing an interactive Patient Timeline, intensivists will have access to a new environment in real-time where they can consult the patient clinical history and the data collected until the moment. The medical history will be available from the moment in which patients is admitted in the ICU until discharge, allowing intensivist to examine data regarding vital signs, medication, exams, among others. This timeline also intends to, through the use of information and models produced by the INTCare system, combine several clinical data in order to help diagnose the future patients’ conditions. This platform will help intensivists to make more accurate decision. This paper presents the first approach of the solution designed

Algorithms and tools for in silico design of cell factories

PhD thesis in Bioengineering

Strategic planning of electricity systems: Integrating renewable energies

Tese de Doutoramento - Programa Doutoral em Engenharia Industrial e Sistemas (PDEIS)

A relational algebra approach to ETL modeling

The MAP-i Doctoral Programme in Informatics, of the Universities of Minho, Aveiro and Porto

Plataforma para suporte ao ciclo de vida de organizações virtuais e seleção dinâmica de parceiros e fornecedores

Tese de Doutoramento em Engenharia Industrial e de Sistemas

Educação para a sustentabilidade: O uso de Sistemas de Informação Geográfica Participativos como instrumento de participação de crianças e adolescentes na construção de sociedades mais sustentáveis

Tese de Doutoramento em Ciências da Educação (Área de Conhecimento: Educação ambiental e para a Sustentabilidade)

Improvign mixing processes with the help of numerical tools

In several industrial applications, highly complex behaviour materials are used together with intricate mixing processes, which difficult the achievement of the desired properties for the produced materials. This is the case of the well-known dispersion of nano-sized fillers in a melt polymer matrix, used to improve the nanocomposite mechanical and/or electrical properties. This mixing is usually performed in twin-screw extruders, that promote complex flow patterns, and, since an in loco analysis of the material evolution and mixing is difficult to perform, numerical tools can be very useful to predict the evolution and behaviour of the material. This work presents a numerical based study to improve the understanding of mixing processes. Initial numerical studies were performed with generalized Newtonian fluids, but, due to the null relaxation time that characterize this type of fluids, the assumption of viscoelastic behavior was required. Therefore, the polymer melt was rheologically characterized, and, a six mode Phan-Thien-Tanner and Giesekus models were used to fit the rheological data. These viscoelastic rheological models were used to model the process. The conclusions obtained in this work provide additional and useful data to correlate the type and intensity of the deformation history promoted to the polymer nanocomposite and the quality of the mixing obtained.

Measurement of the top pair production cross-section in 8 TeV proton-proton collisions using kinematic information in the lepton+jets final state with ATLAS

A measurement is presented of the tt¯ inclusive production cross section in pp collisions at a center-of-mass energy of s√=8  TeV using data collected by the ATLAS detector at the CERN Large Hadron Collider. The measurement was performed in the lepton+jets final state using a data set corresponding to an integrated luminosity of 20.3  fb−1. The cross section was obtained using a likelihood discriminant fit and b-jet identification was used to improve the signal-to-background ratio. The inclusive tt¯ production cross section was measured to be 260±1(stat)+22−23(stat)±8(lumi)±4(beam)  pb assuming a top-quark mass of 172.5 GeV, in good agreement with the theoretical prediction of 253+13−15  pb. The tt¯→(e,μ)+jets production cross section in the fiducial region determined by the detector acceptance is also reported.

Differential top-antitop cross-section measurements as a function of observables constructed from final-state particles using pp collisions at s√=7 TeV in the ATLAS detector

Various differential cross-sections are measured in top-quark pair (tt¯) events produced in proton--proton collisions at a centre-of-mass energy of s√=7 TeV at the LHC with the ATLAS detector. These differential cross-sections are presented in a data set corresponding to an integrated luminosity of 4.6 fb−1. The differential cross-sections are presented in terms of kinematic variables of a top-quark proxy referred to as the pseudo-top-quark whose dependence on theoretical models is minimal. The pseudo-top-quark can be defined in terms of either reconstructed detector objects or stable particles in an analogous way. The measurements are performed on tt¯ events in the lepton+jets channel, requiring exactly one charged lepton and at least four jets with at least two of them tagged as originating from a b-quark. The hadronic and leptonic pseudo-top-quarks are defined via the leptonic or hadronic decay mode of the W boson produced by the top-quark decay in events with a single charged lepton.The cross-section is measured as a function of the transverse momentum and rapidity of both the hadronic and leptonic pseudo-top-quark as well as the transverse momentum, rapidity and invariant mass of the pseudo-top-quark pair system. The measurements are corrected for detector effects and are presented within a kinematic range that closely matches the detector acceptance. Differential cross-section measurements of the pseudo-top-quark variables are compared with several Monte Carlo models that implement next-to-leading order or leading-order multi-leg matrix-element calculations.

Cross-language influences on new second language vocabulary acquisition: the effect of learning method

Dissertação de mestrado integrado em Psicologia

Cross-scale determinants of palm species distribution

We investigate palm species distribution, richness and abundance along the Mokoti, a seasonally-dry river of southeastern Amazon and compare it to the patterns observed at a large scale, comprising the entire Brazilian territory. A total of 694 palms belonging to 10 species were sampled at the Mokoti River basin. Although the species showed diverse distribution patterns, we found that local palm abundance, richness and tree basal area were significantly higher from the hills to the bottomlands of the study region, revealing a positive association of these measures with moisture. The analyses at the larger spatial scale also showed a strong influence of vapor pressure (a measure of moisture content of the air, in turn modulated by temperature) and seasonality in temperature: the richest regions were those where temperature and humidity were simultaneously high, and which also presented a lower degree of seasonality in temperature. These results indicate that the distribution of palms seems to be strongly associated with climatic variables, supporting the idea that, by 'putting all the eggs in one basket' (a consequence of survival depending on the preservation of a single irreplaceable bud), palms have become vulnerable to extreme environmental conditions. Hence, their distribution is concentrated in those tropical and sub-tropical regions with constant conditions of (mild to high) temperature and moisture all year round.

Observation of top-quark pair production in association with a photon and measurement of the t t ¯ γ production cross section in pp collisions at s =7 TeV using the ATLAS detector

A search is performed for top-quark pairs (tt¯) produced together with a photon (γ) with transverse momentum >20 GeV using a sample of tt¯ candidate events in final states with jets, missing transverse momentum, and one isolated electron or muon. The dataset used corresponds to an integrated luminosity of 4.59 fb−1 of proton--proton collisions at a center-of-mass energy of 7 TeV recorded by the ATLAS detector at the CERN Large Hadron Collider. In total 140 and 222 tt¯γ candidate events are observed in the electron and muon channels, to be compared to the expectation of 79±26 and 120±39 non-tt¯γ background events respectively. The production of tt¯γ events is observed with a significance of 5.3 standard deviations away from the null hypothesis. The tt¯γ production cross section times the branching ratio (BR) of the single-lepton decay channel is measured in a fiducial kinematic region within the ATLAS acceptance. The measured value is σfidtt¯γ=63±8(stat.)+17−13(syst.)±1(lumi.) fb per lepton flavor, in good agreement with the leading-order theoretical calculation normalized to the next-to-leading-order theoretical prediction of 48±10 fb.

Poly(vinylidene fluoride-trifluoroethylene)/NAY zeolite hybrid membranes as a drug release platform applied to ibuprofen release

Poly(vinylidene fluoride-trifluoroethylene)/NaY zeolite composite membranes were prepared by solvent casting and evaluated as a suitable drug release platform through the evaluation of loading and release of ibuprofen. The membranes were characterized at the morphological, structural and mechanical levels. The 1H-NMR spectra indicate that only the membranes with 16 and 32 % of NaY were useful for IBU encapsulation and the drug release was followed by UV-Vis spectroscopy. The release profile is independent of the zeolite content and can be described by the Korsmeyer-Peppas model. The membrane with 32 % zeolite content releases more than double IBU amount when compared with the membrane with 16 % showing that zeolite content allows tailoring membrane drug release content for specific applications. The drug release platform developed in this work is suitable for other drugs and applications.