• bitcoinBitcoin(BTC)$80,635.005.77%
  • ethereumEthereum(ETH)$2,429.358.30%
  • tetherTether(USDT)$1.000.04%
  • binancecoinBNB(BNB)$716.504.26%
  • rippleXRP(XRP)$1.314.41%
  • usd-coinUSDC(USDC)$1.000.02%
  • solanaSolana(SOL)$96.646.23%
  • tronTRON(TRX)$0.319247-0.72%
  • Figure HelocFigure Heloc(FIGR_HELOC)$1.051.54%
  • zcashZcash(ZEC)$1,320.2012.28%
  • HyperliquidHyperliquid(HYPE)$84.171.86%
  • dogecoinDogecoin(DOGE)$0.0772165.41%
  • moneroMonero(XMR)$636.811.60%
  • USDSUSDS(USDS)$1.000.02%
  • whitebitWhiteBIT Coin(WBT)$78.046.51%
  • chainlinkChainlink(LINK)$11.587.62%
  • leo-tokenLEO Token(LEO)$9.350.54%
  • cardanoCardano(ADA)$0.1986417.15%
  • stellarStellar(XLM)$0.1684636.15%
  • bitcoin-cashBitcoin Cash(BCH)$282.005.14%
  • nearNEAR Protocol(NEAR)$4.058.48%
  • uniswapUniswap(UNI)$7.749.36%
  • daiDai(DAI)$1.00-0.02%
  • Ethena USDeEthena USDe(USDE)$1.000.06%
  • litecoinLitecoin(LTC)$56.366.62%
  • RainRain(RAIN)$0.005978-6.74%
  • CantonCanton(CC)$0.1016866.04%
  • avalanche-2Avalanche(AVAX)$8.835.52%
  • suiSui(SUI)$0.947.71%
  • USD1USD1(USD1)$1.000.06%
  • the-open-networkGram (prev. Toncoin)(GRAM)$1.182.01%
  • tether-goldTether Gold(XAUT)$4,109.764.57%
  • hedera-hashgraphHedera(HBAR)$0.0733697.40%
  • quant-networkQuant(QNT)$204.848.66%
  • Global DollarGlobal Dollar(USDG)$1.000.02%
  • shiba-inuShiba Inu(SHIB)$0.0000055.04%
  • BittensorBittensor(TAO)$237.397.45%
  • paypal-usdPayPal USD(PYUSD)$1.000.02%
  • crypto-com-chainCronos(CRO)$0.0523825.94%
  • Ripple USDRipple USD(RLUSD)$1.000.02%
  • EthenaEthena(ENA)$0.1834958.64%
  • Ondo US Dollar YieldOndo US Dollar Yield(USDY)$1.150.07%
  • okbOKB(OKB)$112.325.36%
  • Circle USYCCircle USYC(USYC)$1.140.01%
  • pepePepe(PEPE)$0.0000055.67%
  • aaveAave(AAVE)$132.876.15%
  • OndoOndo(ONDO)$0.4147759.01%
  • Pump.funPump.fun(PUMP)$0.0043555.27%
  • MemeCoreMemeCore(M)$0.841.47%
  • BlackRock USD Institutional Digital Liquidity FundBlackRock USD Institutional Digital Liquidity Fund(BUIDL)$1.000.00%
TradePoint.io
  • Main
  • AI & Technology
  • Stock Charts
  • Market & News
  • Business
  • Finance Tips
  • Trade Tube
  • Blog
  • Shop
No Result
View All Result
TradePoint.io
No Result
View All Result

Researchers at Stanford Introduce SUQL: A Formal Query Language for Integrating Structured and Unstructured Data

May 4, 2024
in AI & Technology
Reading Time: 5 mins read
A A
Researchers at Stanford Introduce SUQL: A Formal Query Language for Integrating Structured and Unstructured Data
ShareShareShareShareShare

Large Language Models (LLMs) have gained traction for their exceptional performance in various tasks. Recent research aims to enhance their factuality by integrating external resources, including structured data and free text. However, numerous data sources, such as patient records and financial databases, contain a mix of both types of information.  “Can you find me an Italian restaurant with a romantic atmosphere?”, an agent needs to combine the structured attribute cuisines and the free-text attribute reviews.

Previous chat systems typically employ classifiers to direct queries to specialized modules for handling structured data, unstructured data, or chitchat. However, this method falls short for questions requiring both structured and free-text data. Another approach involves converting structured data into free text, limiting the use of SQL for database queries and the effectiveness of free text retrievers. The necessity for hybrid data queries is underscored by datasets like HybridQA, containing questions necessitating information from both structured and free text sources. Prior endeavours to ground question-answering systems on hybrid data either operate on small datasets, sacrifice the richness of structured data queries or support limited combinations of structured and unstructured knowledge queries.

Stanford researchers introduce an approach to grounding conversational agents in hybrid data sources, utilizing both structured data queries and free-text retrieval techniques. It empirically demonstrates that users frequently ask questions spanning both structured and unstructured data in real-life conversations, with over 49% of queries requiring knowledge from both types. To enhance expressiveness and precision, they propose SUQL (Structured and Unstructured Query Language), a formal language augmenting SQL with primitives for processing free text, enabling a combination of off-the-shelf retrieval models and LLMs with SQL semantics and operators.

The SUQL’s design aims for expressiveness, accuracy, and efficiency. SUQL extends SQL with NLP operators like SUMMARY and ANSWER, facilitating full-spectrum queries on hybrid knowledge sources. LLMs proficiently translate complex text into SQL queries, empowering SUQL for complex queries. While SUQL queries can run on standard SQL compilers, a naive implementation may be inefficient. Outlining SUQL’s free-text primitives, highlighting its distinction from retrieval-based methods by expressing queries comprehensively.

Researchers evaluate SUQL through two experiments: one on HybridQA, a question-answering dataset, and another on real restaurant data from Yelp.com. The HybridQA experiment utilizes LLMs and SUQL to achieve 59.3% Exact Match (EM) and 68.3% F1 score. SUQL outperforms existing models by 8.9% EM and 7.1% F1 on the test set. In real-life restaurant experiments, SUQL demonstrates 93.8% and 90.3% turn accuracy in single-turn and conversational queries respectively, surpassing linearization-based methods by up to 36.8% and 26.9%.

To conclude, this paper introduces SUQL as the inaugural formal query language for hybrid knowledge corpora, encompassing structured and unstructured data. Its innovation lies in integrating free-text primitives into a precise and succinct query framework. In-context learning applied to HybridQA achieves results within 8.9% of the SOTA, trainable on 62K samples. Unlike prior methods, SUQL accommodates large databases and free-text corpora. Experiments on Yelp data demonstrate SUQL’s effectiveness, with a 90.3% success rate in satisfying user queries compared to 63.4% for linearization baselines.


Check out the Paper, Github, and Demo. All credit for this research goes to the researchers of this project. Also, don’t forget to follow us on Twitter. Join our Telegram Channel, Discord Channel, and LinkedIn Group.

If you like our work, you will love our newsletter..

Don’t Forget to join our 41k+ ML SubReddit


YOU MAY ALSO LIKE

Cat Wu to Lead Product Management for OpenAI’s Core Products – Unite.AI

Snap Has More Than 30 Million Paid Subscribers Across Snapchat+ And Other Plans

Asjad is an intern consultant at Marktechpost. He is persuing B.Tech in mechanical engineering at the Indian Institute of Technology, Kharagpur. Asjad is a Machine learning and deep learning enthusiast who is always researching the applications of machine learning in healthcare.


✅ [FREE AI WEBINAR Alert] Using AWS Bedrock & LangChain for Private LLM App Dev: May 6, 2024 10:00am – 11:00am PDT


Credit: Source link

ShareTweetSendSharePin

Related Posts

Cat Wu to Lead Product Management for OpenAI’s Core Products – Unite.AI
AI & Technology

Cat Wu to Lead Product Management for OpenAI’s Core Products – Unite.AI

November 5, 2026
Snap Has More Than 30 Million Paid Subscribers Across Snapchat+ And Other Plans
AI & Technology

Snap Has More Than 30 Million Paid Subscribers Across Snapchat+ And Other Plans

November 4, 2026
Atmospheric AI Secures M Seed for Procurement Modeling Push – Unite.AI
AI & Technology

Atmospheric AI Secures $10M Seed for Procurement Modeling Push – Unite.AI

November 4, 2026
Perplexity Adds Live Web Grounding to Its Decisions API – Unite.AI
AI & Technology

Perplexity Adds Live Web Grounding to Its Decisions API – Unite.AI

November 4, 2026
Next Post
GFL Environmental Inc. (GFL) Q1 2024 Earnings Call Transcript

GFL Environmental Inc. (GFL) Q1 2024 Earnings Call Transcript

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Search

No Result
View All Result
Cat Wu Steps Down as Claude Code Product Chief After Two Years – Unite.AI

Cat Wu Steps Down as Claude Code Product Chief After Two Years – Unite.AI

November 4, 2026
Remembering October 7th terror attacks on Israel three years later

Remembering October 7th terror attacks on Israel three years later

October 31, 2026
AI Data Center Anger Is From the ‘Fringes,’ Host Digital Chair Says

AI Data Center Anger Is From the ‘Fringes,’ Host Digital Chair Says

October 29, 2026

About

Learn more

Our Services

Legal

Privacy Policy

Terms of Use

Bloggers

Learn more

Article Links

Contact

Advertise

Ask us anything

©2020- TradePoint.io - All rights reserved!

Tradepoint.io, being just a publishing and technology platform, is not a registered broker-dealer or investment adviser. So we do not provide investment advice. Rather, brokerage services are provided to clients of Tradepoint.io by independent SEC-registered broker-dealers and members of FINRA/SIPC. Every form of investing carries some risk and past performance is not a guarantee of future results. “Tradepoint.io“, “Instant Investing” and “My Trading Tools” are registered trademarks of Apperbuild, LLC.

This website is operated by Apperbuild, LLC. We have no link to any brokerage firm and we do not provide investment advice. Every information and resource we provide is solely for the education of our readers. © 2020 Apperbuild, LLC. All rights reserved.

No Result
View All Result
  • Main
  • AI & Technology
  • Stock Charts
  • Market & News
  • Business
  • Finance Tips
  • Trade Tube
  • Blog
  • Shop

© 2023 - TradePoint.io - All Rights Reserved!