Sort vs. hash revisited

Efficient algorithms for processing large volumes of data are very important both for relational and new object-oriented database systems. Many query-processing operations can be implemented using sort- or hash-based algorithms, e.g. intersections, joins, and duplicate elimination. In the early relational database systems, only sort-based algorithms were employed. In the last decade, hash-based algorithms have gained acceptance and popularity, and are often considered generally superior to sort-based algorithms such as merge-join. In this article, we compare the concepts behind sort- and hash-based query-processing algorithms and conclude that (1) many dualities exist between the two types of algorithms, (2) their costs differ mostly by percentages rather than by factors, (3) several special cases exist that favor one or the other choice, and (4) there is a strong reason why both hash- and sort-based algorithms should be available in a query-processing system. Our conclusions are supported by experiments performed using the Volcano query execution engine     

Lorazepam-valproate interaction: studies in normal subjects and isolated perfused rat liver

Valproate (VPA) has been shown to interact with all the major antiepileptic drugs (AEDs) through two mechanisms of action: displacement from albumin binding sites and inhibition of drug metabolism. More recently, evidence showed that VPA inhibits the elimination of drugs metabolized by glucuronide conjugation. Lorazepam (LZP), which is primarily eliminated by conjugation with glucuronic acid, is administered concurrently with VPA both in treatment of epilepsy and in patients treated with VPA for psychiatric disorders. Therefore, a significant drug interaction is likely. We investigated such interaction both in in vitro isolated perfused rat liver (IPRL) and in normal subjects. LZP [2 mg, intravenous (i.v.) bolus] was administered to 8 normal volunteers before and after chronic dosing with VPA. In 6 of 8 subjects, VPA significantly decreased LZP plasma clearance by an average of 40% (p < 0.05) and increased LZP concentrations by decreasing formation clearance of the LZP glucuronide. In the IPRL studies, VPA also significantly decreased formation of LZP glucuronide (from 0.72 +/- 0.14 to 0.22 +/- 0.15 ml/h/kg, p < 0.05), indicating that IPRL is a useful tool for evaluation of the effect of VPA on drugs eliminated by glucuronide conjugation.     

The Development of Color Categories in Two Languages: A Longitudinal Study.

This study unites investigations into the linguistic relativity of color categories with research on children's category acquisition. Naming, comprehension, and memory for colors were tracked in 2 populations over a 3-year period. Children from a seminomadic equatorial African culture, whose language contains 5 color terms, were compared with a group of English children. Despite differences in visual environment, language, and education, they showed similar patterns of term acquisition. Both groups acquired color vocabulary slowly and with great individual variation. Those knowing no color terms made recognition errors based on perceptual distance, and the influence of naming on memory increased with age. An initial perceptually driven color continuum appears to be progressively organized into sets appropriate to each culture and language. (PsycINFO Database Record (c) 2010 APA, all rights reserved)     

Identification of a gene that causes primary open angle glaucoma

Glaucoma is a major cause of blindness and is characterized by progressive degeneration of the optic nerve and is usually associated with elevated intraocular pressure. Analyses of sequence tagged site (STS) content and haplotype sharing between families affected with chromosome 1q-linked open angle glaucoma (GLC1A) were used to prioritize candidate genes for mutation screening. A gene encoding a trabecular meshwork protein (TIGR) mapped to the narrowest disease interval by STS content and radiation hybrid mapping. Thirteen glaucoma patients were found to have one of three mutations in this gene (3.9 percent of the population studied). One of these mutations was also found in a control individual (0.2 percent). Identification of these mutations will aid in early diagnosis, which is essential for optimal application of existing therapies.     

Wooden sticks as the source of a pseudoepidemic of infection with Rhizopus microsporus var. rhizopodiformis among immunocompromised patients

Wooden sticks used to suspend feces obtained for surveillance cultures were found to be the source of Rhizopus microsporus var. rhizopodiformis causing a pseudo-outbreak among 17 immunocompromised patients cared for in three different wards. Nonsterile wooden products should therefore not be used for collecting, handling, and processing specimens for microbiological examination.     

School psychologists' acceptability of behavioral and traditional assessment procedures for externalizing problem behaviors.

A national survey of school psychologists' acceptability of psychological assessment techniques in the area of externalizing problem behaviors was examined. School psychologists' ratings of 2 procedures, Behavioral Assessment (BA) and Traditional Assessment (TA), were compared using an analog case study methodology. Using a random sample of 500 National Association of School Psychologists members from the 1991–1992 membership directory, 339 Ss completed the Assessment Rating Profile after reading a hypothetical case summary describing a student with suspected externalizing problem behaviors. Results indicated statistically significant differences between assessment methods and ratings of acceptability. BA procedures were found to be more acceptable than TA procedures. Implications related to the acceptability of psychological assessment techniques, as well as implications for school psychology practitioners are discussed. (PsycINFO Database Record (c) 2010 APA, all rights reserved)