scholarly journals IView: introgression library visualization and query tool

2010 ◽  
Vol 11 (S6) ◽  
Author(s):  
Christopher A Bottoms ◽  
Sherry Flint-Garcia ◽  
Michael D McMullen
Keyword(s):  
Query Tool ◽  
Introgression Library

What's Happening to Profits at Cazenovia Creations?

2013 ◽  
Vol 8 (1) ◽  
pp. 24-29 ◽  
Author(s):  
Margaret Garnsey ◽  
Andrea Hotaling
Keyword(s):  
Financial Analysis ◽  
Financial Statements ◽  
Internal Controls ◽  
Net Income ◽  
Database Query ◽  
Microsoft Access ◽  
Level Data ◽  
Query Tool ◽  
Transaction Level

ABSTRACT In this case, students assume the role of an accounting professional asked by a client to investigate why net income is not as strong as expected. The students must first analyze a set of financial statements to identify areas of possible concern. After determining the areas to investigate, the students use a database query tool to see if they can determine causes by examining transaction level data. Finally, the students are asked to professionally communicate their findings and recommendations to their client. The case provides students with experience in using query-based approaches to answering business questions. It is appropriate for students with basic query and financial analysis skills and knowledge of internal controls. A Microsoft Access database with transaction details for the final seven months of the current year as well as financial statements for the current and prior year are provided.

A k -mer query tool for assessing population diversity in pangenomes

2021 ◽  
Author(s):  
Hang Su ◽  
Ziwei Chen ◽  
Maya L Najarian ◽  
Martin T. Ferris ◽  
Fernando Pardo-Manuel de Villena ◽  
...  
Keyword(s):  
Population Diversity ◽  
Query Tool

scholarly journals Development of a Web-Based Query Tool for Quality Assurance of Clinical Molecular Genetic Test Results

2007 ◽  
Vol 9 (1) ◽  
pp. 95-98 ◽  
Author(s):  
Matthew J. McGinniss ◽  
Rebecca Chen ◽  
Victoria M. Pratt ◽  
Arlene Buller ◽  
Franklin Quan ◽  
...  
Keyword(s):  
Quality Assurance ◽  
Genetic Test ◽  
Molecular Genetic ◽  
Test Results ◽  
Web Based ◽  
Genetic Test Results ◽  
Query Tool ◽  
Molecular Genetic Test

scholarly journals Trends of the incidence of drug use disorders from 1990 to 2017: an analysis based on the Global Burden of Disease 2017 data

2020 ◽  
Vol 29 ◽  
Author(s):  
Zhenyu Pan ◽  
Jun Zhang ◽  
Hua Cheng ◽  
Qingting Bu ◽  
Na Li ◽  
...  
Keyword(s):  
Drug Use ◽  
Incidence Rate ◽  
Data Exchange ◽  
Gaussian Process Regression ◽  
Positive Association ◽  
Current Status ◽  
Drug Use Disorders ◽  
Query Tool ◽  
Incident Cases ◽  
The Relationship

Abstract Aim Drug use disorders are an important issue worldwide. Systematic attempts to estimate the global incidence of drug use disorders are rare. We aimed to determine the incidence of drug use disorders and their trends. Methods We obtained the annual incident cases and age-standardised incidence rate (ASR) of drug use disorders from 1990 to 2017 using the Global Health Data Exchange query tool. The estimated annual percentage changes of the ASR were used to quantify and evaluate the trends in the incidence rate. Gaussian process regression and the Pearson's correlation coefficient were used to assess the relationship between the ASR and socio-demographic index (SDI). Results The number of drug use disorders’ cases increased by 33.5% from 1990 to 2017 globally, whereas the ASR exhibited a stable trend. The ASR was higher in men than in women. Most cases (53.1%) of drug use disorders involved opioid. A positive association (ρ=0.35, p < 0.001) was found between ASR and SDI. Teenagers aged 15–19 years had the highest incidence rate. Conclusions The incident cases of drug use disorders were increasing, but the incidence rate did not change significantly from 1990 to 2017. Current preventive measures and policies for drug use disorders might have little effect. The present results suggest that future strategies should focus on men, teenagers and high-risk regions in order to improve the current status of drug use disorders.

scholarly journals Web services for data warehouses: OMOP and PCORnet on i2b2

2018 ◽  
Vol 25 (10) ◽  
pp. 1331-1338 ◽  
Author(s):  
Jeffrey G Klann ◽  
Lori C Phillips ◽  
Christopher Herrick ◽  
Matthew A H Joss ◽  
Kavishwar B Wagholikar ◽  
...  
Keyword(s):  
Data Model ◽  
Application Programming Interface ◽  
Healthcare Research ◽  
Data Models ◽  
Healthcare Organizations ◽  
Ancillary Data ◽  
Healthcare Data ◽  
Query Tool ◽  
Application Programming ◽  
Rest Api

Abstract Objective Healthcare organizations use research data models supported by projects and tools that interest them, which often means organizations must support the same data in multiple models. The healthcare research ecosystem would benefit if tools and projects could be adopted independently from the underlying data model. Here, we introduce the concept of a reusable application programming interface (API) for healthcare and show that the i2b2 API can be adapted to support diverse patient-centric data models. Materials and Methods We develop methodology for extending i2b2’s pre-existing API to query additional data models, using i2b2’s recent “multi-fact-table querying” feature. Our method involves developing data-model-specific i2b2 ontologies and mapping these to query non-standard table structure. Results We implement this methodology to query OMOP and PCORnet models, which we validate with the i2b2 query tool. We implement the entire PCORnet data model and a five-domain subset of the OMOP model. We also demonstrate that additional, ancillary data model columns can be modeled and queried as i2b2 “modifiers.” Discussion i2b2’s REST API can be used to query multiple healthcare data models, enabling shared tooling to have a choice of backend data stores. This enables separation between data model and software tooling for some of the more popular open analytic data models in healthcare. Conclusion This methodology immediately allows querying OMOP and PCORnet using the i2b2 API. It is released as an open-source set of Docker images, and also on the i2b2 community wiki.

Development of a PSA tracking system for patients wtih prostate cancer following definitive radiotherapy to enhance rural health.

2016 ◽  
Vol 34 (2_suppl) ◽  
pp. 39-39 ◽  
Author(s):  
Michael G. Chang ◽  
Kristine DeSotto ◽  
Paul Taibi ◽  
Sandra Troeschel
Keyword(s):  
Prostate Cancer ◽  
Detection System ◽  
Tracking System ◽  
Failure Detection ◽  
Phone Call ◽  
Therapeutic Window ◽  
Definitive Radiotherapy ◽  
Psa Testing ◽  
Query Tool

39 Background: Patients with prostate cancer (PC) may benefit from early intervention when they experience relapse/recur. About 50% of our PC patients are rural and experience barriers to care due to distance, cost, and convenience. We sought to create a PSA tracking system with the Veterans Administration’s (VA) Electronic Medical Record (EMR) that would provide a remote way to monitor disease progression after definitive radiotherapy (XRT) by annual PSA testing alone. Methods: Using VA’s EMR, we developed a query tool to identify all patients ever treated at our center with XRT for prostate cancer who were alive, had not been seen in our clinic in more than a year, did not have metastatic disease, and had a rising PSA of at least 0.5 ng/ml above nadir, or who had no PSA drawn within 15 months. Results: Among roughly 50,000 unique patients in the McGuire VAMC EMR, we found 1,858 patients treated with XRT for PC more than 5 years ago between 1997 and 2015. Of these 1,190 were still alive and 455 had not been seen by our clinic in 400 days or more. Of these 455 patients, 159 patients had not had a PSA drawn within 15 months and/or their most recent PSA was more than 0.5 ng/ml above nadir, triggering a chart review followed by either a phone call, repeat testing, in person follow up visit, or removal from follow up monitoring if clinically indicated. 296 patients were receiving appropriate care outside of our clinic and had no sign of significant rise in PSA. An analysis by the VA showed annual savings of $60,360 per year in fuel costs by avoiding unnecessary visits. Conclusions: The VA’s robust EMR and a new query tool can identify patients with prostate cancer who are lost to follow up or who needed intervention from among thousands of patients in the EMR, improving quality while reducing cost and unnecessary time and travel for rural and all patients. More importantly, our tool could be modified to improve survival for all VA patients with prostate cancer by creating a VA-wide PSA failure detection system. The system would alert providers to any patient who may benefit from early salvage radiotherapy or hormonal therapy before their disease progresses beyond the therapeutic window of benefit.

Sign in / Sign up

Export Citation Format

Share Document