The impact of spatial data redundancy on SOLAP query performance

Geographic Data Warehouses (GDW) are one of the main technologies used in decision-making processes and spatial analysis, and the literature proposes several conceptual and logical data models for GDW. However, little effort has been focused on studying how spatial data redundancy affects SOLAP (Spatial On-Line Analytical Processing) query performance over GDW. In this paper, we investigate this issue. Firstly, we compare redundant and non-redundant GDW schemas and conclude that redundancy is related to high performance losses. We also analyze the issue of indexing, aiming at improving SOLAP query performance on a redundant GDW. Comparisons of the SB-index approach, the star-join aided by R-tree and the star-join aided by GiST indicate that the SB-index significantly improves the elapsed time in query processing from 25% up to 99% with regard to SOLAP queries defined over the spatial predicates of intersection, enclosure and containment and applied to roll-up and drill-down operations. We also investigate the impact of the increase in data volume on the performance. The increase did not impair the performance of the SB-index, which highly improved the elapsed time in query processing. Performance tests also show that the SB-index is far more compact than the star-join, requiring only a small fraction of at most 0.20% of the volume. Moreover, we propose a specific enhancement of the SB-index to deal with spatial data redundancy. This enhancement improved performance from 80 to 91% for redundant GDW schemas.

The UV/H2O2 - photodegradation of poly(ethyleneglycol) and model compounds

The general mechanism for the photodegradation of polyethyleneglycol (PEG) by H2O2/UV was determined studying the photooxidation of small model molecules, like low molecular weight ethyleneglycols (tetra-, tri-, di-, and ethyleneglycol). After 30 min of irradiation the average molar mass (Mw) of the degradated PEG, analysed by GPC, fall to half of its initial value, with a concomitant increase in polydispersitivity and number of average chain scission (S), characterizing a random chain scission process yielding oligomers and smaller size ethyleneglycols. HPLC analysis of the photodegradation of the model ethyleneglycols proved that the oxidation mechanism involved consecutive reactions, where the larger ethyleneglycols gave rise, successively, to smaller ones. The photodegradation of ethyleneglycol lead to the formation of low molecular weight carboxylic acids, like glycolic, oxalic and formic acids.

Avaliação de solventes de extração por ultrassom usando-se cromatografia líquida de alta eficiência para a determinação de hidrocarbonetos policíclicos aromáticos em solos contaminados

A method using ultrasonication extraction for the determination of 17 polycyclic aromatic hydrocarbons (PAHs), selected by the USEPA and NIOSH as "consent decree" priority pollutants, in soil by High Performance Liquid Chromatography (HPLC) was studied. Separation and detection were completed in 20 min with a C18 columm, acetonitrile-water gradient elution and ultraviolet absorption and fluorescence detections. The detection limits, for a 10 µL of solution injection, were less than 9,917 ng/g in UV detection and less than 1,866 ng/g in fluorescence detection. Several organic solvents were tested for extraction of the 17 PAHs from soils. Acetone was the best solvent among the three solvents tested, and the order of the extraction efficiencies was: acetone>methanol>acetonitrile. Ultrasonication using acetone as solvent extraction was used to evaluate the biodegradation of those compounds in contaminated soil during a vermicomposting process.

Caracterização mecânica e térmica da borracha natural formulada e vulcanizada dos clones: GT 1, IAN 873, PB 235 e RRIM 600

Neste trabalho estudou-se o desempenho mecânico e térmico de compostos de borracha natural (Hevea brasiliensis) de 4 diferentes clones (GT 1, IAN 873, PB 235 e RRIM 600) cultivados no Estado de São Paulo, assim como de uma mistura destes clones e de uma borracha comercial, GEB-1. Estas borrachas foram formuladas e vulcanizadas com tempos de 5, 7 e 9 minutos. A caracterização foi realizada por calorimetria exploratória diferencial, termogravimetria, ensaios de resistência à tração, análise dinâmico-mecânica, medidas de dureza Shore A, microscopia eletrônica de varredura e espectroscopia na região do infravermelho. Os resultados permitiram concluir que o tempo de vulcanização e o tipo de clone não influenciaram na temperatura de transição vítrea (Tg) dos compostos. Os valores de Tg obtidos por DMA foram de cerca de -62 °C, e os resultados ensaios de dureza apresentaram valores próximos de 60 para todos os compostos estudados. Os ensaios de resistência à tração mostraram que o melhor desempenho mecânico foi obtido pelo clone RRIM 600. De acordo com os resultados obtidos neste trabalho, todos os clones atingiram as propriedades reportadas na literatura, podendo ser utilizados, em princípio, nas indústrias de artefatos de borracha separadamente ou na forma de mistura.

On-line identification of minor flavones from sugarcane juice by LC/UV/MS and post-column derivatization

This work describes the on-line characterization of minor flavones from sugarcane (Saccharum officinarum) juice by high-performance liquid chromatography coupled to diode array UV detection and mass spectrometry (LC/UV/MS) using atmospheric pressure chemical ionization-collision-induced dissociation (APCI-CID-MS/MS) and post-column derivatization using UV shift reagents. HPLC-UV analysis with shift reagents provided information about the substitution pattern in the flavonoid skeleton and, combined with MS data, these techniques allowed for the on-line identification of five "garapa" flavones: luteolin-8-C-glucosyl-7-O-glucuronide; tricin-7-O-neohesperoside-4'-O-rhamnoside; tricin-7-O-methylglucuronate-4'-O-rhamnoside; tricin-7-O-methylglucuronide; swertisin, while four other compounds were partially identified as glycosylflavones. Only swertisin (7-O-methylapigenin-6-C-glucoside) was reported previously in sugarcane molasses.

Eletroforese capilar acoplada à espectrometria de massas (CE-MS): vinte anos de desenvolvimento

CE-MS has been increasingly used for analysis of a vast array of compounds. This article reviews the different electrophoretic modes, interfaces and mass analyzers that are commonly used in the CE-MS coupling, as well as the technique advantages and performance characteristics. A large compilation of CE-MS applications is also presented. Therefore, this review is both a guide for beginners and a collection of key references for people who are familiar to the technique. Furthermore, this is the first CE-MS review published in a Brazilian journal and marks the installation of the first two commercial CE-MS units in Sao Paulo State.

Efficient synthesis of benzothiazine and acrylamide compounds

This article describes the synthesis of the new (2Z)-2-(4-methoxybenzylidene)-6-nitro-4H -benzo[1,4]thiazin-3-one, (2Z)-2-(4-methoxybenzylidene)-4-methyl-6-nitro-4H-benzo[1,4]thiazin-3-one, (2Z)-6-amino-2-(4-methoxybenzylidene)-4H -benzo[1,4]thiazin-3-one, (2Z)-6-butylamino-2-(4-methoxybenzylidene)-4-methyl-4H-benzo[1,4]-thiazin-3-one and (2E)-N-alkyl-N-(2-hydroxy-5-nitrophenyl)-3-phenylacrylamides and the spectroscopic data. The arylidenebenzothiazine compounds were prepared using the Knoevenagel condensation with substituted benzaldehydes in the presence of sodium methoxide in DMF. The presence of a nitro substituent in the 4-position, water and a slightly acid reaction medium in this condensation caused the rupture of the benzothiazine ring and subsequent formation of the phenylacrylamide compounds. A crystallographic data was presented for (2E)-3-(4-bromophenyl)-N-dodecyl-N -(2-hydroxy-5-nitrophenyl) acrylamide.

Development of a flow through photo-reactor to study degradation of organic compounds by Sequential Injection Analysis (SIA)

This work describes a photo-reactor to perform in line degradation of organic compounds by photo-Fenton reaction using Sequential Injection Analysis (SIA) system. A copper phthalocyanine-3,4',4²,4²¢-tetrasulfonic acid tetrasodium salt dye solution was used as a model compound for the phthalocyanine family, whose pigments have a large use in automotive coatings industry. Based on preliminary tests, 97% of color removal was obtained from a solution containing 20 µmol L-1 of this dye.

Nanochromics: old materials, new structures and architectures for high performance devices

Due to the development of nanoscience, the interest in electrochromism has increased and new assemblies of electrochromic materials at nanoscale leading to higher efficiencies and chromatic contrasts, low switching times and the possibility of color tuning have been developed. These advantages are reached due to the extensive surface area found in nanomaterials and the large amount of organic electrochromic molecules that can be easily attached onto inorganic nanoparticles, as TiO2 or SiO2. Moreover, the direct contact between electrolyte and nanomaterials produces high ionic transfer rates, leading to fast charge compensation, which is essential for high performance electrochromic electrodes. Recently, the layer-by-layer technique was presented as an interesting way to produce different architectures by the combination of both electrochromic nanoparticles and polymers. The present paper shows some of the newest insights into nanochromic science.

Nursery performance of the pink shrimp Farfantepenaeus paulensis (Crustacea: Decapoda: Penaeidae) postlarvae in different salinities

Nursery performance, development, and RNA:DNA ratio were investigated in Farfantepenaeus paulensis (Pérez-Farfante, 1967) postlarvae acclimated from a salinity of 30‰ to higher (35‰) or lower (16, 22 and 29‰) salinities and reared for 20 days. Overall, higher final weight, yield and growth rate were observed at a salinity of 29‰. RNA:DNA ratio indicated reduced growth potential at a salinity of 35‰. Low salinities resulted in more developed individuals. Thus, early postlarval F. paulensis should not be stocked in salinities higher than that of the original hatchery, otherwise in lower salinities postlarvae should be older and/or have an extended nursery phase. Results may assist in the development of nursery rearing protocols for F. paulensis, an alternative species for aquaculture in subtropical areas.

Índice h de docentes em Saúde Coletiva no Brasil

OBJETIVO: Estimar valores de referência e função de hierarquia de docentes em Saúde Coletiva do Brasil por meio de análise da distribuição do índice h. MÉTODOS: A partir do portal da Coordenação de Aperfeiçoamento de Pessoal de Nível Superior, 934 docentes foram identificados em 2008, dos quais 819 foram analisados. O índice h de cada docente foi obtido na Web of Science mediante algoritmos de busca com controle para homonímias e alternativas de grafia de nome. Para cada região e para o Brasil como um todo ajustou-se função densidade de probabilidade exponencial aos parâmetros média e taxa de decréscimo por região. Foram identificadas medidas de posição e, com o complemento da função probabilidade acumulada, função de hierarquia entre autores conforme o índice h por região. RESULTADOS: Dos docentes, 29,8% não tinham qualquer registro de citação (h = 0). A média de h para o País foi 3,1, com maior média na região Sul (4,7). A mediana de h para o País foi 2,1, também com maior mediana na Sul (3,2). Para uma padronização de população de autores em cem, os primeiros colocados para o País devem ter h = 16; na estratificação por região, a primeira posição demanda valores mais altos no Nordeste, Sudeste e Sul, sendo nesta última h = 24. CONCLUSÕES: Avaliados pelos índices h da Web of Science, a maioria dos autores em Saúde Coletiva não supera h = 5. Há diferenças entres as regiões, com melhor desempenho para a Sul e valores semelhantes entre Sudeste e Nordeste.

Volatile compounds in the thermoplastic extrusion of bovine rumen

The volatile compounds of raw and extruded bovine rumen, extracted by dynamic headspace, were separated by gas chromatography and analyzed by GC-MS. Raw and extruded materials presented thirty-two volatile compounds. The following compounds were identified in raw bovine rumen: heptane, 1-heptene, 4-methyl-2-pentanone, toluene, hexanal, ethyl butyrate, o-xylene, m-xylene, p-xylene, heptanal, limonene, nonanal, dodecane, tridecane, tetradecane, pentadecane, hexadecane, heptadecane and octadecane. The following compounds were identified in the extruded material: 1-heptene, 2,4-dimethylhexane, toluene, limonene, undecane, tetradecane, pentadecane, hexadecane, heptadecane, octadecane and nonadecane. Mass spectra of some unidentified compounds indicated the presence of hydrocarbons with branched chains or cyclic structure.

Performance of transport and selective media for swine Bordetella bronchiseptica recovery and it comparison to polymerase chain reaction detection

Three comparative assays were performed seeking to improve the sensitivity of the diagnosis of Bordetella bronchiseptica infection analyzing swine nasal swabs. An initial assay compared the recovery of B. bronchiseptica from swabs simultaneously inoculated with B. bronchiseptica and some interfering bacteria, immersed into three transport formulations (Amies with charcoal, trypticase soy broth and phosphate buffer according to Soerensen supplemented with 5% of bovine fetal serum) and submitted to different temperatures (10ºC and 27ºC) and periods of incubation (24, 72 and 120 hours). A subsequent assay compared three selective media (MacConkey agar, modified selective medium G20G and a ceftiofur medium) for their recovery capabilities from clinical specimens. One last assay compared the polymerase chain reaction to the three selective media. In the first assay, the recovery of B. bronchiseptica from transport systems was better at 27ºC and the three formulations had good performances at this temperature, but the collection of qualitative and quantitative analysis indicated the advantage of Amies medium for nasal swabs transportation. The second assay indicated that MacConkey agar and modified G20G had similar results and were superior to the ceftiofur medium. In the final assay, polymerase chain reaction presented superior capability of B. bronchiseptica detection to culture procedures.

Productive performance and milk protein fraction composition of dairy cows supplemented with sodium monensin

The objective of this work was to evaluate the levels of sodium monensin on lactating cows and their effects on productive performance and milk protein fraction composition. It was used 12 Holstein cows, distributed in four balanced 3 × 3 Latin squares, and fed three diets: one control without monensin, and two diets with monensin at the levels of 24 or 48 mg/kg DM added to the concentrate. Milk production was daily measured throughout the entire experimental period. The samples used for analysis of milk composition were collected on two alternated days from the two daily milking. Non-protein nitrogen, total nitrogen and non-casein nitrogen contents were directly evaluated in the milk, and casein, whey protein and true protein contents were indirectly determined. The use of monensin in the rations reduced dry matter and nutrient intake, especially when diet with 48 mg/kg of dry matter was given. The ration with 24 mg/kg of DM increased milk production, with or without correction, and also fat and lactose yield, and it improved productive efficiency. The levels of monensin in the ratios did not influence contents of milk crude protein, non-protein nitrogen, non-casein nitrogen, true protein, casein, casein/true protein ratio, whey protein, and of all those fractions expressed as percentage of crude protein. The utilization of monensin in the ratio at the dose of 24 mg/kg of DM influences positively the productive performance of lactating cows, and it does not influence the composition of milk protein fractions.

Energy and amino acid content in phase 1 nursery diet: piglet performance and body chemical composition

It was evaluated the effects of metabolizable energy (ME) and digestible lysine (dLYS) densities on performance and body composition of weaned piglets. The study used 114 piglets weaned at 7.4 ± 0.80 kg, out of which 108 were allotted in the nursery and 6 were slaughtered on the weaning day to determine comparative data of body chemical composition. Six nutrients densities were stipulated from a previous study based on the highest nitrogen retention, maintaining the following ME:LYS relationship in the experimental diets: 3,390:1.291; 3,450:1.409; 3,650:1.411; 3,780:1.461; 3,940:1.507; and 4,109 kcal/kg ME:1.564% dLYS. The experimental diets were offered for 13 days when the piglets reached 12.986 ± 1.449 kg of body weight. The probable residual effects of nutritional density on the subsequent performance of the piglets were evaluated. At the end of initial phase 1, six piglets from each density were slaughtered to determine their chemical composition in body fractions and empty body. There was no significant influence of nutritional levels on the performance of the piglets at the end of the evaluation. The results of food conversion and body composition confirm the level indicated in the previous study, 4 g dLYS/Mcal of ME. The increase of energy and lysine densities confirms the need for a correct relationship among both of them to assure better performance of the piglets at the beginning of the growing phase.