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.

Primusinter (ím)pares - análise da presença dos académicos nos plateaux informativos da TV portuguesa

Os académicos estão a tornar-se uma presença cada vez mais visível nos plateaux informativos da TV portuguesa. Não são um grupo muito diversificado. Pelo contrário. Apresentam-se como uma confraria que é oriunda das universidades de Lisboa e pertence a um reduzido número de campos de saberes. Aos plateaux televisivos portugueses dificilmente chegará o fazer-ciência concreto. O que chega são alguns dos seus actores, o que não significa que o consigam por um efeito de reconhecimento inter pares, mas, antes, por um efeito de verdadeiras imparidades: porque já adquiriram suficiente capital simbólico em zonas exteriores ao campo científico. Zonas mais limítrofes, como o campo institucional-académico, ou zonas mais afastadas, como o campo comunicacional.

Assessment of national parks affected by naturbanization processes in Southern Europe

This paper assesses land-use changes related to naturbanization processes on three biosphere reserves in Southern Europe. A comparative analysis has been done on the National Parks in Peneda-Ger^es in North Portugal, C_evennes in South France and Sierra Nevada in South Spain, using Corine Land Cover data from 1990 until 2006. Results indicate that the process of land-use intensification is taking place in the frame of naturbanization dynamics that could jeopardize the role of Protected Areas. Focusing on the trends faced by National Parks and their surrounding territories, the analysis demonstrates, both in quantitative and spatial terms, the intensification processes of land-use changes and how it is important to know them for coping with increasing threats. The article concludes that in the current context of increasing stresses, a broader focus on nature protection, encompassing the wider countryside, is needed if the initiatives for biodiversity protection are to be effective.

Process simulation support in BPM tools: The case of BPMN

Due to the increasing acceptance of BPM, nowadays BPM tools are extensively used in organizations. Core to BPM are the process modeling languages, of which BPMN is the one that has been receiving most attention these days. Once a business process is described using BPMN, one can use a process simulation approach in order to find its optimized form. In this context, the simulation of business processes, such as those defined in BPMN, appears as an obvious way of improving processes. This paper analyzes the business process modeling and simulation areas, identifying the elements that must be present in the BPMN language in order to allow processes described in BPMN to be simulated. During this analysis a set of existing BPM tools, which support BPMN, are compared regarding their limitations in terms of simulation support.

Conceptual-physical bridging – From BPMN models to physical implementations on kettle

Developing and implementing data-oriented workflows for data migration processes are complex tasks involving several problems related to the integration of data coming from different schemas. Usually, they involve very specific requirements - every process is almost unique. Having a way to abstract their representation will help us to better understand and validate them with business users, which is a crucial step for requirements validation. In this demo we present an approach that provides a way to enrich incrementally conceptual models in order to support an automatic way for producing their correspondent physical implementation. In this demo we will show how B2K (Business to Kettle) system works transforming BPMN 2.0 conceptual models into Kettle data-integration executable processes, approaching the most relevant aspects related to model design and enrichment, model to system transformation, and system execution.

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.

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.

Degradation of all-inkjet-printed organic thin-film transistors with TIPS-pentacene under processes applied in textile manufacturing

Printed electronics represent an alternative solution for the manufacturing of low-temperature and large area flexible electronics. The use of inkjet printing is showing major advantages when compared to other established printing technologies such as, gravure, screen or offset printing, allowing the reduction of manufacturing costs due to its efficient material usage and the direct-writing approach without requirement of any masks. However, several technological restrictions for printed electronics can hinder its application potential, e.g. the device stability under atmospheric or even more stringent conditions. Here, we study the influence of specific mechanical, chemical, and temperature treatments usually appearing in manufacturing processes for textiles on the electrical performance of all-inkjet-printed organic thin-film transistors (OTFTs). Therefore, OTFTs where manufactured with silver electrodes, a UV curable dielectric, and 6,13-bis(triisopropylsilylethynyl) pentance (TIPS-pentacene) as the active semiconductor layer. All the layers were deposited using inkjet printing. After electrical characterization of the printed OTFTs, a simple encapsulation method was applied followed by the degradation study allowing a comparison of the electrical performance of treated and not treated OTFTs. Industrial calendering, dyeing, washing and stentering were selected as typical textile processes and treatment methods for the printed OTFTs. It is shown that the all-inkjet-printed OTFTs fabricated in this work are functional after their submission to the textiles processes but with degradation in the electrical performance, exhibiting higher degradation in the OTFTs with shorter channel lengths (L=10 μm).

Coagulation/flocculation/flotation/nanofiltration processes using Moringa Oleifera as coagulant of Eutrophized river

This study investigated the efficiency of Moringa oleifera (MO) seeds as natural coagulant in coagulation/flocculation/dissolved air flotation (C/F/DAF), followed by nanofiltration (NF) for Microcystis protocystis and microcystin-LR removal. The methodology adopted in this work was performed in two steps: 1) coagulation/flocculation/dissolved air flotation (C/F/DAF) process using the MO extracted in saline solution of potassium chloride (KCl-1M) and sodium chloride (NaCl-1M) in optimum dosage 50 mg·L-1; 2) nanofiltration process using NF90 and NF270 membrane provided Dow Chemical Company®. A working pressure of 8 bar was applied. In all samples were analyzed color, turbidity, pH, cyanobacterial cells count and microcystin concentration. The use of MO seeds as natural coagulant, obtained satisfactory results in the M. protocystis, color and turbidity removal. NF was able to completely remove cyanobacterial cells and microcystins (100 %) from M. protocystis (always under the quantification limit). Therefore, C/F/DAF+NF sequence is a safe barrier against M. protocystis and microcystins in drinking water.

Narrative change in Gloria Films: Comparing various processes of therapeutic innovation

Aims: The present study focuses on the analysis of novelty emergence in classic Gloria Films with Rogers, Perls, and Ellis to understand how the same client formulated her own problem and if and how change occurred in those three sessions. Method: The Innovative Moments Coding System was applied to track innovative moments (IMs) and their themes. Results: The session with Rogers showed more diversity in disclosed problems and themes of IMs, as well as a higher proportion of reflection IMs. The session with Perls demonstrated a high proportion of protest IMs. The session with Ellis showed less innovation than other sessions. The changes found were based mostly on reflection and protest IMs in three sessions. Conclusion: Narrative innovations occurred in the three single sessions. The type of dominant innovation is consistent with the therapeutic model and the IMs model. The exploration of the IMs’ themes allowed a more precise identification of Gloria's new narrative positions and their development throughout those sessions.

Modelling Z→ττ processes in ATLAS with τ-embedded Z→μμ data

This paper describes the concept, technical realisation and validation of a largely data-driven method to model events with Z→ττ decays. In Z→μμ events selected from proton-proton collision data recorded at s√=8 TeV with the ATLAS experiment at the LHC in 2012, the Z decay muons are replaced by τ leptons from simulated Z→ττ decays at the level of reconstructed tracks and calorimeter cells. The τ lepton kinematics are derived from the kinematics of the original muons. Thus, only the well-understood decays of the Z boson and τ leptons as well as the detector response to the τ decay products are obtained from simulation. All other aspects of the event, such as the Z boson and jet kinematics as well as effects from multiple interactions, are given by the actual data. This so-called τ-embedding method is particularly relevant for Higgs boson searches and analyses in ττ final states, where Z→ττ decays constitute a large irreducible background that cannot be obtained directly from data control samples.

Literatura russa em Portugal: das vias de difusão aos sentidos de receção: o caso de Leão Tolstói

Tese de Doutoramento em Ciências da Literatura (área de especialização em Literatura Comparada).

Macroscopic and histopathological study of the placenta: an essential resource in litigation processes

The pathological study of the placenta is of upmost importance in cases of unexplained fetal/perinatal loss and often these carry litigation implications. Integrating pathological findings and the underlying pathophysiological processes, leading to placental lesions, is fundamental for the evaluation of poor fetal and perinatal outcomes and to distinguish from cases of true negligence.

O livro na revista: como revistas semanais brasileiras e portuguesas abordam livros e literatura

Dissertação de mestrado em Comunicação, Arte e Cultura

Selfie: a força comunicacional do autorretrato que as redes sociais reinventaram

Dissertação de mestrado em Ciências da Comunicação (área de especialização em Informação e Jornalismo)