Aline Lúcia Baroni, Coral Calero, Mario Piattini, Fernando Brito e Abreu



Relational databases are the most important in the database world and are evolving to object-relational databases in order to allow the possibility of working with new and complex data and applications. One widely accepted mechanism for assuring the quality of an object-relational database is the use of metrics formally and empirically validated. Also it is important to formalize the metrics for having a better understanding of their definitions. Metrics formalization assures the reliable repetition of their computation and facilitates the automation of metrics collection. In this paper we present the formalization of a set of metrics defined for object-relational databases described using SQL:2003. For doing the formalization we have produced the ontology of the SQL:2003 as a framework for representing the SQL schema definitions. The ontology has been represented using UML and the definition of the metrics has been done using OCL (Object-Constraint Language) which is part of the UML 2.0 standard.


  1. Baroni A. L., 2002. Formal Definition of Object-Oriented Design Metrics. Master Thesis. Vrije Universiteit Brussel - Belgium, in collaboration with Ecole des Mines de Nantes - France and New University of Lisbon - Portugal. August.
  2. Baroni A. L., Brito e Abreu F., 2002. Formalizing ObjectOriented Design Metrics upon the UML Meta-Model. In Proceedings of the 16th Brazilian Symposium on Software Engineering, Gramado - RS, Brazil. October.
  3. Basili V., Briand L., Melo W. L., 1996. A Validation of Object-Oriented Design Metrics as Quality Indicators. IEEE Transactions on Software Engineering, vol. 22, pp. 751-760.
  4. Briand L., Arisholm S., Counsell F., Houdek F., Thévenod-Fosse P., 1999. Empirical Studies of Object-Oriented Artifacts, Methods, and Processes: State of the Art and Future Directions. Empirical Software Engineering, 4 (4), 387-404.
  5. Briand L., El Emam K., Morasca, S., 1995. Theoretical and Empirical Validation of Software Product Measures. International Software Engineering Research Network, Technical Report ISERN-95-03.
  6. Briand L., Morasca S., Basili, V., 1996. Property-Based Software Engineering Measurement. IEEE Transactions on Software Engineering. 22 (1). pp.68-85.
  7. Chidamber S., Kemerer C., 1994. A Metrics Suite for Object-Oriented Design. IEEE Transactions on Software Engineering. 20 (6). pp.476-493. June.
  8. Fenton N., Pfleeger S. L., 1997. Software Metrics: A Rigorous Approach 2nd. edition. London. Chapman & Hall.
  9. ISO/IEC 9075 Standard, 2003. Information Technology - Database Languages - SQL, International Organization for Standardization.
  10. ISO/IEC 9126 Standard, 2001. Software Product Evaluation-Quality Characteristics and Guidelines for Their Use, International Organization for Standardization.
  11. Leavitt N., 2000. Whatever Happened to Object-Oriented Databases?. IEEE Computer Society. pp. 16-19.
  12. Li W., Henry S., 1993. Object-Oriented Metrics that Predicts Maintainability, Journal of Systems and Software, 23, 111-122.
  13. Melton, J., 2003. Advanced SQL:2003. Understanding object-relational and other features. Morgan Kauffman Publishers. Elsevier Science. USA
  14. OMG, 2003. UML 2 Object Constraint Language Specification (version 2.0)”, Object Management Group, October.
  15. OMG, 2003. Unified Modeling Language Specification (version 1.5), Object Management Group, March.
  16. Pfleeger, S. L., 1997. Assessing Software Measurement. IEEE Software. March/April. pp. 25-26.
  17. Piattini M., Calero C., Sahraoui H., Lounis H., 2001. Object-Relational Database Metrics. L'Object, vol. March.
  18. Sneed H. M., Foshag O., 1998. Measuring Legacy Database Structures. Proceedings of the European Software Measurement Conference (FESMA 98). Antwerp. May 6-8. Coombes. Van Huysduynen and Peeters (eds.). pp.199-211.
  19. Stonebraker M., Brown P., 1999. Object-Relational DBMSs Tracking the Next Great Wave, California, Morgan Kauffman Publishers.
  20. Zuse H., 1998. A Framework of Software Measurement. Berlin. Walter de Gruyter.

Paper Citation

in Harvard Style

Lúcia Baroni A., Calero C., Piattini M. and Brito e Abreu F. (2005). A FORMAL DEFINITION FOR OBJECT-RELATIONAL DATABASE METRICS . In Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 972-8865-19-8, pages 334-339. DOI: 10.5220/0002510503340339

in Bibtex Style

author={Aline Lúcia Baroni and Coral Calero and Mario Piattini and Fernando Brito e Abreu},
booktitle={Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS,},

in EndNote Style

JO - Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS,
SN - 972-8865-19-8
AU - Lúcia Baroni A.
AU - Calero C.
AU - Piattini M.
AU - Brito e Abreu F.
PY - 2005
SP - 334
EP - 339
DO - 10.5220/0002510503340339