Materialized view selection under the maintenance time constraint

A data warehouse is a data repository which collects and maintains a large amount of data from multiple distributed, autonomous and possibly heterogeneous data sources. Often the data is stored in the form of materialized views in order to provide fast access to the integrated data. One of the most important decisions in designing a data warehouse is the selection of views for materialization. The objective is to select an appropriate set of views that minimizes the total query response time with the constraint that the total maintenance time for these materialized views is within a given bound. This view selection problem is totally different from the view selection problem under the disk space constraint. In this paper the view selection problem under the maintenance time constraint is investigated. Two efficient, heuristic algorithms for the problem are proposed. The key to devising the proposed algorithms is to define good heuristic functions and to reduce the problem to some well-solved optimization problems. As a result, an approximate solution of the known optimization problem will give a feasible solution of the original problem. (C) 2001 Elsevier Science B.V. All rights reserved.

An easy and reliable method for establishment and maintenance of leaf and root cell cultures of Arabidopsis thaliana

Cell suspension cultures are useful for a wide range of biochemical and physiological studies, yet their production can be technically demanding and often unreliable. Here we describe a protocol for producing Arabidopsis cell suspension cultures that is reliable and easy to use.

Energy cost of physical activity in cystic fibrosis

Objective: The purpose of this study was to compare the energy cost of standardized physical activity (ECA) between patients with cystic fibrosis (CF) and healthy control subjects. Design: Cross-sectional study using patients with CF and volunteers from the community. Setting: University laboratory. Subjects: Fifteen patients (age 24.6 +/- 4.6 y) recruited with consent from their treating physician and 16 healthy control subjects (age 25.3 +/- 3.2) recruited via local advertisement. Interventions. Patients and controls walked on a computerised treadmill at 1.5 km/h for 60 min followed by a 60 min recovery period and, on a second occasion, cycled at 0.5 kp (kilopond), 30 rpm followed by a 60 min recovery. The ECA was measured via indirect calorimetry. Resting energy expenditure (REE), nutritional status, pulmonary function and genotype were determined. Results: The REE in patients was significantly greater than the REE measured in controls (P = 0.03) and was not related to the severity of lung disease or genotype. There was a significant difference between groups when comparing the ECA for walking kg root FFM (P = 0.001) and cycling kg root FFM (P = 0.04). The ECA for each activity was adjusted (ECA(adj)) for the contribution of REE (ECA kJ kg root FFM 120 min(-1) - REE kJ kg root FFM 120 min(-1)). ECA(adj) revealed a significant difference between groups for the walking protocol (P = 0.001) but no difference for the cycling protocol (P = 0.45). This finding may be related to the fact that the work rate during walking was more highly regulated than during cycling. Conclusions ECA in CF is increased and is likely to be explained by an additional energy-requiring component related to the exercise itself and not an increased REE. Sponsorship. The Prince Charles Hospital Foundation; MLR was in receipt of a QUTPRA Scholarship.

Energy cost of activity assessed by indirect calorimetry and a (CO2)-C-13 breath test

Purpose: The aim of this study was to assess the accuracy of a (CO2)-C-13 breath test for the prediction of short-duration energy expenditure. Methods: Eight healthy volunteers walked at 1.5 km.h(-1) for 60 min followed by 60-min recovery. During this time, the energy cost of physical activity was measured via respiratory calorimetry and a C-13 bicarbonate breath test. A further eight subjects were tested using the same two methods during a 60-min cycle at 0.5 kp. 30 ipm followed by a 60-min recovery. The rate of appearance of (CO2)-C-13, (RaCO2) was measured and the mean ratio, (V) over dot CO2/RaCO2 was used to calculate energy expenditure using the isotopic approach. Results: As would be expected, there was a significant difference in the energy cost of walking and cycling using both methods (P < 0.05). However. no significant differences were observed between respiratory calorimetry and the isotope method for measurement of energy expenditure while walking or cycling. Conclusions: These data suggest that the C-13 breath test is a valid method that can be used to measure the energy cost of short duration physical activity in a field setting.

Cost of malaria control in China: Henan's consolidation programme from community and government perspectives

Objective To assist with strategic planning for the eradication,of malaria in Henan Province, China, which reached the consolidation phase of malaria control in 1992, when only 318 malaria cases were reported, Methods We conducted a prospective two-year study of the costs for Henan's malaria control programme. We used a cost model that could also be applied to other malaria programmes in-mainland China, and analysed the cost of the three components of Henan's malaria programme. suspected malaria case management,, vector surveillance,,and population blood surveys. Primary cost data were collected from the government, and data on suspected malaria patient's were collected in two malaria counties (population 2 093 100). We enlisted the help of 260 village doctors. in six-townships or former communities (population 247 762), and studied all 12 315 reported cases of suspected malaria in catchment areas in 1994 and 1995. Findings The average-annual government investment in malaria control was estimated to be US$ 111 516 (case-management 59%; active blood surveys 25%;vector surveillance 12%; and contingencies and special projects 4%). The average cost (direct and indirect) for-patients seeking-treatment for suspected malaria was US$ 3.48, equivalent,to 10 days' income for rural residents. Each suspected malaria case cost the government an, average of US$ 0.78. Conclusion Further cuts in government funding will increase future costs, when epidemic malaria returns; investment in malaria control should therefore continue at least at current levels,of US$ 0.03 per person a risk.

A model of factors affecting an information system's change in state

Management are keen to maximize the life span of an information system because of the high cost, organizational disruption, and risk of failure associated with the re-development or replacement of an information system. This research investigates the effects that various factors have on an information system's life span by understanding how the factors affect an information system's stability. The research builds on a previously developed two-stage model of information system change whereby an information system is either in a stable state of evolution in which the information system's functionality is evolving, or in a state of revolution, in which the information system is being replaced because it is not providing the functionality expected by its users. A case study surveyed a number of systems within one organization. The aim was to test whether a relationship existed between the base value of the volatility index (a measure of the stability of an information system) and certain system characteristics. Data relating to some 3000 user change requests covering 40 systems over a 10-year period were obtained. The following factors were hypothesized to have significant associations with the base value of the volatility index: language level (generation of language of construction), system size, system age, and the timing of changes applied to a system. Significant associations were found in the hypothesized directions except that the timing of user changes was not associated with any change in the value of the volatility index. Copyright (C) 2002 John Wiley Sons, Ltd.

Technical, allocative, cost and scale efficiencies in Bangladesh rice cultivation: A non-parametric approach

Applying programming techniques to detailed data for 406 rice farms in 21 villages, for 1997, produces inefficiency measures, which differ substantially from the results of simple yield and unit cost measures. For the Boro (dry) season, mean technical efficiency was efficiency was 56.2 per cent and 69.4 per cent, allocative efficiency was 81.3 per cent, cost efficiency was 56.2 per cent and scale efficiency 94.9 per cent. The Aman (wet) season results are similar, but a few points lower. Allocative inefficiency is due to overuse of labour, suggesting population pressure, and of fertiliser, where recommended rates may warrant revision. Second-stage regressions show that large families are more inefficient, whereas farmers with better access to input markets, and those who do less off-farm work, tend to be more efficient. The information on the sources of inter-farm performance differentials could be used by the extension agents to help inefficient farmers. There is little excuse for such sub-optimal use of survey data, which are often collected at substantial costs.

High-performance L-band series and parallel switches using low-cost p-i-n diodes

Low-cost UHF-band p-i-n diodes are used to develop high-performance L-band series and parallel switches. To stop the rectification of large RF, signals, the diodes are biased at a large reverse-bias voltage. Parasitic elements of the diodes are tuned out using LC circuits in biasing circuits without increasing the size of the switches. (C) 2002 John Wiley Sons, Inc.

Strategic maintenance management

The approach to maintenance management has changed over the last one hundred years. Over the last few years, the Reliability Engineering and Risk Management Group (RERMG) at the University of Queensland has developed an approach called the strategic maintenance management (SMM) approach. The paper outlines the approach and contrasts it with the current approaches. It then discusses the industry-university partnership in the implementation of this approach and the current activities at the University of Queensland to assist industry in the implementation of the SMM approach.

New product warranty: A literature review

Warranty is an important element of marketing new products as better warranty signals higher product quality and provides greater assurance to customers. Servicing warranty involves additional costs to the manufacturer and this cost depends on product reliability and warranty terms. Product reliability is influenced by the decisions made during the design and manufacturing of the product. As such warranty is very important in the context of new products. Product warranty has received the attention of researchers from many different disciplines and the literature on warranties is vast. This paper carries out a review of the literature that has appeared in the last ten years. It highlights issues of interest to manufacturers in the context of managing new products from an overall business perspective. (C) 2002 Elsevier Science B.V. All rights reserved.

High dependency units: Issues to consider in their planning

This review discusses the issues to be considered in establishing new or extending existing high dependency unit (HDU) services. A defined high dependency service becomes cost-effective when patient care requires more than one nurse for three patients. Professional guidelines for HDUs vary and there are no national accreditation criteria. Casemix and service delivery specifications for the HDU need to be defined and agreed upon within the institution. Establishing a new HDU service requires changes to care delivery. Many potential HDU patients are currently managed in general wards or in the intensive care unit. The service should be discussed widely and marketed within the institution, and the development of defined working relationships with the ICU and primary care teams oil the wards is mandatory.

Who does not gain weight? Prevalence and predictors of weight maintenance in young women

OBJECTIVE: To investigate the prevalence and predictors of weight maintenance over time in a large sample of young Australian women. DESIGN: This population study examined baseline and 4y follow-up data from the cohort of young women participating in the Australian Longitudinal Study on Women's Health. SUBJECTS: A total of 8726 young women aged 18 - 23y at baseline. MEASURES: Height, weight and body mass index (BMI); physical activity; time spent sitting; selected eating behaviours (eg dieting, disordered eating, takeaway food consumption); cigarette smoking, alcohol consumption; parity; and socio-demographic characteristics. RESULTS: Only 44% of the women reported their BMI at follow-up to be within 5% of their baseline BMI (maintainers); 41% had gained weight and 15% had lost weight. Weight maintainers were more likely to be in managerial or professional occupations; to have never married; to be currently studying; and not to be mothers. Controlling for sociodemographic factors, weight maintainers were more likely to be in a healthy weight range at baseline, and to report that they spent less time sitting, and consumed less takeaway food, than women who gained weight. CONCLUSIONS: Fewer than half the young women in this community sample maintained their weight over this 4y period in their early twenties. Findings of widespread weight gain, particularly among those already overweight, suggest that early adulthood, which is a time of significant life changes for many women, may be an important time for implementing strategies to promote maintenance of healthy weight. Strategies which encourage decreased sitting time and less takeaway food consumption may be effective for encouraging weight maintenance at this life stage.