A Rule-based Skyline Computation over a dynamic database

Skyline query which relies on the notion of Pareto dominance filters the data items from a database by ensuring only those data items that are not worse than any others are selected as skylines. However, the dynamic nature of databases in which their states and/or structures change throughout their lifetime to incorporate the current and latest information of database applications, requires a new set of skylines to be derived. Blindly computing skylines on the new state/structure of a database is inefficient, as not all the data items are affected by the changes. Hence, this paper proposes a rule-based approach in tackling the above issue with the main aim at avoiding unnecessary skyline computations. Based on the type of operation that changes the state/structure of a database, i.e. insert/delete/update a data item(s) or add/remove a dimension(s), a set of rules are defined. Besides, the prominent dominance relationships when pairwise comparisons are performed are retained; which are then utilised in the process of computing a new set of skylines. Several analyses have been conducted to evaluate the performance and prove the efficiency of our proposed solution

Mortality and pulmonary complications in patients undergoing surgery with perioperative sars-cov-2 infection: An international cohort study

Background The impact of severe acute respiratory syndrome coronavirus 2 (SARS-CoV-2) on postoperative recovery needs to be understood to inform clinical decision making during and after the COVID-19 pandemic. This study reports 30-day mortality and pulmonary complication rates in patients with perioperative SARS-CoV-2 infection. Methods This international, multicentre, cohort study at 235 hospitals in 24 countries included all patients undergoing surgery who had SARS-CoV-2 infection confirmed within 7 days before or 30 days after surgery. The primary outcome measure was 30-day postoperative mortality and was assessed in all enrolled patients. The main secondary outcome measure was pulmonary complications, defined as pneumonia, acute respiratory distress syndrome, or unexpected postoperative ventilation. Findings This analysis includes 1128 patients who had surgery between Jan 1 and March 31, 2020, of whom 835 (740%) had emergency surgery and 280 (248%) had elective surgery. SARS-CoV-2 infection was confirmed preoperatively in 294 (261%) patients. 30-day mortality was 238% (268 of 1128). Pulmonary complications occurred in 577 (512%) of 1128 patients; 30-day mortality in these patients was 380% (219 of 577), accounting for 817% (219 of 268) of all deaths. In adjusted analyses, 30-day mortality was associated with male sex (odds ratio 175 [95% CI 128-240], p<00001), age 70 years or older versus younger than 70 years (230 [165-322], p<00001), American Society of Anesthesiologists grades 3-5 versus grades 1-2 (235 [157-353], p<00001), malignant versus benign or obstetric diagnosis (155 [101-239], p=0046), emergency versus elective surgery (167 [106-263], p=0026), and major versus minor surgery (152 [101-231], p=0047). Interpretation Postoperative pulmonary complications occur in half of patients with perioperative SARS-CoV-2 infection and are associated with high mortality. Thresholds for surgery during the COVID-19 pandemic should be higher than during normal practice, particularly in men aged 70 years and older. Consideration should be given for postponing non-urgent procedures and promoting non-operative treatment to delay or avoid the need for surgery. Funding National Institute for Health Research (NIHR), Association of Coloproctology of Great Britain and Ireland, Bowel and Cancer Research, Bowel Disease Research Foundation, Association of Upper Gastrointestinal Surgeons, British Association of Surgical Oncology, British Gynaecological Cancer Society, European Society of Coloproctology, NIHR Academy, Sarcoma UK, Vascular Society for Great Britain and Ireland, and Yorkshire Cancer Research

Mortality and pulmonary complications in patients undergoing surgery with perioperative SARS-CoV-2 infection: an international cohort study

Background: The impact of severe acute respiratory syndrome coronavirus 2 (SARS-CoV-2) on postoperative recovery needs to be understood to inform clinical decision making during and after the COVID-19 pandemic. This study reports 30-day mortality and pulmonary complication rates in patients with perioperative SARS-CoV-2 infection. Methods: This international, multicentre, cohort study at 235 hospitals in 24 countries included all patients undergoing surgery who had SARS-CoV-2 infection confirmed within 7 days before or 30 days after surgery. The primary outcome measure was 30-day postoperative mortality and was assessed in all enrolled patients. The main secondary outcome measure was pulmonary complications, defined as pneumonia, acute respiratory distress syndrome, or unexpected postoperative ventilation. Findings: This analysis includes 1128 patients who had surgery between Jan 1 and March 31, 2020, of whom 835 (74·0%) had emergency surgery and 280 (24·8%) had elective surgery. SARS-CoV-2 infection was confirmed preoperatively in 294 (26·1%) patients. 30-day mortality was 23·8% (268 of 1128). Pulmonary complications occurred in 577 (51·2%) of 1128 patients; 30-day mortality in these patients was 38·0% (219 of 577), accounting for 81·7% (219 of 268) of all deaths. In adjusted analyses, 30-day mortality was associated with male sex (odds ratio 1·75 [95% CI 1·28–2·40], p\textless0·0001), age 70 years or older versus younger than 70 years (2·30 [1·65–3·22], p\textless0·0001), American Society of Anesthesiologists grades 3–5 versus grades 1–2 (2·35 [1·57–3·53], p\textless0·0001), malignant versus benign or obstetric diagnosis (1·55 [1·01–2·39], p=0·046), emergency versus elective surgery (1·67 [1·06–2·63], p=0·026), and major versus minor surgery (1·52 [1·01–2·31], p=0·047). Interpretation: Postoperative pulmonary complications occur in half of patients with perioperative SARS-CoV-2 infection and are associated with high mortality. Thresholds for surgery during the COVID-19 pandemic should be higher than during normal practice, particularly in men aged 70 years and older. Consideration should be given for postponing non-urgent procedures and promoting non-operative treatment to delay or avoid the need for surgery. Funding: National Institute for Health Research (NIHR), Association of Coloproctology of Great Britain and Ireland, Bowel and Cancer Research, Bowel Disease Research Foundation, Association of Upper Gastrointestinal Surgeons, British Association of Surgical Oncology, British Gynaecological Cancer Society, European Society of Coloproctology, NIHR Academy, Sarcoma UK, Vascular Society for Great Britain and Ireland, and Yorkshire Cancer Research

Reducing the environmental impact of surgery on a global scale: systematic review and co-prioritization with healthcare workers in 132 countries

Abstract Background Healthcare cannot achieve net-zero carbon without addressing operating theatres. The aim of this study was to prioritize feasible interventions to reduce the environmental impact of operating theatres. Methods This study adopted a four-phase Delphi consensus co-prioritization methodology. In phase 1, a systematic review of published interventions and global consultation of perioperative healthcare professionals were used to longlist interventions. In phase 2, iterative thematic analysis consolidated comparable interventions into a shortlist. In phase 3, the shortlist was co-prioritized based on patient and clinician views on acceptability, feasibility, and safety. In phase 4, ranked lists of interventions were presented by their relevance to high-income countries and low–middle-income countries. Results In phase 1, 43 interventions were identified, which had low uptake in practice according to 3042 professionals globally. In phase 2, a shortlist of 15 intervention domains was generated. In phase 3, interventions were deemed acceptable for more than 90 per cent of patients except for reducing general anaesthesia (84 per cent) and re-sterilization of ‘single-use’ consumables (86 per cent). In phase 4, the top three shortlisted interventions for high-income countries were: introducing recycling; reducing use of anaesthetic gases; and appropriate clinical waste processing. In phase 4, the top three shortlisted interventions for low–middle-income countries were: introducing reusable surgical devices; reducing use of consumables; and reducing the use of general anaesthesia. Conclusion This is a step toward environmentally sustainable operating environments with actionable interventions applicable to both high– and low–middle–income countries

The Peripheral Versus Central Antinociception of a Novel Opioid Agonist: Acute Inflammatory Pain in Rats.

Opioid analgesics devoid of central side effects are unmet medical need in the treatment of acute pain (e.g. post-operative pain). Recently, we have reported on 14-O-methylmorphine-6-O-sulfate (14-O-MeM6SU), a novel opioid agonist of high efficacy producing peripheral antinociception in subchronic inflammatory pain in certain doses. The present study focused on the antinociceptive effect of 14-O-MeM6SU compared to morphine in formalin test of an early/acute (Phase I) and late/tonic (Phase II) pain phases. Subcutaneous 14-O-MeM6SU (253-1012 nmol/kg) and morphine (3884-31075 nmol/kg) dose dependently reduced the pain behaviors of both phases. Co-administered naloxone methiodide (NAL-M), a peripherally acting opioid antagonist, abolished the antinociceptive effect of 506 nmol/kg 14-O-MeM6SU. On the other hand, the effects of 14-O-MeM6SU (1012 nmol/kg) and morphine (15538 nmol/kg) were only partially affected by NAL-M, indicating the contribution of CNS to antinociception. Locally injected test compounds into formalin treated paws caused antinociception in both phases. Locally effective doses of test compounds were also injected into contralateral paws. Morphine showed effects in both phases, 14-O-MeM6SU in certain doses failed to produce antinociception in either phase. A NAL-M reversible systemic dose of 14-O-MeM6SU and the lowest systemic effective dose of morphine were evaluated for their sedative effects following isoflurane-induced sleeping (righting reflex). In contrast to morphine, 14-O-MeM6SU in certain antinociceptive doses showed no impact on sleeping time. These data highlight that high efficacy opioids of limited CNS penetration in certain doses mitigate somatic and inflammatory pain by targeting MOR at the periphery