Search

Electronic medical records (EMRs) are stored in relational databases. It can be challenging to access the required information if the user is unfamiliar with the database schema or general database fundamentals. Hence, researchers have explored text-to-SQL generation methods that provide healthcare professionals direct access to EMR data without needing a database expert. However, currently available datasets have been essentially "solved" with state-of-the-art models achieving accuracy greater than or near 90%. In this paper, we show that there is still a long way to go before solving text-to-SQL generation in the medical domain. To show this, we create new splits of the existing medical text-to- SQL dataset MIMICSQL that better measure the generalizability of the resulting models. We evaluate state-of-the-art language models on our new split showing substantial drops in performance with accuracy dropping from up to 92% to 28%, thus showing substantial room for improvement. Moreover, we introduce a novel data augmentation approach to improve the generalizability of the language models. Overall, this paper is the first step towards developing more robust text-to-SQL models in the medical domain., (©2023 AMIA - All rights reserved.)

A sudden increase in mortality, preceded by a short history of respiratory signs and diarrhea, occurred in a backyard flock of 48 game chickens in the Central Valley of California. Necropsy findings included severe generalized linear hemorrhages and/or ulcers in the digestive tract, larynx, and trachea. Histology revealed severe multifocal hemorrhages and necrosis in the mucosa of the respiratory and digestive tracts, vasculitis, and necrosis of lymphoid tissue. The birds were serologically negative to Newcastle disease virus; this was consistent with an acute infection. The avian paramyxovirus type 1 isolated was characterized as velogenic viscerotropic Newcastle disease virus. A thorough epidemiologic investigation was carried out, and no other premises were found to have birds with clinical signs or evidence of exposure. The entire outbreak was limited to the original backyard flock and resolved within 14 days of the onset of clinical signs.