Please use this identifier to cite or link to this item:
Authors: Keramopoulos, Euclid
Dervos, Dimitris A.
Deligiannis, Ignatios
Evangelidis, Georgios
Pouyioutas, Philippos
Type: Conference Paper
Subjects: FRASCATI::Natural sciences::Computer and information sciences
Keywords: graphical query languages
relational database model
object-relational database model
object-oriented database model
semistructured database model
Issue Date: 2012
Publisher: IATED
Volume: EDULEARN12 Proceedings
First Page: 3964
Last Page: 3970
Volume Title: 4th International Conference on Education and New Learning Technologies
Abstract: 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.
ISSN: 2340-1117
Appears in Collections:Department of Applied Informatics

Files in This Item:
File Description SizeFormat 
2012_EDULEARN.pdf146,98 kBAdobe PDFView/Open

This item is licensed under a Creative Commons License Creative Commons