CONTINUOUS CONCEPTUAL SCHEMA QUALITY CHECKING

Christian Kop

2009

Abstract

Since a conceptual database schema is the backbone of data intensive software, the schema must be continuously checked during the requirements engineering step in order to get the proper quality. One possibility is to check if the conceptual schema of the database provides the necessary data for retrieval needs. Talking about the retrieval needs would help but SQL is too technical for that purpose. To solve this problem, this paper presents an approach which uses controlled language queries for checking a conceptual schema.

References

  1. 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.
  2. 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 2nd Conference ISTA 2003, GI Lecture Notes in Informatics, Vol. p-30, Koellen Verlag,, Bonn, 2003, pp. 153 - 165.
  3. 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.
  4. 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.
  5. Embley, D.W., 1989. NFQL: The Natural Forms Query Language. In ACM Transactions on Database Systems, Vol. 14. No. 2., 1989, pp. 168 - 211.
  6. 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
  7. 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.
  8. 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.
  9. 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.
  10. 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.
  11. 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.
  12. 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 10th International Conference on Applications of Natural Language to Information Systems (NLDB 2005), Lecture Notes in Computer Science (LNCS), Vol. 3531, 2005, pp. 10 - 20.
  13. Kapetainos, E, Baer, D, Groenewoud P., 2005. Simplifying syntactic and semantic parsing of NLbased queries in adavanced application domains. In Data & Knowledge Engineering Journal , Vol. 55, 2005, pp. 38 - 58.
  14. Kao, M.; Cercone, N.; Luk, W.-S., 1988. Providing quality responses with natural language interfaces: the null value problem”. In IEEE Transactions on Software Engineering, Volume 14 (7), 1988, pp. 959 - 984.
  15. Lindland, O., Sindre, G., Solvberg, A..: Understanding Quality in Conceptual Modeling, IEEE Software, March 1994, pp. 29 - 42.
  16. Moody, D., 1996. Graphical Entity Relationship Models: Towards a More User Understandable Representation of Data. In Thalheim, B. (Ed.): Proceedings of the 15th International Conference on Conceptual Modelling, Cottbus, Germany, Lecture Notes in Computer Science (LNCS), Vol. 1157. Springer Verlag Berlin Heidelberg New York, 1996, pp. 227 - 245.
  17. Moody, D., 2005. Theoretical and practical issues in evaluating quality of conceptual models: current state and future directions. In Data & Knowledge Engineering Volume 55, 2005, pp. 243 - 276
  18. Nijssen, G.M., Halpin, T.A., 1989. Conceptual Schema and Relational Database Design - A fact oriented approach, Prentice Hall Publishing. Company. 1989.
  19. Owei, V, Rhee, H-S., Navathe, Sh., 1997, Natural Language Query Filtration in the Conceptual Query Language. In Proceedings of the 30th Hawaii International Conference on System Science, Vol. 3. IEEE Press, 1997, pp. 539 - 550.
  20. Stratica, N., Kosseim, L., Desai, B.C., 2005. Using semantic templates for a natural language interface to the CINDI virtual library. In Data & Knowledge Engineering, Vol 55, 2005, pp. 4 - 19.
  21. Terwillinger, J.F., Delcambre, L.M., Logan, J., 2007. Queyring through a user interface. In Data & Knowledge Engineering, Vol. 63, 2007, 774 - 794.
Download


Paper Citation


in Harvard Style

Kop C. (2009). CONTINUOUS CONCEPTUAL SCHEMA QUALITY CHECKING . In Proceedings of the 4th International Conference on Software and Data Technologies - Volume 1: ICSOFT, ISBN 978-989-674-009-2, pages 186-193. DOI: 10.5220/0002254101860193


in Bibtex Style

@conference{icsoft09,
author={Christian Kop},
title={CONTINUOUS CONCEPTUAL SCHEMA QUALITY CHECKING},
booktitle={Proceedings of the 4th International Conference on Software and Data Technologies - Volume 1: ICSOFT,},
year={2009},
pages={186-193},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002254101860193},
isbn={978-989-674-009-2},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 4th International Conference on Software and Data Technologies - Volume 1: ICSOFT,
TI - CONTINUOUS CONCEPTUAL SCHEMA QUALITY CHECKING
SN - 978-989-674-009-2
AU - Kop C.
PY - 2009
SP - 186
EP - 193
DO - 10.5220/0002254101860193