Natural Language Querying of Complex Business Intelligence Queries

被引:13
|
作者
Sen, Jaydeep [1 ]
Ozcan, Fatma [1 ]
Quamar, Abdul [1 ]
Stager, Greg [2 ]
Mittal, Ashish [1 ]
Jammi, Manasa [1 ]
Lei, Chuan [1 ]
Saha, Diptikalyan [1 ]
Sankaranarayanan, Karthik [1 ]
机构
[1] IBM Res AI, Yorktown Hts, NY 10598 USA
[2] IBM Canada, Markham, ON, Canada
关键词
D O I
10.1145/3299869.3320248
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
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.
引用
收藏
页码:1997 / 2000
页数:4
相关论文
共 50 条
  • [21] Natural language querying of process execution data
    Kobeissi, Meriana
    Assy, Nour
    Gaaloul, Walid
    Defude, Bruno
    Benatallah, Boualem
    Haidar, Bassem
    [J]. INFORMATION SYSTEMS, 2023, 116
  • [22] A natural language querying interface for process mining
    Luciana Barbieri
    Edmundo Madeira
    Kleber Stroeh
    Wil van der Aalst
    [J]. Journal of Intelligent Information Systems, 2023, 61 : 113 - 142
  • [23] A natural language approach to flexible model querying
    Smart, J
    Cairns, A
    McNicol, JW
    Marshall, B
    [J]. COMPUTERS AND ELECTRONICS IN AGRICULTURE, 1996, 14 (04) : 317 - 331
  • [24] Explaining Structured Queries in Natural Language
    Koutrika, Georgia
    Simitsis, Alkis
    Ioannidis, Yannis E.
    [J]. 26TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING ICDE 2010, 2010, : 333 - 344
  • [25] Natural Language queries in CBR systems
    Diaz-Agudo, Belen
    Recio-Garcia, Juan A.
    Gonzalez-Calero, Pedro A.
    [J]. 19TH IEEE INTERNATIONAL CONFERENCE ON TOOLS WITH ARTIFICIAL INTELLIGENCE, VOL II, PROCEEDINGS, 2007, : 468 - 472
  • [26] Understanding Search Queries in Natural Language
    Neverilova, Zuzana
    Kvassay, Matej
    [J]. RASLAN 2018: RECENT ADVANCES IN SLAVONIC NATURAL LANGUAGE PROCESSING, 2018, : 85 - 93
  • [27] Ontology Based Natural Language Queries Transformation into SPARQL Queries
    Askar, Majid
    Algergawy, Alsayed
    Soliman, Taysir Hassan A.
    Koenig-Ries, Birgitta
    Sewisy, Adel A.
    [J]. BALTIC JOURNAL OF MODERN COMPUTING, 2020, 8 (04): : 719 - 731
  • [28] Natural Language Understanding for Partial Queries
    Liu, Xiaohu
    Celikyilmaz, Asli
    Sarikaya, Ruhi
    [J]. 2015 IEEE WORKSHOP ON AUTOMATIC SPEECH RECOGNITION AND UNDERSTANDING (ASRU), 2015, : 397 - 400
  • [29] Audio Retrieval with Natural Language Queries
    Oncescu, Andreea-Maria
    Koepke, A. Sophia
    Henriques, Joao F.
    Akata, Zeynep
    [J]. INTERSPEECH 2021, 2021, : 2411 - 2415
  • [30] Translating natural language questions to SQL queries (nested queries)
    Sindhuja Swamidorai
    T Satyanarayana Murthy
    K V Sriharsha
    [J]. Multimedia Tools and Applications, 2024, 83 : 45391 - 45405