About this paper

Appears in:
Pages: 3964-3970
Publication year: 2012
ISBN: 978-84-695-3491-5
ISSN: 2340-1117

Conference name: 4th International Conference on Education and New Learning Technologies
Dates: 2-4 July, 2012
Location: Barcelona, Spain

CRITICAL ANALYSIS OF DESIGNING A GRAPHICAL QUERY LANGUAGE

E. Keramopoulos1, D. Dervos1, I. Deligiannis1, G. Evangelidis2, P. Pouyioutas3

1Alexander Technological Educational Institute of Thessaloniki (GREECE)
2University of Macedonia (GREECE)
3University of Nicosia (CYPRUS)
The last two decades the information has been stored in a plethora of different databases, locations and data models. In many cases, companies and organizations use data, that stored in a variety of data models and remote database servers, which can be correlated. A challenge would be to define queries joining data from all those different sources. Thus, data can be found in Relational, Object-Relational, Object-Oriented, XML or even in text files. For each model there is a corresponding query language, i.e. SQL, SQL3, OQL and XQuery. Moreover, it is very tricky to join data from different sources and we have not found in the literature a query language that has been designed to use data in the same query from Relational, Object-Relational, Object-Oriented and XML databases.

On the other hand, the query syntax, of all the above mentioned query languages, is complicated and demanding especially for novice users. The majority of computer users need only to learn how to complete simple work tasks, whereas the problems they have to solve are usually expressed in non-computing terms. For this reason users prefer to use graphical query languages instead of a query language that has a textual syntax.

In this paper, we present our conclusions in designing graphical query languages (GQLs). We have already designed, developed and evaluated, by organizing a controlled experiment, two GQLs, i.e. GOQL for Object-Oriented Database System and KINISIS for XML databases. The most important lesson that we learned is that it is very important the design of a graphical query language to be “free” of the underlying query language. Finally, we introduce a solution to the problem of joining data from different sources which stored in different database models, based on a graphical query language.
@InProceedings{KERAMOPOULOS2012CRI,
author = {Keramopoulos, E. and Dervos, D. and Deligiannis, I. and Evangelidis, G. and Pouyioutas, P.},
title = {CRITICAL ANALYSIS OF DESIGNING A GRAPHICAL QUERY LANGUAGE},
series = {4th International Conference on Education and New Learning Technologies},
booktitle = {EDULEARN12 Proceedings},
isbn = {978-84-695-3491-5},
issn = {2340-1117},
publisher = {IATED},
location = {Barcelona, Spain},
month = {2-4 July, 2012},
year = {2012},
pages = {3964-3970}}
TY - CONF
AU - E. Keramopoulos AU - D. Dervos AU - I. Deligiannis AU - G. Evangelidis AU - P. Pouyioutas
TI - CRITICAL ANALYSIS OF DESIGNING A GRAPHICAL QUERY LANGUAGE
SN - 978-84-695-3491-5/2340-1117
PY - 2012
Y1 - 2-4 July, 2012
CI - Barcelona, Spain
JO - 4th International Conference on Education and New Learning Technologies
JA - EDULEARN12 Proceedings
SP - 3964
EP - 3970
ER -
E. Keramopoulos, D. Dervos, I. Deligiannis, G. Evangelidis, P. Pouyioutas (2012) CRITICAL ANALYSIS OF DESIGNING A GRAPHICAL QUERY LANGUAGE, EDULEARN12 Proceedings, pp. 3964-3970.
User:
Pass: