An overview of cooperative answering in databases
The field of cooperative answering goes back to work started by Joshi and Webber  in natural language processing in the early 1980s at the University of Pennsylvania. The work was applied to databases and information systems at the University of Pennsylvania by Kaplan [14, 15] and Mays . Other early work at the University of Pennsylvania and at other universities is discussed in [25, 13, 26, 16, 18, 24]. Databases and knowledge base systems are often difficult to use because they do not attempt to cooperate with their users. A database or a knowledge base query system provides literal answers to queries posed to them. Such answers to queries may not always be the best answers. Instead, an answer with extra or alternative information may be more useful and less misleading to a user.
This lecture surveys foundational work that has been done toward developing database and knowledge base systems with the ability to exhibit cooperative behavior. In the 1970s, Grice  proposed maxims of cooperative conversation. These maxims provide the starting point for the field of cooperative answering.
To develop a general system for data and knowledge bases, it is important to specify both the sources of information needed to provide cooperative behaviors, and what constitutes cooperative behavior. Several sources of knowledge apply: the basic knowledge in a system is given by explicit data, referred to as data in a relational database, or facts (extensional data) in a deductive database; by general rules that permit new relations (or new predicates) to be developed from existing data, referred to as views in relational databases and as intensional data in deductive databases; and by integrity constraints that must be consistent with the extensional and intensional data. Integrity constraints may be obtained either through the user or the database administrator, or by a data mining capability. Whereas integrity constraints must be consistent with every instance of the database schema, another source of knowledge is state constraints, which may apply to the current state, and need not apply to a subsequent state upon update. Two additional sources of knowledge arise from information about the users. One describes the class of the user, for example, an engineer or a child, each of whom expect different kinds of answers to queries, and user constraints that must be satisfied. User constraints need not be consistent with the database, but reflect the interests, preferences and desires of the user.
Misconceptions. A misconception is a query for which it is not possible, in any state of the database to have an answer.
State Misconceptions. A state misconception is a query for which it is not possible to have an answer, given the current state of the database.
False Presuppositions. A query has a false presupposition when it fails to have an answer, but is neither a misconception nor a state misconception.
Intensional Answer. An intensional answer is a generalization of a query which provides a rule that satisfies the query, but does not necessarily provide data that satisfies the query.
Relaxed Answer. A relaxed answer to a query is an answer that may or may not satisfy the original query, but provides an alternative answer that may meet the needs of the user.
Scalar Implicature. A scalar implicature is a range that may meet the query.
User Goals, Inferences and Preferences. User goals, interests and preferences should be adhered to when answering a query.
Cooperative AnsweRing Meta Interpreter (CARMIN), developed at the University of Maryland by Minker and his students [9, 8, 10].
User Goals, Interests and Limited Preferences
CoBase, developed at UCLA by Chu and his students [3,2,1,4,5]. A language, CoSQL has been implemented and interfaced with an existing database (Oracle) and SQL.
User Goals, Inferences and Preferences
FLEX, developed at George Mason University by Motro [23, 19–22].
Well Formedness Test of Queries and Automatic Modification
For a discussion of the state-of-the-art of cooperative answering systems, see
A functional description is provided of a cooperative database system. It is currently possible to develop a cooperative capability that interfaces with any of the existing database systems. Since proposed and future versions of relational databases will include capabilities to handle recursion and semantic query optimization, the ability to include cooperative capabilities will, in the not too distant future, be incorporated into such systems.
Unable to display preview. Download preview PDF.
- 1.W. W. Chu and Q. Chen. A structured approach for cooperative query answering. IEEE Transactions on Knowledge and Data Engineering, 6(5), Oct. 1994.Google Scholar
- 3.W. W. Chu, Q. Chen, and R.-C. Lee. Cooperative query answering via type abstraction hierarchy. In S. M. Deen, editor, Cooperating Knowledge Based Systems 1990, pages 271–290. Springer-Verlag, University of Keele, U.K., 1991.Google Scholar
- 4.W. W. Chu, Q. Chen, and M. A. Merzbacher. CoBase: A cooperative database system. In R. Demolombe and T. Imielinski, editors, Nonstandard Queries and Nonstandard Answers, Studies in Logic and Computation 3, chapter 2, pages 41–73. Clarendon Press, Oxford, 1994.Google Scholar
- 8.T. Gaasterland, P. Godfrey, J. Minker, and L. Novik. A cooperative answering system. In A. Voronkov, editor, Proceedings of the Logic Programming and Automated Reasoning Conference, Lecture Notes in Artificial Intelligence 624, pages 478–480. Springer-Verlag, St. Petersburg, Russia, July 1992.Google Scholar
- 9.T. Gaasterland, P. Godfrey, J. Minker, and L. Novik. Cooperative answers in database systems. In Proceedings of the Space Operations, Applications, and Research Conference, Houston, Texas, Aug. 1992.Google Scholar
- 10.P. Godfrey, J. Minker, and L. Novik. An architecture for a cooperative database system. In W. Litwin and T. Risch, editors, Proceedings of the First International Conference on Applications of Databases, Lecture Notes in Computer Science 819, pages 3–24. Springer Verlag, Vadstena, Sweden, June 1994.Google Scholar
- 11.H. Grice. Logic and Conversation. In P. Cole and J. Morgan, editors, Syntax and Semantics. Academic Press, 1975.Google Scholar
- 12.A. Joshi, B. Webber, and I. Sag, editors. Elements of Discourse Understanding. Cambridge University Press, 1981.Google Scholar
- 13.A. K. Joshi, B. L. Webber, and R. M. Weischedel. Living up to expectations: Computing expert responses. In Proceedings of the National Conference on Artificial Intelligence, pages 169–175, University of Texas at Austin, Aug. 1984. The American Association for Artificial Intelligence.Google Scholar
- 14.S. J. Kaplan. Appropriate responses to inappropriate questions. In Joshi et al. , pages 127–144.Google Scholar
- 16.W. Lehnert. A computational theory of human question answering. In Joshi et al. , pages 145–176.Google Scholar
- 17.E. Mays. Correcting misconceptions about database structure. In Proceedings of the CSCSI '80, 1980.Google Scholar
- 18.K. McKeown. Generating Natural Language Text in Response to Questions about Database Queries. PhD thesis, University of Pennsylvania, 1982.Google Scholar
- 19.A. Motro. Extending the relational model to support goal queries. In Proceedings from the First International Workshop on Expert Database Systems, pages 129–150. Benjamin/Cummings, 1986.Google Scholar
- 21.A. Motro. Using constraints to provide intensional answers to relational queries. In Proceedings of the Fifteenth International Conference on Very Large Data Bases, Aug. 1989.Google Scholar
- 24.M. E. Pollack. Generating expert answers through goal inference. Technical report, SRI International, Stanford, California, Oct. 1983.Google Scholar
- 25.M. E. Pollack, J. Hirschberg, and B. Webber. User participation in the reasoning processes of expert systems. In Proceedings of the American Association of Artificial Intelligence, 1982.Google Scholar
- 26.B. L. Webber and E. Mays. Varieties of user misconceptions: Detection and correction. In Proceedings of the Eighth International Joint Conference on Artificial Intelligence, pages 650–652, Karlsruhe, Germany, Aug. 1983.Google Scholar