Seamlessly integrating similarity queries in SQL

Modern database applications are increasingly employing database management systems (DBMS) to store multimedia and other complex data. To adequately support the queries required to retrieve these kinds of data, the DBMS need to answer similarity queries. However, the standard structured query language (SQL) does not provide effective support for such queries. This paper proposes an extension to SQL that seamlessly integrates syntactical constructions to express similarity predicates to the existing SQL syntax and describes the implementation of a similarity retrieval engine that allows posing similarity queries using the language extension in a relational DBM. The engine allows the evaluation of every aspect of the proposed extension, including the data definition language and data manipulation language statements, and employs metric access methods to accelerate the queries. Copyright (c) 2008 John Wiley & Sons, Ltd.

Caracterização do jogo simbólico em deficientes auditivos: estudo de casos e controles

TEMA: crianças deficientes auditivas não adquirem linguagem no mesmo período e velocidade de uma criança normo-ouvinte, pois o aprendizado da linguagem oral é um evento essencialmente auditivo. O desenvolvimento da criança consiste na aquisição progressiva de habilidades motoras e psicocognitivas, e a entrada no mundo simbólico é fator preponderante para que a criança possa atingir os níveis de maior complexidade no domínio da linguagem. OBJETIVO: relacionar o jogo simbólico e aspectos do desenvolvimento infantil em crianças deficientes auditivas com seus pares ouvintes. MÉTODO: 32 crianças, de ambos os sexos, de 2 a 6 anos de idade, pareadas por idade, foram submetidas à Avaliação da Maturidade Simbólica e ao Teste de Triagem do Desenvolvimento de Denver II, sendo 16 deficientes auditivas neurossensorial de grau moderado a profundo (grupo pesquisa - GP) e 16 normo-ouvintes (grupo controle - GC). RESULTADOS: observou-se simbolismo na brincadeira de 81,25% do GP, enquanto que no GC isto ocorreu em 87,5%. No Teste de Denver II 100% do GP foi classificado como risco, e o GC apresentou 94% de crianças normais e 6% de risco (p < 0,001). CONCLUSÃO: observou-se desempenho semelhante nos dois grupos quanto ao jogo simbólico. Entretanto, numa análise qualitativa, o GP apresentou brincadeiras menos complexas que o GC. Observou-se que o GP apresentou desempenho no jogo simbólico compatível ao seu desempenho nos aspectos pessoal-social, motor fino-adaptativo e motor grosseiro do Teste de Denver II.

Effects of the condylar process fracture on facial symmetry in rats submitted to protein undernutrition

PURPOSE: To investigate the facial symmetry of rats submitted to experimental mandibular condyle fracture and with protein undernutrition (8% of protein) by means of cephalometric measurements. METHODS: Forty-five adult Wistar rats were distributed in three groups: fracture group, submitted to condylar fracture with no changes in diet; undernourished fracture group, submitted to hypoproteic diet and condylar fracture; undernourished group, kept until the end of experiment, without condylar fracture. Displaced fractures of the right condyle were induced under general anesthesia. The specimens were submitted to axial radiographic incidence, and cephalometric mensurations were made using a computer system. The values obtained were subjected to statistical analyses among the groups and between the sides in each group. RESULTS: There was significative decrease of the values of serum proteins and albumin in the undernourished fracture group. There was deviation of the median line of the mandible relative to the median line of the maxilla, significative to undernutrition fracture group, as well as asymmetry of the maxilla and mandible, in special in the final period of experiment. CONCLUSION: The mandibular condyle fracture in rats with proteic undernutrition induced an asymmetry of the mandible, also leading to consequences in the maxilla.

Influence of specimens' design and manufacturing process on microtensile bond strength to enamel: laboratory and FEA comparison

This study evaluated the effect of specimens' design and manufacturing process on microtensile bond strength, internal stress distributions (Finite Element Analysis - FEA) and specimens' integrity by means of Scanning Electron Microscopy (SEM) and Laser Scanning Confocal Microscopy (LCM). Excite was applied to flat enamel surface and a resin composite build-ups were made incrementally with 1-mm increments of Tetric Ceram. Teeth were cut using a diamond disc or a diamond wire, obtaining 0.8 mm² stick-shaped specimens, or were shaped with a Micro Specimen Former, obtaining dumbbell-shaped specimens (n = 10). Samples were randomly selected for SEM and LCM analysis. Remaining samples underwent microtensile test, and results were analyzed with ANOVA and Tukey test. FEA dumbbell-shaped model resulted in a more homogeneous stress distribution. Nonetheless, they failed under lower bond strengths (21.83 ± 5.44 MPa)c than stick-shaped specimens (sectioned with wire: 42.93 ± 4.77 MPaª; sectioned with disc: 36.62 ± 3.63 MPa b), due to geometric irregularities related to manufacturing process, as noted in microscopic analyzes. It could be concluded that stick-shaped, nontrimmed specimens, sectioned with diamond wire, are preferred for enamel specimens as they can be prepared in a less destructive, easier, and more precise way.

Effect of nitric oxide inhibitor and donor substances on the infammatory process caused by endodontic irrigants

Nitric oxide (NO) has been considered a key molecule in infammation. OBJECTIVE: The aim of this study was to evaluate the effect of treatment with L-NAME and sodium nitroprussiate, substances that inhibit and release NO, respectively, on tissue tolerance to endodontic irrigants. MATERIAL AND METHODS: The vital dye exudation method was used in a rat subcutaneous tissue model. Injections of 2% Evans blue were administered intravenously into the dorsal penial vein of 14 male rats (200-300 g). The NO inhibitor and donor substances were injected into the subcutaneous tissue in the dorsal region, forming two groups of animals: G1 was inoculated with L-NAME and G2 with sodium nitroprussiate. Both groups received injections of the test endodontic irrigants: acetic acid, 15% citric acid, 17% EDTA-T and saline (control). After 30 min, analysis of the extravasated dye was performed by light absorption spectrophotometry (620 nm). RESULTS: There was statistically signifcant difference (p<0.05) between groups 1 and 2 for all irrigants. L-NAME produced a less intense infammatory reaction and nitroprussiate intensifed this process. CONCLUSIONS: Independently of the administration of NO inhibitors and donors, EDTA-T produced the highest irritating potential in vital tissue among the tested irrigating solutions.

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.

Dependence of the crossover exponent with the diffusion rate in the generalized contact process model

We study how the crossover exponent, phi, between the directed percolation (DP) and compact directed percolation (CDP) behaves as a function of the diffusion rate in a model that generalizes the contact process. Our conclusions are based in results pointed by perturbative series expansions and numerical simulations, and are consistent with a value phi = 2 for finite diffusion rates and phi = 1 in the limit of infinite diffusion rate.

Screening process for activity determination of conductive oxide electrodes for organic oxidation

A modified method for the calculation of the normalized faradaic charge (q fN) is proposed. The method involves the simulation of an oxidation process, by cyclic voltammetry, by employing potentials in the oxygen evolution reaction region. The method is applicable to organic species whose oxidation is not manifested by a defined oxidation peak at conductive oxide electrodes. The variation of q fN for electrodes of nominal composition Ti/RuX Sn1-X O2 (x = 0.3, 0.2 and 0.1), Ti/Ir0.3Ti0.7O2 and Ti/Ru0.3Ti0.7O2 in the presence of various concentrations of formaldehyde was analyzed. It was observed that electrodes containing SnO2 are the most active for formaldehyde oxidation. Subsequently, in order to test the validity of the proposed model, galvanostatic electrolyses (40 mA cm-2) of two different formaldehyde concentrations (0.10 and 0.01 mol dm-3) were performed. The results are in agreement with the proposed model and indicate that this new method can be used to determine the relative activity of conductive oxide electrodes. In agreement with previous studies, it can be concluded that not only the nature of the electrode material, but also the organic species in solution and its concentration are important factors to be considered in the oxidation of organic compounds.

Spectroscopic characterization and investigation of the dynamic of charge compensation process of supramolecular films derived from tetra-2-pyridyl-1,4-pyrazine ligand

This work describes the infrared spectroscopy characterization and the charge compensation dynamics in supramolecular film FeTPPZFeCN derived from tetra-2-pyridyl-1,4-pyrazine (TPPZ) with hexacyanoferrate, as well as the hybrid film formed by FeTPPZFeCN and polypyrrole (PPy). For supramolecular film, it was found that anion flux is greater in a K+ containing solution than in Li+ solution, which seems to be due to the larger crystalline ionic radius of K+. The electroneutralization process is discussed in terms of electrostatic interactions between cations and metallic centers in the hosting matrix. The nature of the charge compensation process differs from others modified electrodes based on Prussian blue films, where only cations such as K+ participate in the electroneutralization process. In the case of FeTPPZFeCN/PPy hybrid film, the magnitude of the anions’s flux is also dependent on the identity of the anion of the supporting electrolyte.

Health Related Quality of Life Assessment questionnaire for children aged 5 to 11 years with HIV/AIDS: cross-cultural adaptation for the Portuguese language

The objective of this study is to describe preliminary results from the cross-cultural adaptation of the Quality of Life Assessment Questionnaire, used to measure health related quality of life (HRQL) in Brazilian children aged between 5 and 11 with HIV/AIDS. The cross-cultural model evaluated the Concept, Item, Semantic and Measurement Equivalences (internal consistency and intra-observer reliability). Evaluation of the conceptual, item, semantic equivalences showed that the Portuguese version is pertinent for the Brazilian context. Four of seven domains showed internal consistency above 0.70 (α: 0.76-0.90) and five of seven revealed intra-observer reliability (ricc: 0.41-0.70). This first Portuguese version of the HRQL questionnaire can be understood as a valuable tool for assessing children's HRQL, but further studies with large samples and more robust analyses are recommended before use in the Brazilian context.

The Process of Simulation Authoring/Creation by Chemistry Teachers: A Service Learning Experience

Two case studies are presented to describe the process of public school teachers authoring and creating chemistry simulations. They are part of the Virtual Didactic Laboratory for Chemistry, a project developed by the School of the Future of the University of Sao Paulo. the documental analysis of the material produced by two groups of teachers reflects different selection process for both themes and problem-situations when creating simulations. The study demonstrates the potential for chemistry learning with an approach that takes students' everyday lives into account and is based on collaborative work among teachers and researches. Also, from the teachers' perspectives, the possibilities of interaction that a simulation offers for classroom activities are considered.

Architecture for machining process and production monitoring based in open computer numerical control

This paper proposes an architecture for machining process and production monitoring to be applied in machine tools with open Computer numerical control (CNC). A brief description of the advantages of using open CNC for machining process and production monitoring is presented with an emphasis on the CNC architecture using a personal computer (PC)-based human-machine interface. The proposed architecture uses the CNC data and sensors to gather information about the machining process and production. It allows the development of different levels of monitoring systems with mininium investment, minimum need for sensor installation, and low intrusiveness to the process. Successful examples of the utilization of this architecture in a laboratory environment are briefly described. As a Conclusion, it is shown that a wide range of monitoring solutions can be implemented in production processes using the proposed architecture.

Bond Strength of Multicomponent White Cast Iron Coatings Applied by HVOF Thermal Spray Process

Multicomponent white cast iron is a new alloy that belongs to system Fe-C-Cr-W-Mo-V, and because of its excellent wear resistance it is used in the manufacture of hot rolling mills rolls. To date, this alloy has been processed by casting, powder metallurgy, and spray forming. The high-velocity oxyfuel process is now also considered for the manufacture of components with this alloy. The effects of substrate, preheating temperature, and coating thickness on bond strength of coatings have been determined. Substrates of AISI 1020 steel and of cast iron with preheating of 150 A degrees C and at room temperature were used to apply coatings with 200 and 400 mu m nominal thickness. The bond strength of coatings was measured with the pull-off test method and the failure mode by scanning electron microscopic analysis. Coatings with thickness of 200 mu m and applied on substrates of AISI 1020 steel with preheating presented bond strength of 87 +/- A 4 MPa.

Importance of considering a material micro-failure criterion in the numerical modelling of the shot peening process applied to parabolic leaf springs

Shot peening is a cold-working mechanical process in which a shot stream is propelled against a component surface. Its purpose is to introduce compressive residual stresses on component surfaces for increasing the fatigue resistance. This process is widely applied in springs due to the cyclical loads requirements. This paper presents a numerical modelling of shot peening process using the finite element method. The results are compared with experimental measurements of the residual stresses, obtained by the X-rays diffraction technique, in leaf springs submitted to this process. Furthermore, the results are compared with empirical and numerical correlations developed by other authors.

Intrinsic colony conditions affect the provisioning and oviposition process in the stingless bee Melipona scutellaris

The cell provisioning and oviposition process (POP) is a unique characteristic of stingless bees (Meliponini), in which coordinated interactions between workers and queen regulate the filling of brood cells with larval resources and subsequent egg laying. Environmental conditions seem to regulate reproduction in stingless bees; however, little is known about how the amount of food affects quantitative sequences of the process. We examined intrinsic variables by comparing three colonies in distinct conditions (strong, intermediate and weak state). We predicted that some of these variables are correlated with temporal events of POP in Melipona scutellaris colonies. The results demonstrated that the strong colony had shorter periods of POP.