construction of a schema as early as possible and
then during each refinement iteration step. Therefore
the focus is not a generation of SQL but on checking
the quality of the schema. It is thought as a help, if it
is necessary to check the schema, before any
prototype or user interface form can be built.
Opposite to the graphical query languages where the
query is constructed by navigating through the
schema, the end user must not necessarily be
confronted with the schema during creation of the
queries. This has the advantage that the user is not
influenced by the schema but freely names the
notions which he needs for the query. The query
then helps to check if the designed schema can
handle the notions used in the query.
6 SUMMARY
This work uses controlled language queries for
continuous schema quality checking. Each query is
applied on the schema in order to find defects which
can be a basis for discussion and further refinement
of the schema.
This strategy was chosen to give both developers
and end users the possibility to communicate about
the end users retrieval needs. It was of interest how
far such a language can be constructed without huge
linguistic lexicons. Instead only information which
is necessary to define a good schema and
information that could support the development of
data intensive software itself was allowed.
In future, the approach might be extended to
transform column names of an EXCEL sheet into a
query. The query language itself might be extended
to formulas.
REFERENCES
Assenova, P. Johannesson, P., 1996. Improving the
Quality in Conceptual Modelling by the Use of
Schema Transformations. In Thalheim, B. (ed.):
Proceedings of the 15th International Conference on
Conceptual Modeling, Cottbus, Germany, Lecture
Notes in Computer Science (LNCS), Vol. 1157.
Springer Verlag Berlin Heidelberg New York, 1996,
pp. 277 – 291.
Berger, H., Dittenbach, M., Merkl D., 2003. Quering
Tourism Information Systems in Natural Language, In
Godlevsky, M., Liddle, St., Mayr, H.C. (eds).
Informaton Systems Technology and its Applications –
Proceedings of the 2
nd
Conference ISTA 2003, GI
Lecture Notes in Informatics, Vol. p-30, Koellen
Verlag,, Bonn, 2003, pp. 153 – 165.
Bloesch, A.C., Halpin, T.A., 1996. ConQuer: A
Conceptual Query Language. In Thalheim, B. (ed.):
Proceedings of the 15th International Conference on
Conceptual Modeling, Cottbus, Germany, Lecture
Notes in Computer Science (LNCS), Vol. 1157.
Springer Verlag Berlin Heidelberg New York, 1996,
pp. 121 – 133.
Dalianis, H., 1992, A method for validating a conceptual
model by natural language discourse generation. In P.
Loucopoulos (Eds.), Proceedings of the Fourth
International Conference CAiSE’92 on Advanced
Information Systems Enginering. Lecture Notes in
Computer Sciences (LNCS) Vol. 594, Springer
Verlag, 1992, pp. 425-444.
Embley, D.W., 1989. NFQL: The Natural Forms Query
Language. In ACM Transactions on Database
Systems, Vol. 14. No. 2., 1989, pp. 168 – 211.
Easterbrook St., Yu, E., Aranda, J. Fan, Y. Horkoff, J.
Leica, M., Quadir, R.A., 2005, Do Viewpoints Lead to
Better Conceptual Models? An Exporatory Case
Study. In Proceedings of the 13th IEEE Conferences n
Requirements Engineering (RE’05). IEEE Press, 2005,
pp. 199 – 208
Fuchs, N.E., Höfler, S., Kaljurand, K., Rinaldi, F.,
Schneider G., 2005. Attempto Controlled English: A
Knowledge Representation Language Readable by
Humans and Machines. In Norbert Eisinger N. and
Maluszynski, J. (eds.): Reasoning Web, First
International Summer School 2005, Lecture Notes in
Computer Science (LNCS)mVol. 3564, Springer
Verlag, 2005 pp. 213-250.
Halpin, T., Curland, M., 2006. Automated Verbalization
for ORM 2. In Proceedings, OTM 2006 Workshops -
On the Move to Meaningful Internet Systems 2006,
Lecture Notes in Computer Science (LNCS 4278),
Springer Verlag, 2006, pp. 1181 – 1190.
ter Hofstede, A.H.M., Proper, H.A., van der Weide, Th.P.,
1996. Exploring Fact Verbalizations for Conceptual
Query Formulation. In. van de Riet, R.P., Burg,
J.F.M., van der Vos, A.J. Proceedings of the Second
International Workshop on Applications of Natural
Language to Information Systems, IOS Press,
Amsterdam, Oxford, Tokyo, 1996, pp. 40 – 51.
Jaakkola, H., Thalheim, B., 2003. Visual SQL – High
Quality ER Based Query Treatment”, In. Jeusfeld, M.,
Pastor, O. (eds.) Conceptual Modelling for Novel
Application Domains, Lecture Notes in Computer
Science (LNCS), Vol. 2814, Springer Verlag, Berlin,
Heidelberg, New York, 2003, pp. 129 – 139.
Järvelin, K., Niemi, T., Salminen, A., 2000. “The visual
query language CQL for transitive and relational
computation”. In Data & Knowledge Engineering,
Vol. 35, 2000, pp. 39 – 51.
Kardovácz, Z.T., 2005. On the Transformation of
Sentences with Genetive Relations to SQL Queries. In.
Montoyo, A., Munoz, R., Metais, E. (eds.)
Proceedings of the 10
th
International Conference on
Applications of Natural Language to Information
Systems (NLDB 2005), Lecture Notes in Computer
Science (LNCS), Vol. 3531, 2005, pp. 10 – 20.
ICSOFT 2009 - 4th International Conference on Software and Data Technologies
192