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.

Characterization of micro-mesoporous carbon media

A simple method to characterize the micro and mesoporous carbon media is discussed. In this method, the overall adsorption quantity is the sum of capacities of all pores (slit shape is assumed), in each of which the process of adsorption occurs in two sequential steps: the multi-layering followed by pore filling steps. The critical factor in these two steps is the enhancement of the pressure of occluded 'free' molecules in the pore as well as the enhancement of the adsorption layer thickness. Both of these enhancements are due to the overlapping of the potential fields contributed by the two opposite walls. The classical BET and modified Kelvin equations are assumed to be applicable for the two steps mentioned above, with the allowance for the enhanced pore pressure, the enhanced adsorption energy and the enhanced BET constant,all of which vary with pore width. The method is then applied to data of many carbon samples of different sources to derive their respective pore size distributions, which are compared with those obtained from DFT analysis. Similar pore size distributions (PSDs) are observed although our method gives sharper distribution. Furthermore, we use our theory to analyze adsorption data of nitrogen at 77 K and that of benzene at 303 K (ambient temperature). The PSDs derived from these two different probe molecules are similar, with some small differences that could be attributed to the molecular properties, such as the collision diameter. Permeation characteristics of sub-critical fluids are also discussed in this paper. (C) 2001 Elsevier Science B.V. All rights reserved.

Television and cultural studies: Unfinished business

This introductory article argues that the current state of debate on television within cultural studies is marked by considerable areas of theoretical and political uncertainty. The spread of deregulatory and privatizing public policies in relation to television, and the disarticulation of television from the idea of the national community and from the role of the citizen, have posed new problems for theorizing the relation between television and its audiences. In this article I survey a number of key areas of debate: the relation between television, the nation and the state; television and the citizen/consumer, television content and performance, and the likely future(s) of television.

Transport of endosomal early antigen I in the rat sciatic nerve and location in cultured neurons

Early endosomal antigen I (EEAI) is known to be a marker of early endosomes and in cultured hippocampal neurons it preferentially localizes to the dendritic but not the axonal compartment. We show in cultured dorsal root ganglia and superior cervical ganglia neurons that EEAI localizes to the cell bodies and the neurites of both sensory and sympathetic neurons. We then show in vivo using a ligated rat sciatic nerve that EEAI significantly accumulates on the proximal side and not on the distal side of the ligation. This suggests that EEAI is transported in the anterograde direction in axons either as part of the homeostatic process or to the nerve ligation site in response to nerve injury. NeuroReport 12:281-284 (C) 2001 Lippincott Williams & Wilkins.

Effect of gender on ownership and income in veterinary practice

Objective To estimate the effect of gender on ownership and income in veterinary practice in Australia. Methods Questionnaire completed by private veterinary practitioners, and analysed using the SAS System for Windows 7.0. Results More than three-quarters (78%) of male but 36% of female private practitioners were partial or sole owners of practices. The median annual income for all male practitioners working more than 40 hours/week was $70K, but that for females was $43K. These disparities existed in both city and country practices, and in the case of income it increased with increasing time in the workforce. Male practice owners also reported higher incomes than female owners. Conclusions Female veterinary practitioners are less likely to own practices, and more likely to earn low incomes than males. These differentials do not appear to be due to location, hours worked or years since graduation or, in the case of income, to whether they are owners or employees. The evidence points to a lower interest by women than men in the business aspects of veterinary practice.

Reliability factors in business software: volatility, requirements and end-users

Many business-oriented software applications are subject to frequent changes in requirements. This paper shows that, ceteris paribus, increases in the volatility of system requirements decrease the reliability of software. Further, systems that exhibit high volatility during the development phase are likely to have lower reliability during their operational phase. In addition to the typically higher volatility of requirements, end-users who specify the requirements of business-oriented systems are usually less technically oriented than people who specify the requirements of compilers, radar tracking systems or medical equipment. Hence, the characteristics of software reliability problems for business-oriented systems are likely to differ significantly from those of more technically oriented systems.