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.

On compliance of business processes with business contracts

This paper addresses the problem of ensuring compliance of business processes, implemented within and across organisational boundaries, with the constraints stated in related business contracts. In order to deal with the complexity of this problem we propose two solutions that allow for a systematic and increasingly automated support for addressing two specific compliance issues. One solution provides a set of guidelines for progressively transforming contract conditions into business processes that are consistent with contract conditions thus avoiding violation of the rules in contract. Another solution compares rules in business contracts and rules in business processes to check for possible inconsistencies. Both approaches rely on a computer interpretable representation of contract conditions that embodies contract semantics. This semantics is described in terms of a logic based formalism allowing for the description of obligations, prohibitions, permissions and violations conditions in contracts. This semantics was based on an analysis of typical building blocks of many commercial, financial and government contracts. The study proved that our contract formalism provides a good foundation for describing key types of conditions in contracts, and has also given several insights into valuable transformation techniques and formalisms needed to establish better alignment between these two, traditionally separate areas of research and endeavour. The study also revealed a number of new areas of research, some of which we intend to address in near future.

Lessons from a comprehensive clinical audit of users of psychiatric services who committed suicide

Objective: Characteristics of patients who committed suicide were examined to provide a picture of the treatment they received before death and to determine whether and how the suicides could have been pre vented by the service system. Methods: The unnatural-deaths register was matched to the psychiatric case register in the state of Victoria in Australia to identify suicides by people with a history of public-sector psychiatric service use who committed suicide between July 1, 1989, and June 30, 1994. Data on patient and treatment characteristics were examined by three experienced clinicians, who made judgments about whether the suicide could have been prevented had the service system responded differently. Quantitative and qualitative data were descriptively analyzed. Results: A total of 629 psychiatric patients who had committed suicide were identified. Seventy-two percent of the patients were male, 62 percent were under 40 years old, and 51 percent were unmarried. They had a range of disorders, with the most common being schizophrenia or schizoaffective disorder (36 percent). Sixty-seven percent had previously attempted suicide. A total of 311 patients (49 percent) received care within four weeks of death. Twenty percent of the suicides were considered preventable. Key factors associated with preventability were poor staff-patient relationships, incomplete assessments, poor assessment and treatment of depression and psychological problems, and poor continuity of care. Conclusions: Opportunities exist for the psychiatric service system to alter practices at several levels and thereby reduce patient suicides.