Joliet
How to Prompt LLMs for Text-to-SQL: A Study in Zero-shot, Single-domain, and Cross-domain Settings
Chang, Shuaichen, Fosler-Lussier, Eric
Large language models (LLMs) with in-context learning have demonstrated remarkable capability in the text-to-SQL task. Previous research has prompted LLMs with various demonstration-retrieval strategies and intermediate reasoning steps to enhance the performance of LLMs. However, those works often employ varied strategies when constructing the prompt text for text-to-SQL inputs, such as databases and demonstration examples. This leads to a lack of comparability in both the prompt constructions and their primary contributions. Furthermore, selecting an effective prompt construction has emerged as a persistent problem for future research. To address this limitation, we comprehensively investigate the impact of prompt constructions across various settings and provide insights into prompt constructions for future text-to-SQL studies.
ConvNets for Counting: Object Detection of Transient Phenomena in Steelpan Drums
Hawley, Scott H., Morrison, Andrew C.
We train an object detector built from convolutional neural networks to count interference fringes in elliptical antinode regions in frames of high-speed video recordings of transient oscillations in Caribbean steelpan drums illuminated by electronic speckle pattern interferometry (ESPI). The annotations provided by our model aim to contribute to the understanding of time-dependent behavior in such drums by tracking the development of sympathetic vibration modes. The system is trained on a dataset of crowdsourced human-annotated images obtained from the Zooniverse Steelpan Vibrations Project. Due to the small number of human-annotated images and the ambiguity of the annotation task, we also evaluate the model on a large corpus of synthetic images whose properties have been matched to the real images by style transfer using a Generative Adversarial Network. Applying the model to thousands of unlabeled video frames, we measure oscillations consistent with audio recordings of these drum strikes. One unanticipated result is that sympathetic oscillations of higher-octave notes significantly precede the rise in sound intensity of the corresponding second harmonic tones; the mechanism responsible for this remains unidentified. This paper primarily concerns the development of the predictive model; further exploration of the steelpan images and deeper physical insights await its further application.
Intimacy in the Early Days of Online Dating
Gus, a 19-year-old homeschooled Christian from Joliet, Illinois, is trawling Facebook. He's just recovered from a debilitating bout of depression, and he's looking for someone to talk to. Through an online personality test, he finds a match: Jiyun, a 20-year-old from Korea, who moved to New York City with her family for her brother's cancer treatment. Gus messages her, and they begin chatting. "I started to fall for him when I saw these tagged videos on Facebook," Jiyun reveals in Nancy Schwartzman's short documentary, xoxosms.
The drone that found a Shaker Village in New Hampshire
Scanning an empty field that once housed a Shaker village in New Hampshire, Jesse Casana had come in search of the foundations of stone buildings, long-forgotten roadways and other remnants of this community dating to the 1790s. But instead of a trowel and shovel, Casana and his Dartmouth College colleague Chad Hill are using a drone equipped with a thermal imaging camera and mapping instruments. The camera can identify remnants of buildings and other structures up to several feet below the surface, since the temperatures of that brick or stone material is often warmer than the soil around it. Dartmouth's Chad Hill readies a drone to be flown over a site of a Shaker Village in Enfield, NH. The team was able to recognize traces of long-removed historic buildings and pathways at the Shaker Village in Enfield, N.H. The community once housed nearly 100 buildings but was sold in the 1920s and is now an outdoor history museum.