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

O aumento da quantidade de dados gerados que se tem verificado nos últimos anos e a que se tem vindo a dar o nome de Big Data levou a que a tecnologia relacional começasse a demonstrar algumas fragilidades no seu armazenamento e manuseamento o que levou ao aparecimento das bases de dados NoSQL. Estas estão divididas por quatro tipos distintos nomeadamente chave/valor, documentos, grafos e famílias de colunas. Este artigo é focado nas bases de dados do tipo column-based e nele serão analisados os dois sistemas deste tipo considerados mais relevantes: Cassandra e HBase.

Enzymatic phosphorylation of hair keratin enhances fast adsorption of cationic moieties

The current study describes the in vitro phosphorylation of a human hair keratin, using protein kinase for the first time. Phosphorylation of keratin was demonstrated by 31P NMR (Nuclear Magnetic Resonance) and Diffuse Reflectance Infrared Fourier Transform (DRIFT) techniques. Phosphorylation induced a 2.5 fold increase of adsorption capacity in the first 10 minutes for cationic moiety like Methylene Blue (MB). Thorough description of MB adsorption process was performed by several isothermal models. Reconstructed fluorescent microscopy images depict distinct amounts of dye bound to the differently treated hair. The results of this work suggest that the enzymatic phosphorylation of keratins might have significant implications in hair shampooing and conditioning, where short application times of cationic components are of prime importance.

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

Remoção fotocatalítica de micropoluentes em meios porosos funcionalizados

Dissertação de mestrado integrado em Engenharia Civil

Separation by thermal diffusion in a rotary column

A rotary thermal diffusion column with the inner cylinder rotating and the outer cylinder static was used to separate n-heptane-benzene mixtures at different speeds of rotation. The results show that the column efficiency depends on the speed of rotation. For the optimum speed the increase in efficiency relative to the static column was of the order of 8%. The role of the geometric irregularities in the annulus width on performance of the rotary column is also discussed.

Investigation into the potential for establishing a self-sustainable wetland ecosystem over pyritic mine tailings

Research was conducted to investigate the potential for ecologically engineering a sustainable wetland ecosystem over pyritic mine tailings to prevent the generation of acid mine drainage. Ecological engineering is technology with the primary goal being the creation of self-sustainable ecological systems. Work involved the design and construction of a pilot-scale wetland system comprising three wetland cells, each covering 100 m2. Approximately forty tonnes of pyritic mine tailings were deposited on the base of the first cell above a synthetic liner, covered with peat, flooded and planted with emergent wetland macrophytes Typha latifolia, Phragmites australis, and Juncus effusus. The second cell was constructed as a conventional free water surface wetland, planted identically, and used as a reference wetland/experimental control. Wetland monitoring to determine long-term sustainability focused on indicators of ecosystem health including ecological, hydrological, physico-chemical, geochemical, and biotic metrics. An integrated assessment was conducted that involved field ecology in addition to ecological risk assessment. The objective of the field ecology study was to use vegetative parameters as ecological indicators for documenting wetlands success or degradation. The goal of the risk assessment was to determine if heavy-metal contamination of the wetland sediments occurred through metal mobilisation from the underlying tailings, and to evaluate if subsequent water column chemistry and biotic metal concentrations were significantly correlated with adverse wetland ecosystem impacts. Data were used to assess heavy metal bioavailability within the system as a function of metal speciation in the wetland sediments. Results indicate hydrology is the most important variable in the design and establishment of the tailings wetland and suggest a wetland cover is an ecologically viable alternative for pyritic tailings which are feasible to flood. Ecological data indicate that in terms of species richness and diversity, the tailings-wetland was exhibiting the ecological characteristics of natural wetlands within two years. Ata indicate that pH and conductivity in the tailings-wetland were not adversely impacted by the acid-generating potential or sulphate concentration of the tailings substrate and its porewater. Similarly, no enhanced seasonal impacts from sulphate or metals in the water column, nor adverse impacts on the final water quality of the outflows, were detected. Mean total metal concentrations in the sediments of the tailings-wetland indicate no significant adverse mobilisation of metals into the peat substrate from the tailings. Correlation analyses indicate a general increase in sediment metal concentration in this wetland with increasing water depth and pH, and a corresponding decrease in the metal concentrations of the water column. Sediment extractions also showed enrichment of Cd, Fe, Pb and Zn in the oxidisable fraction (including sulphides and organic matter) of the tailings-wetland sediments. These data suggest that adsorption and coprecipitation of metals is occurring from the water column of the tailings wetland with organic material at increasing depths under reducing conditions. The long-term control of metal bioavailability in the tailings wetland will likely be related to the presence and continual build-up of organic carbon binding sites in the developing wetland above the tailings. Metal speciation including free-metal ion concentration and the impact of physico-chemical parameters particularly pH and organic matter, were investigated to assess ecotoxicological risk. Results indicate that potentially bioavailable metals (the sum of the exchangeable and reducible fractions) within the tailings wetland are similar to values cited for natural wetlands. Estimated free-metal ion concentrations calculated from geochemical regression models indicate lower free-metal ion concentrations of Cd in the tailings wetland than natural wetlands and slightly higher free-metal ion concentrations of Pb and Zn. Increased concentrations of metals in roots, rhizomes and stems of emergent macrophytes did not occur in the tailings wetland. Even though a substantial number of Typha latifolia plants were found rooting directly into tailings, elevated metals were not found in these plant tissues. Phragmites also did not exhibit elevated metal concentrations in any plant tissues. Typha and Phragmites populations appear to be exhibiting metal-tolerant behaviour. The chemistry of the water column and sediments in Silvermines wetland were also investigated and were much more indicative of a wetland system impacted by heavy metal contamination than the tailings-wetland. Mean Dc, Fe, Mn, Pb and Zn concentrations in the water column and sediments of Silvermines wetlands were substantially higher than in the pilot wetlands and closely approximate concentrations in these matrices contaminated with metals from mining. In addition, mean sulphate concentration in Silvermines wetland was substantially higher and is closer to sulphate concentrations in waters associated with mining. Potentially bioavailable metals were substantially elevated in Silvermines wetland in comparison to the pilot wetlands and higher than those calculated for natural rive sediments. However, Fe oxy-hydroxide concentrations in Silvermines sediments are also much higher than in the pilot wetlands and this significantly impacts the concentration of free-metal ions in the sediment porewater. The free-metal ion concentrations for Pb and Zn indicate that Silvermines wetland is retaining metals and acting as a treatment wetland for drainage emanating from Silvermines tailings dam.

On the structure and development of the vertebral column of Amia [by] O. P. Hay.

v.1:no.1(1895)

Nylon wool column: a tool for obtaining monokine-rich eluates in the absence of serum

Diverse conditions for stimulating human mononuclear cells to release thymocyte costimulatory factors were tested for their contribution to the generation of supernatants high titers of these monokines. Activity titers increased with LPS concentration, reaching a plateau between 1 and 10 microng/ml. Indomethacin did not modify the monokine, but the assay for thymocyte costimulatory activity was substantially affected by inhibitory substances produced by the monocytes in the absence of indomethacin. The use of nylon wool columns to trap the cells was shown to be effective in raising cellular densities without decreasing activity titers. As result, the yield per cell could be maintained even in the absence of serum, an important step toward the goal of purifiying bioactive from crude broths.

Geochemistry of highly acidic mine water following disposal into a natural lake with carbonate bedrock

Acid mine drainage (AMD) from the Zn-Pb(-Ag-Bi-Cu) deposit of Cerro de Pasco (Central Peru) and waste water from a Cu-extraction plant has been discharged since 1981 into Lake Yanamate, a natural lake with carbonate bedrock. The lake has developed a highly acidic pH of similar to 1. Mean lake water chemistry was characterized by 16,775 mg/L acidity as CaCO(3), 4330 mg/L Fe and 29,250 mg/L SO(4). Mean trace element concentrations were 86.8 mg/L Cu, 493 mg/L Zn, 2.9 mg/L Pb and 48 mg/L As, which did not differ greatly from the discharged AMD. Most elements showed increasing concentrations from the surface to the lake bottom at a maximal depth of 41 m (e.g. from 3581 to 5433 mg/L Fe and 25,609 to 35,959 mg/L SO(4)). The variations in the H and 0 isotope compositions and the element concentrations within the upper 10 m of the water column suggest mixing with recently discharged AMD, shallow groundwater and precipitation waters. Below 15 m a stagnant zone had developed. Gypsum (saturation index, SI similar to 0.25) and anglesite (SI similar to 0.1) were in equilibrium with lake water. Jarosite was oversaturated (SI similar to 1.7) in the upper part of the water column, resulting in downward settling and re-dissolution in the lower part of the water column (SI similar to -0.7). Accordingly, jarosite was only found in sediments from less than 7 m water depth. At the lake bottom, a layer of gel-like material (similar to 90 wt.% water) of pH similar to 1 with a total organic C content of up to 4.40 wet wt.% originated from the kerosene discharge of the Cu-extraction plant and had contaminant element concentrations similar to the lake water. Below the organic layer followed a layer of gypsum with pH 1.5, which overlaid the dissolving carbonate sediments of pH 5.3-7. In these two layers the contaminant elements were enriched compared to lake water in the sequence As < Pb approximate to Cu < Cd < Zn = Mn with increasing depth. This sequence of enrichment was explained by the following processes: (i) adsorption of As on Fe-hydroxides coating plant roots at low pH (up to 3326 mg/kg As), (ii) adsorption at increasing pH near the gypsum/calcite boundary (up to 1812 mg/kg Pb, 2531 mg/kg Cu. and 36 mg/kg Cd), and (iii) precipitation of carbonates (up to 5177 mg/kg Zn and 810 mg/kg Mn: all data corrected to a wet base). The infiltration rate was approximately equal to the discharge rate, thus gypsum and hydroxide precipitation had not resulted in complete clogging of the lake bedrocks. (C) 2010 Elsevier Ltd. All rights reserved.

Rapid profiling of intact glucosinolates in Arabidopsis leaves by UHPLC-QTOFMS using a charged surface hybrid column.

INTRODUCTION: The analysis of glucosinolates (GS) is traditionally performed by reverse-phase liquid chromatography coupled to ultraviolet detection after a time-consuming desulphation step, which is required for increased retention. Simpler and more efficient alternative methods that can shorten both sample preparation and analysis are much needed. OBJECTIVE: To evaluate the feasibility of using ultrahigh-pressure liquid chromatography coupled to quadrupole time-of-flight mass spectrometry (UHPLC-QTOFMS) for the rapid profiling of intact GS. METHODOLOGY: A simple and short extraction of GS from Arabidopsis thaliana leaves was developed. Four sub-2 µm reverse-phase columns were tested for the rapid separation of these polar compounds using formic acid as the chromatographic additive. High-resolution QTOFMS was used to detect and identify GS. RESULTS: A novel charged surface hybrid (CSH) column was found to provide excellent retention and separation of GS within a total running time of 11 min. Twenty-one GS could be identified based on their accurate mass as well as isotopic and fragmentation patterns. The method was applied to determine the changes in GS content that occur after herbivory in Arabidopsis. In addition, we evaluated its applicability to the profiling of other Brassicaceae species. CONCLUSION: The method developed can profile the full range of GS, including the most polar ones, in a shorter time than previous methods, and is highly compatible with mass spectrometric detection.

Estudi del comportament de materials nanoestructurats en el tractament d'aigües contaminades amb arsènic

El SPION (Super Paramagnetic Iron Oxide Nanoparticles) ha estat estudiat com un nou adsorbent per eliminar l’arsènic d’aigües contaminades. Les condicions òptimes de treball es van assolir per un pH de 3,6 i per concentracions inferiors als 100ppm. No es van trobar interferències significatives produïdes pels cations Cu, Ni i Zn en l’adsorció de l’As, sent el fosfat l’anió que més interfereix. Una esponja de cel·lulosa s’ha utilitzat com a suport del SPION, per disminuir les agregacions de les nanopartícules en suspensió i per proporcionar una material adequat per l’adsorció en continu, experiment amb columnes. Així, es va obtenir un augment de la capacitat d’adsorció del SPION per l’As(V), mentre que per l’As(III) continua sent baixa, per tant s’augmenta la selectivitat per l’As(V). Les interferències aniòniques afecten d’igual manera a l’adsorció de l’As(III) i l’As(V) quan l’adsorció és en continu o en discontinu. Els cations metàl·lics no interfereixen en l’adsorció de l’arsènic, a excepció del coure que és adsorbit i porta a la disminució de l’adsorció d’arsènic.

Arsenic(V) adsorption onto α-Al2O3 between 25 and 70°C

The adsorption of As(V) onto alpha -Al2O3 was investigated at 25, 50 and 70 degreesC using batch adsorption experiments. Results indicate that As is strongly adsorbed at low pH and gets progressively released to the fluid with increasing pH above 7. At any pH, increasing temperature favors aqueous species of As over surface species. Surface complexation constants were determined at the experimental temperatures by fitting the adsorption data. Adsorption reactions were then converted to semi-isocolumbic reactions, i.e, reactions with balanced like-charged aqueous species. Intrinsic adsorption constants of semi-isocolumbic reactions change linearly when plotted against inverse temperature, suggesting that the heat capacity of these reactions remains constant over the temperature range considered. This permitted thermodynamic parameters of intrinsic surface complexation constants to be determined. Changes in surface complexation constants result in a change in the surface speciation with increasing temperature. This change is similar to the one observed for aqueous species, i.e. increasing temperature favors less negatively charged species below a pH of 9 and more negatively charged species above a pH of 10. Comparison with the stability of As surface complexes with Fe suggests that surface complexes with Al are more stable. (C) 2001 Elsevier Science Ltd. All rights reserved.

Stratigraphic Column of Iowa, 2004

Stratigraphic Column of Iowa