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.

Evidence for inter- and intra-species biofilm formation variability among a small group of coagulase-negative staphylococci

Coagulase-negative staphylococci (CoNS) are common bacterial colonisers of the human skin. They are often involved in nosocomial infections due to biofilm formation in indwelling medical devices. While biofilm formation has been extensively studied in Staphylococcus epidermidis, little is known regarding other CoNS species. Here, biofilms from six different CoNS species were characterised in terms of biofilm composition and architecture. Interestingly, the ability to form a thick biofilm was not associated with any particular species, and high variability on biofilm accumulation was found within the same species. Cell viability assays also revealed different proportions of live and dead cells within biofilms formed by different species, although this parameter was particularly similar at the intra-species level. On the other hand, biofilm disruption assays demonstrated important inter- and intra-species differences regarding extracellular matrix composition. Lastly, confocal laser scanning microscopy (CLSM) experiments confirmed this variability, highlighting important differences and common features of CoNS biofilms. We hypothesised that the biofilm formation heterogeneity observed was rather associated with biofilm matrix composition than with cells themselves. Additionally, our results indicate that polysaccharides, DNA and proteins are fundamental pieces in the process of CoNS biofilm formation.

Recensão de Lee, E. (2005). How internet radio can change the world : an activist’s handbook. Nova Iorque : iUniverse, Inc.

(Excerto) O entusiasmo pela comunicação digital percorre transversalmente a obra How Internet Radio Can Change the World: An Activist’s Handbook, de Eric Lee. Esta postura tão apologista das possibilidades comunicativas oferecidas pela Internet reforça provavelmente um conjunto alargado de entendimentos sobre a conquista do quotidiano pelo digital. Em 1967, McLuhan e Fiore já se referiam aos circuitos eletrónicos como ‘extensões do sistema nervoso central’. Numa leitura mais contemporânea, José Bragança de Miranda refere: “vivemos, nos nossos dias, no meio de conexões, de links, do on‑line, estamos votados à participação, à ‘interactividade’, etc. Algo de novo está a emergir” (2001, p. 265). Maria Teresa Cruz (2001) define a convergência tecnológica das relações sociais como a ‘mobilização erótica da técnica’. Esta obra aqui recenseada pretende, assim, desafiar a utilização da rádio digital para “melhorar a comunicação e solidificar as organizações” (p. 1), em torno de três grupos de reflexão.

Solving large 0–1 multidimensional knapsack problems by a new simplified binary artificial fish swarm algorithm

The artificial fish swarm algorithm has recently been emerged in continuous global optimization. It uses points of a population in space to identify the position of fish in the school. Many real-world optimization problems are described by 0-1 multidimensional knapsack problems that are NP-hard. In the last decades several exact as well as heuristic methods have been proposed for solving these problems. In this paper, a new simpli ed binary version of the artificial fish swarm algorithm is presented, where a point/ fish is represented by a binary string of 0/1 bits. Trial points are created by using crossover and mutation in the different fi sh behavior that are randomly selected by using two user de ned probability values. In order to make the points feasible the presented algorithm uses a random heuristic drop item procedure followed by an add item procedure aiming to increase the profit throughout the adding of more items in the knapsack. A cyclic reinitialization of 50% of the population, and a simple local search that allows the progress of a small percentage of points towards optimality and after that refines the best point in the population greatly improve the quality of the solutions. The presented method is tested on a set of benchmark instances and a comparison with other methods available in literature is shown. The comparison shows that the proposed method can be an alternative method for solving these problems.

Performance assessment of electrically small antennas for implantable microsystems with wireless power and communications

Dissertação de mestrado integrado em Engenharia Biomédica (área de especialização em Eletrónica Médica)

Utilização de gás natural comprimido em veículos pesados de passageiros

Dissertação de mestrado em Engenharia Mecânica

Transferência de Energia sem fios para carregamento de baterias

Dissertação de mestrado integrado em Engenharia Eletrónica Industrial e Computadores

A novel small-caliber bacterial cellulose vascular prosthesis: production, characterization, and preliminary in vivo testing

Vascular grafts are used to bypass damaged or diseased blood vessels. Bacterial cellulose (BC) has been studied for use as an off-the-shelf graft. Herein, we present a novel, cost-effective, method for the production of small caliber BC grafts with minimal processing or requirements. The morphology of the graft wall produced a tensile strength above that of native vessels, performing similarly to the current commercial alternatives. As a result of the production method, the luminal surface of the graft presents similar topography to that of native vessels. We have also studied the in vivo behavior of these BC graft in order to further demonstrate their viability. In these preliminary studies, 1 month patency was achieved, with the presence of neo-vessels and endothelial cells on the luminal surface of the graft.

Trap efficiency evaluation for small mammals in the southern Amazon

The effectiveness of ecological researches on small mammals strongly depends on trapping techniques to survey communities and populations accurately. The main goal of this study was to assess the efficiency of three types of traps (Sherman, Tomahawk and Pitfall) to capture non-volant small mammals. We installed traps in 22 forest fragments in the southern Brazilian Amazonia. We captured 873 individuals belonging to 21 species; most of the individuals (N = 369) and species (N = 19) were trapped using Pitfalls, followed by Shermans (N = 271 individuals; N = 15 species) and Tomahawks (N = 233 individuals; N = 15 species). Pitfalls trapped a richer community subset of small mammals than the two other types of traps, and a more abundant community subset than Tomahawks. Proechimys sp. was the most abundant species trapped (N = 125) and Tomahawk was the most efficient type of trap to capture this species (N = 97 individuals). Neacomys spinosus and Marmosops bishopi were more trapped in Pitfalls (N = 92 and 100 individuals, respectively) than Shermans and Tomahawks. Monodelphis glirina was more trapped in Shermans and Pitfalls than Tomahawks. Species composition trapped using the three types of traps were distinct. Pitfalls captured a more distinct subset of the small mammal community than the two other live traps. We recommend the association of the three types of traps to reach a more comprehensive sampling of the community of small mammals. Thus, as stated by previous studies, we also recommend the complementary use of Shermans, Tomahawks and Pitfalls to account for a thorough sampling of the whole small mammal community in researches conducted in the tropical forests of Amazonia.

Vegetational changes during the last millennium inferred from a palynological record from the Bananal Island, Tocantins, Brazil

The Bananal Island is regarded the largest fluvial island in the world, bounded by Araguaia and Javaés rivers, being located in southwest of Tocantins. The objectives of this work were to provide information about the vegetational changes that occurred at the Bananal Island, in order to contribute to the understanding the dynamics of past and current savanna and areas of ecotones with forests. Thus, a sedimentary core collected from a small lake at the Bananal Island plain was submitted to pollen and radiocarbon dating analyses. The results showed that the last millennium was dominated by forest reflecting a wet climate. At the beginning of the record (920-770 yr cal BP) the wet climate and high rainfall produced flooding during long rainy seasons that maintained the Javaés River connected to the studied lake, and hence, this environment was marked by the presence of a homogenous forest rich in Moraceae/Urticaceae, due to flooded soils occurrence. During the following period (770-304 yr cal BP) the reduced rainfall and shortening of the rainy seasons isolated the lake from the Javaés River for long periods, which caused a diversification of the forest and gave rise to the appearance of the components of floodplain forest and marsh vegetation adapted to waterlogged soils. Since 304 years cal BP to the present day this environment remained dominated by this diverse forest and the lacustrine conditions were also similar to previous phase, with a slight increase of moisture in the last 84 years that caused the increase of Piranhea.

The seasonal diet of Aequidens tetramerus (Cichlidae) in a small forest stream in the Machado River basin, Rondônia, Brazil

Trophic relationships in fish communities are affected by the availability of resources, which in turn is affected by spatial and temporal variations throughout the year. The aims of this study were to characterize the diet of A. tetramerus in a streamlet in the north of Brazil and compare its composition in different hydrological seasons (wet and dry seasons). Collections were performed every two months from October 2011 to September 2012 with the aid of seine nets, hand net and fishing traps in the streamlet located in the Machado River drainage basin in the Rondônia state. Most of the specimens collected were quite small (< 40 mm) and had empty stomachs. Our results showed that A. tetramerus feeds on a wide variety of items of plant origin, such as algae, seeds and leaves, as well as items of animal origin, including bryozoans, crustaceans, fish scales, terrestrial insects and detritus. The data also indicated higher consumption of aquatic insects than other food items, suggesting a primarily insect-based diet. Items of plant and allochthonous origin were consumed more in the wet season than in the dry season, but there were no seasonal differences in the consumption of animal and autochthonous items.

Contribution to the marine propeller hydrodynamic design for small boats in the Amazon region

ABSTRACTIn the Amazon, river navigation is very important due to the length of navigable rivers and the lack of alternative road networks. Boats usually operate in unfavorable conditions, since there is no hydrodynamic relation among propellers, geometry, and the dimensions of the boat hull. Currently, there is no methodology for propeller hydrodynamic optimization with low computational cost and easy implementation in the region. The aim of this work was to develop a mathematical approach for marine propeller design applied to boats typically found on Amazon rivers. We developed an optimized formulation for the chord and pitch angle distributions, taking into account the classical model of Glauert. A theoretical analysis for the thrust and torque relationships on an annular control volume was performed. The mathematical model used was based on the Blade Element Momentum Theory (BEMT). We concluded that the new methodology proposed in this work demonstrates a good physical behavior when compared with the theory of Glauert and the experimental data of the Wageningen B3-50 propeller.

Crowdfunding e resiliência das comunidades: estudo de caso

Dissertação de mestrado integrado em Engenharia e Gestão de Sistemas de Informação

Hydrocarbonoclastic bacteria: from bioremediation to bioenergy feedstock

Tese de Doutoramento em Engenharia Química e Biológica.

Ligantes de baixo impacto ambiental e baixo custo, baseados na ativação química de escórias de aciaria

Dissertação de mestrado integrado em Engenharia Civil