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.

Communicating trustworthiness and building trust in interorganizational virtual organizations

We propose a theory of trust in interorganizational virtual organizations that focuses on how trustworthiness can be communicated and trust built in this environment. The theory highlights three issues that must be dealt with if the potential obstacles to the development of trust in the virtual context are to be overcome. These are communication of trustworthiness facilitated by reliable Information and Communication Technology (ICT), establishment of a common business understanding, and strong business ethics. We propose four specific propositions relating to these issues, and suggest topics to be explored in future research. (C) 2001 Elsevier Science Inc. All rights reserved.

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.

Localization of small esophageal cancers for radiation planning using endoscopic contrast injection: report on a series of eight cases

Recently, Barrett's esophagus and early adenocarcinomas have been detected increasingly frequently in routine follow-up of patients with gastroesophageal reflux. Although surgery is the treatment of choice, some patients are medically unfit for esophagectomy and, in this case, the only alternative curative therapy is radical chemoradiation therapy. In addition, some patients who present with symptoms have small tumors that cannot be localized accurately using routine imaging techniques. This report describes a series of eight patients with small esophageal cancers in whom the tumors were successfully localized following endoscopic injection of contrast, and treated with chemoradiation therapy. The treatment was successful in seven patients. This method of tumor localization demonstrated that conventional techniques are mostly, unreliable when applied to very early cancers.

Organizational actions in response to threats and opportunities

In this study, we tested a model in which threats and opportunities lead directly to different organizational actions and compared it to a model in which organizational characteristics moderate organizational actions taken in response to threats and opportunities. To better understand these effects, we differentiated the dimensions of threat and opportunity associated with the threat-rigidity hypothesis from the dimensions associated with prospect theory. In this study, threats had the main and moderated effects predicted from the literature, but opportunities did not.