-
Synthetic SQL Column Descriptions and Their Impact on Text-to-SQL Performance
Authors:
Niklas Wretblad,
Oskar Holmström,
Erik Larsson,
Axel Wiksäter,
Oscar Söderlund,
Hjalmar Öhman,
Ture Pontén,
Martin Forsberg,
Martin Sörme,
Fredrik Heintz
Abstract:
Relational databases often suffer from uninformative descriptors of table contents, such as ambiguous columns and hard-to-interpret values, impacting both human users and text-to-SQL models. In this paper, we explore the use of large language models (LLMs) to automatically generate detailed natural language descriptions for SQL database columns, aiming to improve text-to-SQL performance and automa…
▽ More
Relational databases often suffer from uninformative descriptors of table contents, such as ambiguous columns and hard-to-interpret values, impacting both human users and text-to-SQL models. In this paper, we explore the use of large language models (LLMs) to automatically generate detailed natural language descriptions for SQL database columns, aiming to improve text-to-SQL performance and automate metadata creation. We create a dataset of gold column descriptions based on the BIRD-Bench benchmark, manually refining its column descriptions and creating a taxonomy for categorizing column difficulty. We then evaluate several different LLMs in generating column descriptions across the columns and different difficulties in the dataset, finding that models unsurprisingly struggle with columns that exhibit inherent ambiguity, highlighting the need for manual expert input. We also find that incorporating such generated column descriptions consistently enhances text-to-SQL model performance, particularly for larger models like GPT-4o, Qwen2 72B and Mixtral 22Bx8. Notably, Qwen2-generated descriptions, containing by annotators deemed superfluous information, outperform manually curated gold descriptions, suggesting that models benefit from more detailed metadata than humans expect. Future work will investigate the specific features of these high-performing descriptions and explore other types of metadata, such as numerical reasoning and synonyms, to further improve text-to-SQL systems. The dataset, annotations and code will all be made available.
△ Less
Submitted 5 November, 2024; v1 submitted 8 August, 2024;
originally announced August 2024.
-
Gravitational Waves in Locally Rotationally Symmetric (LRS) Class II Cosmologies
Authors:
Michael Bradley,
Mats Forsberg,
Zoltán Keresztes
Abstract:
In this work we consider perturbations of homogeneous and hypersurface orthogonal cosmological backgrounds with local rotational symmetry (LRS), using a method based on the 1 + 1 + 2 covariant split of spacetime. The backgrounds, of LRS class II, are characterised by that the vorticity, the twist of the 2-sheets, and the magnetic part of the Weyl tensor all vanish. They include the flat Friedmann…
▽ More
In this work we consider perturbations of homogeneous and hypersurface orthogonal cosmological backgrounds with local rotational symmetry (LRS), using a method based on the 1 + 1 + 2 covariant split of spacetime. The backgrounds, of LRS class II, are characterised by that the vorticity, the twist of the 2-sheets, and the magnetic part of the Weyl tensor all vanish. They include the flat Friedmann universe as a special case. The matter contents of the perturbed spacetimes are given by vorticity-free perfect fluids, but otherwise the perturbations are arbitrary and describe gravitational, shear, and density waves. All the perturbation variables can be given in terms of the time evolution of a set of six harmonic coefficients. This set decouples into one set of four coefficients with the density perturbations acting as source terms, and another set of two coefficients describing damped source-free gravitational waves with odd parity. We also consider the flat Friedmann universe, which~has been considered by several others using the 1 + 3 covariant split, as a check of the isotropic limit. In agreement with earlier results we find a second-order wavelike equation for the magnetic part of the Weyl tensor which decouples from the density gradient for the flat Friedmann universes. Assuming vanishing vector perturbations, including the density gradient, we find a similar equation for the electric part of the Weyl tensor, which was previously unnoticed.
△ Less
Submitted 3 January, 2018;
originally announced January 2018.
-
Gravitational, shear and matter waves in Kantowski-Sachs cosmologies
Authors:
Zoltán Keresztes,
Mats Forsberg,
Michael Bradley,
Peter K. S. Dunsby,
László Á. Gergely
Abstract:
A general treatment of vorticity-free, perfect fluid perturbations of Kantowski-Sachs models with a positive cosmological constant are considered within the framework of the 1+1+2 covariant decomposition of spacetime. The dynamics is encompassed in six evolution equations for six harmonic coefficients, describing gravito-magnetic, kinematic and matter perturbations, while a set of algebraic expres…
▽ More
A general treatment of vorticity-free, perfect fluid perturbations of Kantowski-Sachs models with a positive cosmological constant are considered within the framework of the 1+1+2 covariant decomposition of spacetime. The dynamics is encompassed in six evolution equations for six harmonic coefficients, describing gravito-magnetic, kinematic and matter perturbations, while a set of algebraic expressions determine the rest of the variables. The six equations further decouple into a set of four equations sourced by the perfect fluid, representing forced oscillations and two uncoupled damped oscillator equations.
The two gravitational degrees of freedom are represented by pairs of gravito-magnetic perturbations. In contrast with the Friedmann case one of them is coupled to the matter density perturbations, becoming decoupled only in the geometrical optics limit. In this approximation, the even and odd tensorial perturbations of the Weyl tensor evolve as gravitational waves on the anisotropic Kantowski-Sachs background, while the modes describing the shear and the matter density gradient are out of phase dephased by $π/2$ and share the same speed of sound.
△ Less
Submitted 5 December, 2015; v1 submitted 29 July, 2015;
originally announced July 2015.
-
Perturbations of Kantowski-Sachs models with a cosmological constant
Authors:
Zoltán Keresztes,
Mats Forsberg,
Michael Bradley,
Peter K. S. Dunsby,
László Á. Gergely
Abstract:
We investigate perturbations of Kantowski-Sachs models with a positive cosmological constant, using the gauge invariant 1+3 and 1+1+2 covariant splits of spacetime together with a harmonic decomposition. The perturbations are assumed to be vorticity-free and of perfect fluid type, but otherwise include general scalar, vector and tensor modes. In this case the set of equations can be reduced to six…
▽ More
We investigate perturbations of Kantowski-Sachs models with a positive cosmological constant, using the gauge invariant 1+3 and 1+1+2 covariant splits of spacetime together with a harmonic decomposition. The perturbations are assumed to be vorticity-free and of perfect fluid type, but otherwise include general scalar, vector and tensor modes. In this case the set of equations can be reduced to six evolution equations for six harmonic coefficients.
△ Less
Submitted 3 April, 2013;
originally announced April 2013.
-
Perturbations of Kantowski-Sachs models
Authors:
Michael Bradley,
Mats Forsberg,
Zoltán Keresztes,
László Á. Gergely,
Peter K. S. Dunsby
Abstract:
Perturbations of Kantowski-Sachs models with a positive cosmological constant are considered in a harmonic decomposition, in the framework of gauge invariant 1+3 and 1+1+2 covariant splits of spacetime. Scalar, vector and tensor modes are allowed, however they remain vorticity-free and of perfect fluid type. The dynamics is encompassed in six evolution equations for six harmonic coefficients.
Perturbations of Kantowski-Sachs models with a positive cosmological constant are considered in a harmonic decomposition, in the framework of gauge invariant 1+3 and 1+1+2 covariant splits of spacetime. Scalar, vector and tensor modes are allowed, however they remain vorticity-free and of perfect fluid type. The dynamics is encompassed in six evolution equations for six harmonic coefficients.
△ Less
Submitted 19 March, 2013;
originally announced March 2013.
-
Density growth in Kantowski-Sachs cosmologies with cosmological constant
Authors:
Michael Bradley,
Peter K. S. Dunsby,
Mats Forsberg,
Zoltán Keresztes
Abstract:
In this work the growth of density perturbations in Kantowski-Sachs cosmologies with a positive cosmological constant is studied, using the 1+3 and 1+1+2 covariant formalisms. For each wave number we obtain a closed system for scalars formed from quantities that are zero on the background and hence are gauge-invariant. The solutions to this system are then analyzed both analytically and numericall…
▽ More
In this work the growth of density perturbations in Kantowski-Sachs cosmologies with a positive cosmological constant is studied, using the 1+3 and 1+1+2 covariant formalisms. For each wave number we obtain a closed system for scalars formed from quantities that are zero on the background and hence are gauge-invariant. The solutions to this system are then analyzed both analytically and numerically. In particular the effects of anisotropy and the behaviour close to a bounce in the cosmic scale factor are considered. We find that typically the density gradient in the bouncing directions experiences a local maximum at or slightly after the bounce.
△ Less
Submitted 30 April, 2012; v1 submitted 24 June, 2011;
originally announced June 2011.
-
The influence of strong field vacuum polarization on gravitational-electromagnetic wave interaction
Authors:
Mats Forsberg,
Demetrios Papadopoulos,
Gert Brodin
Abstract:
The interaction between gravitational and electromagnetic waves in the presence of a static magnetic field is studied. The field strength of the static field is allowed to surpass the Schwinger critical field, such that the quantum electrodynamical (QED) effects of vacuum polarization and magnetization are significant. Equations governing the interaction are derived and analyzed. It turns out that…
▽ More
The interaction between gravitational and electromagnetic waves in the presence of a static magnetic field is studied. The field strength of the static field is allowed to surpass the Schwinger critical field, such that the quantum electrodynamical (QED) effects of vacuum polarization and magnetization are significant. Equations governing the interaction are derived and analyzed. It turns out that the energy conversion from gravitational to electromagnetic waves can be significantly altered due to the QED effects. The consequences of our results are discussed.
△ Less
Submitted 28 May, 2010;
originally announced May 2010.
-
Interaction between gravitational waves and plasma waves in the Vlasov description
Authors:
G. Brodin,
M. Forsberg,
M. Marklund,
D. Eriksson
Abstract:
The nonlinear interaction between electromagnetic, electrostatic and gravitational waves in a Vlasov plasma is reconsidered. By using a orthonormal tetrad description the three-wave coupling coefficients are computed. Comparing with previous results, it is found that the present theory leads to algebraic expression that are much reduced, as compared to those computed using a coordinate frame for…
▽ More
The nonlinear interaction between electromagnetic, electrostatic and gravitational waves in a Vlasov plasma is reconsidered. By using a orthonormal tetrad description the three-wave coupling coefficients are computed. Comparing with previous results, it is found that the present theory leads to algebraic expression that are much reduced, as compared to those computed using a coordinate frame formalism. Furthermore, here we calculate the back-reaction on the gravitational waves, and a simple energy conservation law is deduced in the limit of a cold plasma.
△ Less
Submitted 11 November, 2009;
originally announced November 2009.
-
Harmonic generation of gravitational wave induced Alfven waves
Authors:
Mats Forsberg,
Gert Brodin
Abstract:
Here we consider the nonlinear evolution of Alfven waves that have been excited by gravitational waves from merging binary pulsars. We derive a wave equation for strongly nonlinear and dispersive Alfven waves. Due to the weak dispersion of the Alfven waves, significant wave steepening can occur, which in turn implies strong harmonic generation. We find that the harmonic generation is saturated d…
▽ More
Here we consider the nonlinear evolution of Alfven waves that have been excited by gravitational waves from merging binary pulsars. We derive a wave equation for strongly nonlinear and dispersive Alfven waves. Due to the weak dispersion of the Alfven waves, significant wave steepening can occur, which in turn implies strong harmonic generation. We find that the harmonic generation is saturated due to dispersive effects, and use this to estimate the resulting spectrum. Finally we discuss the possibility of observing the above process.
△ Less
Submitted 26 November, 2007;
originally announced November 2007.
-
Nonlinear Interactions Between Gravitational Radiation and Modified Alfven Modes in Astrophysical Dusty Plasmas
Authors:
Mats Forsberg,
Gert Brodin,
Mattias Marklund,
Padma K. Shukla,
Joachim Moortgat
Abstract:
We present an investigation of nonlinear interactions between Gravitational Radiation and modified Alfvén modes in astrophysical dusty plasmas. Assuming that stationary charged dust grains form neutralizing background in an electron-ion-dust plasma, we obtain the three wave coupling coefficients, and calculate the growth rates for parametrically coupled gravitational radiation and modified Alfvé…
▽ More
We present an investigation of nonlinear interactions between Gravitational Radiation and modified Alfvén modes in astrophysical dusty plasmas. Assuming that stationary charged dust grains form neutralizing background in an electron-ion-dust plasma, we obtain the three wave coupling coefficients, and calculate the growth rates for parametrically coupled gravitational radiation and modified Alfvén-Rao modes. The threshold value of the gravitational wave amplitude associated with convective stabilization is particularly small if the gravitational frequency is close to twice the modified Alfvén wave-frequency. The implication of our results to astrophysical dusty plasmas is discussed.
△ Less
Submitted 19 September, 2006; v1 submitted 16 June, 2006;
originally announced June 2006.
