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.

Pre-processing for noise detection in gene expression classification data

Due to the imprecise nature of biological experiments, biological data is often characterized by the presence of redundant and noisy data. This may be due to errors that occurred during data collection, such as contaminations in laboratorial samples. It is the case of gene expression data, where the equipments and tools currently used frequently produce noisy biological data. Machine Learning algorithms have been successfully used in gene expression data analysis. Although many Machine Learning algorithms can deal with noise, detecting and removing noisy instances from the training data set can help the induction of the target hypothesis. This paper evaluates the use of distance-based pre-processing techniques for noise detection in gene expression data classification problems. This evaluation analyzes the effectiveness of the techniques investigated in removing noisy data, measured by the accuracy obtained by different Machine Learning classifiers over the pre-processed data.

Spatial analysis of urban violence based on emergency room data

OBJECTIVE: To estimate the spatial intensity of urban violence events using wavelet-based methods and emergency room data. METHODS: Information on victims attended at the emergency room of a public hospital in the city of São Paulo, Southeastern Brazil, from January 1, 2002 to January 11, 2003 were obtained from hospital records. The spatial distribution of 3,540 events was recorded and a uniform random procedure was used to allocate records with incomplete addresses. Point processes and wavelet analysis technique were used to estimate the spatial intensity, defined as the expected number of events by unit area. RESULTS: Of all georeferenced points, 59% were accidents and 40% were assaults. There is a non-homogeneous spatial distribution of the events with high concentration in two districts and three large avenues in the southern area of the city of São Paulo. CONCLUSIONS: Hospital records combined with methodological tools to estimate intensity of events are useful to study urban violence. The wavelet analysis is useful in the computation of the expected number of events and their respective confidence bands for any sub-region and, consequently, in the specification of risk estimates that could be used in decision-making processes for public policies.

I2: uma molécula didática

Iodine vapor is a very suitable substance to learn about molecular energy levels and transitions, and to introduce spectroscopic techniques. As a diatomic molecule its spectra are relatively simple and allow straightforward treatment of the data leading to the potential energy curves and to quantum mechanics concepts. The overtone bands, in the resonance Raman scattering, and the band progressions, in the electronic spectra, play an important role in the calculation of the Morse potential curves for the fundamental and excited electronic state. A weaker chemical bond in the electronic excited state, compared to the fundamental state, is evidenced by the increase in the equilibrium interatomic distance. The resonance Raman scattering of I2 is highlighted due to its importance for obtaining the anharmonicity constant in the fundamental electronic state.

Electrochemical and photocatalytic reactions of polycyclic aromatic hydrocarbons investigated by raman spectroscopy

This paper presents the study of photochemical behavior of polycyclic aromatic hydrocarbons (PAHs), potential pollutants in secondary reactions in aerosols, through Raman spectroscopy compared with its electrochemical behavior. The PAHs studied include pyrene, anthracene, phenanthrene and fluorene. These were adsorbed onto TiO2 and irradiated with ultraviolet light (254 nm). Their electrochemical oxidation was studied by in situ Surface-enhanced Raman Scattering (SERS) and led to the formation of carbonyl-containing products. Oxidized intermediates bearing the C=O group were also formed during photodegradation. The joint analysis of the photodegradation data with those produced by electrochemical means - using spectroscopic techniques for the identification and characterization of the products - revealed the formation of identical products for anthracene, but not for pyrene. A reasonable explanation for this difference in results is that photochemical and electrochemical oxidation reactions proceed via different mechanisms. While photocatalytic degradation over TiO2 is initiated by hydroxyl radicals, electrochemical oxidation is initiated by the direct electron transfer from adsorbed PAH to the electrode, generating PAH cation radicals that undergo subsequent reactions.

New data on the natural history and description of the immatures of Fulgeochlizus bruchi, a bioluminescent beetle from Central Brazil (Elateridae, Pyrophorini)

The mature larva and pupa of Fulgeochlizus bruchi (Candèze, 1896) are described and illustrated. Bioluminescent patterns are also given. Comments, new data on the first instar larva and natural history data are presented. The first instar larvae differ from the mature larvae mainly in their chaetotaxy, which is sparse and more symmetrically distributed.

Calibration of the dietary data obtained from the Brazilian center of the Natural History of HPV Infection in Men study: the HIM Study

The objective of this study was to estimate the regressions calibration for the dietary data that were measured using the quantitative food frequency questionnaire (QFFQ) in the Natural History of HPV Infection in Men: the HIM Study in Brazil. A sample of 98 individuals from the HIM study answered one QFFQ and three 24-hour recalls (24HR) at interviews. The calibration was performed using linear regression analysis in which the 24HR was the dependent variable and the QFFQ was the independent variable. Age, body mass index, physical activity, income and schooling were used as adjustment variables in the models. The geometric means between the 24HR and the calibration-corrected QFFQ were statistically equal. The dispersion graphs between the instruments demonstrate increased correlation after making the correction, although there is greater dispersion of the points with worse explanatory power of the models. Identification of the regressions calibration for the dietary data of the HIM study will make it possible to estimate the effect of the diet on HPV infection, corrected for the measurement error of the QFFQ.

Discrepancies among ecological, household, and individual data on fruits and vegetables consumption in Brazil

Information on fruits and vegetables consumption in Brazil in the three levels of dietary data was analyzed and compared. Data about national supply came from Food Balance Sheets compiled by the FAO; household availability information was obtained from the Brazilian National Household Budget Survey (HBS); and actual intake information came from a large individual dietary intake survey that was representative of the adult population of São Paulo city. All sources of information were collected between 2002 and 2003. A subset of the HBS, representative of São Paulo city, was used in our analysis in order to improve the quality of the comparison with actual intake data. The ratio of national supply to household availability of fruits and vegetables was 2.6 while the ratio of national supply to actual intake was 4.0. The discrepancy ratio in the comparison between household availability and actual intake was smaller, 1.6. While the use of supply and availability data has advantages, as lower cost, must be taken into account that these sources tend to overestimate actual intake of fruits and vegetables.

Body Mass Index, Cigarette Smoking, and Alcohol Consumption and Cancers of the Oral Cavity, Pharynx, and Larynx: Modeling Odds Ratios in Pooled Case-Control Data

study-specific results, their findings should be interpreted with caution

Assessing influence in survival data with a cure fraction and covariates

Diagnostic methods have been an important tool in regression analysis to detect anomalies, such as departures from error assumptions and the presence of outliers and influential observations with the fitted models. Assuming censored data, we considered a classical analysis and Bayesian analysis assuming no informative priors for the parameters of the model with a cure fraction. A Bayesian approach was considered by using Markov Chain Monte Carlo Methods with Metropolis-Hasting algorithms steps to obtain the posterior summaries of interest. Some influence methods, such as the local influence, total local influence of an individual, local influence on predictions and generalized leverage were derived, analyzed and discussed in survival data with a cure fraction and covariates. The relevance of the approach was illustrated with a real data set, where it is shown that, by removing the most influential observations, the decision about which model best fits the data is changed.

Polyelectrolyte-protein complexation driven by charge regulation

The interplay between the biocolloidal characteristics (especially size and charge), pH, salt concentration and the thermal energy results in a unique collection of mesoscopic forces of importance to the molecular organization and function in biological systems. By means of Monte Carlo simulations and semi-quantitative analysis in terms of perturbation theory, we describe a general electrostatic mechanism that gives attraction at low electrolyte concentrations. This charge regulation mechanism due to titrating amino acid residues is discussed in a purely electrostatic framework. The complexation data reported here for interaction between a polyelectrolyte chain and the proteins albumin, goat and bovine alpha-lactalbumin, beta-lactoglobulin, insulin, k-casein, lysozyme and pectin methylesterase illustrate the importance of the charge regulation mechanism. Special attention is given to pH congruent to pI where ion-dipole and charge regulation interactions could overcome the repulsive ion-ion interaction. By means of protein mutations, we confirm the importance of the charge regulation mechanism, and quantify when the complexation is dominated either by charge regulation or by the ion-dipole term.

Electromagnetic energy within a magnetic infinite cylinder and scattering properties for oblique incidence

We analytically calculate the time-averaged electromagnetic energy stored inside a nondispersive magnetic isotropic cylinder that is obliquely irradiated by an electromagnetic plane wave. An expression for the optical-absorption efficiency in terms of the magnetic internal coefficients is also obtained. In the low absorption limit, we derive a relation between the normalized internal energy and the optical-absorption efficiency that is not affected by the magnetism and the incidence angle. This relation, indeed, seems to be independent of the shape of the scatterer. This universal aspect of the internal energy is connected to the transport velocity and consequently to the diffusion coefficient in the multiple scattering regime. Magnetism favors high internal energy for low size parameter cylinders, which leads to a low diffusion coefficient for electromagnetic propagation in 2D random media. (C) 2010 Optical Society of America

Data collapse, scaling functions, and analytical solutions of generalized growth models

We consider a nontrivial one-species population dynamics model with finite and infinite carrying capacities. Time-dependent intrinsic and extrinsic growth rates are considered in these models. Through the model per capita growth rate we obtain a heuristic general procedure to generate scaling functions to collapse data into a simple linear behavior even if an extrinsic growth rate is included. With this data collapse, all the models studied become independent from the parameters and initial condition. Analytical solutions are found when time-dependent coefficients are considered. These solutions allow us to perceive nontrivial transitions between species extinction and survival and to calculate the transition's critical exponents. Considering an extrinsic growth rate as a cancer treatment, we show that the relevant quantity depends not only on the intensity of the treatment, but also on when the cancerous cell growth is maximum.

Analysis of breast cancer by small angle X-ray scattering (SAXS)

Small angle X-ray scattering (SAXS) images of normal breast tissue and benign and malignant breast tumour tissues, fixed in formalin, were measured at the momentum transfer range of 0.063 nm(-1) <= q (=4 pi sin(theta/2)/lambda) <= 2.720 nm(-1). Four intrinsic parameters were extracted from the scattering profiles (1D SAXS image reduced) and, from the combination of these parameters, another three parameters were also created. All parameters, intrinsic and derived, were subject to discriminant analysis, and it was verified that parameters such as the area of diffuse scatter at the momentum transfer range 0.50 <= q <= 0.56 nm(-1), the ratio between areas of fifth-order axial and third-order lateral peaks and third-order axial spacing provide the most significant information for diagnosis (p < 0.001). Thus, in this work it was verified that by combining these three parameters it was possible to classify human breast tissues as normal, benign lesion or malignant lesion with a sensitivity of 83% and a specificity of 100%.

Identification of Neoplasias of Breast Tissues Using a Powder Diffractometer

An investigation was carried out to study the potential use of the angular distribution of scattered photons by human breast samples for a rapid identification of neoplasias of breast tissues. This technique has possible applications as diagnostic aid for breast cancer. In this work, a commercial powder diffractometer was used to obtain the scattering profiles from breast tissues histopathologically classified as normal breast tissues, fibroadenomas (benign breast diseases) and carcinomas (malignant breast diseases), in the interval 0.02 angstrom(-1) < x < 0.62 angstrom(-1). The experimental methods and data corrections are discussed in detail, and they included background subtraction, polarization, self-attenuation and geometric effects. The validation of the experimental procedure was achieved through an analysis of water sample. The results showed that the scattering profile is a unique impression of each type of tissue, being correlated with their microscopic morphological features. Multivariate analysis was applied to these profiles in order to verify if the information carried by these scattering profiles allow the differentiation between normal, benign and malignant breast tissues. The statistical analysis results showed that a correct identification of 75% of the analyzed samples is accomplished. The values of sensibility and specificity of this method in correctly differentiating between normal and neoplastic samples were 95.6% and 82.3%, respectively, while the values for differentiation between benign and malignant neoplasias were 78.6% and 62.5%. These initial results indicate the feasible use of commercial powder diffractometer to provide a rapid diagnostic with a high sensitivity.