The design and implementation of a meaning driven data query language

Kapetanios, E., Baer, D., Groenewoud, P. and Mueller, P. 2002. The design and implementation of a meaning driven data query language. in: Proceedings of the 14th International Conference on Scientific and Statistical Database Management, July 24-26, 2002, Edinburgh, Scotland, UK. USA IEEE . pp. 20-23

Chapter titleThe design and implementation of a meaning driven data query language
AuthorsKapetanios, E., Baer, D., Groenewoud, P. and Mueller, P.
Abstract

We present the design and implementation of a Meaning Driven Data Query Language - MDDQL - which aims at the construction of queries through system made suggestions

of natural language based query terms for both scientific

application domain terms and operator/operation ones. A query construction blackboard is used where query language

terms are suggested to the user in its preferred natural

language and in a name centered way, together with their connotation. This helps in understanding the meaning of the terms and/or operators or operations to be included in the query. Furthermore, the construction of the query turns out to be an incremental refinement of the query under construction through semantic constraints, where only those domain language terms and/or operators/operations are suggested which result into meaningful combinations of query terms as related to the scientific application domain

semantics. Therefore, semantically meaningless queries can be prevented during the query construction. Such a semantics aware mechanism is not available in conventional database query languages such as SQL, where one is allowed to execute a query calculating, for example, the average of numerical data values whereas they represent the codes of categorical values. Moreover, no familiarity with the semantics of complex database schemes or interpretation

of the symbols (names of classes/tables/attributes, value codes) underlying the storage model, as well as familiarity with the syntax of a database specific query language are needed by the end-user. The constructed query can be submitted to the MDDQL query interpretation and transformation engine, where the corresponding SQL-query

is generated and delegated to a DBMS (e.g., Oracle, MSAccess, SQL-Server). Generation of SQL-statements addressing NF2 data models such as those provided by the

object-relational Oracle DBMS is also enabled. The query

result is presented in a table based form where all storage

model symbols are interpreted and can be exported for the

usage with statistical software packages (e.g., SPSS).

Book titleProceedings of the 14th International Conference on Scientific and Statistical Database Management, July 24-26, 2002, Edinburgh, Scotland, UK.
Page range20-23
Year2002
PublisherIEEE
FileKapetanios_Baer_Groenewoud_Mueller_final.pdf
Publication dates
Published2002
Place of publicationUSA
ISBN0769516327
Digital Object Identifier (DOI)doi:10.1109/SSDM.2002.1029702

Related outputs

Are Deep Learning Approaches Suitable for Natural Language Processing?
Alshahrani, S. and Kapetanios, E. 2016. Are Deep Learning Approaches Suitable for Natural Language Processing? NLDB 2016: 21st International Conference on Applications of Natural Language to Information Systems. Salford, Manchester, UK 22 - 25 Jun 2016 Springer.

A cross-lingual knowledge base
Kapetanios, E. A cross-lingual knowledge base.

Developing Prognostic Models Using Duality Principles for DC-to-DC Converters
Samie, M., Motlagh, A.M.S., Alghassi, A., Perinpanayagam, S. and Kapetanios, E. 2015. Developing Prognostic Models Using Duality Principles for DC-to-DC Converters. IEEE Transactions on Power Electronics. 30 (5), pp. 2872 - 2884.

Reliability enhanced EV using pattern recognition techniques
Samie, M., Motlagh, A.M.S., Alghassi, A., Perinpanayagam, S. and Kapetanios, E. 2014. Reliability enhanced EV using pattern recognition techniques. Electric Vehicle Conference (IEVC), 2014 IEEE International . Florence 17 Dec 2014 IEEE .

Principle of Duality on Prognostics
Samie, M., Amir, M., Motlagh, A.M.S., Alghassi, A., Perinpanayagam, S. and Kapetanios, E. 2014. Principle of Duality on Prognostics. International Journal of Advanced Computer Science and Applications(IJACSA). 5 (6), pp. 43-52.

HREBS and cohesion chains as similar tools for semantic text properties research
Tatar, D., Lupea, M. and Kapetanios, E. 2013. HREBS and cohesion chains as similar tools for semantic text properties research. KEPT 2013: Knowledge Engineering: Principles and Techniques Conference. Babes-Bolyai University, Cluj-Napocca, Romania July 5-7, 2013

Entangled semantics
Tanase, D. and Kapetanios, E. 2013. Entangled semantics. Métais, E., Meziane, F., Saraee, M., Sugumaran, V. and Vadera, S. (ed.) NLDB 2013: 18th International Conference on Application of Natural Language to Information Systems. University of Salford, Manchester, UK 19-21 June 2013 Springer.

Natural language processing: semantic aspects
Kapetanios, E., Tatar, D. and Sacarea, C. 2013. Natural language processing: semantic aspects. London CRC Press, Taylor & Francis.

Are SKOS concept schemas ready for multilingual applications?
Tanase, D. and Kapetanios, E. 2012. Are SKOS concept schemas ready for multilingual applications? in: Sack, H. and Pellegrini, T. (ed.) I-SEMANTICS 2012 - proceedings of the 8th International Conference on Semantic Systems, Graz, Austria — September 05 - 07, 2012 New York ACM. pp. 149-156

Ontology-based operational risk management
Lykourentzou, I., Papadaki, K., Kalliakmanis, A., Djaghloul, Y., Latour, T., Charalambis, I. and Kapetanios, E. 2011. Ontology-based operational risk management. in: 2011 IEEE 13th conference on commerce and enterprise computing (CEC) Luxembourg IEEE . pp. 153-160

Collective intelligence systems: classification and modeling
Lykourentzou, I., Vergados, D., Kapetanios, E. and Loumos, V. 2011. Collective intelligence systems: classification and modeling. Journal of Emerging Technologies in Web Intelligence (JETWI). 3 (3), pp. 217-226.

Collectively intelligent information and knowledge management
Kapetanios, E., Chbeir, R. and Andres, F. 2010. Collectively intelligent information and knowledge management. International Journal of Organizational and Collective Intelligence. 1 (4).

Exploring the relationship between UML design metrics for Web applications and maintainability
Ghosheh, E., Black, S.E., Kapetanios, E. and Baldwin, M. 2010. Exploring the relationship between UML design metrics for Web applications and maintainability. Journal of Object Technology. 9 (3), pp. 125-144.

Text segments as constrained formal concepts
Tatar, D., Kapetanios, E., Sacarea, C. and Tanase, D. 2010. Text segments as constrained formal concepts. in: Ida, T., Negru, V., Jebelean, T., Petcu, D., Watt, S. and Zaharie, D. (ed.) 12th International Symposium on Symbolic and Numeric Algorithms for Scientific Computing (SYNASC), Timisoara, Romania, 23-26 September 2010 IEEE . pp. 223-228

Weighting common syntactic structures for natural language based information retrieval
Liu, C., Wang, H., McClean, S.I. and Kapetanios, E. 2010. Weighting common syntactic structures for natural language based information retrieval. CIKM 2010: 19th ACM International Conference on Information and Knowledge Management. Toronto, Canada 26 - 30 Oct 2010

On the notion of collective intelligence: opportunity or challenge?
Kapetanios, E. 2010. On the notion of collective intelligence: opportunity or challenge? International Journal of Organizational and Collective Intelligence. 1 (1), pp. 1-14.

Guest editorial: Special issue on collective intelligence
Kapetanios, E. and Koutrika, G. 2010. Guest editorial: Special issue on collective intelligence. Information Sciences. 180 (1), pp. 1-3.

Guest editorial: Special Issue – 13th International Conference on Natural Language and Information Systems (NLDB 2008)
Kapetanios, E., Sugumaran, V. and Spiliopoulou, M. 2010. Guest editorial: Special Issue – 13th International Conference on Natural Language and Information Systems (NLDB 2008). Data & Knowledge Engineering. 69 (3), pp. 249-250.

At the cross-road of the social Web and cross-lingual information retrieval
Tanase, D. and Kapetanios, E. 2009. At the cross-road of the social Web and cross-lingual information retrieval. in: Murugesan, S. (ed.) Handbook of research on Web 2.0, 3.0, and X.0: technologies, business, and social applications USA Information Science Reference.

Natural language and information systems: 13th international conference on applications of natural language to information systems, NLDB 2008, London, UK, June 24-27, 2008 proceedings
Kapetanios, E., Sugumaran, V. and Spiliopoulou, M. 2009. Natural language and information systems: 13th international conference on applications of natural language to information systems, NLDB 2008, London, UK, June 24-27, 2008 proceedings. Springer.

Quo Vadis computer science: from Turing to personal computer, personal content and collective intelligence
Kapetanios, E. 2008. Quo Vadis computer science: from Turing to personal computer, personal content and collective intelligence. Data & Knowledge Engineering. 67 (2), pp. 286-292.

A parametric linguistics based approach for cross-lingual web querying
Kapetanios, E., Sugumaran, V. and Tanase, D. 2008. A parametric linguistics based approach for cross-lingual web querying. Data & Knowledge Engineering. 66 (1), pp. 35-52.

Evaluating the impact of personal dictionaries for cross-language information retrieval of socially annotated images
Tanase, D. and Kapetanios, E. 2008. Evaluating the impact of personal dictionaries for cross-language information retrieval of socially annotated images. iCLEF Workshop. Aarhus, Denmark 16 Sep 2008

An algebra and conceptual model for semantic tagging of collaborative digital libraries
Kapetanios, E. and Schall, M. 2007. An algebra and conceptual model for semantic tagging of collaborative digital libraries. Second Workshop on Foundations of Digital Libraries in conjunction with 11th European Conference on Research and Advanced Technologies on Digital Libraries (ECDL 2007). Budapest, Hungary 20 Sep 2007

Cross-lingual information retrieval and delivery using community mobile networks
Schriram, R., Sugumaran, V. and Kapetanios, E. 2006. Cross-lingual information retrieval and delivery using community mobile networks. in: 1st International Conference on Digital Information Management Los Alamitos, USA IEEE . pp. 320-325

Multi-lingual Web querying: a parametric linguistics based approach
Kapetanios, E., Sugumaran, V. and Tanase, D. 2006. Multi-lingual Web querying: a parametric linguistics based approach. in: Kop, C., Fliedl, G., Mayr, H.C. and Metais, E. (ed.) Natural Language Processing and Information Systems: 11th International Conference on Applications of Natural Language to Information Systems, NLDB 2006, Klagenfurt, Austria, May 31 - June 2, 2006. Proceedings Berlin, Germany Springer.

Simplifying syntactic and semantic parsing of NL-based queries in advanced application domains
Kapetanios, E., Baer, D. and Groenewoud, P. 2005. Simplifying syntactic and semantic parsing of NL-based queries in advanced application domains. Data & Knowledge Engineering. 55 (1), pp. 38-58.

Multi-lingual database querying and the atoms of language
Kapetanios, E. and Chountas, P. 2005. Multi-lingual database querying and the atoms of language. in: Montoyo, A., Munoz, R. and Metais, E. (ed.) Natural Language Processing and Information Systems: 10th International Conference on Applications of Natural Language to Information Systems, NLDB 2005, Alicante, Spain, June 15-17, 2005. Proceedings Berlin, Germany Springer.

MDDQL: an ontology driven, multi-lingual query language and system for an integrated view of heterogeneous data sources
Kapetanios, E. and Chountas, P. 2005. MDDQL: an ontology driven, multi-lingual query language and system for an integrated view of heterogeneous data sources. Semantic Technology Conference 2005. California, USA 07-10 Mar 2005

On the relativity of ontological domains and their specifications
Kapetanios, E. 2005. On the relativity of ontological domains and their specifications. in: Khosrow-Pour, M. (ed.) Encyclopedia of information science and technology Hershey, USA Idea Group Reference.

MDDQL-Stat: data querying and analysis through integration of intentional and extensional semantics
Kapetanios, E., Baer, D., Glaus, B. and Groenewoud, P. 2004. MDDQL-Stat: data querying and analysis through integration of intentional and extensional semantics. in: 16th International Conference on Scientific and Statistical Database Management (SSDBM'04) USA IEEE . pp. 353-356

Assessment of indications in interventional cardiology: appropriateness and necessity of coronary angiography and revascularization
Schilling, J., Gerstl, P., Kapetanios, E., Lee, C.Y. and Bertel, O. 2003. Assessment of indications in interventional cardiology: appropriateness and necessity of coronary angiography and revascularization. American Journal of Medical Quality. 18 (4), pp. 155-163.

Simplifying syntactic and semantic parsing of NL-based queries in advanced application domains
Kapetanios, E., Baer, D. and Groenewoud, P. 2003. Simplifying syntactic and semantic parsing of NL-based queries in advanced application domains. in: Dusterhoft, A. and Thalheim, B. (ed.) Natural Language Processing and Information Systems, 8th International Conference on Applications of Natural Language to Information Systems, June 2003, Burg (Spreewald), Germany Springer. pp. 127-140

Query construction through meaningful suggestions of terms
Kapetanios, E. and Groenewoud, P. 2002. Query construction through meaningful suggestions of terms. in: Andreasen, T. (ed.) FQAS '02: Proceedings of the 5th International Conference on Flexible Query Answering Systems Berlin, Germany Springer.

A semantically advanced querying methodology for medical knowledge and decision support
Kapetanios, E. 2002. A semantically advanced querying methodology for medical knowledge and decision support. in: Grutter, R. (ed.) Knowledge media in healthcare: opportunities and challenges Hershey, USA Idea Group Publishing. pp. 96-130

A meaning driven querying methodology: end user oriented querying
Kapetanios, E. 2001. A meaning driven querying methodology: end user oriented querying. PhD thesis Swiss Federal Institute of Technology (ETH), Zurich Department of Computer Science

A semantics based interactive query formulation technique
Baer, D., Groenewoud, P., Kapetanios, E. and Keuser, S. 2001. A semantics based interactive query formulation technique. in: Proceedings of the Second International Workshop on User Interfaces to Data Intensive Systems (UIDIS'01) USA IEEE . pp. 43-49

Appropriateness and necessity research on the internet: using a "second opinion system"
Schilling, J., Faisst, K., Kapetanios, E., Wyss, P., Norrie, M.C. and Gutzwiller, F. 2000. Appropriateness and necessity research on the internet: using a "second opinion system". Methods of Information in Medicine. 39 (3), pp. 233-237.

MDDQL: a visual query language for metadata driven querying
Kapetanios, E., Norrie, M.C. and Fuhrer-Stakic, D. 2000. MDDQL: a visual query language for metadata driven querying. in: Arisawa, H. and Catarci, T. (ed.) Advances in Visual Information Management: proceedings of the Fifth Working Conference on Visual Database Systems (VDB5), Fukuoka, Japan, May 10-12, 2000 London, UK Kluwer Academic Publishers.

An information states blackboard as an intelligent querying interface for snow and avalanche data
Kapetanios, E., Norrie, M.C. and Frei, A. 1999. An information states blackboard as an intelligent querying interface for snow and avalanche data. in: Paton, N.W. and Griffiths, T. (ed.) User Interfaces to Data Intensive Systems: proceedings USA IEEE . pp. 32-41

Context based querying of scientific data: changing querying paradigms?
Kapetanios, E., Norrie, M.C. and Brabec, B. 1999. Context based querying of scientific data: changing querying paradigms? in: Miller, C. and Musick, R. (ed.) Third IEEE Metadata Conference Proceedings, 06-07 April 1999, Bethesda, MD IEEE .

Permalink - https://westminsterresearch.westminster.ac.uk/item/93x60/the-design-and-implementation-of-a-meaning-driven-data-query-language


Share this
Tweet
Email