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.

Upgrading a TCABR data analysis and acquisition system for remote participation using Java, XML, RCP and modern client/server communication/authentication

The TCABR data analysis and acquisition system has been upgraded to support a joint research programme using remote participation technologies. The architecture of the new system uses Java language as programming environment. Since application parameters and hardware in a joint experiment are complex with a large variability of components, requirements and specification solutions need to be flexible and modular, independent from operating system and computer architecture. To describe and organize the information on all the components and the connections among them, systems are developed using the extensible Markup Language (XML) technology. The communication between clients and servers uses remote procedure call (RPC) based on the XML (RPC-XML technology). The integration among Java language, XML and RPC-XML technologies allows to develop easily a standard data and communication access layer between users and laboratories using common software libraries and Web application. The libraries allow data retrieval using the same methods for all user laboratories in the joint collaboration, and the Web application allows a simple graphical user interface (GUI) access. The TCABR tokamak team in collaboration with the IPFN (Instituto de Plasmas e Fusao Nuclear, Instituto Superior Tecnico, Universidade Tecnica de Lisboa) is implementing this remote participation technologies. The first version was tested at the Joint Experiment on TCABR (TCABRJE), a Host Laboratory Experiment, organized in cooperation with the IAEA (International Atomic Energy Agency) in the framework of the IAEA Coordinated Research Project (CRP) on ""Joint Research Using Small Tokamaks"". (C) 2010 Elsevier B.V. All rights reserved.

Studies on Anopheles (Kerteszia) homunculus Komp (Diptera: Culicidae)

The present findings suggest that Anopheles (Kerteszia) homunculus may comprise more than one species. The rDNA ITS2 sequence data corroborate the presence of An. homunculus l.s. in Mata Atlantica, southern Brazil, and suggest that specimens from Trinidad may belong to an unnamed morphologically similar species. There is a need for additional studies to establish the geographical distribution of An. homunculus l.s. in continental South America and in Trinidad, especially in southern Mata Atlantica, Brazil.

Protein identification pipeline for the homology-driven proteomics

Homology-driven proteomics is a major tool to characterize proteomes of organisms with unsequenced genomes. This paper addresses practical aspects of automated homology-driven protein identifications by LC-MS/MS on a hybrid LTQ orbitrap mass spectrometer. All essential software elements supporting the presented pipeline are either hosted at the publicly accessible web server, or are available for free download. (C) 2008 Elsevier B.V. All rights reserved.

Refolded dengue virus type 2 NS1 protein expressed in Escherichia coli preserves structural and immunological properties of the native protein

The dengue virus NS1 protein has been shown to be a protective antigen under different experimental conditions but the recombinant protein produced in bacterial expression systems is usually not soluble and loses structural and immunological features of the native viral protein In the present study, experimental conditions leading to purification and refolding of the recombinant dengue virus type 2 (DENV-2) NS1 protein expressed in Escherichia coil are described The refolded recombinant protein was recovered as heat-stable soluble dimers with preserved structural features, as demonstrated by spectroscopic methods In addition, antibodies against epitopes of the NS1 protein expressed in eukaryotic cells recognized the refolded protein expressed in E coli but not the denatured form or the same protein submitted to a different refolding condition Collectively, the results demonstrate that the recombinant NS1 protein preserved important conformation and antigenic determinants of the native virus protein and represents a valuable reagent either for the development of vaccines or for diagnostic methods. (C) 2010 Elsevier B V All rights reserved

Paged similarity queries

An important feature of a database management systems (DBMS) is its client/server architecture, where managing shared memory among the clients and the server is always an tough issue. However, similarity queries are specially sensitive to this kind of architecture, since the answer sizes vary widely. Usually, the answers of similarity query are fully processed to be sent in full to the user, who often is interested in just parts of the answer, e.g. just few elements closer or farther to the query reference. Compelling the DBMS to retrieve the full answer, further ignoring its majority is at least a waste of server processing power. Paging the answer is a technique that splits the answer onto several pages, following client requests. Despite the success of paging on traditional queries, little work has been done to support it in similarity queries. In this work, we present a technique that not only provides paging in similarity range or k-nearest neighbor queries, but also supports them in two variations: the forward similarity query and the backward similarity query. They return elements either increasingly farther of increasingly closer to the query reference. The reported experiments show that, depending on the proportion of the interesting part over the full answer, both techniques allow answering queries much faster than it is obtained in the non-paged way. (C) 2010 Elsevier Inc. All rights reserved.

Cloning, expression, purification and characterization of recombinant glutathione-S-transferase from Xylella fastidiosa

Xylella fastidiosa is an important pathogen bacterium transmitted by xylem-feedings leafhoppers that colonizes the xylem of plants and causes diseases on several important crops including citrus variegated chlorosis (CVC) in orange and lime trees. Glutathione-S-transferases (GST) form a group of multifunctional isoenzymes that catalyzes both glutathione (GSH)-dependent conjugation and reduction reactions involved in the cellular detoxification of xenobiotic and endobiotic compounds. GSTs are the major detoxification enzymes found in the intracellular space and mainly in the cytosol from prokaryotes to mammals, and may be involved in the regulation of stress-activated signals by suppressing apoptosis signal-regulating kinase 1. In this study, we describe the cloning of the glutathione-S-transferase from X. fastidiosa into pET-28a(+) vector, its expression in Escherichia coli, purification and initial structural characterization. The purification of recombinant xfGST (rxfGST) to near homogeneity was achieved using affinity chromatography and size-exclusion chromatography (SEC). SEC demonstrated that rxfGST is a homodimer in solution. The secondary and tertiary structures of recombinant protein were analyzed by circular dichroism and fluorescence spectroscopy, respectively. The enzyme was assayed for activity and the results taken together indicated that rxfGST is a stable molecule, correctly folded, and highly active. Several members of the GST family have been extensively studied. However, xfGST is part of a less-studied subfamily which yet has not been structurally and biochemically characterized. In addition, these studies should provide a useful basis for future studies and biotechnological approaches of rxfGST. (C) 2008 Elsevier Inc. All rights reserved.