The effects of normalisation on the ability of business end-users to detect data anomalies: An experimental evaluation

With the proliferation of relational database programs for PC's and other platforms, many business end-users are creating, maintaining, and querying their own databases. More importantly, business end-users use the output of these queries as the basis for operational, tactical, and strategic decisions. Inaccurate data reduce the expected quality of these decisions. Implementing various input validation controls, including higher levels of normalisation, can reduce the number of data anomalies entering the databases. Even in well-maintained databases, however, data anomalies will still accumulate. To improve the quality of data, databases can be queried periodically to locate and correct anomalies. This paper reports the results of two experiments that investigated the effects of different data structures on business end-users' abilities to detect data anomalies in a relational database. The results demonstrate that both unnormalised and higher levels of normalisation lower the effectiveness and efficiency of queries relative to the first normal form. First normal form databases appear to provide the most effective and efficient data structure for business end-users formulating queries to detect data anomalies.

Dam worms

Human and animal infection rates with the Oriental schistosome have steadily declined in China over the last half-century, but the Three Gorges Dam may reverse this decline by creating new, or enlarging existing, ideal environments for the worm and its aquatic snail intermediate host.

A sociolinguistic approach to applied epistemology: Examining technocratic values in global 'knowledge' policy

This special issue presents an excellent opportunity to study applied epistemology in public policy. This is an important task because the arena of public policy is the social domain in which macro conditions for ‘knowledge work’ and ‘knowledge industries’ are defined and created. We argue that knowledge-related public policy has become overly concerned with creating the politico-economic parameters for the commodification of knowledge. Our policy scope is broader than that of Fuller (1988), who emphasizes the need for a social epistemology of science policy. We extend our focus to a range of policy documents that include communications, science, education and innovation policy (collectively called knowledge-related public policy in acknowledgement of the fact that there is no defined policy silo called ‘knowledge policy’), all of which are central to policy concerned with the ‘knowledge economy’ (Rooney and Mandeville, 1998). However, what we will show here is that, as Fuller (1995) argues, ‘knowledge societies’ are not industrial societies permeated by knowledge, but that knowledge societies are permeated by industrial values. Our analysis is informed by an autopoietic perspective. Methodologically, we approach it from a sociolinguistic position that acknowledges the centrality of language to human societies (Graham, 2000). Here, what we call ‘knowledge’ is posited as a social and cognitive relationship between persons operating on and within multiple social and non-social (or, crudely, ‘physical’) environments. Moreover, knowing, we argue, is a sociolinguistically constituted process. Further, we emphasize that the evaluative dimension of language is most salient for analysing contemporary policy discourses about the commercialization of epistemology (Graham, in press). Finally, we provide a discourse analysis of a sample of exemplary texts drawn from a 1.3 million-word corpus of knowledge-related public policy documents that we compiled from local, state, national and supranational legislatures throughout the industrialized world. Our analysis exemplifies a propensity in policy for resorting to technocratic, instrumentalist and anti-intellectual views of knowledge in policy. We argue that what underpins these patterns is a commodity-based conceptualization of knowledge, which is underpinned by an axiology of narrowly economic imperatives at odds with the very nature of knowledge. The commodity view of knowledge, therefore, is flawed in its ignorance of the social systemic properties of ��knowing’.

Space: Irrealis objects in technology policy and their role in a new political economy

In this article, I show how new spaces are being prefigured for colonization in new economy policy discourses. Drawing on a corpus of 1.3 million words collected from legislatures throughout the world, I show the role of policy language in creating the foundations of an emergent form of political economy: The analysis is informed by principles from critical discourse analysis (CDA), classical political economy and critical media studies. It foregrounds a functional aspect of language called process metaphor to show how aspects of human activity are prefigured for mass commodification by the manipulation of realis and irrealis spaces. I also show how the fundamental element of any new political economy, the property element, is being largely ignored. Current moves to create a privately owned global space, which is as concrete as landed property - namely, the electromagnetic spectrum - has significant ramifications for the future of social relations in any global knowledge economy.

Least-Cost Planning and electricity industry reform in Australia

Least-Cost Planning played a key role in the development of the energy efficiency and renewable energy industries in the USA, It has not been widely used elsewhere, largely due to differences in other nations' regulatory environments and the emergence of competitive markets as the dominant paradigm for electricity planning, Least-Cost Planning, however may over valuable insights for creating regulatory framework for competitive electricity markers. This paper examines some lessons which may be extracted from an analysis of the Least-Cost Planning experience in the USA and suggests how these lessons might prove beneficial in guiding Australia's electricity industry reform, This analysis demonstrates how market-based reforms may be flawed if they ignore the history of previous reform processes.

Are community newspapers really different?

Cafarella has written what amounts to a wake-up call for many journalism educators. Her paper will have varying degrees of relevance for different educators and different institutions. In some instances, she may well be reflecting the viewpoints of particular educators in particular situations but these same educators, because of institutional pressures and the very pressures of time and limited resources that Cafarella discusses in a suburban newspaper setting, are unable to implement their heart’s desire. For example, they may want to do all the things Cafarella cited, but to meet the academic requirements of their institution as opposed to the training needs of their students they must achieve a balance between the practical and the theoretical, between their own teaching and research performance, and they must be able to cope with the marking load they generate by creating endless practical assignments. Shorthand bobs up in Cafarella’s paper as a hurdle the graduate cadet must clear before being elevated to the status of graded journalist after the one-year cadetship, and I am reminded that arguments about the inclusion of shorthand in tertiary journalism courses has been debated at national and institutional levels for the past quarter of a century. In fact, shorthand is a kind of shorthand for this practice versus theory debate.

Multi-fluorescent silica colloids for encoding large combinatorial libraries

Large chemical libraries can be synthesized on solid-support beads by the combinatorial split-and-mix method. A major challenge associated with this type of library synthesis is distinguishing between the beads and their attached compounds. A new method of encoding these solid-support beads, 'colloidal bar-coding', involves attaching fluorescent silica colloids ('reporters') to the beads as they pass through the compound synthesis, thereby creating a fluorescent bar code on each bead. In order to obtain sufficient reporter varieties to bar code extremely large libraries, many of the reporters must contain multiple fluorescent dyes. We describe here the synthesis and spectroscopic analysis of various mono- and multi-fluorescent silica particles for this purpose. It was found that by increasing the amount of a single dye introduced into the particle reaction mixture, mono- fluorescent silica particles of increasing intensities could be prepared. This increase was highly reproducible and was observed for six different fluorescent dyes. Multi-fluorescent silica particles containing up to six fluorescent dyes were also prepared. The resultant emission intensity of each dye in the multi-fluorescent particles was found to be dependent upon a number of factors; the hydrolysis rate of each silane-dye conjugate, the magnitude of the inherent emission intensity of each dye within the silica matrix, and energy transfer effects between dyes. We show that by varying the relative concentration of each silane-dye conjugate in the synthesis of multi-fluorescent particles, it is possible to change and optimize the resultant emission intensity of each dye to enable viewing in a fluorescence detection instrument.

Liquid distribution in wet granulation: dimensionless spray flux

This study investigates binder distribution in wet granulation and focuses on the nucleation zone, which is the area where the liquid binder and powder surface come into contact and form the initial nuclei. An equipment independent parameter, dimensionless spray flux Psi (a), is defined to characterise the most important process parameters in the nucleation process: solution flowrate, powder flux, and binder drop size. Ex-granulator experiments are used to study the relationship between dimensionless spray flux, process variables and the coverage of binder fluid on the powder surface. Lactose monohydrate powder on a variable speed riffler passed under a flat spray once only. Water and 7% HPC solution at two spray pressures were used as binders. Experiments with red dye and image analysis demonstrate that changes in dimensionless spray flux correlate with a measurable difference in powder surface coverage. Nucleation experiments show that spray flux controls the size and shape of the nuclei size distribution. At low Psi (a), the system operates in the drop controlled regime, where one drop forms one nucleus and the nuclei size distribution is narrow. At higher Psi (a), the powder surface cakes creating a broader size distribution. For controlled nucleation with the narrowest possible size distribution, it is recommended that the dimensionless spray flux be less than 0.1 to be in the drop-controlled regime. (C) 2001 Elsevier Science S.A. All rights reserved.

Pediculus humanus capitis infestations in the community: A pilot study into transmission, treatment and factors affecting control

Head lice (Pediculus humanus capitis) infestations affect schoolchildren worldwide, creating social, economic and health consequences for families. Problems with self-detection, chronic infestations and classroom transmission are compounded by increasing resistance of the lice to pediculicides. Public health strategies are based on limited research and little is known about transmission dynamics. Mismanagement and transmission in the general community are blamed for control failure. The purpose of this study was to explore community head-lice experience in Brisbane, Australia, and to identify critical factors underlying control failure. A home-based pilot survey used physical examination to verify transmission and treatment patterns which were self-reported by a group of trace-contact families in addition to other unconnected participants. The survey was enlarged to further compare therapy outcomes and suspected risk factors. The findings reinforce those of previous studies - that children attending school and early childhood centres, and subsequently their families, are most at risk of contracting pediculosis capitis, and some may carry lice for years. First-line (pediculicidal) treatment and even additional physical methods of hand-picking and fine-toothed combing usually fail to eradicate lice quickly and completely (overall cure-rate 39 per cent, n = 84 cases). Failures were linked to hair characteristics. Public education alone may not control pediculosis. Accurate diagnosis requires considerable experience; a strong case exists for returning to institutional surveillance.

Growth and hard tissue remodelling in the dentition of the Australian lungfish, Neoceratodus forsteri (Osteichthyes: Dipnoi)

The extant lungfish, including three genera, the Australian, South American and African lungfishes, retain a dentition that appeared first in the Devonian, in some of the oldest members of this group. The dentition consists of permanent tooth plates with persistent cusps that appear early in development of the fish. The cusps, separate early in development, form ridges that are arranged in a radiating pattern, and fusion of the cusps to each other and to the underlying jaw bone produces a tooth plate. The lungfish dentition is based on a template of mantle dentine that surrounds bone trabeculae enclosed in the tooth plate. The mantle layer is covered by enamel. In most derived dipnoans, this framework encloses two further forms of dentine, known as interdenteonal and circumdenteonal dentines. The tooth plates grow in area and in depth without evidence of macroscopic resorption of dentines or of enamel. Increase in size and changes in shape of lungfish tooth plates is actually achieved by a process involving microscopic remodelling of the bone contained within the margin of each tooth plate, and the later addition of new dentines and enamel within and around the bone. This is accomplished without creating weakness in the structural integrity of the tooth plate and bone complex, and proceeds in line with growth and remodelling of the jaw bones attached to the tooth plates.

A sponge allelochemical induces ascidian settlement but inhibits metamorphosis

Secondary metabolites synthesised by sessile invertebrates appear to play a role in creating and maintaining space on hard substrata by repelling competitors. In this study, we investigated the responses of the larvae of the ascidian Herdmania curvata to haliclonacyclamine A (HA), the major component of a suite of cytotoxic alkaloids extracted from the sponge Haliclona sp. 628. Both Haliclona sp. 628 and Herdmania curvata inhabit the crest and slope of Heron Island Reef. High rates of settlement were induced in competent H. curvata larvae by a range of concentrations of HA, all lower than that naturally occurring in the sponge. HA did not induce precompetent larvae to settle. Although early metamorphosis of HA-induced larvae was normal, larvae exposed to all but the lowest concentration of HA were developmentally arrested after completion of tail resorption, at about 4 h after the initiation of metamorphosis. These postlarvae underwent extensive cellular necrosis within 24 h. We also demonstrate that the addition of a transcriptional inhibitor, actinomycin D, to larvae also causes inhibition of metamorphosis after tail resorption is completed. Analyses of incorporation of radiolabelled nucleotides to measure levels of transcription during normal development and after the addition of the transcriptional inhibitor indicate that there is a significant burst of transcriptional activity just after tail resorption is completed. Despite inhibiting metamorphosis at the same stage as actinomycin D, HA increases initial rates of RNA synthesis after induction of metamorphosis in a manner similar to that observed in normal postlarvae until the onset of cellular necrosis. We conclude that HA initially induces H. curvata larvae to settle and progress through early metamorphosis possibly by engaging the same pathway as other artificial and environmental cues but subsequently inhibits completion of metamorphosis, resulting in death of the postlarvae. Since HA does not affect overall transcription rates, it appears to disrupt another important developmental process during early metamorphosis.

Partial automation of database processing of simulation outputs from L-systems models of plant morphogenesis

Models of plant architecture allow us to explore how genotype environment interactions effect the development of plant phenotypes. Such models generate masses of data organised in complex hierarchies. This paper presents a generic system for creating and automatically populating a relational database from data generated by the widely used L-system approach to modelling plant morphogenesis. Techniques from compiler technology are applied to generate attributes (new fields) in the database, to simplify query development for the recursively-structured branching relationship. Use of biological terminology in an interactive query builder contributes towards making the system biologist-friendly. (C) 2002 Elsevier Science Ireland Ltd. All rights reserved.

Monitoring and isolation of blood dendritic cells from apheresis products in healthy individuals: a platform for cancer immunotherapy

The fundamental role of dendritic cells (DC in initiating and directing the primary immune response is well established. Furthermore, it is now accepted that DC may be useful in new vaccination strategies for preventing certain malignant and infectious diseases. As blood DC (BDC physiology differs from that of the DC homologues generated in vitro from monocyte precursors, it is becoming more relevant to consider BDC for therapeutic interventions. Until recently, protocols for the isolation of BDC were laborious and inefficient; therefore, their use for investigative cancer immunotherapy is not widespread. In this study, we carefully documented BDC counts, yields and subsets during apheresis (Cobe Spectra), the initial and essential procedure in creating a BDC isolation platform for cancer immunotherapy. We established that an automated software package (Version 6,0 AutoPBPC) provides an operator-independent reliable source of motionuclear cells (MNC for BDC preparation. Further, we observed that BDC might be recovered in high yields, often greater than 100% relative to the number of circulating BDC predicted by blood volume. An average of 66 million (range, 17-179) BDC per 10-1 procedure were obtained, largely satisfying the needs for immunization. Higher yields were possible on total processed blood volumes of 151. BDC were not activated by the isolation procedure and, more importantly, both BDC subsets (CD11c(+)CD123(low) and CD11c(-)CD123(high)) were equally represented. Finally, we established that the apheresis product could be used for antibody-based BDC immunoselection and demonstrated that fully functional BDC can be obtained by this procedure. (C) 2002 Published by Elsevier Science B.V.

The synthesis and structure of an n-terminal dodecanoic acid conjugate of a-conotoxin MII

The alpha-conotoxin MII is a 16 amino acid long peptide toxin isolated from the marine snail, Conus magus. This toxin has been found to be a highly selective and potent inhibitor of neuronal nicotinic acetylcholine receptors of the subtype alpha3beta2. To improve the bioavailability of this peptide, we have coupled to the N-terminus of conotoxin MII, 2-amino-D,L-dodecanoic acid (Laa) creating a lipidic linear peptide which was then successfully oxidised to produce the correctly folded conotoxin MII construct.

Mitochondrial genomes of parasitic flatworms

Complete or near-complete mitochondrial genomes are now available for 11 species or strains of parasitic flatworms belonging to the Trematoda and the Cestoda. The organization of these genomes is not strikingly different from those of other eumetazoans, although one gene (atp8) commonly found in other phyla is absent from flatworms. The gene order in most flatworms has similarities to those seen in higher protostomes such as annelids. However, the gene order has been drastically altered in Schistosoma mansoni, which obscures this possible relationship. Among the sequenced taxa, base composition varies considerably, creating potential difficulties for phylogeny reconstruction. Long non-coding regions are present in all taxa, but these vary in length from only a few hundred to similar to10 000 nucleotides. Among Schistosoma spp., the long non-coding regions are rich in repeats and length variation among individuals is known. Data from mitochondrial genomes are valuable for studies on species identification, phylogenies and biogeography.