DACA: architecture to implement dynamic access control mechanisms on business tier components

Access control is a software engineering challenge in database applications. Currently, there is no satisfactory solution to dynamically implement evolving fine-grained access control mechanisms (FGACM) on business tiers of relational database applications. To tackle this access control gap, we propose an architecture, herein referred to as Dynamic Access Control Architecture (DACA). DACA allows FGACM to be dynamically built and updated at runtime in accordance with the established fine-grained access control policies (FGACP). DACA explores and makes use of Call Level Interfaces (CLI) features to implement FGACM on business tiers. Among the features, we emphasize their performance and their multiple access modes to data residing on relational databases. The different access modes of CLI are wrapped by typed objects driven by FGACM, which are built and updated at runtime. Programmers prescind of traditional access modes of CLI and start using the ones dynamically implemented and updated. DACA comprises three main components: Policy Server (repository of metadata for FGACM), Dynamic Access Control Component (DACC) (business tier component responsible for implementing FGACM) and Policy Manager (broker between DACC and Policy Server). Unlike current approaches, DACA is not dependent on any particular access control model or on any access control policy, this way promoting its applicability to a wide range of different situations. In order to validate DACA, a solution based on Java, Java Database Connectivity (JDBC) and SQL Server was devised and implemented. Two evaluations were carried out. The first one evaluates DACA capability to implement and update FGACM dynamically, at runtime, and, the second one assesses DACA performance against a standard use of JDBC without any FGACM. The collected results show that DACA is an effective approach for implementing evolving FGACM on business tiers based on Call Level Interfaces, in this case JDBC.

Multi-purpose adaptable business tier components based on Call Level Interfaces

Call Level Interfaces (CLI) play a key role in business tiers of relational and on some NoSQL database applications whenever a fine tune control between application tiers and the host databases is a key requirement. Unfortunately, in spite of this significant advantage, CLI are low level API, this way not addressing high level architectural requirements. Among the examples we emphasize two situations: a) the need to decouple or not to decouple the development process of business tiers from the development process of application tiers and b) the need to automatically adapt business tiers to new business and/or security needs at runtime. To tackle these CLI drawbacks, and simultaneously keep their advantages, this paper proposes an architecture relying on CLI from which multi-purpose business tiers components are built, herein referred to as Adaptable Business Tier Components (ABTC). Beyond the reference architecture, this paper presents a proof of concept based on Java and Java Database Connectivity (an example of CLI).

ABTC: multi-purpose adaptable business tier components based on Call Level Interfaces

Call Level Interfaces (CLI) are low level API that play a key role in database applications whenever a fine tune control between application tiers and the host databases is a key requirement. Unfortunately, in spite of this significant advantage, CLI were not designed to address organizational requirements and contextual runtime requirements. Among the examples we emphasize the need to decouple or not to decouple the development process of business tiers from the development process of application tiers and also the need to automatically adapt to new business and/or security needs at runtime. To tackle these CLI drawbacks, and simultaneously keep their advantages, this paper proposes an architecture relying on CLI from which multi-purpose business tiers components are built, herein referred to as Adaptable Business Tier Components (ABTC). This paper presents the reference architecture for those components and a proof of concept based on Java and Java Database Connectivity (an example of CLI).

Lacertid lizards as bioindicators of agricultural contamination

Apesar do recente aumento no número de estudos, os lagartos persistem como um dos grupos menos estudados em ecotoxicologia e o desconhecimento em relação à sua resposta à contaminação ambiental é enorme. A nível europeu, os lacertídeos têm sido identificados como potenciais espécies modelo para a ecotoxicologia com répteis. O principal objectivo deste projecto era determinar se um lacertídeo abundante pertencente ao género Podarcis, podia ser utilizado como bioindicador de exposição e toxicidade em zonas agrícolas. Para atingir este objectivo, utilizámos uma estratégia integrada com três fases. Numa primeira fase realizou-se um estudo de campo para documentar o tipo de exposição e parâmetros populacionais de populações de lacertídeos que ocorrem em zonas de uso intenso de pesticidas e zonas de agricultura orgânica. A segunda fase consistiu num estudo de mesocosmo em que se expuseram juvenis a um conjunto de pesticidas em condições controladas durante um período de um ano. Finalmente, a terceira fase incluiu um estudo laboratorial sobre os efeitos do clorpirifos, um dos insecticidas mais utilizado a nível global, em lagartixas. No término de cada um dos estudos, analisaram-se diversos biomarcadores e parâmetros de exposição e toxicidade a pesticidas nos diferentes indivíduos. Este conjunto abrangente de parâmetros foi analisado em diferentes níveis de organização biológica, incluindo parâmetros populacionais, bem como comportamentais, fisiológicos, bioquímicos e histológicos. Em geral, detectaram-se poucas diferenças estatísticas significativas entre as populações dos campos expostos a pesticidas e populações referência. Confirmando a dificuldade que existe em isolar os efeitos de diferentes contaminantes sobre as populações de outros factores locais, ciclos sazonais ou eventos estocásticos. As populações de P. bocagei parecem ser capazes de lidar com o nível observado de exposição a pesticidas. No entanto, indivíduos que vivem em locais expostos a pesticidas parecem estar menos adaptados ecologicamente do que aqueles que vivem em locais referência, apresentando um estado de depleção nutricional e sinais de stress metabólico. Os resultados obtidos com os animais da experiência de mesocosmo parecem reforçar estes resultados. Os animais prosperaram relativamente bem em todos os mesocosmos, independentemente do tratamento ou não com pesticidas, apresentando uma ampla gama de comportamentos naturais. A abordagem laboratorial confirmou P. bocagei como um valioso indicador de exposição sub-letal a doses ambientalmente realistas de clorpirifos. De acordo, com o conjunto d resultados obtidos, P. bocagei parece ser um bioindicador adequado de exposição a pesticidas.

Advanced energy efficient coordinated multi-point transmission for OFDMA

The ever-growing energy consumption in mobile networks stimulated by the expected growth in data tra ffic has provided the impetus for mobile operators to refocus network design, planning and deployment towards reducing the cost per bit, whilst at the same time providing a signifi cant step towards reducing their operational expenditure. As a step towards incorporating cost-eff ective mobile system, 3GPP LTE-Advanced has adopted the coordinated multi-point (CoMP) transmission technique due to its ability to mitigate and manage inter-cell interference (ICI). Using CoMP the cell average and cell edge throughput are boosted. However, there is room for reducing energy consumption further by exploiting the inherent exibility of dynamic resource allocation protocols. To this end packet scheduler plays the central role in determining the overall performance of the 3GPP longterm evolution (LTE) based on packet-switching operation and provide a potential research playground for optimizing energy consumption in future networks. In this thesis we investigate the baseline performance for down link CoMP using traditional scheduling approaches, and subsequently go beyond and propose novel energy e fficient scheduling (EES) strategies that can achieve power-e fficient transmission to the UEs whilst enabling both system energy effi ciency gain and fairness improvement. However, ICI can still be prominent when multiple nodes use common resources with di fferent power levels inside the cell, as in the so called heterogeneous networks (Het- Net) environment. HetNets are comprised of two or more tiers of cells. The rst, or higher tier, is a traditional deployment of cell sites, often referred to in this context as macrocells. The lower tiers are termed small cells, and can appear as microcell, picocells or femtocells. The HetNet has attracted signiffi cant interest by key manufacturers as one of the enablers for high speed data at low cost. Research until now has revealed several key hurdles that must be overcome before HetNets can achieve their full potential: bottlenecks in the backhaul must be alleviated, as well as their seamless interworking with CoMP. In this thesis we explore exactly the latter hurdle, and present innovative ideas on advancing CoMP to work in synergy with HetNet deployment, complemented by a novel resource allocation policy for HetNet tighter interference management. As system level simulator has been used to analyze the proposed algorithm/protocols, and results have concluded that up to 20% energy gain can be observed.

Derivation of soil screening values for metals in Portuguese natural soil

The increasing human activity has been responsible by profound changes and a constinuos degradation of the soil compartment in all the European territory. Some European policies are appearing focusing soil’s protection and the management of contaminated sites, in order to recover land for other uses. To regulate the risk assessment and the management of contaminated soils, many European member states adopted soil guideline values, as for example soil screnning values (SSV).These values are particularly useful for the the first tier of the Ecological Risk Assessment (ERA) processes of contaminated sites,especially for a first screening of sites requiring a more site-specific evaluation. Hence, the approriate definition of regional SSVs will have relevant economic impacts in the management of contaminated sites. Portugal is one of European Member States that still lack these soil guideline values. In this context, this study gaves a remarkable contribution in the generation of ecotoxicological data for soil microbiological parameters, terrestrial plants and invertebrates for the derivation of SSVs for uranium (U), cadmium (Cd) and copper (Cu), using a Portuguese natural soil, representative of a dominant type of soil in the Portuguese territory. SSVs were derived based on two methods proposed by the the Technical Guidance Document for Risk Assessment of the European Commission; namely the assessment factor method (AF) and the species sensitivity distribution (SSD) method (with some adaptations). The outputs of both methods were compared and discussed. Further, this study laid the foundation for a deeper reflection about the cut-off (hazard concentration for a given percentage of species - HCps) to be estimated from the SSDs, and to be selected for the derivation of SSVs, with the adequate level of protection. It was proven that this selection may vary for different contaminants, however a clear justification should be given, in each case. The SSvs proposed in this study were for: U (151.4 mg U kg-1dw), Cd (5.6 mg Cd kg-1dw), and Cu (58.5 mg Cu kg-1dw) These values should now be tested for their descriminating power of soils with different levels of contamination. However, this studies clarifies the approach that should be followed for the derivation of SSVs for other metals and organic contaminants, and for other dominant types of Portuguese natural soils.

Organic contaminants in urban soils: major inputs and potential risks

Urban soil quality may be severely affected by hydrophobic organic contaminants (HOCs), impairing environmental quality and human health. A comprehensive study was conducted in two contrasting Portuguese urban areas (Lisbon and Viseu) in order to assess the levels and potential risks of these contaminants, to identify sources and study their behaviour in soils. The concentrations of HOCs were related to the size of the city, with much higher contamination levels observed in Lisbon urban area. Source apportionment was performed by studying the HOCs profiles, their relationship with potentially toxic elements and general characteristics of soil using multivariate statistical methods. Lisbon seems to be affected by nearby sources (traffic, industry and incineration processes) whereas in Viseu the atmospheric transport may be playing an important role. In a first tier of risk assessment (RA) it was possible to identify polycyclic aromatic hydrocarbons (PAHs) in Lisbon soils as a potential hazard. The levels of PAHs in street dusts were further studied and allowed to clarify that traffic, tire and pavement debris can be an important source of PAHs to urban soils. Street dusts were also identified as being a potential concern regarding human and environmental health, especially if reaching the nearby aquatic bodies. Geostatistical tools were also used and their usefulness in a RA analysis and urban planning was discussed. In order to obtain a more realistic assessment of risks of HOCs to environment and human health it is important to evaluate their available fraction, which is also the most accessible for organisms. Therefore, a review of the processes involved on the availability of PAHs was performed and the outputs produced by the different chemical methods were evaluated. The suitability of chemical methods to predict bioavailability of PAHs in dissimilar naturally contaminated soils has not been demonstrated, being especially difficult for high molecular weight compounds. No clear relationship between chemical and biological availability was found in this work. Yet, in spite of the very high total concentrations found in some Lisbon soils, both the water soluble fraction and the body residues resulting from bioaccumulation assays were generally very low, which may be due to aging phenomena. It was observed that the percentage of soluble fraction of PAHs in soils was found to be different among compounds and mostly regulated by soil properties. Regarding bioaccumulation assays, although no significant relationship was found between soil properties and bioavailability, it was verified that biota-to-soil bioaccumulation factors were sample dependent rather than compound dependent. In conclusion, once the compounds of potential concern are targeted, then performing a chemical screening as a first tier can be a simple and effective approach to start a RA. However, reliable data is still required to improve the existing models for risk characterization.

Effects of environmental factors on the toxicity of pesticides to zebrafish embryos

During the last century mean global temperatures have been increasing. According to the predictions, the temperature change is expected to exceed 1.5ºC in this century and the warming is likely to continue. Freshwater ecosystems are among the most sensitive mainly due to changes in the hydrologic cycle and consequently changes in several physico-chemical parameters (e.g. pH, dissolved oxygen). Alterations in environmental parameters of freshwater systems are likely to affect distribution, morphology, physiology and richness of a wide range of species leading to important changes in ecosystem biodiversity and function. Moreover, they can also work as co-stressors in environments where organisms have already to cope with chemical contamination (such as pesticides), increasing the environmental risk due to potential interactions. Therefore, the objective of this work was to evaluate the effects of climate change related environmental parameters on the toxicity of pesticides to zebrafish embryos. The following environmental factors were studied: pH (3.0-12.0), dissolved oxygen level (0-8 mg/L) and UV radiation (0-500 mW/m2). The pesticides studied were the carbamate insecticide carbaryl and the benzimidazole fungicide carbendazim. Stressors were firstly tested separately in order to derive concentration- or intensity-response curves to further study the effects of binary combinations (environmental factors x pesticides) by applying mixture models. Characterization of zebrafish embryos response to environmental stress revealed that pH effects were fully established after 24 h of exposure and survival was only affected at pH values below 5 and above 10. Low oxygen levels also affected embryos development at concentrations below 4 mg/L (delay, heart rate decrease and edema), and at concentrations below 0.5 mg/L the survival was drastically reduced. Continuous exposure to UV radiation showed a strong time-dependent impact on embryos survival leading to 100% of mortality after 72 hours of exposure. The toxicity of pesticides carbaryl and carbendazim was characterized at several levels of biological organization including developmental, biochemical and behavioural allowing a mechanistic understanding of the effects and highlighting the usefulness of behavioural responses (locomotion) as a sensitive endpoint in ecotoxicology. Once the individual concentration response relationship of each stressor was established, a combined toxicity study was conducted to evaluate the effects of pH on the toxicity of carbaryl. We have shown that pH can modify the toxicity of the pesticide carbaryl. The conceptual model concentration addition allowed a precise prediction of the toxicity of the jointeffects of acid pH and carbaryl. Nevertheless, for alkaline condition both concepts failed in predicting the effects. Deviations to the model were however easy to explain as high pH values favour the hydrolysis of carbaryl with the consequent formation of the more toxic degradation product 1- naphtol. Although in the present study such explanatory process was easy to establish, for many other combinations the “interactive” nature is not so evident. In the context of the climate change few scenarios predict such increase in the pH of aquatic systems, however this was a first approach focused in the lethal effects only. In a second tier assessment effects at sublethal level would be sought and it is expectable that more subtle pH changes (more realistic in terms of climate changes scenarios) may have an effect at physiological and biochemical levels with possible long term consequences for the population fitness.