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.

Critical cyber pedagogy: Doing multiliteracies in the Singapore classrooms

The Ministry of Education in Singapore has embarked on the ambitious project of introducing IT in schools. The IT Masterplan, budgeted at a cost of $2 billion, aims to wire up all schools by the year 2002. While the well-funded IT Masterplan is seeing the project in its final phase of implementation, this paper argues for a "critical cyber pedagogy" along with the acquisition of the functional and operational skills of technology. Drawing on theories of critical multiliteracies (Burbules & Callister, 2000; Luke, 2000b; New London Group, 1996), this paper explores and suggests how an instructional design of two classroom activities can be utilized as new forms of cyber and technoliteracies. Through the critical evaluation of websites and hypertext construction, students will be equipped with a new literacy that extends reading and writing by incorporating new blended forms of hybrid textualities. This technology-assisted pedagogy can achieve the desired outcome of self-directed learning, teamwork, critical thinking and problem solving strategies necessary for a knowledge-based society.

A dynamic model with on-line identification for rotary sugar drying processes

A dynamic modelling methodology, which combines on-line variable estimation and parameter identification with physical laws to form an adaptive model for rotary sugar drying processes, is developed in this paper. In contrast to the conventional rate-based models using empirical transfer coefficients, the heat and mass transfer rates are estimated by using on-line measurements in the new model. Furthermore, a set of improved sectional solid transport equations with localized parameters is developed in this work to reidentified on-line using measurement data, the model is able to closely track the dynamic behaviour of rotary drying processes within a broad range of operational conditions. This adaptive model is validated against experimental data obtained from a pilot-scale rotary sugar dryer. The proposed modelling methodology can be easily incorporated into nonlinear model based control schemes to form a unified modelling and control framework.place the global correlation for the computation of solid retention time. Since a number of key model variables and parameters are identified on-line using measurement data, the model is able to closely track the dynamic behaviour of rotary drying processes within a broad range of operational conditions. This adaptive model is validated against experimental data obtained from a pilot-scale rotary sugar dryer. The proposed modelling methodology can be easily incorporated into nonlinear model based control schemes to form a unified modelling and control framework.

Hydraulic Performances of Minimum Energy Loss Culverts in Australia

Culverts are among the most common hydraulic structures. Modern designs do not differ from ancient structures and are often characterised by significant afflux at design flows. A significant advance was the development of the Minimum Energy Loss (MEL) culverts in the late 1950s. The design technique allows a drastic reduction in upstream flooding associated with lower costs. The development and operational performances of this type of structure is presented. The successful operation of MEL culverts for more than 40 years is documented with first-hand records during and after floods. The experiences demonstrate the design soundness while highlighting the importance of the hydraulic expertise of the design engineers.

Supervisory control of wastewater treatment plants by combining principal component analysis and fuzzy c-means clustering

In this paper a methodology for integrated multivariate monitoring and control of biological wastewater treatment plants during extreme events is presented. To monitor the process, on-line dynamic principal component analysis (PCA) is performed on the process data to extract the principal components that represent the underlying mechanisms of the process. Fuzzy c-means (FCM) clustering is used to classify the operational state. Performing clustering on scores from PCA solves computational problems as well as increases robustness due to noise attenuation. The class-membership information from FCM is used to derive adequate control set points for the local control loops. The methodology is illustrated by a simulation study of a biological wastewater treatment plant, on which disturbances of various types are imposed. The results show that the methodology can be used to determine and co-ordinate control actions in order to shift the control objective and improve the effluent quality.

A generalised dynamic model for char particle gasification with structure evolution and peripheral fragmentation

A generalised model for the prediction of single char particle gasification dynamics, accounting for multi-component mass transfer with chemical reaction, heat transfer, as well as structure evolution and peripheral fragmentation is developed in this paper. Maxwell-Stefan analysis is uniquely applied to both micro and macropores within the framework of the dusty-gas model to account for the bidisperse nature of the char, which differs significantly from the conventional models that are based on a single pore type. The peripheral fragmentation and random-pore correlation incorporated into the model enable prediction of structure/reactivity relationships. The occurrence of chemical reaction within the boundary layer reported by Biggs and Agarwal (Chem. Eng. Sci. 52 (1997) 941) has been confirmed through an analysis of CO/CO2 product ratio obtained from model simulations. However, it is also quantitatively observed that the significance of boundary layer reaction reduces notably with the reduction of oxygen concentration in the flue gas, operational pressure and film thickness. Computations have also shown that in the presence of diffusional gradients peripheral fragmentation occurs in the early stages on the surface, after which conversion quickens significantly due to small particle size. Results of the early commencement of peripheral fragmentation at relatively low overall conversion obtained from a large number of simulations agree well with experimental observations reported by Feng and Bhatia (Energy & Fuels 14 (2000) 297). Comprehensive analysis of simulation results is carried out based on well accepted physical principles to rationalise model prediction. (C) 2001 Elsevier Science Ltd. AH rights reserved.

Sludge population optimisation: a new dimension for the control of biological wastewater treatment systems

The activated sludge comprises a complex microbiological community. The structure (what types of microorganisms are present) and function (what can the organisms do and at what rates) of this community are determined by external physico -chemical features and by the influent to the sewage treatment plant. The external features we can manipulate but rarely the influent. Conventional control and operational strategies optimise activated sludge processes more as a chemical system than as a biological one. While optimising the process in a short time period, these strategies may deteriorate the long-term performance of the process due to their potentially adverse impact on the microbial properties. Through briefly reviewing the evidence available in the literature that plant design and operation affect both the structure and function of the microbial community in activated sludge, we propose to add sludge population optimisation as a new dimension to the control of biological wastewater treatment systems. We stress that optimising the microbial community structure and property should be an explicit aim for the design and operation of a treatment plant. The major limitations to sludge population optimisation revolve around inadequate microbiological data, specifically community structure, function and kinetic data. However, molecular microbiological methods that strive to provide that data are being developed rapidly. The combination of these methods with the conventional approaches for kinetic study is briefly discussed. The most pressing research questions pertaining to sludge population optimisation are outlined. (C) 2002 Elsevier Science Ltd. All rights reserved.

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.

Design, development, and testing of X-band amplifying reflectarrays

The design and development of two X-band amplifying reflectarrays is presented. The arrays use dual-polarized aperture coupled patch antennas with FET transistors and phasing circuits to amplify a microwave signal and to radiate it in a chosen direction. Two cases are considered, one when a reflectarray converts a spherical wave due to a feed horn into a plane wave radiated into a boresight direction, and two, when the reflectarray converts a spherical wave due to a dual-polarized four-element feed array into a co-focal spherical wave. This amplified signal is received in an orthogonal port of the feed array so that the entire structure acts as a spatial power combiner. The two amplifying arrays are tested in the near-field zone for phase distribution over their apertures to achieve the required beam formation. Alternatively, their radiation patterns or gains are investigated.

Glycogen-accumulating organisms in laboratory-scale and full scale wastewater treatment processes

Laboratory-scale sequencing batch reactors (SBRs) as models for wastewater treatment processes were used to identify glycogen-accumulating organisms (GAOs), which are thought to be responsible for the deterioration of enhanced biological phosphorus removal (EBPR). The SBRs (called Q and T), operated under alternating anaerobic-aerobic conditions typical for EBPR, generated mixed microbial communities (sludges) demonstrating the GAO phenotype. Intracellular glycogen and poly-beta-hydroxyalkanoate (PHA) transformations typical of efficient EBPR occurred but polyphosphate was not bioaccumulated and the sludges contained 1.8% P (sludge Q) and 1.5% P (sludge T). 16S rDNA clone libraries were prepared from DNA extracted from the Q and T sludges. Clone inserts were grouped into operational taxonomic units (OTUs) by restriction fragment length polymorphism banding profiles. OTU representatives were sequenced and phylogenetically analysed. The Q sludge library comprised four OTUs and all six determined sequences were 99.7% identical, forming a cluster in the gamma-Proteobacteria radiation. The T sludge library comprised eight OTUs and the majority of clones were Acidobacteria subphylum 4 (49% of the library) and candidate phylum OPU (39% of the library). One OTU (two clones, of which one was sequenced) was in the gamma-Proteobacteria radiation with 95% sequence identity to the Q sludge clones. Oligonucleotide probes (called GAOQ431 and GAOQ989) were designed from the gamma-Proteobacteria clone sequences for use in fluorescence in situ hybridization (FISH); 92 % of the Q sludge bacteria and 28 % of the T sludge bacteria bound these probes in FISH. FISH and post-FISH chemical staining for PHA were used to determine that bacteria from a novel gamma-Proteobacteria cluster were phenotypically GAOs in one laboratory-scale SBR and two fullscale wastewater treatment plants. It is suggested that the GAOs from the novel cluster in the gamma-Proteobacteria radiation be named 'Candidatus Competibacter phosphatis'.

Development of a novel titration and off-gas analysis (TOGA) sensor for study of biological processes in wastewater treatment systems

The development of the new TOGA (titration and off-gas analysis) sensor for the detailed study of biological processes in wastewater treatment systems is outlined. The main innovation of the sensor is the amalgamation of titrimetric and off-gas measurement techniques. The resulting measured signals are: hydrogen ion production rate (HPR), oxygen transfer rate (OTR), nitrogen transfer rate (NTR), and carbon dioxide transfer rate (CTR). While OTR and NTR are applicable to aerobic and anoxic conditions, respectively, HPR and CTR are useful signals under all of the conditions found in biological wastewater treatment systems, namely, aerobic, anoxic and anaerobic. The sensor is therefore a powerful tool for studying the key biological processes under all these conditions. A major benefit from the integration of the titrimetric and off-gas analysis methods is that the acid/base buffering systems, in particular the bicarbonate system, are properly accounted for. Experimental data resulting from the TOGA sensor in aerobic, anoxic, and anaerobic conditions demonstrates the strength of the new sensor. In the aerobic environment, carbon oxidation (using acetate as an example carbon source) and nitrification are studied. Both the carbon and ammonia removal rates measured by the sensor compare very well with those obtained from off-line chemical analysis. Further, the aerobic acetate removal process is examined at a fundamental level using the metabolic pathway and stoichiometry established in the literature, whereby the rate of formation of storage products is identified. Under anoxic conditions, the denitrification process is monitored and, again, the measured rate of nitrogen gas transfer (NTR) matches well with the removal of the oxidised nitrogen compounds (measured chemically). In the anaerobic environment, the enhanced biological phosphorus process was investigated. In this case, the measured sensor signals (HPR and CTR) resulting from acetate uptake were used to determine the ratio of the rates of carbon dioxide production by competing groups of microorganisms, which consequently is a measure of the activity of these organisms. The sensor involves the use of expensive equipment such as a mass spectrometer and requires special gases to operate, thus incurring significant capital and operational costs. This makes the sensor more an advanced laboratory tool than an on-line sensor. (C) 2003 Wiley Periodicals, Inc.

A hedging point strategy - balancing effluent quality, economy and robustness in the control of wastewater treatment plants

An operational space map is an efficient tool to compare a large number of operational strategies to find an optimal choice of setpoints based on a multicriterion. Typically, such a multicriterion includes a weighted sum of cost of operation and effluent quality. Due to the relative high cost of aeration such a definition of optimality result in a relatively high fraction of the effluent total nitrogen in the form of ammonium. Such a strategy may however introduce a risk into operation because a low degree of ammonium removal leads to a low amount of nitrifiers. This in turn leads to a reduced ability to reject event disturbances, such as large variations in the ammonium load, drop in temperature, the presence of toxic/inhibitory compounds in the influent etc. Hedging is a risk minimisation tool, with the aim to "reduce one's risk of loss on a bet or speculation by compensating transactions on the other side" (The Concise Oxford Dictionary (1995)). In wastewater treatment plant operation hedging can be applied by choosing a higher level of ammonium removal to increase the amount of nitrifiers. This is a sensible way to introduce disturbance rejection ability into the multi criterion. In practice, this is done by deciding upon an internal effluent ammonium criterion. In some countries such as Germany, a separate criterion already applies to the level of ammonium in the effluent. However, in most countries the effluent criterion applies to total nitrogen only. In these cases, an internal effluent ammonium criterion should be selected in order to secure proper disturbance rejection ability.

A framework for extreme-event control in wastewater treatment

In this paper an approach to extreme event control in wastewater treatment plant operation by use of automatic supervisory control is discussed. The framework presented is based on the fact that different operational conditions manifest themselves as clusters in a multivariate measurement space. These clusters are identified and linked to specific and corresponding events by use of principal component analysis and fuzzy c-means clustering. A reduced system model is assigned to each type of extreme event and used to calculate appropriate local controller set points. In earlier work we have shown that this approach is applicable to wastewater treatment control using look-up tables to determine current set points. In this work we focus on the automatic determination of appropriate set points by use of steady state and dynamic predictions. The performance of a relatively simple steady-state supervisory controller is compared with that of a model predictive supervisory controller. Also, a look-up table approach is included in the comparison, as it provides a simple and robust alternative to the steady-state and model predictive controllers, The methodology is illustrated in a simulation study.

Dual mode cooling house in the warm humid tropics

Passive techniques as an alternative to artificial cooling can bring important energy, environmental, financial, operational and qualitative benefits. However, regions such as the wet tropics can reach high levels of thermal stress in which passive means alone are unable to provide appropriate thermal comfort standards for some parts of the year. Despite a great accumulation of empirical information on the passive performance of houses for either free-running or conditioned modes, very little work has been done on the thermal performance of buildings that can operate with a mixed-running strategy in warm-humid climates. Buildings with such design features are able to balance the needs for comfort, privacy, and energy efficiency during different periods of the year. As free-running and conditioned modes are believed by many to be 'opposite' approaches, and have been presented as separate strategies, this paper demonstrates that not all parameters are directly opposite and a possible dual-mode integrated operation can be used for warm-humid locations for maximum comfort and minimum energy requirements. For this purpose, simulation runs using ESP-R (University of Strathclyde, ESRU, UK) were based on the climate data of Darwin (Australia) and on the ventilation styles of the house: free running and conditioned. Design features applicable to both, i.e. for a dual mode operation could be identified and the differences between conditioned and free running were demonstrated and proved not to be totally conflicting and therefore suitable for a dual mode operation. Different daily usage profiles (five use patterns were defined), and zoning of sleeping and living areas are presented. The dual mode use patterns compared to the base case house, for all the user possibilities, had improved performances of 17-52%, when compared to the free-running mode and 66-98% when compared to the conditioned mode. Simulation runs using other warm-humid climates (Miami, USA; Sao Luis, Brazil; Kuala Lumpur, Malaysia) were also conducted and compared to the results found for Darwin. (C) 2002 Elsevier Science Ltd. All rights reserved.

A review of guidelines and standards for telemedicine

We conducted a review to establish the range and scope of current telemedicine guidelines and standards. Published guidelines were identified by searching the Medline and Telemedicine Information Exchange (TIE) databases, and by performing a Google search using the term 'telemedicine guidelines'. Three types of guidelines were identified, namely clinical, operational and technical. Clinical guidelines included those for teleradiology, telepsychiatry, home telenursing, minor injuries telemedicine, surgical telemedicine, teledermatology and telepathology. Operational guidelines included those for email communication, Internet access and videoconferencing. Technical guidelines included those from the American Telemedicine Association and the US Office for the Advancement of Telehealth. The main standards relevant to telemedicine include those of the International Telecommunication Union and the DICOM standard. The scarcity of guidelines and standards suggests that telemedicine is not yet near to routine use. If an international telemedicine organization were to take responsibility for defining guidelines, under the direction of clinicians with appropriate telemedicine experience, this might speed up their development.