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.

The real economic effects of cross-delistingfrom the united states: evidence on post-operating performance, financial constraints and stock crash risk

Tese de Doutoramento em Ciências Empresariais.

Experimental analysis of the cyclic response of traditional timber joints and their influence on the seismic capacity of timber frame structures

Timber connections represent the crucial part of a timber structure and a great variability exists in terms of types of connections and mechanisms. Taking as case study the widespread traditional timber frame structures, in particular the Portuguese Pombalino buildings, one of the most common timber connection is the half-lap joint. Connections play a major role in the overall behaviour of a structure, particularly when assessing their seismic response, since damage is concentrated at the connections. For this reason, an experimental campaign was designed and distinct types of tests were carried out on traditional half-lap joints to assess their in-plane response. In particular, pull-out and in-plane cyclic tests were carried out on real scale unreinforced connections. Subsequently, the connections were retrofitted, using strengthening techniques such as self-tapping screws, steel plates and GFRP sheets. The tests chosen were meant to capture the hysteretic behaviour and dissipative capacity of the connections and characterise their response and, therefore, their influence on the seismic response of timber frame walls, particularly concerning their uplifting and rotation capacity, that could lead to rocking in the walls. In this paper, the results of the experimental campaign are presented in terms of hysteretic curves, dissipated energy and equivalent viscous damping ratio. Moreover, recommendations are provided on the most appropriate retrofitting solutions.

Project management: evaluation of the problems in the portuguese construction industry

During recent decades it has been possible to identify several problems in construction industry project management, related with to systematic failures in terms of fulfilling its schedule, cost and quality targets, which highlight a need for an evaluation of the factors that may cause these failures. Therefore, it is important to understand how project managers plan the projects, so that the performance and the results can be improved. However, it is important to understand if other areas beyond cost and time management that are mentioned on several studies as the most critical areas, receive the necessary attention from construction project managers. Despite the cost and time are the most sensitive areas/fields, there are several other factors that may lead to project failure. This study aims at understand the reasons that may cause the deviation in terms of cost, time and quality, from the project management point of view, looking at the knowledge areas mentioned by PMI (Project Management Institute).

Effects of residues on the degradation of PHA produced from mixed microbial cultures and processed in extrusion

Thermal degradation upon melting is one of the major drawbacks reported for polyhydroxyalkanoates (PHA). However, the role of residues originating from the fermentation and the extraction steps on the thermal stability of this class of biopolymers still needs to be clarified. In the particular case of PHA produced from mixed microbial cultures (MMC), this topic is even less documented in the literature. Here, two polyhydroxy(butyrate-co-valerate) (PHBV) produced from MMC enriched in PHA accumulating organisms and fed with cheese whey were studied. A micro extrusion line is used to produce filaments and assess the processability and the degradation of processed PHBV. The prototype micro extrusion line allows for studying grams of materials. The two PHBV contain 18 mol% HV. PHBV was recovered with 11 wt% residues, and further submitted to a purification procedure resulting in a second biopolyester containing less than 2 wt% impurities. The thermorheological characterization of the two PHBV is first presented, together with their semicrystalline properties. Then the processing windows of the two biopolyesters are presented. Finally, the properties of extruded filaments are reported and the thermomechanical degradation of PHBV is extensively studied. The structure was assessed by wide angle X-ray diffraction, mechanical and rheological properties are reported, thermal properties are studied with differential scanning calorimetry and thermogravimetric analysis, whereas Fourier Transform Infrared spectroscopy was used to assess the impact of the extrusion on PHBV chemical structure. All results obtained with the two PHBV are compared to assess the effects of residues on both PHBV processability and degradation.

A study on the performance of technology transfer units

Universities are increasingly institutionalizing activities related to technology transfer and one of the main institutional mechanisms that has emerged is the “technology transfer unit” (TTU). Many of them are focusing their activities on the management of the university intellectual property. Studies have investigated factors that seem to affect their performance, but few have looked in detail at internal procedures and techniques that are used in their processes related to technology evaluation and licensing. The aim of this paper is to provide a comprehensive overview of some of the several steps that comprises the processes regarding technology evaluation and licensing, providing an analysis of the critical issues that affect each step of the process. A review of the literature was made, complemented with interviews to seven university TTUs, which was used as a check and a complement to the literature review and as way of perceiving from an insider perspective, the problems and issues that this paper wants to emphasize and to state clearly.

Wi-Fi fingerprinting in the real world – RTLS@UM at the EvAAL competition

Research and development around indoor positioning and navigation is capturing the attention of an increasing number of research groups and labs around the world. Among the several techniques being proposed for indoor positioning, solutions based on Wi-Fi fingerprinting are the most popular since they exploit existing WLAN infrastructures to support software-only positioning, tracking and navigation applications. Despite the enormous research efforts in this domain, and despite the existence of some commercial products based on Wi-Fi fingerprinting, it is still difficult to compare the performance, in the real world, of the several existing solutions. The EvAAL competition, hosted by the IPIN 2015 conference, contributed to fill this gap. This paper describes the experience of the RTLS@UM team in participating in track 3 of that competition.

On the impact of overlapping access points in detecting node encounters

Data traces, consisting of logs about the use of mobile and wireless networks, have been used to study the statistics of encounters between mobile nodes, in an attempt to predict the performance of opportunistic networks. Understanding the role and potential of mobile devices as relaying nodes in message dissemination and delivery depends on the knowledge about patterns and number of encounters among nodes. Data traces about the use of WiFi networks are widely available and can be used to extract large datasets of encounters between nodes. However, these logs only capture indirect encounters between nodes, and the resulting encounters datasets might not realistically represent the spatial and temporal behaviour of nodes. This paper addresses the impact of overlapping between the coverage areas of different Access Points of WiFi networks in extracting encounters datasets from the usage logs. Simulation and real-world experimental results show that indirect encounter traces extracted directly from these logs strongly underestimate the opportunities for direct node-to- node message exchange in opportunistic networks.

Tax compliance and tax complexity in Portugal: essays on the perception of tax professionals

Tese de Doutoramento em Contabilidade.

Influence of design parameters on the mechanical behavior and porosity of braided fibrous stents

In spite of all innovations in stent design, commonly used metallic stents present several problems such as corrosion, infection and restenosis, leading to health complications or even death of patients. In this context, the present paper reports a systematic investigation on designing and development of 100% fiber based stents, which can eliminate or minimize the problems with existing metallic stents. For this purpose, braided stents were produced by varying different materials, structural and process parameters such as mono-filament type and diameter, braiding angle and mandrel diameter. The influence of these design parameters on mechanical behavior as well as stent's porosity was thoroughly investigated, and suitable parameters were selected for developing a stentwith mechanical characteristics and porosity matching with the commercial stents. According to the experimental results, the best performance was achieved with a polyester stent designed with 0.27 mm monofilament diameter, braiding angle of 35° and mandrel diameter of 6 mm, providing similar properties to commercial Nitinol stents.

A demonstration case on the derivation of process-level logical architectures for ambient assisted living ecosystems

When representing the requirements for an intended software solution during the development process, a logical architecture is a model that provides an organized vision of how functionalities behave regardless of the technologies to be implemented. If the logical architecture represents an ambient assisted living (AAL) ecosystem, such representation is a complex task due to the existence of interrelated multidomains, which, most of the time, results in incomplete and incoherent user requirements. In this chap- ter, we present the results obtained when applying process-level modeling techniques to the derivation of the logical architecture for a real industrial AAL project. We adopt a V-Model–based approach that expresses the AAL requirements in a process-level perspec- tive, instead of the traditional product-level view. Additionally, we ensure compliance of the derived logical architecture with the National Institute of Standards and Technology (NIST) reference architecture as nonfunctional requirements to support the implementa- tion of the AAL architecture in cloud contexts.

Study on the degradation of natural fiber geotextiles

Current societal challenges increasingly demand the need to seek for efficient and sustainable solutions to daily problems. Construction, as a result of its activity, is one of the main responsible industry for the exploitation of resources and greenhouse gas emissions. In this way, several research works are being undertaken to change some of the current practices. This paper presents the work being done at University of Minho to study de degradation of natural fibers when used as a sustainable solution for soil reinforcement. Jute and sisal fibrous structures (0º/90º) were studied in terms of their degradation over time, when incorporated into soil and when subject to accelerated aging tests in a QUV weathering test equipment. Results show that the process of biodegradation of natural fibers is clearly accelerated by the action of temperature, moisture and solar radiation, explaining further degradation of jute and sisal fibers when exposed to these factors, although more pronounced in jute fabric structures.