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.

Relating MODIS vegetation index time-series with structure, light absorption and stem production of fast-growing Eucalyptus plantations

By allowing the estimation of forest structural and biophysical characteristics at different temporal and spatial scales, remote sensing may contribute to our understanding and monitoring of planted forests. Here, we studied 9-year time-series of the Normalized Difference Vegetation Index (NDVI) from the Moderate Resolution Imaging Spectroradiometer (MODIS) on a network of 16 stands in fast-growing Eucalyptus plantations in Sao Paulo State, Brazil. We aimed to examine the relationships between NDVI time-series spanning entire rotations and stand structural characteristics (volume, dominant height, mean annual increment) in these simple forest ecosystems. Our second objective was to examine spatial and temporal variations of light use efficiency for wood production, by comparing time-series of Absorbed Photosynthetically Active Radiation (APAR) with inventory data. Relationships were calibrated between the NDVI and the fractions of intercepted diffuse and direct radiation, using hemispherical photographs taken on the studied stands at two seasons. APAR was calculated from the NDVI time-series using these relationships. Stem volume and dominant height were strongly correlated with summed NDVI values between planting date and inventory date. Stand productivity was correlated with mean NDVI values. APAR during the first 2 years of growth was variable between stands and was well correlated with stem wood production (r(2) = 0.78). In contrast, APAR during the following years was less variable and not significantly correlated with stem biomass increments. Production of wood per unit of absorbed light varied with stand age and with site index. In our study, a better site index was accompanied both by increased APAR during the first 2 years of growth and by higher light use efficiency for stem wood production during the whole rotation. Implications for simple process-based modelling are discussed. (C) 2009 Elsevier B.V. All rights reserved.

VEGETABLE OIL STRUCTURE AND ANTIOXIDANTS

Five vegetable oils: canola, soybean, corn, cottonseed and sunflower oils were characterized with respect to their composition by gas chromatography and viscosity. The compositions of the vegetable oils suggest that they exhibit substantially different propensity for oxidation following the order of: canola < corn < cottonseed < sunflower approximate to soybean. Viscosities at 40 degrees C and 100 degrees C and the viscosity index (VI) values were determined for the vegetable oils and two petroleum oil quenchants: Microtemp 157 (a conventional slow oil) and Microtemp 153B (an accelerated or fast oil). The kinematic viscosities of the different vegetable and petroleum oils at 40 degrees C were similar. The VI values for the different vegetable oils were very close and varied between 209-220 and were all much higher than the VI values obtained for Microtemp 157 (96) and Microtemp 153B (121). These data indicate that the viscosity variations of these vegetable oils are substantially less sensitive to temperature variation than are the parafinic oil based Microtemp 157 and Microtemp 153B. Although these data suggest that any of the vegetable oils evaluated could be blended with minimal impact on viscosity, the oxidative stability would surely be substantially impacted. Cooling curve analysis was performed on these vegetable oils at 60 degrees C under non-agitated conditions. These results were compared with cooling curves obtained for Microtemp 157, a conventional, unaccelerated petroleum oil, and Microtemp 153B, an accelerated petroleum oil under the same conditions. The results showed that cooling profiles of the different vegetable oils were similar as expected from the VI values. However, no boiling was observed wit any of the vegetable oils and heat transfer occurs only by convection since there is no full-film boiling and nucleate boiling process as typically observed for petroleum oil quenchants, including those of this study. Therefore, high-temperature cooling is considerable faster for vegetable oils as a class. The cooling properties obtained suggest that vegetable oils would be especially suitable fur quenching low-hardenability steels such as carbon steels.

Spatial genetic structure of Hymenaea stigonocarpa Mart. ex Hayne assessed with chloroplast microsatellite markers

The use of chloroplast DNA markers (cpDNA) helps to elucidate questions related to ecology, evolution and genetic structure. The knowledge of inter-and intra-population genetic structure allows to design effective conservation and management strategies for tropical tree species. With the aim to help the conservation of Hymenaea stigonocarpa of the Cerrado (Brazilian savanna) in Sao Paulo State, an analysis of the spatial genetic structure (SGS) was conducted in two populations using five universal chloroplast microsatellite loci (cpSSR). The population of 68 trees of H. stigonocarpa in the Ecological Station of Itirapina (ESI) had a single haplotype, indicating a strong founder effect. In turn, the population of 47 trees of H. stigonocarpa in a contiguous area that includes the Ecological Station of Assis and the Assis State Forest (ESA), showed six haplotypes ((n) over cap (h) = 6) with a moderate haplotype diversity ((h) over cap = 0667 + 0094), revealing that it was founded by a small number of maternal lineages. The SGS analysis for the population ESA/ASF, using Moran`s I index, indicated limited seed dispersal. Considering SGS, for ex situ conservation strategies in the population ESA/ASF, seed harvesting should require a minimum distance of 750 m among seed-trees.

Structure activity relationship, acute toxicity and cytotoxicity of antimycobacterial neolignan analogues

Objectives The study`s aims were to evaluate the antimycobacterial activity of 13 synthetic neolignan analogues and to perform structure activity relationship analysis (SAR). The cytotoxicity of the compound 2-phenoxy-1-phenylethanone (LS-2, 1) in mammalian cells, such as the acute toxicity in mice, was also evaluated. Methods The extra and intracellular antimycobacterial activity was evaluated on Mycobacterium tuberculosis H37Rv. Cytotoxicity studies were performed using V79 cells, J774 macrophages and rat hepatocytes. Additionally, the in-vivo acute toxicity was tested in mice. The SAR analysis was performed by Principal Component Analysis (PCA). Key findings Among the 13 analogues tested, LS-2 (1) was the most effective, showing promising antimycobacterial activity and very low cytotoxicity in V79 cells and in J774 macrophages, while no toxicity was observed in rat hepatocytes. The selectivity index (SI) of LS-2 (1) was 91 and the calculated LD50 was 1870 mg/kg, highlighting the very low toxicity in mice. SAR analysis showed that the highest electrophilicity and the lowest molar volume are physical-chemical characteristics important for the antimycobacterial activity of the LS-2 (1). Conclusions LS-2 (1) showed promising antimycobacterial activity and very weak cytotoxicity in cell culture, as well as an absence of toxicity in primary culture of hepatocytes. In the acute toxicity study there was an indication of absence of toxicity on murine models, in vivo.

Psychometric qualities of the Brazilian versions of the Fagerstrom Test for Nicotine Dependence and the Heaviness of Smoking Index

This study examined the psychometric properties of the Brazilian versions of the Fagerstrom Test for Nicotine Dependence (FTND) and the Heaviness of Smoking Index (HSI). The test-retest reliability of the FTND was assessed in a sample of 61 smoking university students, with a 15-day interval between assessments. The interrater reliability was examined in 30 smoking patients of a psychosocial care center for alcohol and drug users (PCC-AD). The reliability coefficient was estimated by the kappa and intraclass correlation coefficients. The predictive validity, internal consistency, and factor structure of the FTND and the HSI were evaluated by factor analysis in 271 smokers treated at an emergency unit and at the PCC-AD. The gold standard was the nicotine dependence criteria of DSM-IV, as assessed by the Structured Clinical Interview for DSM-IV. The FTND showed high reliability, with correlation coefficients of .92 for test-retest reliability and .99 for interrater reliability. Both the FTND and the HSI presented high levels of sensitivity and specificity. The internal consistency evaluation yielded a Cronbach`s alpha coefficient of .83 for the FTND and of .56 for the HSI. An exploratory factor analysis found 2 factors in the FTND, which were validated by a confirmatory factor analysis. The results obtained in this study confirm the validity and reliability of the Brazilian versions of the FTND and the HSI.

Effects of processing methods on amaranth starch digestibility and predicted glycemic index

Amaranth has attracted a great deal of interest in recent decades due to its valuable nutritional, functional, and agricultural characteristics. Amaranth seeds can be cooked, popped, roasted, flaked, or extruded for consumption. This study compared the in vitro starch digestibility of processed amaranth seeds to that of white bread. Raw seeds yielded rapidly digestible starch content (RDS) of 30.7% db and predicted glycemic index (pGI) of 87.2, the lowest among the studied products. Cooked, extruded, and popped amaranth seeds had starch digestibility similar to that of white bread (92.4, 91.2, and 101.3, respectively), while flaked and roasted seeds generated a slightly increased glycemic response (106.0 and 105.8, respectively). Cooking and extrusion did not alter the RDS contents of the seeds. No significant differences were observed among popped, flaked, and roasted RDS contents (38.0%,46.3%, and 42.9%, respectively), which were all lower than RDS content of bread (51.1%). Amaranth seed is a high glycemic food most likely because of its small starch granule size, low resistant starch content (< 1%), and tendency to completely lose its crystalline and granular starch structure during those heat treatments.

An improved estimate of leaf area index based on the histogram analysis of hemispherical photographs

Leaf area index (LAI) is a key parameter that affects the surface fluxes of energy, mass, and momentum over vegetated lands, but observational measurements are scarce, especially in remote areas with complex canopy structure. In this paper we present an indirect method to calculate the LAI based on the analyses of histograms of hemispherical photographs. The optimal threshold value (OTV), the gray-level required to separate the background (sky) and the foreground (leaves), was analytically calculated using the entropy crossover method (Sahoo, P.K., Slaaf, D.W., Albert, T.A., 1997. Threshold selection using a minimal histogram entropy difference. Optical Engineering 36(7) 1976-1981). The OTV was used to calculate the LAI using the well-known gap fraction method. This methodology was tested in two different ecosystems, including Amazon forest and pasturelands in Brazil. In general, the error between observed and calculated LAI was similar to 6%. The methodology presented is suitable for the calculation of LAI since it is responsive to sky conditions, automatic, easy to implement, faster than commercially available software, and requires less data storage. (C) 2008 Elsevier B.V. All rights reserved.

Comparing species and measures of landscape structure as indicators of conservation importance

P>1. The use of indicators to identify areas of conservation importance has been challenged on several grounds, but nonetheless retains appeal as no more parsimonious approach exists. Among the many variants, two indicator strategies stand out: the use of indicator species and the use of metrics of landscape structure. While the first has been thoroughly studied, the same cannot be said about the latter. We aimed to contrast the relative efficacy of species-based and landscape-based indicators by: (i) comparing their ability to reflect changes in community integrity at regional and landscape spatial scales, (ii) assessing their sensitivity to changes in data resolution, and (iii) quantifying the degree to which indicators that are generated in one landscape or at one spatial scale can be transferred to additional landscapes or scales. 2. We used data from more than 7000 bird captures in 65 sites from six 10 000-ha landscapes with different proportions of forest cover in the Atlantic Forest of Brazil. Indicator species and landscape-based indicators were tested in terms of how effective they were in reflecting changes in community integrity, defined as deviations in bird community composition from control areas. 3. At the regional scale, indicator species provided more robust depictions of community integrity than landscape-based indicators. At the landscape scale, however, landscape-based indicators performed more effectively, more consistently and were also more transferable among landscapes. The effectiveness of high resolution landscape-based indicators was reduced by just 12% when these were used to explain patterns of community integrity in independent data sets. By contrast, the effectiveness of species-based indicators was reduced by 33%. 4. Synthesis and applications. The use of indicator species proved to be effective; however their results were variable and sensitive to changes in scale and resolution, and their application requires extensive and time-consuming field work. Landscape-based indicators were not only effective but were also much less context-dependent. The use of landscape-based indicators may allow the rapid identification of priority areas for conservation and restoration, and indicate which restoration strategies should be pursued, using remotely sensed imagery. We suggest that landscape-based indicators might often be a better, simpler, and cheaper strategy for informing decisions in conservation.

A further exploration of a nucleophilicity index based on the gas-phase ionization potentials

An empirical nucleophilicity index based on the gas-phase ionization potentials has been recently shown to be useful categorizing and settling the nucleophilicity power of a series of captodative ethylenes reacting in cycloaddition reactions (L.R. Domingo, E. Chamorro, P. Perez, Journal of Organic Chemistry 73 (2008) 4615-4624). In the present work, the applicability of such model is tested within a broader series of substituted alkenes, substituted aromatic compounds and simple nucleophilic molecules. This index obtained within a Koopman`s theorem framework has been evaluated here in both gas and solution phases for several well-known nucleophiles. These results are found to be linearly correlated. Finally, the feasibility of the predictive character of this index has been discussed in comparison to the available experimental nucleophilicities of some amines in water. These results further support and validate the usefulness of such approximation in the modeling of the global nucleophilicity. (C) 2008 Elsevier B.V. All rights reserved.

Evaluation of the dental structure loss produced during maintenance and replacement of occlusal amalgam restorations

The aim of this in vitro study was to evaluate four different approaches to the decision of changing or not defective amalgam restorations in first primary molar teeth concerning the loss of dental structure. Ditched amalgam restorations (n = 11) were submitted to four different treatments, as follows: Control group - polishing and finishing of the restorations were carried out; Amalgam group - the ditched amalgam restorations were replaced by new amalgam restorations; Composite resin group - the initial amalgam restorations were replaced by composite resin restorations; Flowable resin group - the ditching around the amalgam restorations was filled with flowable resin. Images of the sectioned teeth were made and the area of the cavities before and after the procedures was determined by image analysis software to assess structural loss. The data were submitted to ANOVA complemented by the Student Newman Keuls test (p < 0.05). The cavities in all the groups presented significantly greater areas after the procedures. However, the amalgam group showed more substantial dental loss. The other three groups presented no statistically significant difference in dental structure loss after the re-treatments. Thus, replacing ditched amalgam restorations by other similar restorations resulted in a significant dental structure loss while maintaining them or replacing them by resin restorations did not result in significant loss.

Fitossociologia de um Cerrado denso em área de influência de torre de fluxo de carbono, Pé-de-Gigante, Parque Estadual de Vassununga, SP

O domínio do Cerrado compreende uma área contínua nos estados centrais do Brasil e áreas disjuntas em outros estados, incluindo São Paulo. Essa vegetação ocupava originalmente 21% do território brasileiro, restando atualmente apenas 21,6% de sua extensão original. A área recoberta por essa vegetação em São Paulo cobria 14% de sua área total e seus remanescentes recobrem menos de 1% da ocorrência original dessa vegetação. Estudos recentes indicam que o valor da produtividade líquida no Cerrado Pé-de-Gigante (SP) constitui um pequeno dreno de carbono e indicou que a sazonalidade foi o fator determinante do valor observado. Os estudos dos fluxos de carbono em ecossistemas terrestres são raramente acompanhados de abordagens ecofisiológicas de modo a explorar a relação funcional das espécies que compõem o ecossistema e os valores líquidos obtidos para o mesmo. Assim, o objetivo deste trabalho foi caracterizar estruturalmente a vegetação presente na área de maior influência da torre de fluxo instalada no Cerrado Pé-de-Gigante, visando possibilitar estudos relacionados à quantificação em longo prazo da dinâmica dos fluxos de água, energia e CO2 na vegetação de Cerrado. Para isso foram levantadas 20 parcelas (10 x 10 m) em 0,2 ha de Cerrado, e amostraram-se todas as plantas com perímetro ao nível do solo >6 cm (exceto lianas e árvores mortas). A distribuição das classes de diâmetro e estrutura vertical, assim como os parâmetros fitossociológicos foram analisados. Encontramos 1451 indivíduos, distribuídos em 85 espécies, 52 gêneros e 31 famílias. A densidade absoluta e área basal foram de 7255 ind. ha-1 e de 7,9 m².ha-1, respectivamente. A família Leguminosae apresentou o maior número de espécies (13). O Índice de diversidade de Shannon (H') foi 3,27 nats.ind-1. A distribuição em classes de diâmetro mostrou uma curva de "J" invertido, estando a maioria dos indivíduos na primeira classe. Concluímos que a área deve ser classificada como Cerrado denso, devido principalmente à dominância pela espécie arbórea Anadenanthera falcata, cuja ocorrência no estado foi relatada apenas em locais com solos ricos em saturação de bases na região das Cuestas Basálticas, devido também à maior área basal dos indivíduos, comparando com outros fragmentos de Cerrado. Além da espécie citada, Myrcia lingua e Xylopia aromatica, apresentaram os maiores IVI (Valor de importância).

Association of polymorphisms at the ADIPOR1 regulatory region with type 2 diabetes and body mass index in a Brazilian population with European or African ancestry

Association studies between ADIPOR1 genetic variants and predisposition to type 2 diabetes (DM2) have provided contradictory results. We determined if two single nucleotide polymorphisms (SNP c.-8503G>A and SNP c.10225C>G) in regulatory regions of ADIPOR1 in 567 Brazilian individuals of European (EA; N = 443) or African (AfA; N = 124) ancestry from rural (quilombo remnants; N = 439) and urban (N = 567) areas. We detected a significant effect of ethnicity on the distribution of the allelic frequencies of both SNPs in these populations (EA: -8503A = 0.27; AfA: -8503A = 0.16; P = 0.001 and EA: 10225G = 0.35; AfA: 10225G = 0.51; P < 0.001). Neither of the polymorphisms were associated with DM2 in the case-control study in EA (SNP c.-8503G>A: DM2 group -8503A = 0.26; control group -8503A = 0.30; P = 0.14/SNP 10225C>G: DM2 group 10225G = 0.37; control group 10225G = 0.32; P = 0.40) and AfA populations (SNP c.-8503G>A: DM2 group -8503A = 0.16; control group -8503A = 0.15; P = 0.34/SNP 10225C>G: DM2 group 10225G = 0.51; control group 10225G = 0.52; P = 0.50). Similarly, none of the polymorphisms were associated with metabolic/anthropometric risk factors for DM2 in any of the three populations, except for HDL cholesterol, which was significantly higher in AfA heterozygotes (GC = 53.75 ± 17.26 mg/dL) than in homozygotes. We conclude that ADIPOR1 polymorphisms are unlikely to be major risk factors for DM2 or for metabolic/anthropometric measurements that represent risk factors for DM2 in populations of European and African ancestries.

Estudos de relações estrutura-atividade quantitativas (QSAR) de bis-benzamidinas com atividade antifúngica

This paper describes 2D-QSAR and 3D-QSAR studies against Candida albicans and Cryptococcus neofarmans for a set of 20 bisbenzamidines. In the studies of 2D-QSAR with C. albicans it was obtained a correlation between log MIC-1 and lipolo component-Z (r² = 0.68; Q² = 0.51). In the case of C. neofarmans a correlation between log MIC-1 and lipolo component-Z and of Balaban index (r² = 0.85; Q² = 0.6) was obtained. 3D-QSAR studies using CoMFA showed that the steric fields contributed more to the predicted activities for Candida albicans (94.9%) and Cryptococcus neofarmans (97.9%).

Benthic macrofauna structure in the northeast area of Todos os Santos Bay, Bahia State, Brazil: patterns of spatial and seasonal distribution

Structure of intertidal and subtidal benthic macrofauna in the northeastern region of Todos os Santos Bay (TSB), northeast Brazil, was investigated during a period of two years. Relationships with environmental parameters were studied through uni-and multivariate statistical analyses, and the main distributional patterns shown to be especially related to sediment type and content of organic fractions (Carbon, Nitrogen, Phosphorus), on both temporal and spatial scales. Polychaete annelids accounted for more than 70% of the total fauna and showed low densities, species richness and diversity, except for the area situated on the reef banks. These banks constitute a peculiar environment in relation to the rest of the region by having coarse sediments poor in organic matter and rich in biodetritic carbonates besides an abundant and diverse fauna. The intertidal region and the shallower area nearer to the oil refinery RLAM, with sediments composed mainly of fine sand, seem to constitute an unstable system with few highly dominant species, such as Armandia polyophthalma and Laeonereis acuta. In the other regions of TSB, where muddy bottoms predominated, densities and diversity were low, especially in the stations near the refinery. Here the lowest values of the biological indicators occurred together with the highest organic compound content. In addition, the nearest sites (stations 4 and 7) were sometimes azoic. The adjacent Caboto, considered as a control area at first, presented low density but intermediate values of species diversity, which indicates a less disturbed environment in relation to the pelitic infralittoral in front of the refinery. The results of the ordination analyses evidenced five homogeneous groups of stations (intertidal; reef banks; pelitic infralittoral; mixed sediments; Caboto) with different specific patterns, a fact which seems to be mainly related to granulometry and chemical sediment characteristics.