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.

Effects of short- and long-term exposure to c-AMP and c-GMP on the noradrenaline transporter

The effects of short- and long-term exposure of cells to elevated cyclic adenosine monophosphate (c-AMP), using dibutyryl-c-AMP, 8-bromo-c-AMP, cholera toxin or forskolin, or cyclic guanosine monophosphate (c-GMP), using dibutyryl-c-GMP or 8-bromo-c-GMP, on the activity and expression of the noradrenaline transporter (NAT) were examined. Short- or long-term c-GMP elevation had no effects on H-3-noradrenaline uptake by rat PC12 phaeochromocytoma cells or human SK-N-SH-SY5Y neuroblastoma cells. Short-term c-AMP elevation (for 17 min experiment duration) caused a decrease in H-3-noradrenaline uptake by PC12 cells, but had no effects on SK-N-SH-SY5Y cells or COS-7 cells transfected with human or rat NAT cDNA. c-AMP did not affect H-3-nisoxetine binding to PC12 cells. Long-term (24 h) exposure to elevated c-AMP levels caused a decrease in H-3-noradrenaline uptake and NAT mRNA in PC12 cells, but had no effects on SK-N-SH-SY5Y cells and caused a small increase in H-3-noradrenaline uptake in COS-7 cells heterologously expressing rat or human NAT. Hence, c-AMP, but not c-GMP, causes a cell type-dependent reduction in NAT activity after short-term exposure and a reduction in NAT expression after long-term exposure. (C) 2001 Elsevier Science Ltd. All rights reserved.

New perspectives on the role of aldosterone excess in cardiovascular disease

1. Evidence from recent experimental and clinical studies suggests that excessive circulating levels of aldosterone can bring about adverse cardiovascular sequelae independent of the effects on blood pressure. Examples of these sequelae are the development of myocardial and vascular fibrosis in uninephrectomized, salt-loaded rats infused with mineralocorticoids and, in humans, an association of aldosterone with left ventricular hypertrophy, impaired diastolic and systolic function, salt and water retention causing aggravation of congestion in patients with established congestive cardiac failure (CCF), reduced vascular compliance and an increased risk of arrhythmias (resulting from intracardiac fibrosis, hypokalaemia, hypomagnesaemia, reduced baroreceptor sensitivity and potentiation of catecholamine effects). 2. These sequelae of aldosterone excess may contribute to the pathogenesis and worsen the prognosis of CCF and hypertension. 3. The heart and blood vessels may be capable of extra-adrenal aldosterone biosynthesis, raising the possibility that aldosterone may have paracrine or autocrine (and not just endocrine) effects on cardiovascular tissues. 4. The high prevalence of CCF, which is associated with secondary aldosteronism, and primary aldosteronism (PAL; recently recognized to be a much more common cause of hypertension than was previously thought) argue for an important role for aldosterone excess as a cause of cardiovascular injury. 5. The recognition of non-blood pressure-dependent adverse sequelae of aldosterone excess raises the question as to whether normotensive individuals with PAL, who have been detected as a result of genetic or biochemical screening among families with inherited forms of PAL, are at excess risk of cardiovascular events. 6. Provided that patients are carefully investigated in order to permit the appropriate selection of specific surgical (laparoscopic adrenalectomy for PAL that lateralizes on adrenal venous sampling) or medical (treatment with aldosterone antagonist medications) management and safety considerations for the use of aldosterone antagonists are kept in mind, the appreciation of a widening role for aldosterone in cardiovascular disease should provide a substantially better outlook for many patients with CCF and hypertension.

Multiple impacts of the HIV/AIDS epidemic on the aged in rural Uganda

This paper reports research conducted among theaged residents of a rural, Southwestern Ugandanvillage. It documents their knowledge ofHIV/AIDS, their perceptions of their own riskof infection, and the multiple impacts of thecurrent HIV/AIDS epidemic on their lives. Mostolder individuals have a sound understanding ofthe sexual transmission of HIV, and someconsider themselves to be at risk of infectionthrough having multiple sexual partners. Theyattempt to limit their children's exposure toHIV, but many of these children have left thevillage to live in urban areas of relativelyhigh HIV prevalence. The loss of adult childrendeprives the aged of any support these childrenmight have provided as their parents'capabilities declined with advancing age.Female-headed households were more affected inthis way than were male-headed households. TheAIDS epidemic has increased the number ofburials taking place in the village, and theiraccumulated costs, both in time and money, andcreated new hardships for the aged, who alsohave to cope with grief that accompaniescontinuing deaths among their children andtheir contemporaries' children.

PCDDs in the water/sediment-seagrass-dugong (Dugong dugon) food chain on the Great Barrier Reef (Australia)

Polychlorinated dibenzo-p-dioxin (PCDD) and dibenzofuran (PCDF) concentrations were measured in sediment and seagrass from five locations in or adjacent to the Great Barrier Reef Marine Park. A full spectrum of Cl(5-8)DDs were present in all samples and, in particular, elevated levels of Cl8DD were found. PCDFs could not be quantified in any samples. The PCDD concentrations ranged over two orders of magnitude between sites, and there was a good correlation between sediment and seagrass levels. There were large quantities of sediment present on the seagrass (20-62% on a dry wt. basis), and it was concluded that this was a primary source of the PCDDs in the seagrass samples. The PCDD levels in the seagrass samples were compared with the levels in the tissue of three dugongs stranded in the same region. The relative accumulation of the 2,3,7,8-substituted PCDD congeners in the dugongs decreased by over two orders of magnitude with increasing degree of chlorination. This was attributed to the reduced absorption of the higher chlorinated congeners in the digestive tract, a behaviour that has been observed in other mammals such as domestic cows. (C) 2001 Elsevier Science Ltd. All rights reserved.

The feasibility of regulating gambling on the internet

Internet gambling presents substantial new challenges to governments and regulatory agencies. Existing approaches to betting, lotteries and gaming are limited by the nature of Internet technology, and the international nature of the activity. Particular aspects of Internet gambling are considered, and the conclusion is reached that prohibition is an ineffectual alternative, and that licensing of gambling services providers is the appropriate approach. Copyright © 2001 John Wiley & Sons, Ltd.

The effect of videoconferencing on the depth perception of observers

The ability of the human eye to perceive depth was measured using a specially designed instrument. Visual acuity and both monocular and binocular stereoacuity were measured when viewing the instrument directly and via a videoconferencing link. Ten subjects with an average age of 32.5 years (range 24-50) took part in the study. The group mean visual acuity using both eyes under normal test conditions was -0.04 logMAR (Snellen 6/5) compared with 0.18 logMAR (Snellen 6/10) for the video-link. The mean stereoacuity using both eyes was 37 (SD 18) under normal test conditions. When a videoconferencing link was used, the mean stereoacuity fell to 1218 (SD 1203) using one eye and to 1651 (SD 1419) using both eyes. The ability to perceive depth remotely via a video-link was significantly decreased compared with normal test conditions.

On the relation between ownership structure and capital structure

The agency relationship between managers and shareholders has the potential to influence decision-making in the firm which in turn potentially impacts on firm characteristics such as value and leverage. Prior evidence has demonstrated an association between ownership structure and firm value. This paper extends the literature by examining a further link between ownership structure and capital structure. Using an agency framework, it is argued that the distribution of equity ownership among corporate managers and external blockholders may have a significant relation with leverage. The empirical results provide support for a positive relation between external blockholders and leverage, and non-linear relation between the level of managerial share ownership and leverage. The results also suggest that the relation between external block ownership and leverage varies across the level of managerial share ownership. These results are consistent with active monitoring by blockholders, and the effects of convergence-of-interests and management entrenchment.

An action research report on the Korean national digital library

This paper presents the results of my action research. I was involved in establishing and running a digital library that was founded by the government of South Korea. The process involved understanding the relationship between the national IT infrastructure and the success factors of the digital library. In building, the national IT infrastructure, a digital library system was implemented; it combines all existing digitized university libraries and can provide overseas information, such as foreign journal articles, instantly and freely to every Korean researcher. An empirical survey was made as a part of the action research; the survey determined user satisfaction in the newly established national digital library. After obtaining the survey results, I suggested that the current way of running the nationwide government-owned digital library should be retained. (C) 2002 Elsevier Science B.V. All rights reserved.

Impact numbers: measures of risk factor impact on the whole population from case-control and cohort studies

Objective: To describe new measures of risk from case-control and cohort studies, which are simple to understand and relate to numbers of the population at risk. Design: Theoretical development of new measures of risk. Setting: Review of literature and previously described measures. Main results: The new measures are: (1) the population impact number (PIN), the number of those in the whole population among whom one case is attributable to the exposure or risk factor (this is equivalent to the reciprocal of the population attributable risk),- (2) the case impact number (CIN) the number of people with the disease or outcome for whom one case will be attributable to the exposure or risk factor (this is equivalent to the reciprocal of the population attributable fraction); (3) the exposure impact number (EIN) the number of people with the exposure among whom one excess case is attributable to the exposure (this is equivalent to the reciprocal of the attributable risk); (4) the exposed cases impact number (ECIN) the number of exposed cases among whom one case is attributable to the exposure (this is equivalent to the reciprocal of the aetiological fraction). The impact number reflects the number of people in each population (the whole population, the cases, all those exposed, and the exposed cases) among whom one case is attributable to the particular risk factor. Conclusions: These new measures should help communicate the impact on a population, of estimates of risk derived from cohort or case-control studies.