{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,8,2]],"date-time":"2025-08-02T17:47:51Z","timestamp":1754156871683,"version":"3.41.2"},"reference-count":57,"publisher":"Emerald","issue":"1","license":[{"start":{"date-parts":[[2021,7,26]],"date-time":"2021-07-26T00:00:00Z","timestamp":1627257600000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.emerald.com\/insight\/site-policies"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["DTA"],"published-print":{"date-parts":[[2022,1,18]]},"abstract":"<jats:sec><jats:title content-type=\"abstract-subheading\">Purpose<\/jats:title><jats:p>Current possibilities of accessing business data by regular users usually involve complicated user interfaces or require technical expertise. This results in situations when business owners are separated from their data. The aim of this research is to apply an innovative approach leveraging conversational interfaces to tackle this problem.<\/jats:p><\/jats:sec><jats:sec><jats:title content-type=\"abstract-subheading\">Design\/methodology\/approach<\/jats:title><jats:p>The authors examine the current possibilities of accessing business data by business, users with an emphasis on conversational interfaces employing a chatbot as an alternative to traditional approaches. The authors propose a new concept relying on a guided conversation, and through experiments with a real chatbot and database, the authors demonstrate the benefits of the proposed approach.<\/jats:p><\/jats:sec><jats:sec><jats:title content-type=\"abstract-subheading\">Findings<\/jats:title><jats:p>The authors found out that the key to the success of our approach is a decomposition of complex database queries and their incremental construction in conversations. This also enables natural discovery of the domain model through constantly provided feedback. Based on the experiments with a real chatbot, the authors demonstrate that defining conversation flows and maintaining the conversation context is a crucial aspect contributing to the overall accuracy, together with keeping the conversation within the defined limits in its certain parts.<\/jats:p><\/jats:sec><jats:sec><jats:title content-type=\"abstract-subheading\">Originality\/value<\/jats:title><jats:p>The authors present a novel approach using natural language interfaces for accessing data by business users. In contrast to existing approaches, the authors emphasize incremental construction of queries, predefined conversation flows and constraining the conversations, when necessary.<\/jats:p><\/jats:sec>","DOI":"10.1108\/dta-03-2021-0062","type":"journal-article","created":{"date-parts":[[2021,7,23]],"date-time":"2021-07-23T03:49:19Z","timestamp":1627012159000},"page":"87-102","source":"Crossref","is-referenced-by-count":1,"title":["Conversational interfaces for unconventional access to business relational data structures"],"prefix":"10.1108","volume":"56","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-8704-6022","authenticated-orcid":false,"given":"Pavel","family":"Kosteln\u00edk","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-8892-4256","authenticated-orcid":false,"given":"Franti\u0161ek","family":"Da\u0159ena","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"140","published-online":{"date-parts":[[2021,7,26]]},"reference":[{"first-page":"39","article-title":"Dbiqs \u2013 an intelligent system for querying and mining databases using NLP","year":"2014","key":"key2022011708183000300_ref001"},{"key":"key2022011708183000300_ref002","doi-asserted-by":"crossref","first-page":"113113","DOI":"10.1016\/j.dss.2019.113113","article-title":"Two decades of research on business intelligence system adoption, utilization and success \u2013 a systematic literature review","volume":"125","year":"2019","journal-title":"Decision Support Systems"},{"key":"key2022011708183000300_ref003","unstructured":"Amtrak, I. (2013), \u201cMeet Julie: your virtual Amtrak travel assistant\u201d, available at: https:\/\/www.amtrak.com\/about-julie-amtrak-virtual-travel-assistant."},{"first-page":"148","article-title":"Maximum entropy models for named entity recognition","year":"2003","key":"key2022011708183000300_ref004"},{"volume-title":"Beginning AI Bot Frameworks: AI and Bot Basics","year":"2018","key":"key2022011708183000300_ref005"},{"key":"key2022011708183000300_ref006","doi-asserted-by":"crossref","first-page":"932","DOI":"10.14778\/2336664.2336667","article-title":"SODA: generating SQL for business users","volume":"5","year":"2012","journal-title":"Proceedings of the VLDB Endowment"},{"volume-title":"ValueNet: A Neural Text-To-SQL Architecture Incorporating Values","year":"2020","key":"key2022011708183000300_ref007"},{"volume-title":"Enterprise Resource Planning and Business Intelligence Systems for Information Quality: An Empirical Analysis in the Italian Setting (Contributions to Management Science)","year":"2018","key":"key2022011708183000300_ref008"},{"key":"key2022011708183000300_ref009","doi-asserted-by":"crossref","first-page":"377","DOI":"10.1145\/362384.362685","article-title":"A relational model of data for large shared data banks","volume":"13","year":"1970","journal-title":"Communications of the ACM"},{"key":"key2022011708183000300_ref010","doi-asserted-by":"crossref","first-page":"225","DOI":"10.1017\/S0269888900005476","article-title":"Natural language interfaces to databases","volume":"5","year":"1990","journal-title":"The Knowledge Engineering Review"},{"year":"2011","key":"key2022011708183000300_ref011","article-title":"The implementation of a storytelling chatbot"},{"key":"key2022011708183000300_ref012","first-page":"177","article-title":"Multi-platform chatbot modeling and deployment with the Jarvis framework","volume-title":"Advanced Information Systems Engineering","year":"2019"},{"key":"key2022011708183000300_ref013","article-title":"An algorithm for solving natural language query execution problems on relational databases","volume":"3","year":"2012","journal-title":"International Journal of Advanced Computer Science and Applications"},{"key":"key2022011708183000300_ref014","doi-asserted-by":"crossref","first-page":"6618","DOI":"10.1200\/jco.2014.32.15_suppl.6618","article-title":"Next steps for IBM Watson Oncology: scalability to additional malignancies","volume":"32","year":"2014","journal-title":"Journal of Clinical Oncology"},{"volume-title":"Developing Enterprise Chatbots: Learning Linguistic Structures","year":"2019","key":"key2022011708183000300_ref015"},{"first-page":"1","volume-title":"Chatbots for CRM and Dialogue Management","year":"2021","key":"key2022011708183000300_ref016"},{"key":"key2022011708183000300_ref017","doi-asserted-by":"crossref","first-page":"e17653","DOI":"10.1200\/jco.2014.32.15_suppl.e17653","article-title":"Piloting IBM Watson Oncology within memorial sloan kettering's regional network","volume":"32","year":"2014","journal-title":"Journal of Clinical Oncology"},{"key":"key2022011708183000300_ref018","unstructured":"Google, Inc. (2020), \u201cContexts \u2013 dialogflow documentation\u201d, available at: https:\/\/cloud.google.com\/dialogflow\/docs\/contexts-overview."},{"volume-title":"Chatbots: Conversation for All of Us, Technical Report","year":"2018","key":"key2022011708183000300_ref019"},{"year":"2019","key":"key2022011708183000300_ref020","article-title":"Towards complex text-to-SQL in cross-domain database with intermediate representation"},{"year":"2017","key":"key2022011708183000300_ref021","article-title":"Enabling organizational agility through self-service business intelligence: the case of a digital marketplace"},{"volume-title":"Mastering Microsoft Teams: End User Guide to Practical Usage, Collaboration, and Governance","year":"2018","key":"key2022011708183000300_ref022"},{"year":"2019","key":"key2022011708183000300_ref023","article-title":"A comprehensive exploration on WikiSQL with table-aware word contextualization"},{"key":"key2022011708183000300_ref024","first-page":"148","article-title":"Slack","volume":"106","year":"2018","journal-title":"Journal of the Medical Library Association"},{"volume-title":"Build Better Chatbots: A Complete Guide to Getting Started with Chatbots","year":"2017","key":"key2022011708183000300_ref025"},{"first-page":"121","article-title":"Understanding user satisfaction with intelligent assistants","year":"2016","key":"key2022011708183000300_ref026"},{"first-page":"519","article-title":"End-to-end neural entity linking","year":"2018","key":"key2022011708183000300_ref027"},{"volume-title":"MySQL 8 Query Performance Tuning: A Systematic Method for Improving Execution Speeds","year":"2020","key":"key2022011708183000300_ref028"},{"volume-title":"Business Analytics for Managers: Taking Business Intelligence beyond Reporting","year":"2017","key":"key2022011708183000300_ref029"},{"first-page":"104","volume-title":"Relational Databases: The Relational Model","year":"2019","key":"key2022011708183000300_ref030"},{"key":"key2022011708183000300_ref031","doi-asserted-by":"crossref","unstructured":"Liao, Q., Geyer, W., Muller, M. and Khazaen, Y. (2020), \u201cConversational interfaces for information search\u201d, in Fu, W.T. and van Oostendorp, H. (Eds), Understanding and Improving Information Search: A Cognitive Approach, Springer International Publishing, Cham, pp. 267-287.","DOI":"10.1007\/978-3-030-38825-6_13"},{"volume-title":"Building a Scalable Data Warehouse with Data Vault 2.0","year":"2015","key":"key2022011708183000300_ref032"},{"first-page":"563","article-title":"Effective keyword search in relational databases","year":"2006","key":"key2022011708183000300_ref033"},{"first-page":"365","volume-title":"Marketing Information Systems: An Integrative View","year":"2014","key":"key2022011708183000300_ref034"},{"key":"key2022011708183000300_ref035","first-page":"1187","article-title":"Modularized and flow-based approach to chatbot design and deployment","volume":"34","year":"2018","journal-title":"Journal of Information Science and Engineering"},{"volume-title":"Developing Bots with Microsoft Bots Framework: Create Intelligent Bots Using MS Bot Framework and Azure Cognitive Services","year":"2018","key":"key2022011708183000300_ref036"},{"key":"key2022011708183000300_ref037","doi-asserted-by":"crossref","unstructured":"McTear, M.F. (2017), \u201cThe rise of the conversational interface: a new kid on the block?\u201d, in Quesada, J.F., Mart\u00edn Mateos, F.-J. and L\u00f3pez Soto, T. (Eds), Future and Emerging Trends in Language Technology. Machine Learning and Big Data, Springer International Publishing, Cham, pp. 38-49.","DOI":"10.1007\/978-3-319-69365-1_3"},{"first-page":"11","volume-title":"The Dawn of the Conversational Interface","year":"2016","key":"key2022011708183000300_ref038"},{"first-page":"510","article-title":"Question answering through transfer learning from large fine-grained supervision data","year":"2017","key":"key2022011708183000300_ref039"},{"key":"key2022011708183000300_ref040","first-page":"121","article-title":"Thinking outside the inbox: use of Slack in clinical groups as a collaborative team communication platform","volume":"5","year":"2020","journal-title":"AEM Education and Training"},{"year":"2013","key":"key2022011708183000300_ref041","article-title":"NOSQL vs RDBMS \u2013 why there is no room for both"},{"volume-title":"Amtrak Customer Success Story","year":"2019","key":"key2022011708183000300_ref042"},{"first-page":"130","article-title":"A Vietnamese natural language interface to database","year":"2012","key":"key2022011708183000300_ref043"},{"first-page":"1532","article-title":"GloVe: global vectors for word representation","year":"2014","key":"key2022011708183000300_ref044"},{"key":"key2022011708183000300_ref045","unstructured":"Progress (2018), \u201c2018 data connectivity annual report\u201d, available at: https:\/\/www.progress.com\/campaigns\/datadirect\/whitepapers\/2018-data-connectivity-annual-report."},{"first-page":"117","article-title":"A theoretical framework for conversational search","year":"2017","key":"key2022011708183000300_ref046"},{"key":"key2022011708183000300_ref047","doi-asserted-by":"crossref","unstructured":"Sherman, R. (Ed.), (2015), Business Intelligence Guidebook, Morgan Kaufmann, Boston.","DOI":"10.1016\/B978-0-12-411461-6.00013-7"},{"volume-title":"Designing Bots: Creating Conversational Experiences","year":"2017","key":"key2022011708183000300_ref048"},{"year":"2020","key":"key2022011708183000300_ref049","article-title":"How to build your own intelligent assistant using Rasa"},{"volume-title":"Building an Enterprise Chatbot: Work with Protected Enterprise Data Using Open Source Frameworks","year":"2019","key":"key2022011708183000300_ref050"},{"key":"key2022011708183000300_ref051","doi-asserted-by":"crossref","first-page":"14","DOI":"10.1109\/MC.2016.196","article-title":"Cuddly user interfaces","volume":"49","year":"2016","journal-title":"Computer"},{"volume-title":"Designing Interfaces","year":"2011","key":"key2022011708183000300_ref052"},{"volume-title":"Well-Read Students Learn Better: On the Importance of Pre-training Compact Models","year":"2019","key":"key2022011708183000300_ref053"},{"key":"key2022011708183000300_ref054","first-page":"1","article-title":"Communicability of traditional interfaces vs chatbots in healthcare and smart home domains","volume":"39","year":"2019","journal-title":"Behaviour and Information Technology"},{"year":"2020","key":"key2022011708183000300_ref055","article-title":"Algorithm inspection for chatbot performance evaluation"},{"first-page":"3911","article-title":"Spider: a large-scale human-labeled dataset for complex and cross-domain semantic parsing and text-to-SQL task","year":"2018","key":"key2022011708183000300_ref056"},{"volume-title":"Seq2SQL: Generating Structured Queries from Natural Language Using Reinforcement Learning","year":"2017","key":"key2022011708183000300_ref057"}],"container-title":["Data Technologies and Applications"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.emerald.com\/insight\/content\/doi\/10.1108\/DTA-03-2021-0062\/full\/xml","content-type":"application\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/www.emerald.com\/insight\/content\/doi\/10.1108\/DTA-03-2021-0062\/full\/html","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,7,24]],"date-time":"2025-07-24T23:15:02Z","timestamp":1753398902000},"score":1,"resource":{"primary":{"URL":"http:\/\/www.emerald.com\/dta\/article\/56\/1\/87-102\/1113780"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2021,7,26]]},"references-count":57,"journal-issue":{"issue":"1","published-online":{"date-parts":[[2021,7,26]]},"published-print":{"date-parts":[[2022,1,18]]}},"alternative-id":["10.1108\/DTA-03-2021-0062"],"URL":"https:\/\/doi.org\/10.1108\/dta-03-2021-0062","relation":{},"ISSN":["2514-9288"],"issn-type":[{"type":"print","value":"2514-9288"}],"subject":[],"published":{"date-parts":[[2021,7,26]]}}}