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.

Controlled partial mine ventiliation recirculation trial at Mount Isa Mines

The ventilation and cooling of deep, hot mines present particular problems in Australia as a consequence of the surface climate, the size of the underground voids, the degree of mechanization and the cost of power in remote areas. A preliminary investigation of the effects of controlled partial recirculation of air was conducted in Mount Isa Mines' Deep Copper section. Gas and dust concentrations were measured in the exhaust air of the major working section to assess the potential for recirculating exhaust air to the intake airways to reduce the cost of providing an acceptable working environment in the deep parts of the mine. Studies were undertaken of airborne dust deposition in vertical airways and the efficiency of usage of the ventilation air in diluting contaminants. It was established that 45% of the respirable dust was deposited in a 130-m vertical raise and 60% of the air supplied to the section could be reused or recirculated. The first major field trial of a controlled partial recirculation system in Australia was undertaken in the light of these results and demonstrated excellent potential for significant reduction in ventilation costs. Gas and dust contaminant levels were well below the threshold limit values during the trial. It is concluded that controlled partial recirculation can be a practical, effective and safe aid to normal ventilation practice in Australian deep, hot mines.

Estimating economic relationships subject to firm- and time-varying equality and inequality constraints

Applied econometricians often fail to impose economic regularity constraints in the exact form economic theory prescribes. We show how the Singular Value Decomposition (SVD) Theorem and Markov Chain Monte Carlo (MCMC) methods can be used to rigorously impose time- and firm-varying equality and inequality constraints. To illustrate the technique we estimate a system of translog input demand functions subject to all the constraints implied by economic theory, including observation-varying symmetry and concavity constraints. Results are presented in the form of characteristics of the estimated posterior distributions of functions of the parameters. Copyright (C) 2001 John Wiley Sons, Ltd.

A comparison of the lateral and posterior retroperitoneoscopic approach for complete and partial nephroureterectomy in children

Objective To report the comparative results of a selective posterior or lateral retroperitoneoscopic approach (RPA) for nephroureterectomy in children. Patients and methods Following an established experience with RPA, 36 complete and 19 partial nephrouretectomies were prospectively randomized to a posterior and lateral retroperitoneoscopic approach. The patients were aged 4 months to 14 years, with a body weight at operation of 5.7-82 kg. For posterior RPA the child is positioned prone, with three access ports. The operating space was created with balloon dissection and maintained with CO2 insufflation. The child was then rotated 30 degrees with the kidney in the dependent position, and the operator and assistant standing on the affected side. In the lateral approach the child is in the lateral decubitus position with the operator and assistant facing the dorsal aspect of the patient. Results There was no significant difference in operative duration between the lateral and posterior approaches for nephrectomy (65 and 47 min) or partial nephrectomy (85 and 75 min). Two lateral nephrectomies required open conversion (one upper pole and one lower pole). Conclusion The posterior approach gives easy and quick access to the renal pedicle. It is preferable for complete nephrectomy alone and partial or polar excision. In children under 5 years old a near complete ureterectomy can be achieved. The lateral approach creates more inferomedial space, gives better access to ectopic kidneys and allows complete ureterectomy in all cases, Access to the pedicle in the normal position requires more frequent positioning of the kidney. Care must be taken as peritoneal tears are more common.

Time of treatment influences the appearance of drug-resistant parasites in Plasmodium falciparum infections

A deterministic mathematical model which predicts the probability of developing a new drug-resistant parasite population within the human host is reported, The model incorporates the host's specific antibody response to PfEMP1, and also investigates the influence of chemotherapy on the probability of developing a viable drug-resistant parasite population within the host. Results indicate that early, treatment, and a high antibody threshold coupled with a long lag time between antibody stimulation and activity, are risk factors which increase the likelihood of developing a viable drug-resistant parasite population. High parasite mutation rates and fast PfEMP1 var gene switching are also identified as risk factors. The model output allows the relative importance of the various risk factors as well as the relationships between them to be established, thereby increasing the understanding of the conditions which favour the development of a new drug-resistant parasite population.

Preprocessing and time-frequency analysis of newborn EEG seizures

Neurological disease or dysfunction in newborn infants is often first manifested by seizures. Prolonged seizures can result in impaired neurodevelopment or even death. In adults, the clinical signs of seizures are well defined and easily recognized. In newborns, however, the clinical signs are subtle and may be absent or easily missed without constant close observation. This article describes the use of adaptive signal processing techniques for removing artifacts from newborn electroencephalogram (EEG) signals. Three adaptive algorithms have been designed in the context of EEG signals. This preprocessing is necessary before attempting a fine time-frequency analysis of EEG rhythmical activities, such as electrical seizures, corrupted by high amplitude signals. After an overview of newborn EEG signals, the authors describe the data acquisition set-up. They then introduce the basic physiological concepts related to normal and abnormal newborn EEGs and discuss the three adaptive algorithms for artifact removal. They also present time-frequency representations (TFRs) of seizure signals and discuss the estimation and modeling of the instantaneous frequency related to the main ridge of the TFR.

Effect of gender on ownership and income in veterinary practice

Objective To estimate the effect of gender on ownership and income in veterinary practice in Australia. Methods Questionnaire completed by private veterinary practitioners, and analysed using the SAS System for Windows 7.0. Results More than three-quarters (78%) of male but 36% of female private practitioners were partial or sole owners of practices. The median annual income for all male practitioners working more than 40 hours/week was $70K, but that for females was $43K. These disparities existed in both city and country practices, and in the case of income it increased with increasing time in the workforce. Male practice owners also reported higher incomes than female owners. Conclusions Female veterinary practitioners are less likely to own practices, and more likely to earn low incomes than males. These differentials do not appear to be due to location, hours worked or years since graduation or, in the case of income, to whether they are owners or employees. The evidence points to a lower interest by women than men in the business aspects of veterinary practice.

A segmentation-based and partial-volume-compensated method for an accurate measurement of lateral ventricular volumes on T-1-weighted magnetic resonance images

Lateral ventricular volumes based on segmented brain MR images can be significantly underestimated if partial volume effects are not considered. This is because a group of voxels in the neighborhood of lateral ventricles is often mis-classified as gray matter voxels due to partial volume effects. This group of voxels is actually a mixture of ventricular cerebro-spinal fluid and the white matter and therefore, a portion of it should be included as part of the lateral ventricular structure. In this note, we describe an automated method for the measurement of lateral ventricular volumes on segmented brain MR images. Image segmentation was carried in combination of intensity correction and thresholding. The method is featured with a procedure for addressing mis-classified voxels in the surrounding of lateral ventricles. A detailed analysis showed that lateral ventricular volumes could be underestimated by 10 to 30% depending upon the size of the lateral ventricular structure, if mis-classified voxels were not included. Validation of the method was done through comparison with the averaged manually traced volumes. Finally, the merit of the method is demonstrated in the evaluation of the rate of lateral ventricular enlargement. (C) 2001 Elsevier Science Inc. All rights reserved.

An aggregate sales model for consumer durables incorporating a time-varying mean replacement age

Forecasting category or industry sales is a vital component of a company's planning and control activities. Sales for most mature durable product categories are dominated by replacement purchases. Previous sales models which explicitly incorporate a component of sales due to replacement assume there is an age distribution for replacements of existing units which remains constant over time. However, there is evidence that changes in factors such as product reliability/durability, price, repair costs, scrapping values, styling and economic conditions will result in changes in the mean replacement age of units. This paper develops a model for such time-varying replacement behaviour and empirically tests it in the Australian automotive industry. Both longitudinal census data and the empirical analysis of the replacement sales model confirm that there has been a substantial increase in the average aggregate replacement age for motor vehicles over the past 20 years. Further, much of this variation could be explained by real price increases and a linear temporal trend. Consequently, the time-varying model significantly outperformed previous models both in terms of fitting and forecasting the sales data. Copyright (C) 2001 John Wiley & Sons, Ltd.

Sequestration of carbon by soil

Soil carbon is a major component of the terrestrial carbon cycle. The soils of the world contain more carbon than the combined total amounts occurring in vegetation and the atmosphere. Consequently, soils are a major reservoir of carbon and an important sink. Because of the relatively long period of time that carbon spends within the soil and is thereby withheld from the atmosphere, it is often referred to as being sequestered. Increasing the capacity of soils to sequester C provides a partial, medium-term countermeasure to help ameliorate the increasing CO2 levels in the atmosphere arising from fossil fuel burning and land clearing. Such action will also help to alleviate the environmental impacts arising from increasing levels of atmospheric CO2. The C sequestration potential of any soil depends on its capacity to store resistant plant components in the medium term and to protect and accumulate the humic substances (HS) formed from the transformations or organic materials in the soil environment. The sequestration potential of a soil depends on the vegetation it supports, its mineralogical composition, the depth of the solum, soil drainage, the availability of water and air, and the temperature of the soil environment. The sequestration potential also depends on the chemical characteristics of the soil organic matter and its ability to resist microbial decomposition. When accurate information for these features is incorporated in model systems, the potentials of different soils to sequester C can be reliably predicted. It is encouraging to know that improved soil and crop management systems now allow field yields to be maintained and soil C reserves to be increased, even for soils with depleted levels of soil C. Estimates of the soil C sequestration potential are discussed. Inevitably HS are the major components of the additionally sequestered C. It will be important to know more about the compositions and associations of these substances in the soil if we are able to predict reasonably accurately the ability of any soil type to sequester C in different cropping and soil management systems.