scholarly journals SARI-SQL: Event Query Language for Event Analysis

2009 ◽  
Author(s):  
Szabolcs Rozsnyai ◽  
Josef Schiefer ◽  
Heinz Roth
Keyword(s):  
Query Language ◽  
Event Analysis

Case study and event analysis for mitigation of unpredictable volcanic hazard

Impact ◽  
2020 ◽  
Vol 2020 (3) ◽  
pp. 26-28
Author(s):  
Tsukasa Ohba
Keyword(s):  
At Risk ◽  
Graduate School ◽  
Volcanic Hazard ◽  
Hazard Mitigation ◽  
Scientific Discipline ◽  
Mitigation Measures ◽  
Event Analysis ◽  
Traditional Methods ◽  
Risk Communities

Volcanology is an extremely important scientific discipline. Shedding light on how and why volcanoes erupt, how eruptions can be predicted and their impact on humans and the environment is crucial to public safety, economies and businesses. Understanding volcanoes means eruptions can be anticipated and at-risk communities can be forewarned, enabling them to implement mitigation measures. Professor Tsukasa Ohba is a scientist based at the Graduate School of International Resource Studies, Akita University, Japan, and specialises in volcanology and petrology. Ohba and his team are focusing on volcanic phenomena including: phreatic eruptions (a steam-driven eruption driven by the heat from magma interacting with water); lahar (volcanic mudflow); and monogenetic basalt eruptions (which consist of a group of small monogenetic volcanoes, each of which erupts only once). The researchers are working to understand the mechanisms of these phenomena using Petrology. Petrology is one of the traditional methods in volcanology but has not been applied to disastrous eruptions before. The teams research will contribute to volcanic hazard mitigation.

scholarly journals 4494 Predictors of Reintubation After Cardiac Surgery

2020 ◽  
Vol 4 (s1) ◽  
pp. 50-50
Author(s):  
Robert Edward Freundlich ◽  
Gen Li ◽  
Jonathan P Wanderer ◽  
Frederic T Billings ◽  
Henry Domenico ◽  
...  
Keyword(s):  
Clinical Trial ◽  
Cardiac Surgery ◽  
High Risk ◽  
Query Language ◽  
Risk Estimation ◽  
Clinical Care ◽  
Model Development ◽  
Calibration Plot ◽  
Iterative Model ◽  
Strong Candidate

OBJECTIVES/GOALS: We modeled risk of reintubation within 48 hours of cardiac surgery using variables available in the electronic health record (EHR). This model will guide recruitment for a prospective, pragmatic clinical trial entirely embedded within the EHR among those at high risk of reintubation. METHODS/STUDY POPULATION: All adult patients admitted to the cardiac intensive care unit following cardiac surgery involving thoracotomy or sternotomy were eligible for inclusion. Data were obtained from operational and analytical databases integrated into the Epic EHR, as well as institutional and departmental-derived data warehouses, using structured query language. Variables were screened for inclusion in the model based on clinical relevance, availability in the EHR as structured data, and likelihood of timely documentation during routine clinical care, in the hopes of obtaining a maximally-pragmatic model. RESULTS/ANTICIPATED RESULTS: A total of 2325 patients met inclusion criteria between November 2, 2017 and November 2, 2019. Of these patients, 68.4% were male. Median age was 63.0. The primary outcome of reintubation occurred in 112/2325 (4.8%) of patients within 48 hours and 177/2325 (7.6%) at any point in the subsequent hospital encounter. Univariate screening and iterative model development revealed numerous strong candidate predictors (ANOVA plot, figure 1), resulting in a model with acceptable calibration (calibration plot, figure 2), c = 0.666. DISCUSSION/SIGNIFICANCE OF IMPACT: Reintubation is common after cardiac surgery. Risk factors are available in the EHR. We are integrating this model into the EHR to support real-time risk estimation and to recruit and randomize high-risk patients into a clinical trial comparing post-extubation high flow nasal cannula with usual care. CONFLICT OF INTEREST DESCRIPTION: REF has received grant funding and consulting fees from Medtronic for research on inpatient monitoring.

scholarly journals Query Rewriting for Incremental Continuous Query Evaluation in HIFUN

Algorithms ◽  
2021 ◽  
Vol 14 (5) ◽  
pp. 149
Author(s):  
Petros Zervoudakis ◽  
Haridimos Kondylakis ◽  
Nicolas Spyratos ◽  
Dimitris Plexousakis
Keyword(s):  
Query Optimization ◽  
Query Language ◽  
Computational Cost ◽  
Continuous Queries ◽  
Continuous Query ◽  
Query Rewriting ◽  
Query Evaluation ◽  
Clear Separation ◽  
Complete Dataset ◽  
High Level

HIFUN is a high-level query language for expressing analytic queries of big datasets, offering a clear separation between the conceptual layer, where analytic queries are defined independently of the nature and location of data, and the physical layer, where queries are evaluated. In this paper, we present a methodology based on the HIFUN language, and the corresponding algorithms for the incremental evaluation of continuous queries. In essence, our approach is able to process the most recent data batch by exploiting already computed information, without requiring the evaluation of the query over the complete dataset. We present the generic algorithm which we translated to both SQL and MapReduce using SPARK; it implements various query rewriting methods. We demonstrate the effectiveness of our approach in temrs of query answering efficiency. Finally, we show that by exploiting the formal query rewriting methods of HIFUN, we can further reduce the computational cost, adding another layer of query optimization to our implementation.

A query language for a Web-site management system

1997 ◽  
Vol 26 (3) ◽  
pp. 4-11 ◽  
Author(s):  
Mary Fernandez ◽  
Daniela Florescu ◽  
Alon Levy ◽  
Dan Suciu
Keyword(s):  
Web Site ◽  
Management System ◽  
Query Language ◽  
Site Management

scholarly journals Aortic Valve Calcification is Associated with Future Cognitive Impairment

2021 ◽  
pp. 1-7
Author(s):  
Hojune E. Chung ◽  
Jessica Chen ◽  
Dhairyasheel Ghosalkar ◽  
Jared L. Christensen ◽  
Alice J. Chu ◽  
...  
Keyword(s):  
Cognitive Impairment ◽  
Aortic Valve ◽  
Lung Cancer Screening ◽  
Continuous Variable ◽  
Smoking History ◽  
Event Analysis ◽  
Aortic Valve Calcification ◽  
Valve Calcification ◽  
Ckd Stage ◽  
New Diagnosis

Background: While an association between atherosclerosis and dementia has been identified, few studies have assessed the longitudinal relationship between aortic valve calcification (AVC) and cognitive impairment (CI). Objective: We sought to determine whether AVC derived from lung cancer screening CT (LCSCT) was associated with CI in a moderate-to-high atherosclerotic risk cohort. Methods: This was a single site, retrospective analysis of 1401 U.S. veterans (65 years [IQI: 61, 68] years; 97%male) who underwent quantification of AVC from LCSCT indicated for smoking history. The primary outcome was new diagnosis of CI identified by objective testing (Mini-Mental Status Exam or Montreal Cognitive Assessment) or by ICD coding. Time-to-event analysis was carried out using AVC as a continuous variable. Results: Over 5 years, 110 patients (8%) were diagnosed with CI. AVC was associated with new diagnosis of CI using 3 Models for adjustment: 1) age (HR: 1.104; CI: 1.023–1.191; p = 0.011); 2) Model 1 plus hypertension, hyperlipidemia, diabetes, CKD stage 3 or higher (glomerular filtration rate <  60 mL/min) and CAD (HR: 1.097; CI: 1.014–1.186; p = 0.020); and 3) Model 2 plus CVA (HR: 1.094; CI: 1.011–1.182; p = 0.024). Sensitivity analysis demonstrated that the association between AVC and new diagnosis of CI remained significant upon exclusion of severe AVC (HR: 1.100 [1.013–1.194]; p = 0.023). Subgroup analysis demonstrated that this association remained significant when including education in the multivariate analysis (HR: 1.127 [1.030–1.233]; p = 0.009). Conclusion: This is the first study demonstrating that among mostly male individuals who underwent LCSCT, quantified aortic valve calcification is associated with new diagnosis of CI.

Sign in / Sign up

Export Citation Format

Share Document