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.

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.

Equivalence between Redfield- and master-equation approaches for a time-dependent quantum system and coherence control

We present a derivation of the Redfield formalism for treating the dissipative dynamics of a time-dependent quantum system coupled to a classical environment. We compare such a formalism with the master equation approach where the environments are treated quantum mechanically. Focusing on a time-dependent spin-1/2 system we demonstrate the equivalence between both approaches by showing that they lead to the same Bloch equations and, as a consequence, to the same characteristic times T(1) and T(2) (associated with the longitudinal and transverse relaxations, respectively). These characteristic times are shown to be related to the operator-sum representation and the equivalent phenomenological-operator approach. Finally, we present a protocol to circumvent the decoherence processes due to the loss of energy (and thus, associated with T(1)). To this end, we simply associate the time dependence of the quantum system to an easily achieved modulated frequency. A possible implementation of the protocol is also proposed in the context of nuclear magnetic resonance.

Equivalence between hot tensile and creep testing data for Kanthal A1 alloy

Hot tensile and creep tests were carried out on Kanthal A1 alloy in the temperature range from 600 to 800 degrees C. Each of these sets of data were analyzed separately according to their own methodologies, but an attempt was made to find a correlation between them. A new criterion proposed for converting hot tensile data to creep data, makes possible the analysis of the two kinds of results according to usual creep relations like: Norton, Monkman-Grant, Larson-Miller and others. The remarkable compatibility verified between both sets of data by this procedure strongly suggests that hot tensile data can be converted to creep data and vice-versa for Kanthal A1 alloy, as verified previously for other metallic materials.

C(0) and bi-Lipschitz K-equivalence of mappings

In this paper we investigate the classification of mappings up to K-equivalence. We give several results of this type. We study semialgebraic deformations up to semialgebraic C(0) K-equivalence and bi-Lipschitz K-equivalence. We give an algebraic criterion for bi-Lipschitz K-triviality in terms of semi-integral closure (Theorem 3.5). We also give a new proof of a result of Nishimura: we show that two germs of smooth mappings f, g : R(n) -> R(n), finitely determined with respect to K-equivalence are C(0)-K-equivalent if and only if they have the same degree in absolute value.

Equivalence between supersymmetric self-dual and Maxwell-Chern-Simons models coupled to a matter spinor superfield

We study the duality of the supersymmetric self-dual and Maxwell-Chern-Simons theories coupled to a fermionic matter superfield, using a master action. This approach evades the difficulties inherent to the quartic couplings that appear when matter is represented by a scalar superfield. The price is that the spinorial matter superfield represents a unusual supersymmetric multiplet, whose main physical properties we also discuss. (C) 2009 Elsevier B.V. All rights reserved.

Methods for Equivalence and Noninferiority Testing

Classical hypothesis testing focuses on testing whether treatments have differential effects on outcome. However, sometimes clinicians may be more interested in determining whether treatments are equivalent or whether one has noninferior outcomes. We review the hypotheses for these noninferiority and equivalence research questions, consider power and sample size issues, and discuss how to perform such a test for both binary and survival outcomes. The methods are illustrated on 2 recent studies in hematopoietic cell transplantation.

Estressores em Unidade de Terapia Intensiva: versão brasileira do The Environmental Stressor Questionnaire

Este estudo teve como objetivo realizar a adaptação cultural do The Environmental Stressor Questionnaire - (ESQ) para a língua portuguesa do Brasil e verificar sua confiabilidade e validade. Foram empregadas as etapas metodológicas recomendadas pela literatura para adaptação cultural. A versão brasileira do ESQ foi aplicada a 106 pacientes de Unidade de Terapia Intensiva (UTI) de dois hospitais, público e privado, do interior do Estado de São Paulo. A confiabilidade foi avaliada quanto à consistência interna e estabilidade (teste e reteste); a validade convergente foi verificada por meio da correlação entre o ESQ e questão genérica sobre estresse em UTI. A confiabilidade foi satisfatória com Alfa de Crombach=0,94 e Coeficiente de Correlação Intraclasse=0,861 (IC95% 0,723; 0,933). Constatou-se correlação entre o escore total do ESQ e a questão genérica sobre estresse (r=0,70), confirmando a validade convergente. A versão brasileira do ESQ mostrou-se uma ferramenta confiável e válida para avaliação de estressores em UTI.

Critical applications of SW 846 US EPA methods to evaluation of marine samples quality

Technical evaluation of analytical data is of extreme relevance considering it can be used for comparisons with environmental quality standards and decision-making as related to the management of disposal of dredged sediments and the evaluation of salt and brackish water quality in accordance with CONAMA 357/05 Resolution. It is, therefore, essential that the project manager discusses the environmental agency's technical requirements with the laboratory contracted for the follow-up of the analysis underway and even with a view to possible re-analysis when anomalous data are identified. The main technical requirements are: (1) method quantitation limits (QLs) should fall below environmental standards; (2) analyses should be carried out in laboratories whose analytical scope is accredited by the National Institute of Metrology (INMETRO) or qualified or accepted by a licensing agency; (3) chain of custody should be provided in order to ensure sample traceability; (4) control charts should be provided to prove method performance; (5) certified reference material analysis or, if that is not available, matrix spike analysis, should be undertaken and (6) chromatograms should be included in the analytical report. Within this context and with a view to helping environmental managers in analytical report evaluation, this work has as objectives the discussion of the limitations of the application of SW 846 US EPA methods to marine samples, the consequences of having data based on method detection limits (MDL) and not sample quantitation limits (SQL), and present possible modifications of the principal method applied by laboratories in order to comply with environmental quality standards.

Análises do matching de identidade generalizado por contingências de três e quatro termos: implicações para equivalência de estímulos

A expansão da tríplice continência em unidades com quatro ou mais elementos abriu novas perspectivas para a compreensão de comportamentos complexos, como a emergência de respostas que derivam da formação de classes de estímulos equivalentes e que modelam comportamentos simbólicos e conceituais. Na investigação experimental, o procedimento de matching to sample tem sido frequentemente empregado para estabelecer discriminações condicionais. Em particular, a obtenção do matching de identidade generalizado é considerada demonstrativa da aquisição dos conceitos de igualdade e diferença. Segundo argumentamos, o fato de se buscar a compreensão desses conceitos a partir de processos discriminativos condicionais pode ter sido responsável pelos frequentes fracassos em demonstrá-los em sujeitos não humanos. A falta de correspondência entre os processos discriminativos responsáveis por estabelecer a relação de reflexividade entre estímulos que formam classes equivalentes e o matching de identidade generalizado, nesse sentido, é aqui revista ao longo de estudos empíricos e discutida com respeito às suas implicações.

Corporeidade e ação nos processos de formação do eu

Parte-se da hipótese de que tanto os modos de constituição da subjetividade, quanto as teses epistemológicas sobre a formação do eu têm sofrido importantes mudanças nas últimas décadas. No plano das identidades pessoais, tal fato se expressa no atenuamento do ideário intimista, tradicionalmente centrado na idéia da vida mental como espaço privado e interior. No plano epistemológico, diferentes saberes vêm questionando a equivalência entre vida mental e interioridade psicológica e propondo descrições da origem do eu que incluam a dimensão da corporeidade e da ação. Considerando as noções de representação e de ação como eixos fundamentais para diferentes concepções da subjetividade, este artigo examina um modelo internalista do psiquismo, contrastando-o com outro que toma o eu como agente corporificado.

Equivalência conceitual, de itens e semântica do Physical Activity Checklist Interview (PACI)

Há lacuna de questionários de atividade física para crianças brasileiras. O Physical Activity Checklist Interview (PACI), desenvolvido em crianças americanas, permite aferir atividade física do dia anterior. Constituem objetivos do estudo: (i) descrever os procedimentos envolvidos na escolha do PACI a ser submetido à adaptação transcultural; (ii) avaliar equivalências conceitual, de itens e semântica da versão adaptada para uso em crianças de 7 a 10 anos. Identificou-se o PACI pela revisão sistemática na qual foram incluídos dezoito questionários. Foram realizadas, no processo de escolha do instrumento, discussões com pesquisadores da área de atividade física. Verificou-se que o PACI permite aferir o construto e dimensões nas populações de origem e alvo, sendo necessário suprimir algumas atividades por não serem comuns na população alvo. Na equivalência semântica, realizou-se tradução, retradução e avaliação dos significados conotativo e referencial, com pré-teste em 24 crianças de 7 a 10 anos. Apresenta-se a versão do PACI adaptada, denominada Lista de Atividades Físicas (LAF).

Equivalência conceitual, de itens e semântica da versão brasileira do instrumento Dysfunctional Voiding Scoring System (DVSS) para avaliação de disfunção do trato urinário inferior em crianças

Investiga-se a equivalência conceitual, de itens e semântica entre o instrumento Dysfunctional Voiding Scoring System (DVSS), utilizado para avaliar a disfunção funcional do trato urinário inferior em crianças, concebido em inglês e uma versão em português. Na primeira etapa realizou-se a avaliação da equivalência conceitual e de itens, seguida de duas traduções do instrumento original para o português. Na segunda etapa foram realizadas 63 entrevistas, com crianças de 3 a 10 anos e responsáveis, e modificação de itens segundo dificuldades de interpretação. Na terceira etapa foi realizada a retradução do instrumento em português para o inglês e avaliação da equivalência semântica. Na quarta etapa, a versão pré-teste foi aplicada em vinte duplas de crianças de 3 a 10 anos e responsáveis. Apresenta-se o instrumento em português com equivalência conceitual, de itens e semântica. Sugere-se que a aplicação do DVSS seja realizada por meio de entrevista por profissional treinado e não baseada em autopreenchimento como proposto no instrumento original.

Stability and ergodicity of piecewise deterministic Markov processes

The main goal of this paper is to establish some equivalence results on stability, recurrence, and ergodicity between a piecewise deterministic Markov process ( PDMP) {X( t)} and an embedded discrete-time Markov chain {Theta(n)} generated by a Markov kernel G that can be explicitly characterized in terms of the three local characteristics of the PDMP, leading to tractable criterion results. First we establish some important results characterizing {Theta(n)} as a sampling of the PDMP {X( t)} and deriving a connection between the probability of the first return time to a set for the discrete-time Markov chains generated by G and the resolvent kernel R of the PDMP. From these results we obtain equivalence results regarding irreducibility, existence of sigma-finite invariant measures, and ( positive) recurrence and ( positive) Harris recurrence between {X( t)} and {Theta(n)}, generalizing the results of [ F. Dufour and O. L. V. Costa, SIAM J. Control Optim., 37 ( 1999), pp. 1483-1502] in several directions. Sufficient conditions in terms of a modified Foster-Lyapunov criterion are also presented to ensure positive Harris recurrence and ergodicity of the PDMP. We illustrate the use of these conditions by showing the ergodicity of a capacity expansion model.

Influence of memory in deterministic walks in random media: Analytical calculation within a mean-field approximation

Consider a random medium consisting of N points randomly distributed so that there is no correlation among the distances separating them. This is the random link model, which is the high dimensionality limit (mean-field approximation) for the Euclidean random point structure. In the random link model, at discrete time steps, a walker moves to the nearest point, which has not been visited in the last mu steps (memory), producing a deterministic partially self-avoiding walk (the tourist walk). We have analytically obtained the distribution of the number n of points explored by the walker with memory mu=2, as well as the transient and period joint distribution. This result enables us to explain the abrupt change in the exploratory behavior between the cases mu=1 (memoryless walker, driven by extreme value statistics) and mu=2 (walker with memory, driven by combinatorial statistics). In the mu=1 case, the mean newly visited points in the thermodynamic limit (N >> 1) is just < n >=e=2.72... while in the mu=2 case, the mean number < n > of visited points grows proportionally to N(1/2). Also, this result allows us to establish an equivalence between the random link model with mu=2 and random map (uncorrelated back and forth distances) with mu=0 and the abrupt change between the probabilities for null transient time and subsequent ones.