arXiv Science⌕ Search

arXiv subjects

Luming Sun

Publications and source records attributed to Luming Sun.

At least 19 recordsLinked to original sources
arXiv2026

Abnormal Nitrogen Abundance in the X-ray Spectrum of Quasi-periodically Erupting Source AT2019wzc

Quasi-periodic eruptions (QPEs) are rapid, recurring soft X-ray bursts, whose nature is still in dispute. A compelling case of QPEs has emerged in the slowly evolving optical transient AT2019wzc, possibly associated with the tidal disruption of a post-main-sequence star by a supermassive black hole. Further evidence of a tidal disruption event (TDE) is crucial to understand the nature of AT2019wzc and establish the link between TDE and QPEs. Here we report the detection of a narrow, blueshifted N VI absorption line in its high-resolution X-ray spectra obtained by XMM-Newton, but weak or undetectable absorption lines from other elements of similar ionization states such as carbon and oxygen. The absorption line features can be reproduced by an ionized gas with ionization parameter $\log \xi \sim 0.3\ {\rm erg~cm~s^{-1}}$ and column density $N_{\rm H}\sim 10^{20}\ {\rm cm^{-2}}$, under the condition of a nitrogen abundance of $11.6_{-7.8}^{+19.6}$ times the solar value. This abnormal nitrogen abundance favors a TDE origin for AT2019wzc, and the absorbing gas may originate from the outflow induced by self-collision of the TDE's debris stream.

astro-ph.HE↗
arXiv2026

Radio and X-ray flux rebrightening six years after outburst in a partially-obscured extreme changing-look AGN

SDSS J1548+2208 is a unique partially-obscured nuclear transient that exhibits multiwavelength outbursts in mid-infrared, X-ray and radio. We present the results from multiwavelength photometric and spectroscopic follow-up observations with a time span of ~2500 days since its discovery. We find that the mid-infrared and X-ray emission (with a hard X-ray spectrum) are still in a high flux level relative to the pre-flare state, suggesting a sudden increased, and possibly long-sustained accreting activity from central black hole. This is supported by the slowly-evolving high-ionization coronal lines. The mid-infrared color turns blue slowly in the rising phase, which is distinct from stellar tidal disruption events (TDEs). All these properties point to the origin of outbursts from an extreme changing-look AGN and the scenario with a normal TDE seems disfavored. The radio spectral energy distribution (SED) in ~0.65-15 GHz is unusual, displaying a double-peak feature with distinct variability characteristics. In addition, we find evidence for the late-time radio rebrightening more than six years since the initial outburst, as well as a possibly new X-ray flare, though the significance for the latter is not high. The peculiar radio flux and SED evolution could be explained by a nascent outflow expanding into and shocking circumnuclear diffuse medium filled by denser clouds. In this case, SDSS J1548+2208 represents a rare changing-look AGN which can launch radio outflows. Continued multiwavelength observations are required to map the dust and gas distribution on pc-scales, providing new insights into the environmental properties that could regulate AGN changing-look phenomenon.

astro-ph.HE↗
arXiv2026

AT2019ijn: a fast-rising, slow-decaying blue optical transient with exceptionally bright radio emission

We report the discovery of a peculiar optical transient, AT2019ijn, occurred in the nuclear region of a dwarf galaxy at z=0.273. It rises rapidly to peak at a luminosity of Mg=-21.1 in 5 days, followed by a slow decline over more than a month, during which the optical emission has a persistently high blackbody temperature of T_BB~1.5-1.6x10^4 K. The radio emission is exceptional which peaks at 640 days after optical discovery with a high luminosity of 2x10^31 erg/s/Hz. The peak radio luminosity is at least two orders of magnitude brighter than known radio-bright fast blue optical transients and supernova explosions at similar epochs, but comparable to jetted tidal disruption events. The luminous and long-lasting radio emission with a late-time peak can be explained by an off-axis relativistic jet with a viewing angle of ~40 deg. We discuss possible origins for AT2019ijn and favor a jetted tidal disruption event involving an intermediate-mass black hole of ~10^5 Msun, although a jetted magnetar model cannot be fully ruled out. AT2019ijn represents a new class of relativistic optical transients that highlights the importance of radio surveys for discovering off-axis jetted events.

astro-ph.HE↗
arXiv2026

Exploring Tidal Disruption Events with SKA and VLBI: Unveiling the Mystery of Black Hole Feeding and Outflows

Tidal disruption events (TDEs) probe the birth and evolution of black hole accretion flows and jets on human timescales. Radio emission traces shocks and outflows from thermal TDEs and powerful relativistic jets in the rare jetted class. SKA Mid, phased for VLBI and used together with global networks, will deliver milliarcsecond imaging, tens of microarcsecond astrometry, and microJy sensitivity, enabling: (i) proper motion measurements that discriminate off axis relativistic jets from subrelativistic winds; (ii) resolved morphologies and magnetic field diagnostics via polarimetry; and (iii) precise nuclear localization to distinguish SMBH vs. IMBH and to reveal recoiling or binary systems. SKA's wide frequency coverage (0.35 to 15.4 GHz) and 1h continuum sensitivities of 3 to 10 microJy per beam, together with multibeam tiedarray VLBI and a transient buffer for rapid triggers, are transformational. LSST, Einstein Probe, and SVOM will increase TDE alerts to hundreds per year, and late time radio flares appear common, ensuring rich SKA VLBI samples. We provide observing strategies, detection forecasts, and predictions, e.g., about 5 proper motion detections of jetted (or off axis) TDEs per year and routine core shift constraints at the microarcsecond level. This program will establish TDEs as laboratories for exploring jet launching, particle acceleration (including neutrinos), black hole accretion history and demographics, and properties of circumnuclear medium.

astro-ph.HE↗
arXiv2026

An Obscured Tidal Disruption Event Uncovered by Its Mid- and Near-Infrared Dust Echo in a Star-Forming Galaxy

We present a comprehensive study of an infrared (IR) flare in the star-forming galaxy SDSS J010320.39+140152.5, which is selected from the sample of mid-IR (MIR) outbursts in nearby galaxies (MIRONG). Its MIR luminosity rose rapidly to a peak of $\sim5.4\times10^{43}$ \lum, maintained in the high state for about a year, and decreased continuously afterward. No optical variability was detected throughout the IR flare. Near-IR follow-up observations around the peak pinpointed the flare's location to spatially coincide with the galactic nucleus, with a $3\sigma$ upper limit of the offset of $\lesssim100$ pc. The IR spectral energy distribution (SED) of the flare is consistent with thermal emission of dust with temperatures of $\sim900$ K. Using a dust radiative transfer model, we inferred a peak UV luminosity of $\sim(4-10)\times10^{44}$ erg s$^{-1}$ and a total energy of $\sim(0.9-2)\times10^{52}$ ergs released. We ruled out the possibility of a supernova, and prefer that the IR flare originated from an obscured tidal disruption event (TDE) rather than a changing-look active galactic nucleus (AGN). This flare stands as one of the most compelling cases to date for the emerging class of dust-obscured TDEs in recent years. They are missed by optical surveys, partly accounting for the observed bias in TDE host galaxies, and represent a crucial, yet often overlooked, component for a complete understanding of the TDE population.

astro-ph.GA↗
arXiv2026

Bala-Join: An Adaptive Hash Join for Balancing Communication and Computation in Geo-Distributed SQL Databases

Shared-nothing geo-distributed SQL databases, such as CockroachDB, are increasingly vital for enterprise applications requiring data resilience and locality. However, we encountered significant performance degradation at the customer side, especially when their deployments span multiple data centers over a Wide Area Network (WAN). Our investigation identifies the bottleneck in the performance of the Distributed Hash Join (Dist-HJ) algorithm, which is contingent upon a crucial balance between communication overhead and computational load. This balance is severely disrupted when processing skewed data from real-world customer workloads, leading to the observed performance decline. To tackle this challenge, we introduce Bala-Join, an adaptive solution to balance the computation and network load in Dist-HJ execution. Our approach consists of the Balanced Partition and Partial Replication (BPPR) algorithm and a distributed online skewed join key detector. The former achieves balanced redistribution of skewed data through a multicast mechanism to improve computational performance and reduce network overhead. The latter provides real-time skewed join key information tailored to BPPR. Furthermore, an Active-Signaling and Asynchronous-Pulling (ASAP) mechanism is incorporated to enable efficient, real-time synchronization between the detector and the redistribution process with minimal overhead. Empirical study shows that Bala-Join outperforms the popular Dist-HJ solutions, increasing throughput by 25%-61%.

cs.DB↗
arXiv2026

Rate of Repeating Tidal Disruption Events with 5--19 years interval

Statistics on tidal disruption events (TDEs) may be contaminated by repeating TDEs (rTDEs), which have been extensively discovered recently. However, the origin of rTDEs remains unclear. In addition, no statistical research on rTDEs with time intervals $>5$ years has been made yet. In this work, we searched for rTDEs with time intervals of 5--19 years using CRTS data in a sample of 16 ZTF BTS TDEs at $z<0.05$. We found 2 rTDE candidates, AT 2019azh and AT 2024pvu, with time intervals of 13.2 and 17.1 years, respectively. The peak luminosities of CRTS flares are close to those of ZTF flares. For the CRTS flare of AT 2024pvu, using GALEX UV observations near the peak, we measured a blackbody temperature of $\sim19500$ K, consistent with TDEs and higher than SNe. Moreover, we estimated the expected number of SNe in the sample to be $\lesssim0.08$, and hence the probability that both CRTS flares are SNe is only 0.3\%. Therefore, the possibility that both CRTS flares are SNe can be ruled out, and it is likely that both are TDEs. Using the two rTDEs, we inferred that the TDE rate is 2--3 orders of magnitude higher than the average over 5--19 years prior to TDE detection. Considering another two rTDEs with intervals of $\sim$2 years in the sample and possible rTDEs missed by CRTS, rTDEs with intervals of $<20$ years may account for 25\%--60\% of the TDE sample. We prefer to explain rTDEs as repeating partial TDEs. If so, the high fraction of rTDEs suggests that the observed optical TDE rate has been overestimated. However, the possibility of independent TDEs cannot be ruled out and requires future observational tests.

astro-ph.HE↗
arXiv2026

Dust-obscured radio-emitting tidal disruption event coincident with a high-energy neutrino event

Despite the growing number of high-energy neutrinos (TeV-PeV) detected by IceCube, their astrophysical origins remain largely unidentified. Recent observations have linked a few tidal disruption events (TDEs) to the production of high-energy neutrino emission, all of which display dust-reprocessed infrared flares, indicating a dust- and gas-rich environment. By cross-matching the neutrino events and a sample of mid-infrared outbursts in nearby galaxies with transient radio flares, we uncover an optically obscured TDE candidate, SDSS J151345.75 $+$ 311125.2, which shows both spatial and temporal coincidence with the sub-PeV neutrino event IC170514B. Using a standard equipartition analysis of the synchrotron spectral evolution spanning 605 days post mid-infrared discovery, we find a little evolution in the radio-emitting region, with a kinetic energy up to $10^{51}$ erg, depending on the outflow geometry and shock acceleration efficiency assumed. High-resolution European VLBI Network imaging reveals a compact radio emission that is unresolved at a scale of $<$ 2.1 pc, with a brightness temperature of $T_b>5\times10^6$ K, suggesting that the observed late-time radio emission might originate from the interaction between a decelerating outflow and a dense circumnuclear medium. If the association is genuine, the neutrino production is possibly related to the acceleration of protons through pp collisions during the outflow expanding process, implying that the outflow-cloud interaction could provide a physical site with a high-density environment for producing the sub-PeV neutrinos. Such a scenario can be tested with future identifications of radio transients coincident with high-energy neutrinos.

astro-ph.HE↗
arXiv2025

Ultraviolet Spectral Evidence for Ansky as a Slowly Evolving Featureless Tidal Disruption Event with Quasiperiodic Eruptions

X-ray quasi-periodic eruptions (QPEs) are rare and enigmatic phenomena that increasingly show a connection to tidal disruption events (TDEs). However, the recently discovered QPEs in ZTF19acnskyy ("Ansky") appear to be linked to an active galactic nucleus (AGN) rather than a TDE, as their slow decay and AGN-like variability differ markedly from that of typical TDEs. This finding may imply broader formation channels for QPEs. To further investigate Ansky's nature, we obtained a timely ultraviolet (UV) spectrum, which reveals a featureless, TDE-like spectrum devoid of broad optical or UV emission lines. Additionally, the steep UV continuum, fitted by a power law with an index of -2.6, aligns more closely with TDEs than with AGNs. Compared to other featureless TDEs, Ansky exhibits a significantly lower blackbody luminosity (10^43 erg s^-1) and much longer rise and decay timescales, suggesting a distinct TDE subclass. An offset TDE involving an intermediate-mass black hole is unlikely, given its position consistent with the galactic center with a 3 sigma upper limit of 54 pc. Instead, we propose that Ansky may result from the tidal disruption of a post-main-sequence star by a typical supermassive black hole. Our findings strengthen the growing evidence for TDE-QPE associations, although other formation channels for QPEs remain plausible and await future observational efforts.

astro-ph.HE↗
arXiv2025

A fast powerful X-ray transient from possible tidal disruption of a white dwarf

Stars captured by black holes (BHs) can be torn apart by strong tidal forces, producing electromagnetic flares. To date, more than 100 tidal disruption events (TDEs) have been observed, each involving invariably normal gaseous stars whose debris falls onto the BH, sustaining the flares over years. White dwarfs (WDs), which are the most prevalent compact stars and a million times denser--and therefore tougher--than gaseous stars, can only be disrupted by intermediate-mass black holes (IMBHs) of 10^2--10^5 solar masses. WD-TDEs are considered to generate more powerful and short-lived flares, but their evidence has been lacking. Here we report observations of a fast and luminous X-ray transient EP250702a detected by Einstein Probe. Its one-day-long X-ray peak as luminous as 10^(47-49) erg/s showed strong recurrent flares with hard spectra extending to several tens of MeV gamma-rays, as detected by Fermi/GBM and Konus-Wind, indicating relativistic jet emission. The jet's X-ray dropped sharply from 3 x 10^49 erg/s to around 10^44 erg/s within 20 days (10 days in the source rest frame). These characteristics are inconsistent with any known transient phenomena other than a jetted-TDE evolving over an unprecedentedly short timescale, indicating the disruption of a WD by an IMBH. At late times, a new soft component progressively dominates the X-ray spectrum, exhibiting an extreme super-Eddington luminosity, which possibly originates from an accretion disc. WD-TDEs open a new window for investigating the elusive IMBHs and their surrounding stellar environments, and they are prime sources of gravitational waves in the band of space-based interferometers.

astro-ph.HE↗
arXiv2025

Outflow-cloud interaction as the possible origin of the peculiar radio emission in the tidal disruption event AT2018cqh

AT2018cqh is a unique optical tidal disruption event (TDE) discovered in a dwarf galaxy exhibiting delayed X-ray and radio flares. We present the results from high-resolution VLBA and e-MERLIN radio observations of AT2018cqh extending to $\delta$t $\sim$ 2250 days post discovery, which reveal a compact radio emission, unresolved at a scale of <~ 0.13 pc at 7.6 GHz, with a high brightness temperature of $T_b$ ~> 4.03 $\times$ 10$^{9}$ K. The radio spectral energy distribution (SED) is found to gradually shift towards a higher peak flux density and frequency over a period of $\sim$1000 days. An equipartition analysis suggests that there is a little change in the radio emitting region over this period, while the electron density increases by a factor of 3. The radio light curve at 0.89 GHz continues to rise, with a bump feature lasting for 240 days. These properties are in contrast to the predictions of standard shockwave model from a diffuse circumnuclear medium, but could be explained if dense clouds exist in the circumnuclear environment. The latter scenario is supported by our hydrodynamic simulations of the interaction of TDE outflow with a cloud, which can reproduce the temporal evolution in the radio SED. This work highlights the importance of the outflow-cloud interaction in explaining the delayed, fast-rising radio emission observed in some TDEs, especially those occurring in galaxies with pre-existing AGN activity.

astro-ph.HE↗
arXiv2025

Distinguishing Tidal Disruption Events and Changing-look Active Galactic Nuclei via Variation of Mid-infrared Color

At present, there is a lack of effective probes to distinguish between mid-infrared (MIR) outbursts induced by tidal disruption events (TDEs) and changing-look active galactic nuclei (CLAGNs) based on only MIR data. Here, we propose that the time variation of MIR color (K-corrected W1-W2 after subtracting the quiescent fluxes) is a promising probe. With an optically selected sample containing TDEs, ambiguous nuclear transients (ANTs), and CLAGNs, we studied the MIR color variation of their MIR counterparts using NEOWISE-R data. We found that the MIR color of TDEs and ANTs turns red faster than CLAGNs during the rising phase, and TDEs have a redder color than ANTs at the earliest phase. The former may be caused by the difference between the ultraviolet light curves of TDEs/ANTs and CLAGNs, or be related to no or relatively weak underlying AGN in TDEs/ANTs, while the latter may be related to the difference in the dust geometry. Based on color variation rate, we selected high-probability TDE, ANT, and CLAGN candidates from MIR outbursts in samples of Jiang et al. (2021) and Masterson et al. (2024). We found that both samples are mixtures of TDEs/ANTs and CLAGNs. For MIR outbursts whose hosts are not Seyfert galaxies, we estimated that $\sim50\%-80\%$ are TDEs and inferred a rate of infrared TDEs of $1.5-2.8\times10^{-5}$ galaxy$^{-1}$ yr$^{-1}$, comparable with that of optical TDEs. The rest are CLAGNs, suggesting the presence of weak AGNs that cannot be identified using common diagnoses. We predicted that with our method, a large amount of dust-obscured TDEs could be selected from future infrared surveys with higher data quality and cadence.

astro-ph.HE↗
arXiv2025

An 85-s X-ray quasi-periodicity after a stellar tidal disruption by a candidate intermediate-mass black hole

It is still in dispute the existence of intermediate-mass black holes (IMBHs) with a mass of ~10^3-10^5 solar masses (Msun), which are the missing link between stellar-mass black holes (5-50 Msun) and supermassive black holes (10^6-10^10 Msun). The bright flares from tidal disruption events (TDEs) provide a new and direct way to probe IMBHs. 3XMM J215022.4-055108 is a unique off-nuclear X-ray transient which can be best explained as the TDE by an IMBH in a massive star cluster, though its mass is not well determined. Here, we report the discovery of a transient X-ray quasi-periodicity signal from 3XMM J215022.4-055108 with a period of ~85 seconds (at a significance of >3.51sigma) and fractional root-mean-squared amplitude of ~10%. Furthermore, the signal is coherent with a quality factor ~16. The significance drops to >3.13sigma if considering all light curves with sufficient quality for QPO search. Combining with the results from X-ray continuum fittings, the detection of QPO allows for joint constraints on the black hole mass and dimensionless spin in the range [9.9*10^3-1.6*10^4 Msun]$ and [0.26-0.36], respectively. This result supports the presence of an IMBH in an off-nuclear massive star cluster and may open up the possibility of studying IMBHs through X-ray timing of TDEs.

astro-ph.HE↗
arXiv2025

Galactic-scale emission-line outflow from the radio-loud quasar 3C 191

Quasar feedback is routinely invoked as an indispensable ingredient in galaxy formation models. Galactic outflows are a crucial agent of quasar feedback that frequently manifest themselves in absorption and emission lines. Measuring the size and energetics of outflows based on absorption lines remains a challenge, and integral-field spectroscopy (IFS) mapping in emission lines is complementary. We present a VLT/SINFONI IFS mapping of quasar 3C 191 at $z \sim 2$, in which the outflow has been analyzed in absorption line spectroscopy. Three components are found based on the morphology and kinetics of [OIII]-emitting gas: a unshifted component which consistent with the systemic redshift and the location of the nucleus, a blueshifted in the north, and a redshifted in the south. The latter two components have velocities $\sim$ 600 km s$^{-1}$ and projected extents of 5 and 11 kpc, respectively, suggesting a biconical outflow structure. The blueshifted component's velocity is consistent with that derived from absorption lines. Using the electron density measured by the absorption lines and the luminosity and velocity of [OIII] outflow, we derive the mass outflow rate to be $\dot{M} \sim $ 9.5-13.4 M$_\odot$ yr$^{-1}$ and kinetic luminosity $\dot{E}_{\rm kin}$ ~ 2.5-3.7 $\times 10^{42}$ erg s$^{-1}$, consistent with absorption line analyses with VLT/Xshooter spectrum. The kinetic luminosity is only 0.01% of the bolometric luminosity, rendering a relatively weak outflow compared to typical expectation for effective feedback.

astro-ph.GA↗
arXiv2025

The distance of quasar outflows from the central source: The first consistent values from emission and absorption determinations

Measuring the distance of quasar outflows from the central source ($R$) is essential for determining their importance for AGN feedback. There are two methods to measure $R$: 1) A direct determination using spatially resolved Integral Field Spectroscopy (IFS) of the outflow in emission. 2) An indirect method which uses the absorption troughs from ionic excited states. The column density ratio between the excited and resonance states yields the outflow number density. Combined with a knowledge of the outflow's ionization parameter, $R$ can be determined. Generally, the IFS method probes $R$ range of several kpc or more, while the absorption method usually yields $R$ values of less than 1 kpc. There is no inconsistency between the two methods as the determinations come from different objects. Here we report the results of applying both methods to the same quasar outflow, where we derive consistent determinations of $R$ $\approx$ 5 kpc. This is the first time where the indirect absorption $R$ determination is verified by a direct spatially resolved IFS observation. In addition, the velocities (and energetics) from the IFS and absorption data are also found to be consistent. Therefore, these are two manifestations of the same outflow. In this paper we concentrate on the absorption $R$ determination for the outflow seen in quasar 3C 191 using VLT/X-shooter observations. We also reanalyze an older absorption determination for the outflow based on Keck/HIRES data and find that revised measurement to be consistent with ours. Our companion paper details the IFS analysis of the same object.

astro-ph.GA↗
arXiv2025

Discovery of a years-delayed radio flare from an unusually slow-evolved tidal disruption event

SDSS J1115+0544 is a unique low-ionization nuclear emission-line region (LINER) galaxy with energetic ultraviolet (UV), optical and mid-infrared outbursts occurring in its nucleus. We present the results from an analysis of multi-wavelength photometric and radio follow-up observations covering a period of ~9 years since its discovery. We find that following a luminosity plateau of ~500 days, the UV/optical emission has decayed back to the pre-outburst level, suggesting that the nuclear outburst might be caused by a stellar tidal disruption event (TDE). In this case, SDSS J1115+0544 could be an unusually slow-evolved optical TDE with longest rise and decline time-scales ever found. Three years later than the optical peak, a delayed radio brightening was found with a 5.5 GHz luminosity as high as ~1.9x10^39 erg/s. Using a standard equipartition analysis, we find the outflow powering the radio emission was launched at t~1260 days with a velocity of beta<~0.1 and kinetic energy of E_K~>10^50 erg. The delayed radio brightening coupled with the disappearing plateau in the UV/optical light curves is consistent with the scenario involving delayed ejection of an outflow from a state transition in the disk. SDSS J1115+0544 is the first TDE displaying both a short-lived UV/optical plateau emission and a late-time radio brightening. Future radio observations of these TDEs in the post-plateau decay phase will help to establish the connection between outflow launching and changes in accretion rate.

astro-ph.HE↗
arXiv2024

Recurring tidal disruption events a decade apart in IRAS F01004-2237

We report the discovery of a second optical flare that occurred in September 2021 in IRAS F01004-2237, where the first flare occurred in 2010 has been reported, and present a detailed analysis of multi-band data. The position of the flare coincides with the galaxy centre with a precision of 650 pc. The flare peaks in $\sim50$ days with an absolute magnitude of $\sim-21$ and fades in two years roughly following $L\propto t^{-5/3}$. It maintains a nearly constant blackbody temperature of $\sim$22,000 K in the late time. Its optical and UV spectra show hydrogen and helium broad emission lines with full width at half maxima of 7,000--21,000 km s$^{-1}$ and He II/H$\alpha$ ratio of 0.3--2.3. It shows weak X-ray emission relative to UV emission, with X-ray flares lasting for $<2-3$ weeks, during which the spectrum is soft with a power-law index $\Gamma=4.4^{+1.4}_{-1.3}$. These characters are consistent with a tidal disruption event (TDE), ruling out the possibilities of a supernova or an active galactic nuclei flare. With a TDE model, we infer a peak UV luminosity of $3.3\pm0.2\times10^{44}$ erg s$^{-1}$ and an energy budget of $4.5\pm0.2\times10^{51}$ erg. The two optical flares separated by $10.3\pm0.3$ years can be interpreted as repeating partial TDEs, double TDEs, or two independent TDEs. Although no definitive conclusion can be drawn, the partial TDEs interpretation predicts a third flare around 2033, and the independent TDEs interpretation predicts a high TDE rate of $\gtrsim10^{-2}$ yr$^{-1}$ in F01004-2237, both of which can be tested by future observations.

astro-ph.HE↗
arXiv2024

Is Large Language Model Good at Database Knob Tuning? A Comprehensive Experimental Evaluation

Knob tuning plays a crucial role in optimizing databases by adjusting knobs to enhance database performance. However, traditional tuning methods often follow a Try-Collect-Adjust approach, proving inefficient and database-specific. Moreover, these methods are often opaque, making it challenging for DBAs to grasp the underlying decision-making process. The emergence of large language models (LLMs) like GPT-4 and Claude-3 has excelled in complex natural language tasks, yet their potential in database knob tuning remains largely unexplored. This study harnesses LLMs as experienced DBAs for knob-tuning tasks with carefully designed prompts. We identify three key subtasks in the tuning system: knob pruning, model initialization, and knob recommendation, proposing LLM-driven solutions to replace conventional methods for each subtask. We conduct extensive experiments to compare LLM-driven approaches against traditional methods across the subtasks to evaluate LLMs' efficacy in the knob tuning domain. Furthermore, we explore the adaptability of LLM-based solutions in diverse evaluation settings, encompassing new benchmarks, database engines, and hardware environments. Our findings reveal that LLMs not only match or surpass traditional methods but also exhibit notable interpretability by generating responses in a coherent ``chain-of-thought'' manner. We further observe that LLMs exhibit remarkable generalizability through simple adjustments in prompts, eliminating the necessity for additional training or extensive code modifications. Drawing insights from our experimental findings, we identify several opportunities for future research aimed at advancing the utilization of LLMs in the realm of database management.

cs.DB↗