scholarly journals User Generated SQL Queries Inform Evaluation of NSSP ESSENCE

2018 ◽  
Vol 10 (1) ◽  
Author(s):  
Aaron Kite-Powell ◽  
Michael Coletta ◽  
Jamie Smimble
Keyword(s):  
Execution Time ◽  
National Level ◽  
System Optimization ◽  
Free Text ◽  
Query Execution ◽  
The Mean ◽  
Execution Times ◽  
Text Query ◽  
Sql Query ◽  
Over Time

Objective: The objective of this work is to describe the use and performance of the NSSP ESSENCE system by analyzing the structured query language (SQL) logs generated by users of the National Syndromic Surveillance Program’s (NSSP) Electronic Surveillance System for the Early Notification of Community-based Epidemics (ESSENCE).Introduction: As system users develop queries within ESSENCE, they step through the user-interface to select data sources and parameters needed for their query. Then they select from the available output options (e.g., time series, table builder, data details). These activities execute a SQL query on the database, the majority of which are saved in a log so that system developers can troubleshoot problems. Secondarily, these data can be used as a form of web analytics to describe user query choices, query volume, query execution time, and develop an understanding of ESSENCE query patterns.Methods: ESSENCE SQL query logs were extracted from April 1, 2016 to August 23th, 2017. Overall query volume was assessed by summarizing volume of queries over time (e.g., by hour, day, and week), and by Site. To better understand system performance the mean, median, and maximum query execution times were summarized over time and by Site. SQL query text was parsed so that we could isolate, 1) Syndromes queried, 2) Sub-syndromes queried, 3) Keyword categories queried, and 4) Free text query terms used. Syndromes, sub-syndromes, and keyword categories were tabulated in total and by Site. Frequencies of free text query terms were analyzed using n-grams, wordclouds, and term co-occurrence relationships. Term co-occurrence network graphs were used to visualize the structure and relationships among terms.Results: There were a total of 354,101 SQL queries generated by users of ESSENCE between April 1, 2016 and August 23rd, 2017. Over this entire time period there was a weekly mean of 4,785 SQL queries performed by users. When looking at 2017 data through August 23rd this figure increases to a mean of 7,618 SQL queries per week for 2017, and since May 2017 the mean number of SQL queries has increased to 10,485 per week. The maximum number of user generated SQL queries in a week was 29,173. The mean, median, and maximum query execution times for all data was 0.61 minutes, 0 minutes, and 365 minutes, respectively. When looking at only queries with a free text component the mean query execution time increases slightly to 0.94 minutes, though the median is still 0 minutes. The peak usage period based on number of SQL queries performed is between 12:00pm and 3:00pm EST.Conclusions: The use of NSSP ESSENCE has grown since implementation. This is the first time the ESSENCE system has been used at a National level with this volume of data, and number of users. Our focus to date has been on successfully on-boarding new Sites so that they can benefit from use of the available tools, providing trainings to new users, and optimizing ESSENCE performance. Routine analysis of the ESSENCE SQL logs can assist us in understanding how the system is being used, how well it is performing, and in evaluating our system optimization efforts.

Predicting SQL Query Execution Time with a Cost Model for Spark Platform

2020 ◽  
Author(s):  
Aleksey Burdakov ◽  
Viktoria Proletarskaya ◽  
Andrey Ploutenko ◽  
Oleg Ermakov ◽  
Uriy Grigorev
Keyword(s):  
Execution Time ◽  
Cost Model ◽  
Query Execution ◽  
Sql Query

scholarly journals Analysis of 220 Years of Floodplain Population Dynamics in the US at Different Spatial Scales

Water ◽  
2021 ◽  
Vol 13 (2) ◽  
pp. 141
Author(s):  
Firoza Akhter ◽  
Maurizio Mazzoleni ◽  
Luigia Brandimarte
Keyword(s):  
Population Dynamics ◽  
Large Scale ◽  
Spatial Scales ◽  
National Level ◽  
State Level ◽  
Economic Activities ◽  
Protection Measures ◽  
Management Planning ◽  
The Us ◽  
Over Time

In this study, we explore the long-term trends of floodplain population dynamics at different spatial scales in the contiguous United States (U.S.). We exploit different types of datasets from 1790–2010—i.e., decadal spatial distribution for the population density in the US, global floodplains dataset, large-scale data of flood occurrence and damage, and structural and nonstructural flood protection measures for the US. At the national level, we found that the population initially settled down within the floodplains and then spread across its territory over time. At the state level, we observed that flood damages and national protection measures might have contributed to a learning effect, which in turn, shaped the floodplain population dynamics over time. Finally, at the county level, other socio-economic factors such as local flood insurances, economic activities, and socio-political context may predominantly influence the dynamics. Our study shows that different influencing factors affect floodplain population dynamics at different spatial scales. These facts are crucial for a reliable development and implementation of flood risk management planning.

scholarly journals Kinetic analysis and optimisation of 18F-rhPSMA-7.3 PET imaging of prostate cancer

2021 ◽  
Author(s):  
Simona Malaspina ◽  
Vesa Oikonen ◽  
Anna Kuisma ◽  
Otto Ettala ◽  
Kalle Mattila ◽  
...  
Keyword(s):  
Prostate Cancer ◽  
Metastatic Disease ◽  
Uptake Kinetics ◽  
Whole Body ◽  
Target Area ◽  
Post Injection ◽  
The Mean ◽  
Pet Radiopharmaceutical ◽  
Time Frames ◽  
Over Time

Abstract Purpose This phase 1 open-label study evaluated the uptake kinetics of a novel theranostic PET radiopharmaceutical, 18F-rhPSMA-7.3, to optimise its use for imaging of prostate cancer. Methods Nine men, three with high-risk localised prostate cancer, three with treatment-naïve hormone-sensitive metastatic disease and three with castration-resistant metastatic disease, underwent dynamic 45-min PET scanning of a target area immediately post-injection of 300 MBq 18F-rhPSMA-7.3, followed by two whole-body PET/CT scans acquired from 60 and 90 min post-injection. Volumes of interest (VoIs) corresponding to prostate cancer lesions and reference tissues were recorded. Standardised uptake values (SUV) and lesion-to-reference ratios were calculated for 3 time frames: 35–45, 60–88 and 90–118 min. Net influx rates (Ki) were calculated using Patlak plots. Results Altogether, 44 lesions from the target area were identified. Optimal visual lesion detection started 60 min post-injection. The 18F-rhPSMA-7.3 signal from prostate cancer lesions increased over time, while reference tissue signals remained stable or decreased. The mean (SD) SUV (g/mL) at the 3 time frames were 8.4 (5.6), 10.1 (7) and 10.6 (7.5), respectively, for prostate lesions, 11.2 (4.3), 13 (4.8) and 14 (5.2) for lymph node metastases, and 4.6 (2.6), 5.7 (3.1) and 6.4 (3.5) for bone metastases. The mean (SD) lesion-to-reference ratio increases from the earliest to the 2 later time frames were 40% (10) and 59% (9), respectively, for the prostate, 65% (27) and 125% (47) for metastatic lymph nodes and 25% (19) and 32% (30) for bone lesions. Patlak plots from lesion VoIs signified almost irreversible uptake kinetics. Ki, SUV and lesion-to-reference ratio estimates showed good agreement. Conclusion 18F-rhPSMA-7.3 uptake in prostate cancer lesions was high. Lesion-to-background ratios increased over time, with optimal visual detection starting from 60 min post-injection. Thus, 18F-rhPSMA-7.3 emerges as a very promising PET radiopharmaceutical for diagnostic imaging of prostate cancer. Trial Registration NCT03995888 (24 June 2019).

scholarly journals A New Multiplatform Model for Outpatient Prenatal and Postpartum Care in a Cohort of COVID-19-Affected Obstetric Patients

2021 ◽  
Vol 18 (10) ◽  
pp. 5144
Author(s):  
Mar Muñoz-Chápuli Gutiérrez ◽  
Ana Durán-Vila ◽  
Javier Ruiz-Labarta ◽  
Pilar Payá-Martínez ◽  
Pilar Pintado Recarte ◽  
...  
Keyword(s):  
Clinical Manifestations ◽  
Specific Treatment ◽  
Rt Pcr ◽  
Good Adherence ◽  
Major Morbidity ◽  
Reference Hospital ◽  
The Mean ◽  
Discharge From Hospital ◽  
Over Time

Spain was one of the epicenters of the first wave of the COVID-19 pandemic. We describe in this article the design and results of a new telephone-and-telematic multiplatform model of systematic prenatal and postpartum follow-up for COVID-19-affected women implemented in a tertiary reference hospital in Madrid. We included patients with RT-PCR-confirmed COVID-19 during pregnancy or delivery from 10 March 2020 to 15 December 2020. We had a total of 211 obstetric patients: 148 (70.1%) were tested at the onset of suspicious clinical manifestations and 62 (29.4%) were tested in the context of routine screening. Of all the patients, 60 women (28.4%) were asymptomatic and 97 (46%) presented mild symptoms. Fifty-one women (24.2%) were admitted to our hospital for specific treatment because of moderate or severe symptoms. We had no missed cases and a good adherence. The mean number of calls per patient was 2.3. We performed 55 in-person visits. We analyzed the complexity of our program over time, showing a two-wave-like pattern. One patient was identified as needing hospitalization and we did not record major morbidity. Telemedicine programs are a strong and reproducible tool to reach to pregnant population affected by COVID-19, to assess its symptoms and severity, and to record for pregnancy-related symptoms both in an outpatient regime and after discharge from hospital.

Adaptors and Innovators: Selection versus Induction

1991 ◽  
Vol 68 (3_suppl) ◽  
pp. 1283-1290 ◽  
Author(s):  
P. A. Holland ◽  
I. Bowskill ◽  
A. Bailey
Keyword(s):  
Cognitive Style ◽  
Past Research ◽  
Significant Shift ◽  
Occupational Groups ◽  
Significant Difference ◽  
The Mean ◽  
New Entrants ◽  
Innovative Cognitive Style ◽  
Over Time ◽  
Established Group

The hypothesis that predictable differences would exist between the mean cognitive style of new entrants and those of the longer serving “established” employees in certain departments while not in others was tested. Data from 99 employees from four departments of a large British pharmaceuticals company who completed the Kirton Adaption-Innovation Inventory provided results broadly in line with the expectations of adaption-innovation theory and past research. The mean innovative cognitive style of new entrants to adaptive departments regressed towards the mean of the establishment and the occupational mean over time. In departments where there was no initial significant difference between the mean cognitive style of the new entrants and the established group, no significant shift was shown over time. Implications of these findings are suggested. The data also indicated norms for two occupational groups where previously they did not exist.

The underrepresentation of female participants in studies assessing the impact of high-dose exercise on cardiovascular outcomes: a scoping review

2021 ◽  
Vol 28 (Supplement_1) ◽  
Author(s):  
S Pallikadavath ◽  
R Patel ◽  
CL Kemp ◽  
M Hafejee ◽  
N Peckham ◽  
...  
Keyword(s):  
Scoping Review ◽  
High Volume ◽  
Cardiovascular Outcomes ◽  
High Dose ◽  
Funding Sources ◽  
Review Protocol ◽  
The Mean ◽  
The Impact ◽  
Over Time ◽  
Funding Acknowledgements

Abstract Funding Acknowledgements Type of funding sources: None. Introduction Cardiovascular adaptations as a result of exercise conducted at high-intensity and high-volume are often termed the ‘Athlete’s heart’. Studies have shown that these cardiovascular adaptations vary between sexes. It is important that both sexes are well represented in this literature. However, many studies assessing the impact of high-dose exercise on cardiovascular outcomes under-recruit female participants. Purpose This scoping review aimed to evaluate the representation of females in studies assessing the impact of high-dose exercise on cardiovascular outcomes and demonstrate how this has changed over time. Methods The scoping review protocol as outlined by Arksey and O’Malley was used. OVID and EMBASE databases were searched and studies independently reviewed by two reviewers. Studies must have investigated the effects of high-dose exercise on cardiovascular outcomes. To assess how the recruitment of females has changed over time, two methods were used. One, the median study date was used to categorise studies into two groups. Two, studies were divided into deciles to form ten equal groups over the study period. Mean percentage of female recruitment and percentage of studies that failed to include females were calculated. Results Overall, 250 studies were included. Over half the studies (50.8%, n = 127) did not include female participants. Only 3.2% (n = 8) did not include male participants. Overall, mean percentage recruitment was 18.2%. The mean percentage of recruitment was 14.5% before 2011 and 21.8% after 2011. The most recent decile of studies demonstrated the highest mean percentage of female recruitment (29.3%) and lowest number of studies that did not include female participants (26.9%). Conclusion Female participants are significantly underrepresented in studies assessing cardiovascular outcomes caused by high-dose exercise. The most recent studies show that female recruitment may be improving, however, this still falls significantly short for equal representation. Risk factors, progression and management of cardiovascular diseases vary between sexes, hence, translating findings from male dominated data is not appropriate. Future investigators should aim to establish barriers and strategies to optimise fair recruitment. Mean percentage females recruited per study (%) Percentage studies that do not include women (%) Overall (n = 250) 18.2 50.8 (n = 127) Studies before 2011 (n = 121) 14.5 59.5 (n = 72) Studies after 2011 (n = 129) 21.8 42.6 (n = 55) Table 1: Female recruitment characteristics. The year 2011 (median study year) was chosen as this divides all included studies into two equal groups.

scholarly journals Why does the European Right accommodate backsliding states? An analysis of 24 European People’s Party votes (2011–2019)

2021 ◽  
Vol 13 (2) ◽  
pp. 169-187
Author(s):  
Lise Esther Herman ◽  
Julian Hoerner ◽  
Joseph Lacey
Keyword(s):  
National Level ◽  
Eastern European ◽  
People's Party ◽  
Number Of Factors ◽  
European People’S Party ◽  
Democratic Principles ◽  
National Governments ◽  
Fundamental Values ◽  
Over Time ◽  
The Eu

AbstractOver the last decade, the EU’s fundamental values have been under threat at the national level, in particular among several Central and Eastern European states that joined the EU since 2004. During this time, the European People’s Party (EPP) has been criticized for its unwillingness to vote for measures that would sanction the Hungarian Fidesz government, one of its members, in breach of key democratic principles since 2010. In this paper, we seek to understand how cohesive the EPP group has been on fundamental values-related votes, how the position of EPP MEPs on these issues has evolved over time, and what explains intra-EPP disagreement on whether to accommodate fundamental values violators within the EU. To address these questions, we analyse the votes of EPP MEPs across 24 resolutions on the protection of EU fundamental values between 2011 and 2019. Our findings reveal below-average EPP cohesion on these votes, and a sharp increase in the tendency of EPP MEPs to support these resolutions over time. A number of factors explain the disagreements we find. While the EPP’s desire to maintain Fidesz within its ranks is central, this explanation does not offer a comprehensive account of the group’s accommodative behaviour. In particular, we find that ideological factors as well as the strategic interests of national governments at the EU level are central to understanding the positions of EPP MEPs, as well as the evolution of these positions over time. These results further our understanding of the nature of the obstacles to EU sanctions in fundamental values abuse cases, and the role of partisanship in fuelling EU inaction especially.

Sign in / Sign up

Export Citation Format

Share Document