Converting natural language text into executable SQL queries significantly impacts the healthcare domain, specifically when applied to electronic medical records. Given that electronic medical records store extensive patient information in a relational multitable database, developing a Text-to-SQL parser would enable the correlation of intricate medical terminology through semantic parsing. A major challenge is designing a versatile Text2SQL parser applicable to new databases. A critical step towards this goal involves schema linking - accurately identifying references to previously unseen columns or tables during SQL creation. In response to these key challenges, we propose a novel framework—Linking Information Enhanced Text2SQL Parsing on Complex Electronic Medical Records (LI-EMRSQL). This model leverages the Poincaré distance metric detection procedure, utilizing induced relations to enhance the performance of pre-existing graph-based parsers and improve schema linkage. To enhance the generalizability of LI-EMRSQL, the detection process is completely unsupervised and does not necessitate additional parameters. On two conventional Text2SQL datasets and two EMRs Text2SQL datasets, the system delivers SOTA performance. Furthermore, notable enhancements in the model's comprehension and alignment of schemas are observed.

Sensors have been installed on many civil infrastructures to monitor structural conditions. False alarm will be triggered, however, by the malfunctioned sensor even under normal conditions. Therefore, pre-processing is needed to identify and classify the sensor fault before structural damage detection and assessment. This paper proposes a deep learning-based method, namely, the Tsfresh Long Short-Term Memory networks (TLSTM), to address the sensor fault classification. The python package Tsfresh is used to extract features that are sensitive to sensor fault from measured signals. These features are further selected with the Benjamini–Yekutieli procedure. With the selected features, a long short-term memory (LSTM) network combining two fully-connected layers and a Softmax layer is constructed to differentiate sensor fault types. Experimental data with five types of sensor faults are obtained by mechanical and electrical simulation. The proposed method is shown able to successfully classify all these sensor fault types.