Automatic generation of ETL physical systems from BPMN conceptual models

ETL conceptual modeling is a very important activity in any data warehousing system project implementation. Owning a high-level system representation allowing for a clear identification of the main parts of a data warehousing system is clearly a great advantage, especially in early stages of design and development. However, the effort to model conceptually an ETL system rarely is properly rewarded. Translating ETL conceptual models directly into something that saves work and time on the concrete implementation of the system process it would be, in fact, a great help. In this paper we present and discuss a hybrid approach to this problem, combining the simplicity of interpretation and power of expression of BPMN on ETL systems conceptualization with the use of ETL patterns to produce automatically an ETL skeleton, a first prototype system, which has the ability to be executed in a commercial ETL tool like Kettle.

Development of hybrid composite plate (HCP) for strengthening and repair of RC structures

Tese de Doutoramento em Engenharia Civil

Integration of geometric consistency contributory factors in three-leg junctions collision prediction models of Portuguese two-lane national highways

This paper aims at developing a collision prediction model for three-leg junctions located in national roads (NR) in Northern Portugal. The focus is to identify factors that contribute for collision type crashes in those locations, mainly factors related to road geometric consistency, since literature is scarce on those, and to research the impact of three modeling methods: generalized estimating equations, random-effects negative binomial models and random-parameters negative binomial models, on the factors of those models. The database used included data published between 2008 and 2010 of 177 three-leg junctions. It was split in three groups of contributing factors which were tested sequentially for each of the adopted models: at first only traffic, then, traffic and the geometric characteristics of the junctions within their area of influence; and, lastly, factors which show the difference between the geometric characteristics of the segments boarding the junctionsâ area of influence and the segment included in that area were added. The choice of the best modeling technique was supported by the result of a cross validation made to ascertain the best model for the three sets of researched contributing factors. The models fitted with random-parameters negative binomial models had the best performance in the process. In the best models obtained for every modeling technique, the characteristics of the road environment, including proxy measures for the geometric consistency, along with traffic volume, contribute significantly to the number of collisions. Both the variables concerning junctions and the various national highway segments in their area of influence, as well as variations from those characteristics concerning roadway segments which border the already mentioned area of influence have proven their relevance and, therefore, there is a rightful need to incorporate the effect of geometric consistency in the three-leg junctions safety studies.

Experimental and numerical approaches for structural assessment in new footbridge designs (SFRSCC–GFPR hybrid structure)

Within the civil engineering field, the use of the Finite Element Method has acquired a significant importance, since numerical simulations have been employed in a broad field, which encloses the design, analysis and prediction of the structural behaviour of constructions and infrastructures. Nevertheless, these mathematical simulations can only be useful if all the mechanical properties of the materials, boundary conditions and damages are properly modelled. Therefore, it is required not only experimental data (static and/or dynamic tests) to provide references parameters, but also robust calibration methods able to model damage or other special structural conditions. The present paper addresses the model calibration of a footbridge bridge tested with static loads and ambient vibrations. Damage assessment was also carried out based on a hybrid numerical procedure, which combines discrete damage functions with sets of piecewise linear damage functions. Results from the model calibration shows that the model reproduces with good accuracy the experimental behaviour of the bridge.

Exploring the potentialities of a new type of CFRP laminate for the simultaneous flexural and shear strengthening of RC beams: numerical research

This study aims to develop an innovative carbon fibre reinforced polymer (CFRP) laminate with a U configuration to address strengthening interventions, where the increment of both flexural and shear capacity of reinforced concrete (RC) elements is required. This strengthening solution combines the near surface mounted (NSM) and embedded through section (ETS) techniques in the same application, since these techniques have already evidenced high performance on flexural and shear strengthening of RC beams using FRP systems, respectively. In fact, the proposed hybrid technique aims to mobilize the advantages provided by these two strengthening techniques by using an innovative CFRP laminate. The strengthening efficacy of this new hybrid NSM/ETS technique was numerically assessed and compared to the corresponding efficiency of NSM and ETS techniques applied separately for the flexural and shear strengthening of RC beams, respectively. The numerical models are described and the main relevant results are presented and discussed.

Development of innovative hybrid sandwich panel slabs: Experimental results

The authors appreciate the collaboration of the following labs: Civitest for developing DHCC materials, PIEP for conducting VARTM process (Eng. Luis Oliveira) and Department of Civil Engineering of Minho University to perform the tests (Mr. Antonio Matos and Eng. Marco Jorge).

Assessment of the efficiency of prefabricated hybrid composite plates (HCPs) for retrofitting of damaged interior RC beam–column joints

The effectiveness of prefabricated hybrid composite plates (HCPs) as a seismic retrofitting solution for damaged interior RC beam-column joints is experimentally studied. HCP is composed of a thin plate made of strain hardening cementitious composite (SHCC) reinforced with CFRP sheets/laminates. Two full-scale severely damaged interior beam-column joints are retrofitted using two different configurations of HCPs. The effectiveness of these retrofitting solutions mainly in terms of hysteretic response, dissipated energy, degradation of secant stiffness, displacement ductility and failure modes are compared to their virgin states. According to these criteria, both solutions resulted in superior responses regarding the ones registered in their virgin states.

Flexural strengthening of RC beams using hybrid composite plate (HCP): experimental and analytical study

Hybrid Composite Plate (HCP) is a reliable recently proposed retrofitting solution for concrete structures, which is composed of a strain hardening cementitious composite (SHCC) plate reinforced with Carbon Fibre Reinforced Polymer (CFRP). This system benefits from the synergetic advantages of these two composites, namely the high ductility of SHCC and the high tensile strength of CFRPs. In the materialstructural of HCP, the ultra-ductile SHCC plate acts as a suitable medium for stress transfer between CFRP laminates (bonded into the pre-sawn grooves executed on the SHCC plate) and the concrete substrate by means of a connection system made by either chemical anchors, adhesive, or a combination thereof. In comparison with traditional applications of FRP systems, HCP is a retrofitting solution that (i) is less susceptible to the detrimental effect of the lack of strength and soundness of the concrete cover in the strengthening effectiveness; (ii) assures higher durability for the strengthened elements and higher protection to the FRP component in terms of high temperatures and vandalism; and (iii) delays, or even, prevents detachment of concrete substrate. This paper describes the experimental program carried out, and presents and discusses the relevant results obtained on the assessment of the performance of HCP strengthened reinforced concrete (RC) beams subjected to flexural loading. Moreover, an analytical approach to estimate the ultimate flexural capacity of these beams is presented, which was complemented with a numerical strategy for predicting their load-deflection behaviour. By attaching HCP to the beams’ soffit, a significant increase in the flexural capacity at service, at yield initiation of the tension steel bars and at failure of the beams can be achieved, while satisfactory deflection ductility is assured and a high tensile capacity of the CFRP laminates is mobilized. Both analytical and numerical approaches have predicted with satisfactory agreement, the load-deflection response of the reference beam and the strengthened ones tested experimentally.

Shear strengthening of damaged reinforced concrete beams with hybrid composite plates

This paper aims to evaluate experimentally the potentialities of Hybrid Composite Plates (HCPs) technique for the shear strengthening of reinforced concrete (RC) beams that were previously subjected to intense damage in shear. HCP is a thin plate of Strain Hardening Cementitious Composite (SHCC) reinforced with Carbon Fiber Reinforced Polymer (CFRP) laminates. For this purpose, an experimental program composed of two series of beams (rectangular and T cross section) was executed to assess the strengthening efficiency of this technique. In the first step of this experimental program, the control beams, without steel stirrups, were loaded up to their shear failure, and fully unloaded. Then, these pre-damaged beams were shear strengthened by applying HCPs to their lateral faces by using a combination of epoxy adhesive and mechanical anchors. The bolts were applied with a certain torque in order to increase the concrete confinement. The obtained results showed that the increase of load carrying capacity of the damaged strengthened beams when HCPs were applied with epoxy adhesive and mechanical anchors was 2 and 2.5 times of the load carrying capacity of the corresponding reference beams (without HCPs) for the rectangular and T cross section beam series, respectively. To further explore the potentialities of the HCPs technique for the shear strengthening, the experimental tests were simulated using an advanced numerical model by a FEM-based computer program. After demonstration the good predictive performance of the numerical model, a parametric study was executed to highlight the influence of SHCC as an alternative for mortar, as well as the influence of torque level applied to the mechanical anchors, on the load carrying capacity of beams strengthened with the proposed technique.

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.

Implementation of integral viscoelastic constitutive models in OpenFOAM® computational library

This work reports the implementation and verification of a new so lver in OpenFOAM® open source computational library, able to cope with integral viscoelastic models based on the integral upper-convected Maxwell model. The code is verified through the comparison of its predictions with analytical solutions and numerical results obtained with the differential upper-convected Maxwell model

Analysis of polydicyclopentadiene-metal hybrid adhesive joints for automotive exterior body applications

An exterior body panel solution containing a polydicyclopentadiene skin attached to an interior metallic reinforcement through adhesive bonding is being studied to be applied in the MobiCar bonnet. With this solution is expected to achieve lightness, adequate structural integrity and cost-efficiency. However, there is uncertainty regarding to the bonnet adhesiveness since different metallic materials and adhesive types are being considered for its development. Thus, in this paper, several samples are tested through shear loading with the aim of understanding the loading magnitude expected by using polydicyclopentadiene, steel DC04+ZE and aluminum alloy AW5754-H111 as substrates adhesively bonded by an epoxy or a methacrylate. Methacrylate adhesive have shown greater shear strength in all types of adhesive joints. PDCPD joints presented the highest displacements. Surface degradation was considered adequate over abrading once none strength difference was seen between the different surface treatments. Steel treated by cataphoresis has shown the highest joint interface strength.

Reverse engineering of web applications

The MAP-i Doctoral Program of the Universities of Minho, Aveiro and Porto

Novel hybrid multifunctional magnetoelectric porous composite films

Novel multifunctional porous films have been developed by the integration of magnetic CoFe2O4 (CFO) nanoparticles into poly(vinylidene fluoride)-Trifuoroethylene (P(VDF-TrFE)), taking advantage of the synergies of the magnetostrictive filler and the piezoelectric polymer. The porous films show a piezoelectric response with an effective d33 coefficient of -22 pC/N-1, a maximum magnetization of 12 emu.g-1 and a maximum magnetoelectric coefficient of 9 mV.cm-1.Oe-1. In this way, a multifunctional membrane has been developed suitable for advanced applications ranging from biomedical to water treatment.

Instrumentos de políticas públicas do turismo: uma análise empírica dos municípios portugueses

Tese de Doutoramento em Ciências da Administração