EBMS Tickets

Issue Number 186
Summary [Search Database] Core Journals - implement functionality on search form
Created 2014-05-29 11:38:56
Issue Type Improvement
Submitted By Juthe, Robin (NIH/NCI) [E]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2014-08-06 21:38:47
Resolution Fixed
Path /home/bkline/backups/jira/oceebms/issue.127616
Description

We would like to begin using the Core Journals checkboxes on the search the database form to allow us to limit the results to only those citations published in the following list of "core" (often cited in PDQ) journals:

1.New England Journal of Medicine
2.JAMA
3.J Clin Oncology
4.JNCI
5.Nature Genetics
6.Lancet
7.Lancet Oncol
8.Ann Intern Med
9.Intl J Rad Onc Bio Phys
10.Blood
11.Pediatric, Blood, & Cancer
12.Cancer
13.BMJ

The default search setting should NOT apply this limitation, but we would select the "yes" checkbox to limit the search results by these journals.

Comment entered 2014-08-06 11:13:35 by Kline, Bob (NIH/NCI) [C]

Do you want an interface for modifying the core journal set? Or is it so stable that getting CBIIT to run SQL scripts from time to time would be more appropriate? If the former, please create a new ticket for the interface (unless there already is one, and I just haven't seen it).

Thanks.

Comment entered 2014-08-06 11:31:56 by Kline, Bob (NIH/NCI) [C]

Could I get the set of journal abbreviations for the core journals? The list above appears to be a mix of full titles, abbreviations, and others:

'New England Journal of Medicine' NOT FOUND
'J Clin Oncology' NOT FOUND
'JNCI' NOT FOUND
'Nature Genetics' NOT FOUND
'Intl J Rad Onc Bio Phys' NOT FOUND
'Pediatric, Blood, & Cancer' NOT FOUND

Thanks.

Comment entered 2014-08-06 12:40:46 by Juthe, Robin (NIH/NCI) [E]

I believe these are the journal abbreviations:

N Engl J Med
J Clin Oncol
J Natl Cancer Inst
Nat Genet
Int J Radiat Oncol Biol Phys
Pediatr Blood Cancer

Comment entered 2014-08-06 12:47:44 by Juthe, Robin (NIH/NCI) [E]

To answer your previous question, we don't need an interface. The list of core journals is fairly stable. Thanks.

Comment entered 2014-08-06 21:38:47 by Kline, Bob (NIH/NCI) [C]

Ready for user review on DEV.

Comment entered 2014-08-07 13:28:05 by Juthe, Robin (NIH/NCI) [E]

This looks good on DEV. Applying the core journal filter slows down the search quite a bit, but it works! Thanks.

Comment entered 2014-08-28 11:58:59 by Kline, Bob (NIH/NCI) [C]

Submit release-3.1-patch.sql to DBA team before code deployment.

Comment entered 2014-09-16 15:33:30 by Shields, Victoria (NIH/NCI) [E]

This is REALLY SLOW on QA, too, but it is working! Verified on QA.

Comment entered 2014-09-18 09:03:31 by Kline, Bob (NIH/NCI) [C]

I suspect it will a bit faster on the production tier, but we've done some extensive investigation into possible approaches to this query, and we have come to the conclusion that there isn't any more optimization that we can do.

Comment entered 2014-09-18 09:46:15 by Shields, Victoria (NIH/NCI) [E]

Thanks, Bob, we appreciate your efforts! You have just spoiled us with such a fast system that anything doing the speed limit seems slow!

Comment entered 2014-11-05 16:45:53 by Shields, Victoria (NIH/NCI) [E]

Verified on PROD.

Elapsed: 0:00:00.000762