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.

Novel colloidal materials for high-throughput screening applications in drug discovery and genomics

Tracking the reaction history is the means of choice to identify bioactive compounds in large combinatorial libraries. The authors describe two approaches to synthesis on silica beads: a) addition of a reporter dye tag during each synthesis step (see Figure), which attaches itself to the bead by colloidal forces, and b) encapsulating arrays of fluorescent dyes into the beads to encode them uniquely, for recognition with a flow cytometer after each reaction step.

Hydrophobicity of Templated Silica Xerogels for Molecular Sieving Applications

Silica xerogels were prepared by a sol-gel process catalyzed by acid with tetraethylorthosilicate, and using an organic covalent ligand template (methyltriethoxysilane) or a noncovalent template C6 surfactant (triethylhexylammonium bromide). The influence of hydrotreatment on the structure of templated xerogels is examined in terms of surface area, micropore volume, average pore size, and pore size distribution, and compared against a blank xerogel (nontemplated). The role of surface functional groups was evaluated using Si-29 nuclear magnetic resonance. The structural integrity of the xerogel was maintained to a large extent in samples that had a high contribution of Q(4) species (siloxane groups). Xerogel matrix densification occurred when there was a large concentration of Q(3) and Q(2) species (silanol groups), which also were responsible for increased hydrophilicity. The templated xerogels resulted in up to a 25% concentration of methyl functional groups (T-3 and T-2 species), leading to hydrophobic xerogels. The best results in terms of structural integrity and hydrophobicity were obtained with templated xerogels prepared with the C6 surfactant. The results in this study suggest that surfactant-enhanced condensation reactions lead to structures with a high contribution of Q(4) groups, which are not susceptible to water attack, but are strong enough to oppose matrix densification during rehydration.

Using visual spatial search interface for WWW applications

Most Internet search engines are keyword-based. They are not efficient for the queries where geographical location is important, such as finding hotels within an area or close to a place of interest. A natural interface for spatial searching is a map, which can be used not only to display locations of search results but also to assist forming search conditions. A map-based search engine requires a well-designed visual interface that is intuitive to use yet flexible and expressive enough to support various types of spatial queries as well as aspatial queries. Similar to hyperlinks for text and images in an HTML page, spatial objects in a map should support hyperlinks. Such an interface needs to be scalable with the size of the geographical regions and the number of websites it covers. In spite of handling typically a very large amount of spatial data, a map-based search interface should meet the expectation of fast response time for interactive applications. In this paper we discuss general requirements and the design for a new map-based web search interface, focusing on integration with the WWW and visual spatial query interface. A number of current and future research issues are discussed, and a prototype for the University of Queensland is presented. (C) 2001 Published by Elsevier Science Ltd.