The DOI matches its Crossref record; 96 of the 101 references it cites were found in a registry or an index.
Natural language interfaces to databases – an introduction
Open accessAbstract
This paper is an introduction to natural language interfaces to databases (NLIDBS). A brief overview of the history of NLIDBS is first given. Some advantages and disadvantages of NLIDBS are then discussed, comparing NLIDBS to formal query languages, form-based interfaces, and graphical interfaces. An introduction to some of the linguistic problems NLIDBS have to confront follows, for the benefit of readers less familiar with computational linguistics. The discussion then moves on to NLIDB architectures, portability issues, restricted natural language input systems (including menu-based NLIDBS), and NLIDBS with reasoning capabilities. Some less explored areas of NLIDB research are then presented, namely database updates, meta-knowledge questions, temporal questions, and multi-modal NLIDBS. The paper ends with reflections on the current state of the art.
Overview
Integrity signals
Registry
Cites
Statistics
Verification
Claims the paper makes
Claims other papers make about this one
Each is checked against this paper’s own text: does it say what the citing paper says it does?
In the citing paper
“E-learning and mental health represent relevant interaction contexts, which have also seen great prominence in recent publications (Androutsopoulos et al., 1995; Chaves & Gerosa, 2021; Følstad & Skjuve, 2019; Hauswald et al., 2016).”
From Charting the Evolution and Future of Conversational Agents: A Research Agenda Along Five Waves and New Frontiers (2024) · cites this paper as Androutsopoulos et al., 1995
Citations
Cites
Proceedings of the 19th International Joint Conference on Artificial Intelligence
Pujol, J. M., Delgado, J., Ramon Sangüesa, A., & Flache, A. (2005) · International Joint Conference on Artificial Intelligence · Cited by 5,771
A relational model of data for large shared data banks
Codd, E. F. (1970) · Communications of the ACM · doi:10.1145/362384.362685 · Cited by 5,547
A relational model of data for large shared data banks
Codd, E. F. (1983) · Communications of the ACM · doi:10.1145/357980.358007 · Cited by 4,797
Principles of database and knowledge-base systems
(1989) · Choice Reviews Online · doi:10.5860/choice.26-5107 · Cited by 2,701
Generalized Phrase Structure Grammar.
Soames, S., Gazdar, G. J. M., Klein, E., Pullum, G. K., & Sag, I. A. (1989) · The Philosophical Review · doi:10.2307/2185122 · Cited by 1,829
Introduction to Montague Semantics
Dowty, D. R., Wall, R. E., & Peters, S. (1980) · Studies in linguistics and philosophy · doi:10.1007/978-94-009-9065-4 · Cited by 1,112
An introduction to unification-based approaches to grammar
Shieber, S. M. (1986) · Digital Access to Scholarship at Harvard (DASH) (Harvard University) · Cited by 935
6. Generalized Phrase Structure Grammar
Steurs, F. (1991) · Amsterdam studies in the theory and history of linguistic science. Series 4, Current issues in linguistic theory · doi:10.1075/cilt.75.08ste · Cited by 758
Logic Programming and Databases
Ceri, S., Gottlob, G., & Tanca, L. (1990) · Surveys in computer science · doi:10.1007/978-3-642-83952-8 · Cited by 750
Distributed Databases: Principles and Systems
Ceri, S., & Pelagatti, G. (1984) · CERN Document Server (European Organization for Nuclear Research) · Cited by 713
Temporal Databases: Theory, Design, and Implementation
Tansel, A. U., Clifford, J., Gadia, S. K., Jajodia, S., Segev, A., & Snodgrass, R. T. (1993) · Cited by 662
Hobbs, J. R. (1978) · Lingua · doi:10.1016/0024-3841(78)90006-2 · Cited by 625
Developing a natural language interface to complex data
Hendrix, G. G., Sacerdoti, E. D., Sagalowicz, D., & Slocum, J. (1978) · ACM Transactions on Database Systems · doi:10.1145/320251.320253 · Cited by 536
An English language question answering system for a large relational database
Waltz, D. L. (1978) · Communications of the ACM · doi:10.1145/359545.359550 · Cited by 346
Covington, M. A. (1994) · Language · doi:10.2307/416341 · Cited by 345
Computational Models of Discourse
(1983) · The MIT Press eBooks · doi:10.7551/mitpress/2019.001.0001 · Cited by 341
Readings in natural language processing
(1989) · Journal of Pragmatics · doi:10.1016/0378-2166(89)90051-9 · Cited by 311
An efficient easily adaptable system for interpreting natural language queries
Warren, D. H. D., & Pereira, F. C. N. (1982) · doi:10.5555/972942.972944 · Cited by 277
TEAM: An experiment in the design of transportable natural-language interfaces
Grosz, B. J., Appelt, D. E., Martin, P. A., & Pereira, F. C. N. (1987) · Artificial Intelligence · doi:10.1016/0004-3702(87)90011-7 · Cited by 264
Recognizing Intentions From Natural Language Utterances
(1983) · The MIT Press eBooks · doi:10.7551/mitpress/2019.003.0004 · Cited by 236
Formal semantics for time in databases
Clifford, J., & Warren, D. S. (1983) · ACM Transactions on Database Systems · doi:10.1145/319983.319986 · Cited by 227
van de Riet, R. P. (1986) · Future Generation Computer Systems · doi:10.1016/0167-739x(86)90015-4 · Cited by 189
Kerschberg, L. (1987) · ITNOW · doi:10.1093/combul/29.2.7 · Cited by 188
Proceedings 14th International Conference on Data Engineering
(1998) · IEEE International Conference on Data Engineering (ICDE) · doi:10.1109/icde.1998.655751 · Cited by 180
Exploring Artificial Intelligence
(1988) · Elsevier eBooks · doi:10.1016/c2013-0-07701-8 · Cited by 179
The role of natural language in a multimodal interface
Cohen, P. R. (1992) · ACM Symposium on User Interface Software and Technology (UIST) · doi:10.1145/142621.142641 · Cited by 170
Seven Steps to Rendezvous with the Casual User.
Codd, E. F. (1974) · Cited by 165
Cooperative Responses From a Portable Natural Language Database Query System
(1983) · The MIT Press eBooks · doi:10.7551/mitpress/2019.003.0005 · Cited by 165
Cooperative responses from a portable natural language query system
Kaplan, S. J. (1982) · Artificial Intelligence · doi:10.1016/0004-3702(82)90035-2 · Cited by 158
Anaphora in Natural Language Understanding: A Survey
Hirst, G. (1981) · Lecture notes in computer science · doi:10.1007/3-540-10858-0 · Cited by 151
Natural language interfaces to databases
Copestake, A., & Jones, K. S. (1990) · The Knowledge Engineering Review · doi:10.1017/s0269888900005476 · Cited by 145
Procedural semantics for a question-answering machine
Woods, W. A. (1968) · AFIPS Fall Joint Computer Conference (FJCC) · doi:10.1145/1476589.1476653 · Cited by 127
Grosz, B. J. (1983) · Conference on Applied Natural Language Processing · doi:10.3115/974194.974201 · Cited by 103
User oriented data base query with the ROBOT natural language query system
Harris, L. (1977) · International Journal of Man-Machine Studies · doi:10.1016/s0020-7373(77)80037-0 · Cited by 98
Menu-based natural language understanding
Tennant, H. R., Ross, K. M., Saenz, R. M., Thompson, C. W., & Miller, J. R. (1983) · Proceedings of the conference - Association for Computational Linguistics. Meeting · doi:10.3115/981311.981341 · Cited by 91
A Field Evaluation of Natural Language for Data Retrieval
Jarke, M., Tuner, J. A., Stohr, E. A., Vassiliou, Y., White, N. H., & Michielse, K. (1985) · IEEE Transactions on Software Engineering · doi:10.1109/tse.1985.231847 · Cited by 87
MASQUE/SQL: an efficient and portable natural language query interface for relational databases
Androutsopoulos, I., Ritchie, G., & Thanisch, P. (1993) · Cited by 77
Self-citationNatural Language Computing: The Commercial Applications
Johnson, T. P. (1984) · The Knowledge Engineering Review · doi:10.1017/s0269888900000588 · Cited by 69
Philips question-answering system PHLIQA1
Scha, R. J. H. (1977) · ACM SIGART Bulletin · doi:10.1145/1045283.1045291 · Cited by 61
Usable natural language interfaces through menu-based natural language understanding
Tennant, H. R., Ross, K. M., & Thompson, C. W. (1983) · ACM SIGCHI Conference on Human Factors in Computing Systems (CHI) · doi:10.1145/800045.801601 · Cited by 61
Whittemore, G., Ferrara, K. W., & Brunner, H. (1990) · Annual Meeting of the Association for Computational Linguistics (ACL) · doi:10.3115/981823.981827 · Cited by 55
Problems in natural-language interface to DBMS with examples from EUFID
Templeton, M., & Burger, J. F. (1983) · Conference on Applied Natural Language Processing · doi:10.3115/974194.974197 · Cited by 54
Discourse pragmatics and ellipsis resolution in task-oriented natural language interfaces
Carbonell, J. (1983) · Annual Meeting of the Association for Computational Linguistics (ACL) · doi:10.3115/981311.981343 · Cited by 52
An Experimental Comparison of Natural and Structured Query Languages
Small, D. W., & Weldon, L. J. (1983) · Human Factors The Journal of the Human Factors and Ergonomics Society · doi:10.1177/001872088302500301 · Cited by 51
Perrault, C. R., & Grosz, B. J. (1986) · Annual Review of Computer Science · doi:10.1146/annurev.cs.01.060186.000403 · Cited by 50
Introducing ask, a simple knowledgeable system
Thompson, B. H., & Thompson, F. B. (1983) · Conference on Applied Natural Language Processing · doi:10.3115/974194.974198 · Cited by 47
Operating statistics for the transformational question answering system
Damerau, F. J. (1981) · OLAC - Open Language Archives Community · doi:10.5555/972881.972884 · Cited by 46
The IRUS Transportable Natural Language Database Interface.
Bates, M., Moser, M., & Stallard, D. G. (1984) · Cited by 42
Natural language processing in LISP
Wood, M. M. (1990) · Science of Computer Programming · doi:10.1016/0167-6423(90)90066-m · Cited by 42
Workshop on the evaluation of natural language processing systems
Palmer, M. S., & Finin, T. (1990) · Cited by 41
Ballard, B. W., Lusth, J. C., & Tinkham, N. L. (1984) · ACM Transactions on Information Systems · doi:10.1145/357417.357418 · Cited by 40
Tense quantifiers, and contexts
Hinrichs, E. (1988) · doi:10.5555/55056.55057 · Cited by 39
Preliminary Analysis of a Breadth-First Parsing Algorithm: Theoretical and Experimental Results
Martin, W. A., Church, K., & Patil, R. S. (1987) · Springer eBooks · doi:10.1007/978-3-642-83030-3_8 · Cited by 38
ASK is transportable in half a dozen ways
Thompson, B. H., & Thompson, F. B. (1985) · ACM Transactions on Information Systems · doi:10.1145/3914.3983 · Cited by 38
Proceedings of the 12th Conference of the European Chapter of the ACL
Fürstenau, H., & Lapata, M. (2009) · Cited by 37
Using a natural language interface with casual users
Capindale, R. A., & Crawford, R. G. (1990) · International Journal of Man-Machine Studies · doi:10.1016/s0020-7373(08)80007-7 · Cited by 34
Prolog for Natural Language Processing
Gal, A., Lapalme, G., Saint‐Dizier, P., & SOMERS, H. L. (1991) · Cited by 33
Problems and some solutions in customization of natural language database front ends
Damerau, F. J. (1985) · ACM Transactions on Information Systems · doi:10.1145/3914.3915 · Cited by 32
Harris, L. (1978) · ACM Annual Conference · doi:10.1145/800127.804087 · Cited by 30
User studies and the design of natural language systems
Whittaker, S., & Stenton, P. (1989) · Conference of the European Chapter of the Association for Computational Linguistics · doi:10.3115/976815.976831 · Cited by 29
Efficient database access from Prolog
Ceri, S., Gottlob, G., & Wiederhold, G. C. M. (1989) · IEEE Transactions on Software Engineering · doi:10.1109/32.21742 · Cited by 29
Formal Semantics and Pragmatics for Natural Language Querying
Clifford, J. (1990) · Cambridge University Press eBooks · doi:10.1017/cbo9780511569753 · Cited by 29
CLARE: A Contextual Reasoning and Cooperative Response Framework for the Core Language EnginePreprint
Alshawi, H., Carter, D. M., Crouch, R., Pulman, S., Rayner, M., & Smith, A. G. (1994) · arXiv (Cornell University) · doi:10.48550/arxiv.cmp-lg/9411002 · Cited by 28
Communicating with databases in natural language
Wallace, M. G. (1984) · Medical Entomology and Zoology · Cited by 27
Experience with INTELLECT: Artificial Intelligence Technology Transfer
Harris, L. (1984) · AI Magazine · doi:10.1609/aimag.v5i2.437 · Cited by 26
A robust portable natural language data base interface
Ginsparg, J. M. (1983) · Conference on Applied Natural Language Processing · doi:10.3115/974194.974199 · Cited by 26
A hybrid approach to representation in the Janus natural language processor
Weischedel, R. (1989) · Annual Meeting of the Association for Computational Linguistics (ACL) · doi:10.3115/981623.981647 · Cited by 25
Transportable natural language processing through simplicity—the PRE system
Epstein, S. S. (1985) · ACM Transactions on Information Systems · doi:10.1145/3914.3985 · Cited by 24
Experience with robot in 12 commercial, natural language data base query applications
Harris, L. (1979) · International Joint Conference on Artificial Intelligence · Cited by 21
Portability of syntax and semantics in DATALOG
Hafner, C. D., & Godden, K. (1985) · ACM Transactions on Information Systems · doi:10.1145/3914.3982 · Cited by 21
An exploratory study of ad hoc query languages to databases
Bell, J. E., & Rowe, L. A. (2003) · IEEE International Conference on Data Engineering (ICDE) · doi:10.1109/icde.1992.213148 · Cited by 20
Database applications using Prolog
Lucas, R. J. (1988) · Halsted Press eBooks · Cited by 19
Is natural language querying practical?
Dekleva, S. M. (1994) · ACM SIGMIS Database the DATABASE for Advances in Information Systems · doi:10.1145/190743.190745 · Cited by 18
Aspects of the automatic generation of SQL statements in a natural language query interface
Ott, N. (1992) · Information Systems · doi:10.1016/0306-4379(92)90009-c · Cited by 17
Guida, G., & Tasso, C. (1983) · Conference on Applied Natural Language Processing · doi:10.3115/974194.974200 · Cited by 17
Bobrow, R., Resnik, P., & Weischedel, R. (1990) · Annual Meeting of the Association for Computational Linguistics (ACL) · doi:10.3115/981823.981852 · Cited by 17
Natural Language Interfaces: A new philosophy
Binot, J.-L., Debille, L., Sedlock, D. M., & Vandecapelle, B. (1991) · ORBi (University of Liège) · Cited by 16
Natural Language Access to Databases: Interpreting Update Requests
Davidson, J. C., & Kaplan, S. J. (1981) · Cited by 15
Access to Multiple Underlying Systems in Janus
Resnik, P. (1989) · doi:10.21236/ada214585 · Cited by 14
Proceedings of the 8th British National Conference on Databases (BNCOD-8)
Brown, A., & Hitchcock, P. (1990) · Open Research (University of Surrey) · Cited by 14
Generating English paraphrases from formal relational calculus expressions
Roeck, A. N. D., & Lowden, B. G. T. (1986) · doi:10.3115/991365.991534 · Cited by 13
Interaction of knowledge sources in a portable natural language interface
Hafner, C. D. (1984) · Annual Meeting of the Association for Computational Linguistics (ACL) · doi:10.3115/980491.980505 · Cited by 13
Accessing Relational and NF2 Databases Through Database Set Predicates
Draxler, C. (1992) · Workshops in computing · doi:10.1007/978-1-4471-3546-3_9 · Cited by 13
Identifying the knowledge requirements of an expert system's natural language processing interface
Diaper, D. (1986) · Cited by 13
Harris, L. (1988) · Cited by 12
The syntax and semantics of user-defined modifiers in a transportable natural language processor
Ballard, B. W. (1984) · Annual Meeting of the Association for Computational Linguistics (ACL) · doi:10.3115/980491.980504 · Cited by 11
Perrault, C. R., & Grosz, B. J. (1988) · Elsevier eBooks · doi:10.1016/b978-0-934613-67-5.50008-3 · Cited by 10
Dialog control in a natural language system
Gerlach, M., & Horacek, H. (1989) · Conference of the European Chapter of the Association for Computational Linguistics · doi:10.3115/976815.976819 · Cited by 8
Fakultät, P. (1991) · Cited by 8
Semantics of temporal queries and temporal data
Hafner, C. D. (1985) · Annual Meeting of the Association for Computational Linguistics (ACL) · doi:10.3115/981210.981211 · Cited by 6
A Formal Approach to Translating English into SQL.
Lowden, B. G. T., Walls, B., Roeck, A. N. D., Fox, C., & Turner, R. (1991) · British National Conference on Databases · Cited by 5
Denotational semantics for natural language question-answering programs
Main, M. G., & Benson, D. B. (1983) · OLAC - Open Language Archives Community · Cited by 5
Applied computational linguistics in perspective: proceedings of the workshop
Johnson, C. D., & Bachenko, J. (1982) · OLAC - Open Language Archives Community · Cited by 4
Natural Language Querying of Historical Databases
Clifford, J. (1987) · Faculty Digital Archive (New York University Florence) · Cited by 2
Computer dialogue laboratory SRI International
Cohen, P. R. (1991) · doi:10.1145/108844.109007 · Cited by 1
Flagged first, then by citations
5 of the 101 references couldn’t be matched to a known paper.
Research works printed but not linked: 35
- Woods W.A. , Kaplan R.M. , and Webber B.N. , (1972) The Lunar Sciences natural language information system: Final Report. BBN Report 2378, Bolt Beranek and Newman Inc., Cambridge, Massachusetts.
- Weischedel, 1989, Proceedings of the 27th Annual Meeting of ACL, 193
- Thompson, 1969, Proceedings of the 24th ACM National Converence, 399
- Tennant, 1983, Proceedings of the 21st Annual Meeting of ACL, 151
- Scha, 1977, SIGART Newsletter
- 1991, Natural Language Markets
- Bobrow, 1990, Processings of the 28th Annual Meeting of ACL, 227
- KBMS – Knowledge Base Management System
- Carbonell, 1983, Proceedings of the 21st Annual Meeting of ACL, 164
- Ballard, 1984, Processings of the 22nd Annual Meeting of ACL, 52
- Ballard, 1986, Proceedings of the 24th Annual Meeting of ACL, 20
- Androutsopoulos I , (1993) Interfacing a natural language front-end to a relational database. MSc thesis. Technical paper 11, Department of Artificial Intelligence, University of Edinburgh.
- Tennant, 1983, Proceedings of CHI'83, Conference on Human Factors in Computer Systems
- Lopes, 1984, Proeedings of the 22nd Annual Meetings of ACL
- Androutsopoulos, 1993, Proceedings of the 6th International Conference on Industrial and Engineering Applications of Artificial Intelligence and Expert Systems, Edinburgh, U.K, 327
- Woods, 1968, Proceedings of the Fall Joint Computer Conference, 457
- Sentance S. , (1989) Improved responses from an English language front end. M.Sc. thesis, Dept. of Artificial Intelligence, University of Edinburgh.
- Alshawi, 1992, The Core Language Engine
- Harris, 1978, Processings of the ACM'78 Annual Conference
- INTELLECT – Natural Language System
- Codd, 1974, Data Base Management
- De Roeck, 1986, Proceedings of the 11th International Conference on Computational Linguistics
- Diaper, 1986, People and Computers: Designing for Usability - Proceedings of the Second Conference of the British Computer Society, Human Computer Interaction Specialist Group, University of York, 263
- Whittemore, 1990, Proceedings of the 28th Annual Meting of ACL, 23
- Gerlach, 1989, Proceedings of the 4th Conference of the European Chapter of ACL, 27
- Giarratano, 1989, Expert Systems: Priniciples and Programming
- Hafner, 1984, Proceedings of the 22nd Annual Meeting of ACL, 57
- Hafner, 1985, Proceedings of the 23rd Annual Meeting of ACL, 1
- Bobrow, 1978, Research in Natural Language Understanding, BBN Report 3878
- Hendrix, 1982, Natural language interface (panel), Computational Linguistics, 8, 55
- Kaplan, 1983, Computational Models of Discourse, 167
- Martin, 1986, Readings in Natural Language Processing, 585
- Thompson, 1975, Advances in Computers, 109
- Lowden, 1986, REMIT: A natural language paraphraser for relational query expressions, ICL Technical Journal, 5, 32
- De Roeck, 1990, Proceedings of InfoJapan '90
Cited by
Sorted by citations
Natural language processing with Python
Bird, S., Klein, E., & Loper, E. (2009) · CERN Document Server (European Organization for Nuclear Research) · Cited by 3,472
Popowich, F. P. (1999) · Wiley Encyclopedia of Electrical and Electronics Engineering · doi:10.1002/047134608x.w6910 · Cited by 834
Zettlemoyer, L., & Collins, M. (2012) · arXiv (Cornell University) · doi:10.48550/arxiv.1207.1420 · Cited by 815
Seq2SQL: Generating Structured Queries from Natural Language using Reinforcement LearningPreprint
Zhong, V., Xiong, C., & Socher, R. (2017) · arXiv (Cornell University) · doi:10.48550/arxiv.1709.00103 · Cited by 1,384
Learning Dependency-Based Compositional Semantics
Liang, P., Jordan, M. I., & Klein, D. (2012) · Computational Linguistics · doi:10.1162/coli_a_00127 · Cited by 553
Metadata
- Authors
- Androutsopoulos, I., Ritchie, G. D., & Thanisch, P.
- Affiliations
- University of Edinburgh (GB)
- ORCID
- Androutsopoulos, I.
- Venue
- Natural Language Engineering
- Publisher
- Cambridge University Press (CUP)
- Published
- 1995-03
- Volume
- 1
- Issue
- 1
- Pages
- 29-81
- ISSN
- 1351-3249 (ISSN-L)
- 1469-8110
- OpenAlex
- W2145618437
- Cited by
- 768
- References
- 101
- Citations by year
- 2026: 27 · 2025: 27 · 2024: 17 · 2023: 22 · 2022: 16 · 2021: 41 · 2020: 49 · 2019: 39 · 2018: 31 · 2017: 32 · 2016: 26 · 2015: 25 · 2014: 29 · 2013: 30 · 2012: 31
- FWCI
- 10.93
- Type
- journal article
- Language
- en
- Open access
- green
- arxiv.org
- Locations
- Natural Language Engineering (publishedVersion)
- arXiv (Cornell University) (submittedVersion)
- arXiv (Cornell University)
- Funders
- State Scholarships Foundation
- Topics
- Physical Sciences › Computer Science › Artificial Intelligence › Natural Language Processing Techniques
- Physical Sciences › Computer Science › Artificial Intelligence › Speech and dialogue systems
- Physical Sciences › Computer Science › Information Systems › Advanced Database Systems and Queries
- Keywords
- natural language interfaces to databases, graphical user interface, linguistic challenges, database architecture, portability, menu-based interface, reasoning skills, database updates, multimodal interfaces
About these checks
Registry, retraction, Cites and statistics results are computed, not judged, with one exception: a printed reference that no index lists is read once by a model before it counts as a citation error. Claims are extracted by a model and kept only when their quote appears verbatim in the text; each cited source is then checked, with a model’s help, for whether it says what the claim relies on. Those verdicts can be wrong — read the claim’s quote and the cited source before relying on one.
Statistics and arithmetic are recomputed, not judged.
Confidence bands are shown only for fields calibrated on our annotated test set. None is calibrated yet, so no band is shown.
What counts as a claim ›How we measure confidence ›How we check this ›
Are you an author, or do you see a problem with this page? Request a review