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.

Enabling computer access: Introduction to the Test of Mouse Proficiency

As the use of technological devices in everyday environments becomes more prevalent, it is clear that access to these devices has become an important aspect of occupational performance. Children are increasingly required to competently manipulate technology such as the computer to fulfil occupational roles of student and player. Occupational therapists are in a position to facilitate the successful interface between children and standard computer technologies. The literature has supported the use of direct manipulation interfaces in computing that requires mastery of devices such as the mouse. Identification of children likely to experience difficulties with mouse use will inform the development of appropriate methods of intervention promoting mouse skill and further enhance participation in occupational tasks. The aim of this paper is to discuss the development of an assessment of mouse proficiency for children. It describes the construction of the assessment, the content of the test, and its content validity.

Fondaparinux verses enoxaparin for the prevention of venous thromboembelism

Venous thromboembolism is a frequent, life-threatening, postoperative complication of hip-fracture and total-knee-replacement surgery. Fondaparinux is a synthetic polysaccharide that selectively binds to antithrombin, the primary endogenous regulator of blood coagulation. Low molecular weight heparins, such as enoxaparin, are less specific inhibitors of coagulation. In patients undergoing hip-fracture surgery, fondaparinux is more effective than once-daily enoxaparin as prophylaxis for venous thromboembolism. Fondaparinux (25 mg/day s.c.) was also more effective than enoxaparin (30 mg s.c. b.i.d.) as prophylaxis for venous thromboembolism in elective knee surgery. These differences may be explained by the fact that there is less prophylaxis cover with enoxaparin, as it has a much shorter duration of action than fondaparinux. Thus, with the present dosing regimens, fondaparinux is probably preferable to enoxaparin for the prevention of venous thromboembolism.

Diabetes detection in Australian general practice: a comparison of diagnostic criteria

Objectives: To study the influence of different diagnostic criteria on the prevalence of diabetes mellitus and characteristics of those diagnosed. Design and setting: Retrospective analysis of data from the general-practice-based Australian Diabetes Screening Study (January 1994 to June 1995). Participants: 5911 people with no previous diagnosis of diabetes, two or more symptoms or risk factors for diabetes, a random venous plasma glucose (PG) level > 5.5 mmol/L and a subsequent oral glucose tolerance test (OGTT) result. Main outcome measure: Prevalence of undiagnosed diabetes based on each of three sets of criteria: 1997 criteria of the American Diabetes Association (ADA), 1996 two-step screening strategy of the Australian Diabetes Society (ADS) (modified according to ADA recommendations about lowered diagnostic fasting PG level), and 1999 definition of the World Health Organization (WHO). Results: Prevalence estimates for undiagnosed diabetes using the American (ADA), Australian (ADS) and WHO criteria (95% CI) were 9.4% (8.7%-10.1%), 16.0% (15.3%-16.7%) and 18.1% (17.1%-19.1%), respectively. People diagnosed with diabetes by fasting PG level (common to all sets of criteria) were more likely to be male and younger than those diagnosed only by 2 h glucose challenge PG level (Australian and WHO criteria only). The Australian (ADS) stepwise screening strategy detected 88% of those who met the WHO criteria for diabetes, including about three-quarters of those with isolated post-challenge hyperglycaemia. Conclusion: The WHO criteria (which include an OGTT result) are preferable to the American (ADA) criteria (which rely totally on fasting PG level), as the latter underestimated the prevalence of undiagnosed diabetes by almost a half. The Australian (ADS) strategy identified most of those diagnosed with diabetes by WHO criteria.

Use of a thermodilution catheter to measure core body temperature, central venous pressure and cardiac output during anaesthesia and surgery in the dog

The use of thermodilution and other methods of monitoring in dogs during surgery and critical care was evaluated. Six Greyhounds were anaesthetised and then instrumented by placing a thermodilution catheter into the pulmonary artery via the jugular vein. A catheter in the dorsal pedal artery also permitted direct measurement of arterial pressures. Core body temperature (degreesC) and central venous pressure (mmHg) were measured, while cardiac output (mL/min/kg) and mean arterial pressure (mmHg) were calculated. A mid-line surgical incision was performed and the physiological parameters were monitored for a total of two hours. All physiological parameters generally declined, although significant increases (P<0.05) were noted for cardiac output following surgical incision. Central venous pressure was maintained at approximately 0mmHg by controlling an infusion of sterile saline. Core body temperature decreased from 37.1+/-0.6degreesC (once instrumented) to 36.6+/-0.60degreesC (at the end of the study), despite warming using heating pads. Physiological parameters indicative of patient viability will generally decline during surgery without intervention. This study describes an approach that can be undertaken in veterinary hospitals to accurately monitor vital signs in surgical and critical care patients.

Parathyroid hormone venous sampling prior to reoperation for primary hyperparathyroidism

Background: The surgical cure rate for primary hyperparathyroidism is greater than 95%. For those who have recurrent or persistent disease, preoperative localization improves reoperation success rates. Selective parathyroid venous sampling (SPVS) for intact parathyroid hormone is particularly useful when non-invasive localization techniques are negative or inconclusive. Methods: We present all known cases (n = 13) between 1994 and 2002 who had venous sampling for localization at our institution prior to reoperation for recurrent or persistent primary hyperparathyroidism. Comparison was made with non-invasive localization procedures. Results of invasive and non-invasive localization were correlated with surgical findings. Results: Of the nine reoperated cases, eight had positive correlations between SPVS and operative findings and histopathology. SPVS did not reveal the parathyroid hormone source in one case with negative non-invasive localization procedures. Comparisons between SPVS, computerized tomography (CT), and parathyroid scintigraphy (MIBI) as expressed in terms of true positive (TP), false positive (FP) and false negative (FN) were: SPVS - TP 88.8%, FP 0%, FN 11.1%; CT - TP 22.2%, FP 22.2%, FN 55.5%; and MIBI - TP 33.3%, FP 0%, FN 66.6%. At least seven of the nine operated cases have been cured; another remained normocalcaemic 2 weeks after subtotal parathyroidectomy. Conclusion: In our institution SPVS has proven to be a valuable tool in cases with recurrent or persistent primary hyperparathyroidism and negative non-invasive localization procedures.

Effect of central venous catheter type on infections: a prospective clinical trial

This study reports on a block clinical trial of two types of central venous catheters (CVCs): antiseptic-impregnated catheters (AIC) and non-impregnated catheters (non-AIC), on catheter tip colonization and bacteraemia. In total, 500 catheters were inserted in 390 patients over the 18 month study period, 260 (52.0%) AIC and 240 (48.0%) non-AIC. Of these, 460 (92.0%) tips (237 AIC and 223 non-AIC) were collected. While significantly fewer AIC, 14 (5.9%), than non-AIC, 30 (13.5%), catheters were colonized (P < 0.01), there was no difference in the rates of bacteraemias in the two groups (0.8% vs. 2.7%, respectively, P = 0.16). There were 6.87 (95% CI 3.38-14.26) and 16.92 (95% CI 10.61-27.12) colonized AIC and non-AIC catheters, respectively, per 1000 catheter days, a difference that was significant (P < 0.01). However, no difference emerged between bacteraemias in AIC and non-AIC catheters per 1000 catheter days measured at 0.98 (95% CI 0.24-5.54) and 3.38 (95% CI 1.29-9.34), respectively (P = 0.10). Of the 444 CVCs that were sited in the subclavian or jugular veins and had tips collected, significantly more catheters were colonized in the jugular group, 19 (20%), compared with the subclavian group, 24 (6.9%; P less than or equal to 0.01). Overall, the low rates of colonization and bacteraemia may be explained by the population studied, the policies used and the employment of a clinical nurse dedicated to CVC management. (C) 2003 The Hospital Infection Society. Published by Elsevier Science Ltd. All rights reserved.