skip to main content
10.1145/3106237.3117765acmconferencesArticle/Chapter ViewAbstractPublication PagesfseConference Proceedingsconference-collections
research-article

Natural language querying in SAP-ERP platform

Published:21 August 2017Publication 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/Google ScholarGoogle Scholar
  2. Open SQL. (Open SQL). Retrieved July 20, 2017 from https://help.sap.com/ saphelp_nw70ehp1/helpdata/en/fc/eb3983358411d1829f0000e829fbfe/content. htmGoogle ScholarGoogle Scholar
  3. SAP - module wise tables. (SAP - module wise tables). Retrieved July 20, 2017 from SAPGUI,SE11,PRESSF4,SAPAPPLICATIONSMENUGoogle ScholarGoogle Scholar
  4. SAP JCo Connector. (SAP JCo Connector). Retrieved July 20, 2017 from https://help.sap.com/saphelp_nwpi711/helpdata/en/48/ 70792c872c1b5ae10000000a42189c/content.htmGoogle ScholarGoogle Scholar
  5. SAP User Statistics. (SAP User Statistics). Retrieved July 20, 2017 from https: //goo.gl/MeFwVaGoogle ScholarGoogle Scholar
  6. THESAURUS. (THESAURUS). Retrieved July 20, 2017 from https://www. merriam-webster.com/thesaurus/companyGoogle ScholarGoogle Scholar
  7. Jonathan Berant et al. 2013. Semantic Parsing on Freebase from Question-Answer Pairs. In EMNLP. 1533–1544.Google ScholarGoogle Scholar
  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. Google ScholarGoogle ScholarDigital LibraryDigital 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.Google ScholarGoogle Scholar
  10. L. Kou, G. Markowsky, and L. Berman. 1981. A Fast Algorithm for Steiner Trees. Acta Informatica 15, 2 (1981), 141–145. Google ScholarGoogle ScholarDigital LibraryDigital Library
  11. D. Küpper, M. Storbel, and D. Rösner. 1993. NAUDA: A Cooperative Natural Language Interface to Relational Databases. In ACM SIGMOD. Google ScholarGoogle ScholarDigital LibraryDigital 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. Google ScholarGoogle ScholarDigital LibraryDigital Library
  13. Yunyao Li, Huahai Yang, and H. V. Jagadish. 2005. NaLIX: An Interactive Natural Language Interface for Querying XML. In ACM SIGMOD. Google ScholarGoogle ScholarDigital LibraryDigital 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 Google ScholarGoogle ScholarDigital LibraryDigital Library
  15. Ana-Maria Popescu et al. 2004. Modern Natural Language Interfaces to Databases: Composing Statistical Parsing with Semantic Tractability. In COLING. Google ScholarGoogle ScholarDigital LibraryDigital Library
  16. Etzioni Oren Popescu, Ana-Maria and Henry Kautz. 2003. Towards a Theory of Natural Language Interfaces to Databases. In IUI. Google ScholarGoogle ScholarDigital LibraryDigital 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. Google ScholarGoogle ScholarDigital LibraryDigital Library

Index Terms

  1. Natural language querying in SAP-ERP platform

      Recommendations

      Comments

      Login options

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

      Sign in
      • 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

        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]

        Publisher

        Association for Computing Machinery

        New York, NY, United States

        Publication History

        • Published: 21 August 2017

        Permissions

        Request permissions about this article.

        Request Permissions

        Check for updates

        Qualifiers

        • research-article

        Acceptance Rates

        Overall Acceptance Rate112of543submissions,21%

      PDF Format

      View or Download as a PDF file.

      PDF

      eReader

      View online with eReader.

      eReader