Ontology and Hyper Graph Based Dashboards in Data Warehousing Systems

Abstract — Analytical and computational requirements are increasing in data warehousing systems. So it is very crucial to identify semantically equivalent data, linking them and discovering structural dependencies. This can be performed using dashboards. Dynamic dashboard will perform the customization of information for specific need of user. And we are using an improved method for dashboard development using hyper graph approach and ontology exploration. Existing dashboard design satisfies given user query and provides flexibility in changing user interactions. In this paper a quick specification of dashboard interfaces is obtained for detailed DB (data base) query language where semantics of user interaction is in a declarative manner

Respiratory support in patients with severe COVID-19 in the International Severe Acute Respiratory and Emerging Infection (ISARIC) COVID-19 study: a prospective, multinational, observational study

Background: Up to 30% of hospitalised patients with COVID-19 require advanced respiratory support, including high-flow nasal cannulas (HFNC), non-invasive mechanical ventilation (NIV), or invasive mechanical ventilation (IMV). We aimed to describe the clinical characteristics, outcomes and risk factors for failing non-invasive respiratory support in patients treated with severe COVID-19 during the first two years of the pandemic in high-income countries (HICs) and low middle-income countries (LMICs). Methods: This is a multinational, multicentre, prospective cohort study embedded in the ISARIC-WHO COVID-19 Clinical Characterisation Protocol. Patients with laboratory-confirmed SARS-CoV-2 infection who required hospital admission were recruited prospectively. Patients treated with HFNC, NIV, or IMV within the first 24 h of hospital admission were included in this study. Descriptive statistics, random forest, and logistic regression analyses were used to describe clinical characteristics and compare clinical outcomes among patients treated with the different types of advanced respiratory support. Results: A total of 66,565 patients were included in this study. Overall, 82.6% of patients were treated in HIC, and 40.6% were admitted to the hospital during the first pandemic wave. During the first 24 h after hospital admission, patients in HICs were more frequently treated with HFNC (48.0%), followed by NIV (38.6%) and IMV (13.4%). In contrast, patients admitted in lower- and middle-income countries (LMICs) were less frequently treated with HFNC (16.1%) and the majority received IMV (59.1%). The failure rate of non-invasive respiratory support (i.e. HFNC or NIV) was 15.5%, of which 71.2% were from HIC and 28.8% from LMIC. The variables most strongly associated with non-invasive ventilation failure, defined as progression to IMV, were high leukocyte counts at hospital admission (OR [95%CI]; 5.86 [4.83-7.10]), treatment in an LMIC (OR [95%CI]; 2.04 [1.97-2.11]), and tachypnoea at hospital admission (OR [95%CI]; 1.16 [1.14-1.18]). Patients who failed HFNC/NIV had a higher 28-day fatality ratio (OR [95%CI]; 1.27 [1.25-1.30]). Conclusions: In the present international cohort, the most frequently used advanced respiratory support was the HFNC. However, IMV was used more often in LMIC. Higher leucocyte count, tachypnoea, and treatment in LMIC were risk factors for HFNC/NIV failure. HFNC/NIV failure was related to worse clinical outcomes, such as 28-day mortality. Trial registration This is a prospective observational study; therefore, no health care interventions were applied to participants, and trial registration is not applicable

Respiratory support in patients with severe COVID-19 in the International Severe Acute Respiratory and Emerging Infection (ISARIC) COVID-19 study: a prospective, multinational, observational study

Background: Up to 30% of hospitalised patients with COVID-19 require advanced respiratory support, including high-flow nasal cannulas (HFNC), non-invasive mechanical ventilation (NIV), or invasive mechanical ventilation (IMV). We aimed to describe the clinical characteristics, outcomes and risk factors for failing non-invasive respiratory support in patients treated with severe COVID-19 during the first two years of the pandemic in high-income countries (HICs) and low middle-income countries (LMICs). Methods: This is a multinational, multicentre, prospective cohort study embedded in the ISARIC-WHO COVID-19 Clinical Characterisation Protocol. Patients with laboratory-confirmed SARS-CoV-2 infection who required hospital admission were recruited prospectively. Patients treated with HFNC, NIV, or IMV within the first 24 h of hospital admission were included in this study. Descriptive statistics, random forest, and logistic regression analyses were used to describe clinical characteristics and compare clinical outcomes among patients treated with the different types of advanced respiratory support. Results: A total of 66,565 patients were included in this study. Overall, 82.6% of patients were treated in HIC, and 40.6% were admitted to the hospital during the first pandemic wave. During the first 24 h after hospital admission, patients in HICs were more frequently treated with HFNC (48.0%), followed by NIV (38.6%) and IMV (13.4%). In contrast, patients admitted in lower- and middle-income countries (LMICs) were less frequently treated with HFNC (16.1%) and the majority received IMV (59.1%). The failure rate of non-invasive respiratory support (i.e. HFNC or NIV) was 15.5%, of which 71.2% were from HIC and 28.8% from LMIC. The variables most strongly associated with non-invasive ventilation failure, defined as progression to IMV, were high leukocyte counts at hospital admission (OR [95%CI]; 5.86 [4.83–7.10]), treatment in an LMIC (OR [95%CI]; 2.04 [1.97–2.11]), and tachypnoea at hospital admission (OR [95%CI]; 1.16 [1.14–1.18]). Patients who failed HFNC/NIV had a higher 28-day fatality ratio (OR [95%CI]; 1.27 [1.25–1.30]). Conclusions: In the present international cohort, the most frequently used advanced respiratory support was the HFNC. However, IMV was used more often in LMIC. Higher leucocyte count, tachypnoea, and treatment in LMIC were risk factors for HFNC/NIV failure. HFNC/NIV failure was related to worse clinical outcomes, such as 28-day mortality. Trial registration This is a prospective observational study; therefore, no health care interventions were applied to participants, and trial registration is not applicable

Association of Country Income Level With the Characteristics and Outcomes of Critically Ill Patients Hospitalized With Acute Kidney Injury and COVID-19

Introduction: Acute kidney injury (AKI) has been identified as one of the most common and significant problems in hospitalized patients with COVID-19. However, studies examining the relationship between COVID-19 and AKI in low- and low-middle income countries (LLMIC) are lacking. Given that AKI is known to carry a higher mortality rate in these countries, it is important to understand differences in this population. Methods: This prospective, observational study examines the AKI incidence and characteristics of 32,210 patients with COVID-19 from 49 countries across all income levels who were admitted to an intensive care unit during their hospital stay. Results: Among patients with COVID-19 admitted to the intensive care unit, AKI incidence was highest in patients in LLMIC, followed by patients in upper-middle income countries (UMIC) and high-income countries (HIC) (53%, 38%, and 30%, respectively), whereas dialysis rates were lowest among patients with AKI from LLMIC and highest among those from HIC (27% vs. 45%). Patients with AKI in LLMIC had the largest proportion of community-acquired AKI (CA-AKI) and highest rate of in-hospital death (79% vs. 54% in HIC and 66% in UMIC). The association between AKI, being from LLMIC and in-hospital death persisted even after adjusting for disease severity. Conclusions: AKI is a particularly devastating complication of COVID-19 among patients from poorer nations where the gaps in accessibility and quality of healthcare delivery have a major impact on patient outcomes

Respiratory support in patients with severe COVID-19 in the International Severe Acute Respiratory and Emerging Infection (ISARIC) COVID-19 study: a prospective, multinational, observational study

International audienceBackground: Up to 30% of hospitalised patients with COVID-19 require advanced respiratory support, including high-flow nasal cannulas (HFNC), non-invasive mechanical ventilation (NIV), or invasive mechanical ventilation (IMV). We aimed to describe the clinical characteristics, outcomes and risk factors for failing non-invasive respiratory support in patients treated with severe COVID-19 during the first two years of the pandemic in high-income countries (HICs) and low middle-income countries (LMICs).Methods: This is a multinational, multicentre, prospective cohort study embedded in the ISARIC-WHO COVID-19 Clinical Characterisation Protocol. Patients with laboratory-confirmed SARS-CoV-2 infection who required hospital admission were recruited prospectively. Patients treated with HFNC, NIV, or IMV within the first 24 h of hospital admission were included in this study. Descriptive statistics, random forest, and logistic regression analyses were used to describe clinical characteristics and compare clinical outcomes among patients treated with the different types of advanced respiratory support.Results: A total of 66,565 patients were included in this study. Overall, 82.6% of patients were treated in HIC, and 40.6% were admitted to the hospital during the first pandemic wave. During the first 24 h after hospital admission, patients in HICs were more frequently treated with HFNC (48.0%), followed by NIV (38.6%) and IMV (13.4%). In contrast, patients admitted in lower- and middle-income countries (LMICs) were less frequently treated with HFNC (16.1%) and the majority received IMV (59.1%). The failure rate of non-invasive respiratory support (i.e. HFNC or NIV) was 15.5%, of which 71.2% were from HIC and 28.8% from LMIC. The variables most strongly associated with non-invasive ventilation failure, defined as progression to IMV, were high leukocyte counts at hospital admission (OR [95%CI]; 5.86 [4.83-7.10]), treatment in an LMIC (OR [95%CI]; 2.04 [1.97-2.11]), and tachypnoea at hospital admission (OR [95%CI]; 1.16 [1.14-1.18]). Patients who failed HFNC/NIV had a higher 28-day fatality ratio (OR [95%CI]; 1.27 [1.25-1.30]).Conclusions: In the present international cohort, the most frequently used advanced respiratory support was the HFNC. However, IMV was used more often in LMIC. Higher leucocyte count, tachypnoea, and treatment in LMIC were risk factors for HFNC/NIV failure. HFNC/NIV failure was related to worse clinical outcomes, such as 28-day mortality. Trial registration This is a prospective observational study; therefore, no health care interventions were applied to participants, and trial registration is not applicable

Thrombotic and hemorrhagic complications of COVID-19 in adults hospitalized in high-income countries compared with those in adults hospitalized in low- and middle-income countries in an international registry

Background: COVID-19 has been associated with a broad range of thromboembolic, ischemic, and hemorrhagic complications (coagulopathy complications). Most studies have focused on patients with severe disease from high-income countries (HICs). Objectives: The main aims were to compare the frequency of coagulopathy complications in developing countries (low- and middle-income countries [LMICs]) with those in HICs, delineate the frequency across a range of treatment levels, and determine associations with in-hospital mortality. Methods: Adult patients enrolled in an observational, multinational registry, the International Severe Acute Respiratory and Emerging Infections COVID-19 study, between January 1, 2020, and September 15, 2021, met inclusion criteria, including admission to a hospital for laboratory-confirmed, acute COVID-19 and data on complications and survival. The advanced-treatment cohort received care, such as admission to the intensive care unit, mechanical ventilation, or inotropes or vasopressors; the basic-treatment cohort did not receive any of these interventions. Results: The study population included 495,682 patients from 52 countries, with 63% from LMICs and 85% in the basic treatment cohort. The frequency of coagulopathy complications was higher in HICs (0.76%-3.4%) than in LMICs (0.09%-1.22%). Complications were more frequent in the advanced-treatment cohort than in the basic-treatment cohort. Coagulopathy complications were associated with increased in-hospital mortality (odds ratio, 1.58; 95% CI, 1.52-1.64). The increased mortality associated with these complications was higher in LMICs (58.5%) than in HICs (35.4%). After controlling for coagulopathy complications, treatment intensity, and multiple other factors, the mortality was higher among patients in LMICs than among patients in HICs (odds ratio, 1.45; 95% CI, 1.39-1.51). Conclusion: In a large, international registry of patients hospitalized for COVID-19, coagulopathy complications were more frequent in HICs than in LMICs (developing countries). Increased mortality associated with coagulopathy complications was of a greater magnitude among patients in LMICs. Additional research is needed regarding timely diagnosis of and intervention for coagulation derangements associated with COVID-19, particularly for limited-resource settings

Implementation of Recommendations on the Use of Corticosteroids in Severe COVID-19

Importance: Research diversity and representativeness are paramount in building trust, generating valid biomedical knowledge, and possibly in implementing clinical guidelines. Objectives: To compare variations over time and across World Health Organization (WHO) geographic regions of corticosteroid use for treatment of severe COVID-19; secondary objectives were to evaluate the association between the timing of publication of the RECOVERY (Randomised Evaluation of COVID-19 Therapy) trial (June 2020) and the WHO guidelines for corticosteroids (September 2020) and the temporal trends observed in corticosteroid use by region and to describe the geographic distribution of the recruitment in clinical trials that informed the WHO recommendation. Design, setting, and participants: This prospective cohort study of 434 851 patients was conducted between January 31, 2020, and September 2, 2022, in 63 countries worldwide. The data were collected under the auspices of the International Severe Acute Respiratory and Emerging Infections Consortium (ISARIC)-WHO Clinical Characterisation Protocol for Severe Emerging Infections. Analyses were restricted to patients hospitalized for severe COVID-19 (a subset of the ISARIC data set). Exposure: Corticosteroid use as reported to the ISARIC-WHO Clinical Characterisation Protocol for Severe Emerging Infections. Main outcomes and measures: Number and percentage of patients hospitalized with severe COVID-19 who received corticosteroids by time period and by WHO geographic region. Results: Among 434 851 patients with confirmed severe or critical COVID-19 for whom receipt of corticosteroids could be ascertained (median [IQR] age, 61.0 [48.0-74.0] years; 53.0% male), 174 307 (40.1%) received corticosteroids during the study period. Of the participants in clinical trials that informed the guideline, 91.6% were recruited from the United Kingdom. In all regions, corticosteroid use for severe COVID-19 increased, but this increase corresponded to the timing of the RECOVERY trial (time-interruption coefficient 1.0 [95% CI, 0.9-1.2]) and WHO guideline (time-interruption coefficient 1.9 [95% CI, 1.7-2.0]) publications only in Europe. At the end of the study period, corticosteroid use for treatment of severe COVID-19 was highest in the Americas (5421 of 6095 [88.9%]; 95% CI, 87.7-90.2) and lowest in Africa (31 588 of 185 191 [17.1%]; 95% CI, 16.8-17.3). Conclusions and relevance: The results of this cohort study showed that implementation of the guidelines for use of corticosteroids in the treatment of severe COVID-19 varied geographically. Uptake of corticosteroid treatment was lower in regions with limited clinical trial involvement. Improving research diversity and representativeness may facilitate timely knowledge uptake and guideline implementation

Characteristics and outcomes of an international cohort of 600 000 hospitalized patients with COVID-19

Background: We describe demographic features, treatments and clinical outcomes in the International Severe Acute Respiratory and emerging Infection Consortium (ISARIC) COVID-19 cohort, one of the world's largest international, standardized data sets concerning hospitalized patients. Methods: The data set analysed includes COVID-19 patients hospitalized between January 2020 and January 2022 in 52 countries. We investigated how symptoms on admission, co-morbidities, risk factors and treatments varied by age, sex and other characteristics. We used Cox regression models to investigate associations between demographics, symptoms, co-morbidities and other factors with risk of death, admission to an intensive care unit (ICU) and invasive mechanical ventilation (IMV). Results: Data were available for 689 572 patients with laboratory-confirmed (91.1%) or clinically diagnosed (8.9%) SARS-CoV-2 infection from 52 countries. Age [adjusted hazard ratio per 10 years 1.49 (95% CI 1.48, 1.49)] and male sex [1.23 (1.21, 1.24)] were associated with a higher risk of death. Rates of admission to an ICU and use of IMV increased with age up to age 60 years then dropped. Symptoms, co-morbidities and treatments varied by age and had varied associations with clinical outcomes. The case-fatality ratio varied by country partly due to differences in the clinical characteristics of recruited patients and was on average 21.5%. Conclusions: Age was the strongest determinant of risk of death, with a ∼30-fold difference between the oldest and youngest groups; each of the co-morbidities included was associated with up to an almost 2-fold increase in risk. Smoking and obesity were also associated with a higher risk of death. The size of our international database and the standardized data collection method make this study a comprehensive international description of COVID-19 clinical features. Our findings may inform strategies that involve prioritization of patients hospitalized with COVID-19 who have a higher risk of death