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 条
  • [1] ATHENA++: Natural Language Querying for Complex Nested SQL Queries
    Sen, Jaydeep
    Lei, Chuan
    Quamar, Abdul
    Özcan, Fatma
    Efthymiou, Vasilis
    Dalmia, Ayushi
    Stager, Greg
    Mittal, Ashish
    Saha, Diptikalyan
    Sankaranarayanan, Karthik
    [J]. Proceedings of the VLDB Endowment, 2020, 13 (11): : 2747 - 2759
  • [2] The NOX Framework Native Language Queries for Business Intelligence Applications
    Eavis, Todd
    Tabbara, Hiba
    Taleb, Ahmad
    [J]. DATA WAREHOUSING AND KNOWLEDGE DISCOVERY, 2010, 6263 : 172 - 189
  • [3] Complex Queries for Querying Linked Data
    Boumechaal, Hasna
    Boufaida, Zizette
    [J]. FUTURE INTERNET, 2023, 15 (03):
  • [4] A Controlled Natural Language for Business Intelligence Monitoring
    Colombo, Christian
    Grech, Jean-Paul
    Pace, Gordon J.
    [J]. NATURAL LANGUAGE PROCESSING AND INFORMATION SYSTEMS, NLDB 2015, 2015, 9103 : 300 - 306
  • [5] Natural language technology for information integration in business intelligence
    Maynard, Diana
    Saggion, Horacio
    Yankova, Milena
    Bontcheva, Kalina
    Peters, Wim
    [J]. BUSINESS INFORMATION SYSTEMS, PROCEEDINGS, 2007, 4439 : 366 - +
  • [6] Explicable knowledge graph (X-KG): generating knowledge graphs for explainable artificial intelligence and querying them by translating natural language queries to SPARQL
    Shaikh N.
    Chauhan T.
    Patil J.
    Sonawane S.
    [J]. International Journal of Information Technology, 2024, 16 (3) : 1605 - 1615
  • [7] Text-to-OverpassQL: A Natural Language Interface for Complex Geodata Querying of OpenStreetMap
    Staniek, Michael
    Schumann, Raphael
    Zuefle, Maike
    Riezler, Stefan
    [J]. TRANSACTIONS OF THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS, 2024, 12 : 562 - 575
  • [8] Querying an Ontology Using Natural Language
    Salgueiro, Ana Marisa
    Alves, Catarina Bile
    Balsa, Joao
    [J]. COMPUTATIONAL PROCESSING OF THE PORTUGUESE LANGUAGE, PROPOR 2018, 2018, 11122 : 164 - 169
  • [9] Natural language querying for video databases
    Erozel, Guzen
    Cicekli, Nihan Kesim
    Cicekli, Ilyas
    [J]. INFORMATION SCIENCES, 2008, 178 (12) : 2534 - 2552
  • [10] Querying knowledge graphs in natural language
    Liang, Shiqi
    Stockinger, Kurt
    de Farias, Tarcisio Mendes
    Anisimova, Maria
    Gil, Manuel
    [J]. JOURNAL OF BIG DATA, 2021, 8 (01)