Abstract
Query formulation by using database specific query languages such as SQL or OQL turns out to be cumbersome or even impossible when end-users need to pose queries to large database schemes. This is due to the difficulties which arise out of the wrong or impossible interpretations of storage models and the lack of mechanisms to embed application domain semantics within query languages. Visual query languages (VQLs) and natural language (NL) based query interfaces in query answering systems alleviate, in some cases, the task of constructing a query. VQLs, however, are bound to visual formalisms which need further interpretation and still lack the use of semantics other than those provided by well-known conceptual models (EER, OMT, etc.). NL based approaches, on the other side, presuppose a considerable knowledge of the vocabulary terms to be used by the end-user for a particular application domain and, furthermore, they do not exploit the meaning of words other than that as provided by the syntax, in order to formulate a meaningful query. This turns out to be cumbersome, especially when advanced terminologies and large vocabularies should be used. This is also strengthened by the non-unique name assumption characterizing the application domain vocabulary. In this paper, we present a query construction paradigm which underlies the Meaning Driven Data Query LanguageMDDQL. It strongly relies on the construction of queries through suggestions of meaningful terms, in a preferred natural language, when requested by the end-user. An inference engine is responsible for the suggestion of a semantically consistent set, not only of application domain terms, but also of operator or operation terms, during the query construction process. All inferences are drawn at a “heuristic level” of representation of the vocabulary, i.e., on the basis of data structures (cyclic graph), and not at an “epistemological level”, i.e., based on logic-like representations.
Preview
Unable to display preview. Download preview PDF.
References
N.R. Adam and A. Gangopadhyay. A form-based natural language front-end to a CIM database. IEEE Transactions on Knowledge and Data Engineering, 9(2):238–250, April 1997.
S. Bechhofer, R. Stevens, G. Ng, A. Jacoby, and C. Goble. Guiding the User: An Ontology Driven Interface. In Norman W. Paton and Tony Griffiths, editors, Proc. User Interfaces to Data Intensive Systems (UIDIS99), pages 158–161, Edinburgh, September 1999. IEEE Press.
J. Cardiff, T. Catarci, and G. Santucci. Semantic query processing in theVENUSenvironment. International Journal of Cooperative Information Systems, 6(2):151–192, June 1997.
T. Catarci, M.F. Costabile, S. Levialdi, and C. Batini. Visual query systems for databases: A survey. Journal of Visual Languages and Computing, 8(2):215–260, April 1997.
R.G.G. Catell and D. K. Barry, editors. The Object Database Standard: ODMG 2.0. Morgan Kaufmann Publishers, Inc., 1997.
Noam Chomsky. Syntactic Structures. Mouton, The Hague, 1957.
Wesley W. Chu, Hua Yang, Kuorong Chiang, Michael Minock, Gladys Chow, and Chris Larson. CoBase: A scalable and extensible cooperative information system. Journal of Intelligent Information Systems, 1996.
W.W. Chu and Q. Chen. A Structured Approach for Cooperative Query Answering. IEEE Transactions on Knowledge and Data Engineering, 6(5):738–749, October 1994.
Ignacio Gil, Peter M.D. Gray, and Graham J.L. Kemp. A Visual Interface and Navigator for the P/FDM Object Database. In N. Paton and T. Griffiths, editors, Proc. of the 1st Inter. Workshop on User Interfaces to Data Intensive Systems, (UIDIS 99), pages 54–63, Edinburgh, Scotland, September 1999. IEEE Computer Society Press.
J. R. Groff and P. N. Weinberg. SQL: the complete reference. Osborne/McGraw-Hill, Berkeley, 1999.
B.J. Grosz, D. Appelt, P. Martin, and F. Pereira. TEAM:An experiment in the design of transportable natural-language interfaces. Journal of Intelligent Information Systems, 32(2):173–244, 1987.
G.G. Hendrix, E.D. Sacerdoti, D. Sagalowicz, and J. Slocum. Developing a natural language interface to complex data. ACMTransactions on Database Systems, 3(2):105-147, June 1978.
E. Kapetanios, D. Baer, P. Groenewoud, and P. Mueller. The Design and Implementation of a Meaning Driven Data Query Language. In Jessie Kennedy, editor, Proc. 14th Inter. Conf. on Scientific and Statistical Databases, Edinburgh, Scotland, July 2002. IEEE Computer Society Press.
E. Kapetanios, M.C. Norrie, and D. Fuhrer-Stakic. MDDQL: A Visual Query Language for Meta-data Driven Querying. In 5th IFIP Inter. Working Conf. on Visual Database Systems, Fukuoka, Japan, May 2000. Kluwer Academic Publisher.
K. Knight, I. Chancer, M. Haines, V. Hatzivassiloglou, and E.-H. Hovy. Filling Knowledge Gaps in a Broad-Coverage MT System. In Proc. of the 14th IJCAI-94, Montreal, Canada, 1995.
K. Knight and S. Luck. Building a Large Knowledge for Machine Translation. In Proc. of the AAAI-94, Seattle, USA, 1994.
Mario Fernadez Lopez. Overview of Methodologies for Building Ontologies. In Proc. of the IJCAI-99 Workshop on Ontologies and Problem-Solving Methods (KRR5), Stockholm, Sweden, August 1999.
David Maier. Database Desiderata for an XML Query Language. In Proc. of the Query Languages Workshop. Cambridge, Mass., December 1998.
J. McCarthy and P. Hayes. Some philosophical problems from the standpoint of artificial intelligence. In D. Michie and B. Meltzer,editors, Machine Intelligence, volume 4. Wiley, NewYork, 1969.
N.W. Paton, R. Stevens, P.G. Baker, C.A. Goble, S. Bechhofer, and A. Brass. Query Processing in the TAMBIS Bioinformatics Source Integration System. In Proc. 11th Int. Conf. on Scientific and Statistical Databases (SSDBM), pages 138–147 1999. IEEE Press, 1999.
J. Robie, J. Lapp, and D. Schach. XML Query Language (XQL). In Proc. of the Query Languages workshop, Cambridge, Mass., December 1998.
F. De Saussure. Cours de Lingistique Generale. Tullio de Mauro, Paris: Payot, 1972.
R. Schank. Identification of conceptualizations underlying natural language. In Computer Models of Thought and Language, pages 187–247. Freeman, San Francisco, CA, 1973.
R. Stevens, P. Baker, S. Bechhofer, G. Ng, A. Jacoby, N.W. Paton, and C.A. Goble. TAMBIS: Transparent Access to Multiple Bioinformatics Information Sources. Bioinformatics, 16(2):184–186, 2000.
S. Ullman. Semantics-An Introduction to the Science of Meaning. Blackwell, Oxford, 1962.
L. Wittgestein. Philosophical Investigations. Blackwell, Oxford:Basil, 1953.
W. A. Woods. Transition network grammars for natural language analysis. CACM, 13(10):591–606, Oct 1970.
G. Zhang, W.W. Chu, F. Meng, and G. Kong. Query Formulation from High-Level Concepts for Relational Databases. In N. Paton and T. Griffiths, editors, Proc. User Interfaces to Data Intensive Systems, UIDIS 99, pages 64–74, Edinburgh, Scotland, September (dy1999). IEEE Computer Society Press.
Guogen Zhang. Interactive Query Formulation Techniques for Databases. PhD thesis, University of California, Los Angeles, 1998.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2002 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Kapetanios, E., Groenewoud, P. (2002). Query Construction through Meaningful Suggestions of Terms. In: Carbonell, J.G., Siekmann, J., Andreasen, T., Christiansen, H., Motro, A., Legind Larsen, H. (eds) Flexible Query Answering Systems. FQAS 2002. Lecture Notes in Computer Science(), vol 2522. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-36109-X_18
Download citation
DOI: https://doi.org/10.1007/3-540-36109-X_18
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-00074-7
Online ISBN: 978-3-540-36109-1
eBook Packages: Springer Book Archive