A relational algebra approach to ETL modeling

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

Effect of NaCl additive on solute-solvent interactions in aqueous polyethylene glycol-sodium sulfate two-phase systems

Abstract Partition behavior of eight small organic compounds and six proteins was examined in poly(ethylene glycol)-8000-sodium sulfate aqueous two-phase systems containing 0.215 M NaCl and 0.5 M osmolyte (sorbitol, sucrose, TMAO) and poly(ethylene glycol)-10000-sodium sulfate-0.215 M NaCl system, all in 0.01 M sodium phosphate buffer, pH 6.8. The differences between the solvent properties of the coexisting phases (solvent dipolarity/polarizability, hydrogen bond donor acidity, and hydrogen bond acceptor basicity) were characterized with solvatochromic dyes using the solvatochromic comparison method. Differences between the electrostatic properties of the phases were determined by analysis of partitioning of sodium salts of dinitrophenylated (DNP-) amino acids with aliphatic alkyl side-chain. The partition coefficients of all compounds examined (including proteins) were described in terms of solute-solvent interactions. The results obtained in the study show that solute-solvent interactions of nonionic organic compounds and proteins in polyethylene glycol-sodium sulfate aqueous two-phase system change in the presence of NaCl additive.

Concurrency detection on finish-to-start activity precedence networks

We explore the finish-to-start precedence relations of project activities used in scheduling problems. From these relations, we devise a method to identify groups of activities that could execute concurrently, i.e. activities in the same group can all execute in parallel. The method derives a new set of relations to describe the concurrency. Then, it is represented by an undirected graph and the maximal cliques problem identifies the groups. We provide a running example with a project from our previous studies in resource constrained project cost minimization together with an example application on the concurrency detection method: the evaluation of the resource stress.

Palinologia holocênica do testemunho Bom Jesus, margem leste da ilha do Marajó, Pará, Amazônia

A porção superior (1,25m) do testemunho de sondagem Bom Jesus (TBJ), coletado no limite campo-mangue da Fazenda Bom Jesus, município de Soure, ilha do Marajó, Pará, Brasil, foi estudada através de análise palinológica de alta resolução objetivando a determinação da composição, abundância e diversidade de tipos polínicos bioindicadores de modificações na paleovegetação durante o Holoceno. 16 amostras sedimentares de 2cm³ foram tratadas de acordo com metodologia padrão em palinologia. Os programas Tilia e Tilia Graph foram utilizados para a construção dos diagramas palinológicos de abundância e concentração. A base do testemunho foi datada por 14C em 2730 ± 40 anos A.P. Foram definidas três zonas palinológicas. A presença de pólen de Rhizophora com abundância máxima de 88% apontou dominância de mangue ao longo de todo o testemunho sedimentar. Variações recorrentes na hidrodinâmica da baía do Marajó, caracterizadas por pulsos erosivos de curto período, parecem ter provocado redução na dominância de mangue. O incremento na abundância de tipos polínicos bioindicadores de campo inundável associados a elementos de restinga e floresta, evidenciam a migração do campo inundável sobre o manguezal. Os dados indicam correlação com outros registros polínicos holocênicos de transgressão marinha para a costa norte amazônica no Holoceno Superior.

Interactions between carpenter bees and orchid bees (Hymenoptera: Apidae) in flowers of Bertholletia excelsa Bonpl. (Lecythidaceae)

Competition between two species of bees for the same type of floral resource may generate antagonistic behavior between them, especially in cultivated areas where food resources are limited, seasonally and locally. In this study, was tested the hypothesis of antagonism between two solitary bee species of the family Apidae, Eulaema mocsaryi (Euglossini) and Xylocopa frontalis (Xylocopini), visiting the Brazil nut flowers (Bertholletia excelsa: Lecythidaceae) in a central Amazonia agricultural area. The visitation time was analyzed to detect the possible temporal overlap in the foraging of these bees. Furthermore, was analyzed their interspecific interactions for manipulating flower species visited by an opponent species, as well as attempts to attack this opponent. The individuals of Xylocopa frontalis visited the Brazil nut flowers before Eulaema mocsaryi, although the peak visitation of both did not presented significant differences. Neither of the species manipulated flowers recently visited by opponent species, and there were practically no antagonistic interactions between them. Thus, X. frontalis and E. mocsaryi shared the same food source in the flowers of B. excelsa due to differences in their time of visits and non-aggressive way of interacting with the opponent. This result has important implications for pollinating the Brazil nut, and a possible management of X. frontalis and E. mocsaryi, since these two were the most abundant pollinators in the studied locality.

Column-based databases: estudo exploratório no âmbito das bases de dados NoSQL

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

Document-based databases: estudo comparativo no âmbito das bases de dados NoSql

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

From software extensions to product lines of dataflow programs

Abstract Dataflow programs are widely used. Each program is a directed graph where nodes are computations and edges indicate the flow of data. In prior work, we reverse-engineered legacy dataflow programs by deriving their optimized implementations from a simple specification graph using graph transformations called refinements and optimizations. In MDE-speak, our derivations were PIM-to-PSM mappings. In this paper, we show how extensions complement refinements, optimizations, and PIM-to-PSM derivations to make the process of reverse engineering complex legacy dataflow programs tractable. We explain how optional functionality in transformations can be encoded, thereby enabling us to encode product lines of transformations as well as product lines of dataflow programs. We describe the implementation of extensions in the ReFlO tool and present two non-trivial case studies as evidence of our work’s generality

Effect of sodium chloride on solutesolvent interactions in aqueous polyethylene glycolsodium sulfate two-phase systems

Partition behavior of eight small organic compounds and six proteins was examined in poly(ethylene glycol)-8000sodium sulfate aqueous two-phase systems containing 0.215 M NaCl and 0.5 M osmolyte (sorbitol, sucrose, TMAO) and poly(ethylene glycol)-10000sodium sulfate0.215 M NaCl system, all in 0.01 M sodium phosphate buffer, pH 6.8. The differences between the solvent properties of the coexisting phases (solvent dipolarity/polarizability, hydrogen bond donor acidity, and hydrogen bond acceptor basicity) were characterized with solvatochromic dyes using the solvatochromic comparison method. Differences between the electrostatic properties of the phases were determined by analysis of partitioning of sodium salts of dinitrophenylated (DNP-) amino acids with aliphatic alkyl side-chain. The partition coefficients of all compounds examined (including proteins) were described in terms of solutesolvent interactions. The results obtained in the study show that solutesolvent interactions of nonionic organic compounds and proteins in polyethylene glycolsodium sulfate aqueous two-phase system change in the presence of NaCl additive.

Interrelationship between partition behavior of organic compounds and proteins in aqueous dextran-Polyethylene glycol and Polyethylene glycol-sodium sulfate two-phase systems

Partition behavior of adenosine and guanine mononucleotides was examined in aqueous dextran-polyethylene glycol (PEG) and PEG-sodium sulfate two-phase systems. The partition coefficients for each series of mononucleotides were analyzed as a functions of the number of phosphate groups and found to be dependent on the nature of nucleic base and on the type of \ATPS\ utilized. It was concluded that an average contribution of a phosphate group into logarithm of partition coefficient of a mononucleotide cannot be used to estimate the difference between the electrostatic properties of the coexisting phases of ATPS. The data obtained in this study were considered together with those for other organic compounds and proteins reported previously, and the linear interrelationship between logarithms of partition coefficients in dextran-PEG, PEG-Na2SO4 and PEG-Na2SO4-0.215 M NaCl (all in 0.01 M Na- or K/Na-phosphate buffer, pH 7.4 or 6.8) was established. Similar relationship was found for the previously reported data for proteins in Dex-PEG, PEG-600-Na2SO4, and PEG-8000-Na2SO4 ATPS. It is suggested that the linear relationships of the kind established in \ATPS\ may be observed for biological properties of compounds as well.

BIOMedical search engine framework: lightweight and customized implementation of domain-specific biomedical search engines

The Smart Drug Search is publicly accessible at http://sing.ei.uvigo.es/sds/. The BIOMedical Search Engine Framework is freely available for non-commercial use at https://github.com/agjacome/biomsef

Topological abstraction of higher-dimensional automata

Higher-dimensional automata constitute a very expressive model for concurrent systems. In this paper, we discuss ``topological abstraction" of higher-dimensional automata, i.e., the replacement of HDAs by smaller ones that can be considered equivalent from the point of view of both computer science and topology. By definition, topological abstraction preserves the homotopy type, the trace category, and the homology graph of an HDA. We establish conditions under which cube collapses yield topological abstractions of HDAs.

Defining habitat characteristics influencing the distribution, density and growth of Plaice (Pleuronectes Platessa) and Dab (Limanda Limanda) on west of Ireland nursery grounds

Plaice (Pleuronectes platessa, L.) and dab (Limanda limanda, L.) are among the most abundant flatfishes in the north-eastern Atlantic region and the dominant species in shallow coastal nursery grounds. With increasing pressures on commercial flatfish stocks in combination with changing coastal environments, better knowledge of population dynamics during all life stages is needed to evaluate variability in year-class strength and recruitment to the fishery. The aim of this research was to investigate the complex interplay of biotic and abiotic habitat components influencing the distribution, density and growth of plaice and dab during the vulnerable juvenile life stage and to gain insight in spatial and temporal differences in nursery habitat quality along the west coast of Ireland. Intraspecific variability in plaice diet was observed at different spatial scales and showed a link with condition, recent growth and morphology. This highlights the effect of food availability on habitat quality and the need to consider small scale variation when attempting to link habitat quality to feeding, growth and condition of juvenile flatfish. There was evidence of trophic, spatial and temporal resource partitioning between juvenile plaice and dab allowing the co-existence of morphologically similar species in nursery grounds. In the limited survey years there was no evidence that the carrying capacity of the studied nursery grounds was reached but spatial and interannual variations in fish growth indicated fluctuating environments in terms of food availability, predator densities, sediment features and physico-chemical conditions. Predation was the most important factor affecting habitat quality for juvenile plaice and dab with crab densities negatively correlated to fish condition whereas shrimp densities were negatively associated with densities of small-sized juveniles in spring. A comparison of proxies for fish growth showed the advantage of Fulton’s K for routine use whereas RNA:DNA ratios proved less powerful when short-term environmental fluctuations are lacking. This study illustrated how distinct sets of habitat features can drive spatial variation in density and condition of juvenile flatfish highlighting the value of studying both variables when modeling habitat requirements. The habitat models generated in this study also provide a powerful tool to predict potential climate and anthropogenic impacts on the distribution and condition of juveniles in flatfish nurseries. The need for effective coastal zone management was emphasized to ensure a sustainable use of coastal resources and successful flatfish recruitment to the fishery.

Анализ экспериментальных данных физического моделирования магнитотеллурического поля лля моделей интрузивных тел с применением компьютерной графики

მაგნიტოტელურული ველის ფიზიკური მოდელირების შედეგები, განსაზღვრული ფორმის ინტრუზიული სხეულებისათვის, დამუშავებულია კომპიუტერული გრაფიკის საშუალებით. დადგინდა, რომ მკვეთრად შემოკონტურდება დღიური ზედაპირის იმიტაციით გადაფარული განსაზღვრული ფორმის სხეულების მდებარეობის საზღვრები. განსხვავებული გეომეტრიის მქონე მოდელების, ელექტრომაგნიტური ველის მდგენელების სივრცულ გრაფიკებზე გამოვლენილია მათთვის დამახასიათებელი განსხვავებები.

Экспериментальное исследование с применением компьютерной графики влияния рельефа дневной поверхности на магнитотеллурическое поле

არაერთგვაროვან გარემოში ელექტროდინამიკური პროცესების მოდელირების დანადგარზე გამოკვლეულია მაგნიტოტელურ ველზე სამგანზომილებიანი უსწორმასწორო დღიური ზედაპირის რელიეფის გავლენა. შედეგები დამუშავებულია კომპიუტერული გრაფიკული პროგრამის გამოყენებით.