Abstract
To reduce the complexities of SQL query generation and increase the flexibilities of user interface, we propose a dialogue-based NLIDB system. The system classifies users’ intentions into domain actions (pairs of a speech act and a concept sequence) using a maximum entropy model. Based on the classification results, the system fills up predefined SQL templates and generates proper SQL queries for natural language interface. In the experiment, the system showed the success rate of 83.4% for SQL generation.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Choi, W., Kim, H., Seo, J.: An Integrated Dialogue Analysis Model for Determining Speech Acts and Discourse Structures. IEICE Information and Systems E88-D(1), 150–157 (2005)
Jung, H., Lee, G.: Multi-Lingual Question Answering with High Portability on Relational Databases. In: Proceedings of COLING Workshop on Multilingual Summarization and Question Answering (2002)
Kim, H., Kim, K., Lee, G., Seo, J.: A Fast and Reliable Question-Answering System Based on Predictive Answer Indexing and Lexico-Syntactic Pattern Matching. International Journal of Computer Processing of Oriental Language 14(4), 341–359 (2001)
Kim, H., Seo, J.: An Efficient Trigram Model for Speech Act Analysis in Small Training Corpus. Journal of Cognitive Science 4(1), 107–120 (2003)
Kim, H., Seon, C., Seo, J.: A Dialogue-Based Information Retrieval Assistant Using Shallow NLP Techniques in Online Sales Domains. IEICE Information and Systems 5, 801–808 (2005)
Levin, L., Langley, C., Lavie, A., Gates, D., Wallace, D., Peterson, K.: Domain Specific Speech Acts for Spoken Language Translation. In: Proceedings of 4th SIGdial Workshop on Discourse and Dialogue (2003)
Lweis, D.D., Ringuette, M.: Comparison of Two Learning Algorithms for Text Categorization. In: Proceedings of SDAIR (1994)
Ristad, E.: Maximum Entropy Modeling Toolkit. Technical Report, Department of Computer Science, Princeton University, Princeton, NJ (1996)
Senturk, C.: Natural Language Interfaces to Databases. In: the Course of Digital Libraries, E6998-003 (1997)
Warren, D., Pereira, F.: An Efficient Easily Adaptable System for Interpreting Natural Language Queries. Computational Linguistics 8 (1982)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2007 Springer Berlin Heidelberg
About this paper
Cite this paper
Kim, H. (2007). A Dialogue-Based NLIDB System in a Schedule Management Domain. In: van Leeuwen, J., Italiano, G.F., van der Hoek, W., Meinel, C., Sack, H., Plášil, F. (eds) SOFSEM 2007: Theory and Practice of Computer Science. SOFSEM 2007. Lecture Notes in Computer Science, vol 4362. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-69507-3_75
Download citation
DOI: https://doi.org/10.1007/978-3-540-69507-3_75
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-69506-6
Online ISBN: 978-3-540-69507-3
eBook Packages: Computer ScienceComputer Science (R0)