• bitcoinBitcoin(BTC)$76,416.000.84%
  • ethereumEthereum(ETH)$2,436.731.44%
  • tetherTether(USDT)$1.00-0.02%
  • binancecoinBNB(BNB)$724.341.40%
  • rippleXRP(XRP)$1.30-0.19%
  • usd-coinUSDC(USDC)$1.00-0.01%
  • solanaSolana(SOL)$99.602.51%
  • tronTRON(TRX)$0.3355080.43%
  • Figure HelocFigure Heloc(FIGR_HELOC)$1.032.64%
  • zcashZcash(ZEC)$1,363.6618.75%
  • HyperliquidHyperliquid(HYPE)$79.192.69%
  • dogecoinDogecoin(DOGE)$0.0810080.99%
  • USDSUSDS(USDS)$1.000.01%
  • moneroMonero(XMR)$499.95-1.35%
  • whitebitWhiteBIT Coin(WBT)$78.570.83%
  • RainRain(RAIN)$0.012894-7.87%
  • chainlinkChainlink(LINK)$11.132.87%
  • leo-tokenLEO Token(LEO)$8.941.15%
  • cardanoCardano(ADA)$0.1963630.45%
  • stellarStellar(XLM)$0.1825743.28%
  • Ethena USDeEthena USDe(USDE)$1.000.03%
  • daiDai(DAI)$1.000.01%
  • bitcoin-cashBitcoin Cash(BCH)$221.010.65%
  • USD1USD1(USD1)$1.00-0.01%
  • uniswapUniswap(UNI)$6.826.40%
  • litecoinLitecoin(LTC)$52.051.87%
  • CantonCanton(CC)$0.0973635.62%
  • the-open-networkGram (prev. Toncoin)(GRAM)$1.320.42%
  • nearNEAR Protocol(NEAR)$2.6814.45%
  • avalanche-2Avalanche(AVAX)$7.543.17%
  • Global DollarGlobal Dollar(USDG)$1.000.00%
  • hedera-hashgraphHedera(HBAR)$0.074156-0.45%
  • suiSui(SUI)$0.724.27%
  • shiba-inuShiba Inu(SHIB)$0.0000051.46%
  • crypto-com-chainCronos(CRO)$0.0586535.34%
  • paypal-usdPayPal USD(PYUSD)$1.00-0.01%
  • tether-goldTether Gold(XAUT)$4,294.90-0.53%
  • BlackRock USD Institutional Digital Liquidity FundBlackRock USD Institutional Digital Liquidity Fund(BUIDL)$1.000.00%
  • Circle USYCCircle USYC(USYC)$1.140.01%
  • BittensorBittensor(TAO)$224.523.05%
  • MemeCoreMemeCore(M)$1.12-0.93%
  • Ripple USDRipple USD(RLUSD)$1.00-0.02%
  • okbOKB(OKB)$111.410.17%
  • Ondo US Dollar YieldOndo US Dollar Yield(USDY)$1.14-0.29%
  • BitwayBitway(BTW)$0.73-4.40%
  • AsterAster(ASTER)$0.737.58%
  • aaveAave(AAVE)$121.870.68%
  • World Liberty FinancialWorld Liberty Financial(WLFI)$0.0589603.19%
  • pax-goldPAX Gold(PAXG)$4,297.38-0.58%
  • mantleMantle(MNT)$0.563.03%
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

Nunchux AI Introduces VC-Attention: A Training-Free Low-Bit Attention Kernel That Speeds Up Video Diffusion Transformers

House Passes Ratepayer Protection Act on Data Center Power Costs – Unite.AI

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

Nunchux AI Introduces VC-Attention: A Training-Free Low-Bit Attention Kernel That Speeds Up Video Diffusion Transformers
AI & Technology

Nunchux AI Introduces VC-Attention: A Training-Free Low-Bit Attention Kernel That Speeds Up Video Diffusion Transformers

September 17, 2026
House Passes Ratepayer Protection Act on Data Center Power Costs – Unite.AI
AI & Technology

House Passes Ratepayer Protection Act on Data Center Power Costs – Unite.AI

September 16, 2026
Snap Introduces A Standalone AI Assistant, Specs Intelligence
AI & Technology

Snap Introduces A Standalone AI Assistant, Specs Intelligence

September 16, 2026
Standalone AR Glasses Are Here
AI & Technology

Standalone AR Glasses Are Here

September 16, 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
Morning News NOW Full Episode – Sept. 8

Morning News NOW Full Episode – Sept. 8

September 16, 2026
Could New Hampshire Change the Midterm Calculus? and Refugee Stories of Survival – Sept. 8

Could New Hampshire Change the Midterm Calculus? and Refugee Stories of Survival – Sept. 8

September 15, 2026
Sit Out or Buy Now? The Signal Ken Mahoney Wants Before Jumping In

Sit Out or Buy Now? The Signal Ken Mahoney Wants Before Jumping In

September 14, 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!