research-article

Natural language querying in SAP-ERP platform

Authors:

Diptikalyan Saha,

Neelamadhav Gantayat,

Barry MitchellAuthors Info & Claims

ESEC/FSE 2017: Proceedings of the 2017 11th Joint Meeting on Foundations of Software Engineering

Pages 878 - 883

https://doi.org/10.1145/3106237.3117765

Published: 21 August 2017 Publication History

Abstract

With the omnipresence of mobile devices coupled with recent advances in automatic speech recognition capabilities, there has been a growing demand for natural language query (NLQ) interface to retrieve information from the knowledge bases. Business users particularly find this useful as NLQ interface enables them to ask questions without the knowledge of the query language or the data schema. In this paper, we apply an existing research technology called ``ATHENA: An Ontology-Driven System for Natural Language Querying over Relational Data Stores'' in the industry domain of SAP-ERP systems. The goal is to enable users to query SAP-ERP data using natural language. We present the challenges and their solutions of such a technology transfer. We present the effectiveness of the natural language query interface on a set of questions given by a set of SAP practitioners.

References

[1]

Dynamic Open SQL. (Dynamic Open SQL). Retrieved July 20, 2017 from https: //www.ibm.com/developerworks/data/library/techarticle/dm-1007sapopensql/

[2]

Open SQL. (Open SQL). Retrieved July 20, 2017 from https://help.sap.com/ saphelp_nw70ehp1/helpdata/en/fc/eb3983358411d1829f0000e829fbfe/content. htm

[3]

SAP - module wise tables. (SAP - module wise tables). Retrieved July 20, 2017 from SAPGUI,SE11,PRESSF4,SAPAPPLICATIONSMENU

[4]

SAP JCo Connector. (SAP JCo Connector). Retrieved July 20, 2017 from https://help.sap.com/saphelp_nwpi711/helpdata/en/48/ 70792c872c1b5ae10000000a42189c/content.htm

[5]

SAP User Statistics. (SAP User Statistics). Retrieved July 20, 2017 from https: //goo.gl/MeFwVa

[6]

THESAURUS. (THESAURUS). Retrieved July 20, 2017 from https://www. merriam-webster.com/thesaurus/company

[7]

Jonathan Berant et al. 2013. Semantic Parsing on Freebase from Question-Answer Pairs. In EMNLP. 1533–1544.

[8]

Aditya Desai, Sumit Gulwani, Vineet Hingorani, Nidhi Jain, Amey Karkare, Mark Marron, Sailesh R, and Subhajit Roy. 2016. Program Synthesis Using Natural Language. In Proceedings of the ICSE (ICSE ’16). ACM, New York, NY, USA, 345– 356.

Digital Library

[9]

Swapnil Kanhe, Pramod Bodke, Akshay Chikhale, and Vaibhav Udawant. 2015. SQL Generation and PL/SQL Execution from Natural Language Processing. In International Journal of Engineering Research and Technology, Vol. 4. IJERT.

[10]

L. Kou, G. Markowsky, and L. Berman. 1981. A Fast Algorithm for Steiner Trees. Acta Informatica 15, 2 (1981), 141–145.

Digital Library

[11]

D. Küpper, M. Storbel, and D. Rösner. 1993. NAUDA: A Cooperative Natural Language Interface to Relational Databases. In ACM SIGMOD.

Digital Library

[12]

Fei Li and H. V. Jagadish. 2014. Constructing an Interactive Natural Language Interface for Relational Databases. Proc. VLDB Endow. 8, 1 (2014), 73–84.

Digital Library

[13]

Yunyao Li, Huahai Yang, and H. V. Jagadish. 2005. NaLIX: An Interactive Natural Language Interface for Querying XML. In ACM SIGMOD.

Digital Library

[14]

Mehdi Manshadi, Daniel Gildea, and James Allen. 2013. Integrating Programming by Example and Natural Language Programming. In AAAI (AAAI’13). AAAI Press, 661–667. http://dl.acm.org/citation.cfm?id=2891460.2891552

Digital Library

[15]

Ana-Maria Popescu et al. 2004. Modern Natural Language Interfaces to Databases: Composing Statistical Parsing with Semantic Tractability. In COLING.

Digital Library

[16]

Etzioni Oren Popescu, Ana-Maria and Henry Kautz. 2003. Towards a Theory of Natural Language Interfaces to Databases. In IUI.

Digital Library

[17]

Diptikalyan Saha, Avrilia Floratou, Karthik Sankaranarayanan, Umar Farooq Minhas, Ashish R. Mittal, and Fatma Özcan. 2016. ATHENA: An Ontology-driven System for Natural Language Querying over Relational Data Stores. Proc. VLDB Endow. 9, 12 (Aug. 2016), 1209–1220.

Digital Library

Cited By

Do HBrachman MDugan CJohnson JLauer JRai PPan Q(2024)Grounding with Structure: Exploring Design Variations of Grounded Human-AI Collaboration in a Natural Language InterfaceProceedings of the ACM on Human-Computer Interaction10.1145/36869028:CSCW2(1-27)Online publication date: 8-Nov-2024
https://dl.acm.org/doi/10.1145/3686902
Gantayat NSaha DSen JMani SDey LChaudhury SKrishnapuram RSingla PRoy R(2019)Goal-based Ontology Creation for Natural Language Querying in SAP-ERP PlatformProceedings of the ACM India Joint International Conference on Data Science and Management of Data10.1145/3297001.3297031(231-237)Online publication date: 3-Jan-2019
https://dl.acm.org/doi/10.1145/3297001.3297031

Index Terms

Natural language querying in SAP-ERP platform
1. Human-centered computing
  1. Human computer interaction (HCI)
    1. Interaction paradigms
      1. Natural language interfaces
2. Information systems
  1. Information retrieval
    1. Document representation
      1. Ontologies

Recommendations

Goal-based Ontology Creation for Natural Language Querying in SAP-ERP Platform
CODS-COMAD '19: Proceedings of the ACM India Joint International Conference on Data Science and Management of Data

The omnipresence of mobile devices coupled with recent advances in automatic speech recognition capabilities has led to a growing demand for natural language querying (NLQ) interfaces to retrieve information from data repositories. Going beyond consumer ...
Natural language querying of databases

Natural language (NL) interfaces for database (DB) query formulation have always been recognized as a much-needed enhancement for DB end-users. NL systems, however, have shortcomings that have led some DB researchers to question their practicality. The ...
Is natural language querying practical?

The study reported here involved the use of the natural language query system INTELLECT. It evaluated the level of correct interpretation to investigate whether the use of such a system is practical. Two sets of queries generated by two groups of senior-...

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences

ESEC/FSE 2017: Proceedings of the 2017 11th Joint Meeting on Foundations of Software Engineering

August 2017

1073 pages

ISBN:9781450351058

DOI:10.1145/3106237

General Chairs:
Eric Bodden
Paderborn University, Germany / Fraunhofer IEM, Germany
,
Wilhelm Schäfer
Paderborn University, Germany
,
Program Chairs:
Arie van Deursen
Delft University of Technology, Netherlands
,
Andrea Zisman
Open University, UK

Copyright © 2017 ACM.

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

SIGSOFT: ACM Special Interest Group on Software Engineering

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 21 August 2017

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article

Conference

ESEC/FSE'17

Sponsor:

SIGSOFT

ESEC/FSE'17: Joint Meeting of the European Software Engineering Conference and the ACM SIGSOFT Symposium on the Foundations of Software Engineering

September 4 - 8, 2017

Paderborn, Germany

Acceptance Rates

Overall Acceptance Rate 112 of 543 submissions, 21%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

2
Total Citations
View Citations
348
Total Downloads

Downloads (Last 12 months)20
Downloads (Last 6 weeks)3

Reflects downloads up to 03 Mar 2025

Other Metrics

View Author Metrics

Citations

Cited By

Do HBrachman MDugan CJohnson JLauer JRai PPan Q(2024)Grounding with Structure: Exploring Design Variations of Grounded Human-AI Collaboration in a Natural Language InterfaceProceedings of the ACM on Human-Computer Interaction10.1145/36869028:CSCW2(1-27)Online publication date: 8-Nov-2024
https://dl.acm.org/doi/10.1145/3686902
Gantayat NSaha DSen JMani SDey LChaudhury SKrishnapuram RSingla PRoy R(2019)Goal-based Ontology Creation for Natural Language Querying in SAP-ERP PlatformProceedings of the ACM India Joint International Conference on Data Science and Management of Data10.1145/3297001.3297031(231-237)Online publication date: 3-Jan-2019
https://dl.acm.org/doi/10.1145/3297001.3297031

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Figures

Tables

Media

View Table of Conten