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