Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
skip to main content
10.1145/3299869.3320248acmconferencesArticle/Chapter ViewAbstractPublication PagesmodConference Proceedingsconference-collections
research-article

Natural Language Querying of Complex Business Intelligence Queries

Published: 25 June 2019 Publication History

Abstract

Natural Language Interface to Database (NLIDB) eliminates the need for an end user to use complex query languages like SQL by translating the input natural language statements to SQL automatically. Although NLIDB systems have seen rapid growth of interest recently, the current state-of-the-art systems can at best handle point queries to retrieve certain column values satisfying some filters, or aggregation queries involving basic SQL aggregation functions. In this demo, we showcase our NLIDB system with extended capabilities for business applications that require complex nested SQL queries without prior training or feedback from human in-the-loop. In particular, our system uses novel algorithms that combine linguistic analysis with deep domain reasoning for solving core challenges in handling nested queries. To demonstrate the capabilities, we propose a new benchmark dataset containing realistic business intelligence queries, conforming to an ontology derived from FIBO and FRO financial ontologies. In this demo, we will showcase a wide range of complex business intelligence queries against our benchmark dataset, with increasing level of complexity. The users will be able to examine the SQL queries generated, and also will be provided with an English description of the interpretation.

References

[1]
Shreyas Bharadwaj, Laura Chiticariu, Marina Danilevsky, et almbox. 2017. Creation and Interaction with Large-scale Domain-Specific Knowledge Bases. PVLDB, Vol. 10 (2017), 1965--1968.
[2]
Chuan Lei, Fatma Ö zcan, Abdul Quamar, Ashish R. Mittal, Jaydeep Sen, Diptikalyan Saha, and Karthik Sankaranarayanan. 2018. Ontology-Based Natural Language Query Interfaces for Data Exploration. IEEE Data Eng. Bull., Vol. 41, 3 (2018), 52--63.
[3]
Fei Li and H. V. Jagadish. 2014. Constructing an Interactive Natural Language Interface for Relational Databases . Proc. VLDB Endow., Vol. 8, 1 (2014), 73--84.
[4]
Matthias Nicola, Irina Kogan, and Berni Schiefer. 2007. An XML transaction processing benchmark. In SIGMOD Conference .
[5]
Ana-Maria Popescu, Oren Etzioni, and Henry Kautz. 2003. Towards a Theory of Natural Language Interfaces to Databases. In Proceedings of the 8th International Conference on Intelligent User Interfaces (IUI '03). ACM, New York, NY, USA, 149--157.
[6]
Diptikalyan Saha, Avrilia Floratou, Karthik Sankaranarayanan, et almbox. 2016. ATHENA: an ontology-driven system for natural language querying over relational data stores. Proceedings of the VLDB Endowment, Vol. 9, 12 (2016), 1209--1220.
[7]
Alane Suhr, Srinivasan Iyer, and Yoav Artzi. 2018. Learning to Map Context-Dependent Sentences to Executable Formal Queries. In NAACL-HLT .
[8]
Prasetya Utama, Nathaniel Weir, Fuat Basik, et almbox. 2018. An End-to-end Neural Natural Language Interface for Databases. arXiv preprint arXiv:1804.00401 (2018).
[9]
Victor Zhong, Caiming Xiong, and Richard Socher. 2017. Seq2SQL: Generating Structured Queries from Natural Language using Reinforcement Learning. arXiv preprint arXiv:1709.00103 (2017).

Cited By

View all
  • (2024)The Effects of Global Market Changes on Automotive Manufacturing and Embedded SoftwareSustainability10.3390/su1612492616:12(4926)Online publication date: 8-Jun-2024
  • (2024)Natural Language Querying on NoSQL Databases: Opportunities and Challenges [Vision Paper]2024 IEEE International Conference on Big Data (BigData)10.1109/BigData62323.2024.10825998(3353-3357)Online publication date: 15-Dec-2024
  • (2023)RHB-Net: A Relation-aware Historical Bridging Network for Text2SQL Auto-CompletionProceedings of the 46th International ACM SIGIR Conference on Research and Development in Information Retrieval10.1145/3539618.3591759(1458-1467)Online publication date: 18-Jul-2023
  • Show More Cited By

Index Terms

  1. Natural Language Querying of Complex Business Intelligence Queries

    Recommendations

    Comments

    Information & Contributors

    Information

    Published In

    cover image ACM Conferences
    SIGMOD '19: Proceedings of the 2019 International Conference on Management of Data
    June 2019
    2106 pages
    ISBN:9781450356435
    DOI:10.1145/3299869
    Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

    Sponsors

    Publisher

    Association for Computing Machinery

    New York, NY, United States

    Publication History

    Published: 25 June 2019

    Permissions

    Request permissions for this article.

    Check for updates

    Author Tags

    1. business intelligence query
    2. intelligent database systems
    3. natural language interface to databases
    4. nested query

    Qualifiers

    • Research-article

    Conference

    SIGMOD/PODS '19
    Sponsor:
    SIGMOD/PODS '19: International Conference on Management of Data
    June 30 - July 5, 2019
    Amsterdam, Netherlands

    Acceptance Rates

    SIGMOD '19 Paper Acceptance Rate 88 of 430 submissions, 20%;
    Overall Acceptance Rate 785 of 4,003 submissions, 20%

    Contributors

    Other Metrics

    Bibliometrics & Citations

    Bibliometrics

    Article Metrics

    • Downloads (Last 12 months)48
    • Downloads (Last 6 weeks)2
    Reflects downloads up to 21 Jan 2025

    Other Metrics

    Citations

    Cited By

    View all
    • (2024)The Effects of Global Market Changes on Automotive Manufacturing and Embedded SoftwareSustainability10.3390/su1612492616:12(4926)Online publication date: 8-Jun-2024
    • (2024)Natural Language Querying on NoSQL Databases: Opportunities and Challenges [Vision Paper]2024 IEEE International Conference on Big Data (BigData)10.1109/BigData62323.2024.10825998(3353-3357)Online publication date: 15-Dec-2024
    • (2023)RHB-Net: A Relation-aware Historical Bridging Network for Text2SQL Auto-CompletionProceedings of the 46th International ACM SIGIR Conference on Research and Development in Information Retrieval10.1145/3539618.3591759(1458-1467)Online publication date: 18-Jul-2023
    • (2023)Towards Natural Language Interfaces for Data Visualization: A SurveyIEEE Transactions on Visualization and Computer Graphics10.1109/TVCG.2022.314800729:6(3121-3144)Online publication date: 1-Jun-2023
    • (2022)ONYX - User Interfaces for Assisting in Interactive Task Learning for Natural Language Interfaces of Data Visualization ToolsExtended Abstracts of the 2022 CHI Conference on Human Factors in Computing Systems10.1145/3491101.3519793(1-7)Online publication date: 27-Apr-2022
    • (2022)HERMES: data placement and schema optimization for enterprise knowledge basesThe VLDB Journal10.1007/s00778-022-00756-y32:3(549-574)Online publication date: 26-Jul-2022
    • (2021)Two New Challenging Resources to Evaluate Natural Language Interfaces to Databases Generated Based on Geobase and GeoqueryHandbook of Research on Natural Language Processing and Smart Service Systems10.4018/978-1-7998-4730-4.ch004(70-100)Online publication date: 2021
    • (2021)Natural Language Interfaces to DatabasesHandbook of Research on Natural Language Processing and Smart Service Systems10.4018/978-1-7998-4730-4.ch001(1-30)Online publication date: 2021
    • (2021)Robust voice querying with MUVEProceedings of the VLDB Endowment10.14778/3476249.347628914:11(2397-2409)Online publication date: 27-Oct-2021
    • (2021)Deep Learning: Systems and ResponsibilityProceedings of the 2021 International Conference on Management of Data10.1145/3448016.3457541(2867-2875)Online publication date: 9-Jun-2021
    • Show More Cited By

    View Options

    Login options

    View options

    PDF

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader

    Media

    Figures

    Other

    Tables

    Share

    Share

    Share this Publication link

    Share on social media