Product literature

To see if we can get valuable information from the literature, we can use the PostgreSQL text search features functionality.

We can gather statistics about the most used words. We use "english" as the dictionary, this will remove common words like "the", "and", "is" from the results.

SELECT word, ndoc
   FROM ts_stat($$
     SELECT to_tsvector('english', literature)
     FROM import.product_literature AS t
  where LENGTH(word) > 4
  order by
    ndoc desc,
    LENGTH(word) desc
  limit 10;

(10 rows)

We can also search for literature references containing one ore more specific words, f.i. "covid". let's do that and find the 10 most referenced literature with the number of reports referencing them. As we will see, it is hard to detect any pattern, but there are more advanced ways to seek through text in PostgreSQL and we encourage everyone that is seriously interested in literature used in reports to look at the PostgreSQL documentation on text search.

  COUNT(DISTINCT local_number)
from import.product_literature
  to_tsvector('simple', literature) @@ to_tsquery('simple', 'covid')
GROUP BY trim(literature)
order by COUNT(DISTINCT local_number) desc limit 10;
Lopez G, Valero Zanuy M, Barrios I, Acute hypertriglyceridemia in patients with covid-19 receiving parenteral nutrition. Nutrients. 2021;13 (7):.29
Hoek A S R, Manintveld C O, Betjes G H M, Hellemons E M, Seghers L, Van Kampen A A J, et al.. COVID-19 in solid organ transplant recipients: a single-center experience. Transplant International. 2020;33:1099–110521
Elikowski W, Fertala N, Zawodna-Marszalek M, Rajewska-Tabor J, Swidurski W, Wajdlich D, Marszalek A, Skrzywanek P, Pyda M, Zytkiewicz M. [Marked self-limiting sinus bradycardia in COVID-19 patients not requiring therapy in the intensive care unit(]12
Aouba A, Baldolli A, Geffray L, Verdon R, Bergot E, Martin-Silva N, et al. Targeting the inflammatory cascade with anakinra in moderate to severe COVID-19 pneumonia: case series. Ann Rheum Dis. 2020;1-2.9
Beyls C, Martin N, Hermida A, Lopinavir-Ritonavir Treatment for COVID-19 Infection in Intensive Care Unit. Circulation: Arrhythmia and Electrophysiology. 2020 AUG;13(E008798):862-865.9
Saez-Gimenez B, Berastegui C, Barrecheguren M, Revilla-Lopez E, Los Arcos I, Alonso R, Aguilar M COVID-19 in lung transplant recipients: A multicenter study.. Am J Transplant.. 2021;21:1816-249
Omidi N, Forouzannia SK, Poorhosseini H, Tafti S.H.A, Salehbeigi S, Lotfi-Tokaldany M. Prosthetic heart valves and the COVID-19 pandemic era: What should we be concerned about?. Journal of cardiac surgery. 2020;35(10) 2500-5. doi:10.1111/jocs.147078
Elec A, Elec F, Oltean M, et. al.. COVID-19 after kidney transplantation: Early outcomes and renal function following antiviral treatment. Int J Infect Dis. 2021;104:426-432.8
Giacchetti G.; Salvio G.; Gianfelice C. et al.. Remote management of osteoporosis in the first wave of the COVID-19 pandemic. Archives of Osteoporosis. 2022;17 (37):1-98
Havlir, D.. 32nd Annual Medical Management of HIV/AIDS and COVID-19. Live Stream Conference. 2020;unk:unk7