A Formal Suite of Object Relational Database Metrics

Authors: Justus S, K Iyakutti

Abstract:

Object Relational Databases (ORDB) are complex in nature than traditional relational databases because they combine the characteristics of both object oriented concepts and relational features of conventional databases. Design of an ORDB demands efficient and quality schema considering the structural, functional and componential traits. This internal quality of the schema is assured by metrics that measure the relevant attributes. This is extended to substantiate the understandability, usability and reliability of the schema, thus assuring external quality of the schema. This work institutes a formalization of ORDB metrics; metric definition, evaluation methodology and the calibration of the metric. Three ORDB schemas were used to conduct the evaluation and the formalization of the metrics. The metrics are calibrated using content and criteria related validity based on the measurability, consistency and reliability of the metrics. Nominal and summative scales are derived based on the evaluated metric values and are standardized. Future works pertaining to ORDB metrics forms the concluding note.

Keywords: Measurements, Product metrics, Metrics calibration, Object-relational database.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1056673

References:

[1] Henderson-Sellers, B. Object-oriented Metrics - Measures of complexity, Prentice-Hall, Upper Saddle River, New Jersey, 1996.
[2] Baroni. A.L, C, Calero, F.B. Abreu and Mario Piatini, "Object relational Metrics Formalization", in Proc. of the Sixth International Conference on Quality Software. 2006. Available: doi.ieeecomputersociety.org/10.1109/QSIC.2006.44.
[3] Baroni.A.L, C. Calero, F. Ruiz and F. Brito eAbreu, "Formalizing Object-Relational Structural Metrics", in Proc. 5th Portuguese Association of Information Systems Conference, November, 2004. http://ctp.di.fct.unl.pt/QUASAR/Resourses/Paper/2004/baroni5CAPSI.p df
[4] Piattini M., Calero C., Sahraoui. H., Lounis H., "Object-Relational Database Metrics", L'object, March, 2001. Available: www.iro.umontreal.ca/~sahraouh/papers/lobjet00_1.pdf
[5] Justus S., "Metrics for Object Relational Databases", in Proc. International Conference on Recent Trends in Information Systems, ISBN: 81-7764-954-X, 483-496, 2006.
[6] Justus S, and Iyakutti. K., "Assessing the Object-level behavioral complexity in Object Relational Databases", Conf. Rec. 3rd IEEE sponsored International Conference on Software Science, Technology and Engineering, Israel, 2007, pp. 48-59, Available:doi.ieeecomputersociety.org/10.1109/SWSTE.2007.6
[7] Chidamber. S.R and Kemerer. C.F., A metrics suite for object oriented design. IEEE Transactions on Software Engineering, Vol. 20, 1994, pp.476-493.
[8] Ammar. H.H., S.M. Yacoub and T. Robinson, "Dynamic metrics for object-oriented designs," in Proc. The 5th International Software Metrics Symposium, Boca Raton, Florida, USA, 1999, pp. 50-61.
[9] Arisholm. E, L.C. Briand, and A. Foyen, 2004. "Dynamic coupling measures for object-oriented software", IEEE Transactions on Software Engineering, Vol. 30, No. 8, pp. 491-506, 2004.
[10] Baroni A. L, "Formal Definition of Object-Oriented Design Metrics", Master Thesis. Vrije Universiteit Brussel - Belgium, 2002.
[11] Berard E. "Metrics for Object-Oriented Software Engineering," an Internet posting on Computer Software Engineering, January 28th, 1995.
[12] Moris. K., "Metrics for object oriented software development", Masters Thesis, M.I.T Sloan School of Management, Cambridge, MA, 1998
[13] David P, C.F. Kemerer, Sandra A.S., and James E.T., "The Structural Complexity of Software: An Experimental Test", IEEE Trans on Software Engineering, Vol. 31, No. 11, 2005, pp.982-995.
[14] Steve Counsell and Stephen Swift, "The Interpretation and utility of three cohesion metrics for object-oriented design", ACM Trans on Software Engineering and Methodology, Vol.15, No.2, 2006, pp.123- 149.
[15] Mitchell and J.F. Power, "Toward a definition of run-time objectoriented metrics", in Proc. 7th ECOOP Workshop on Quantitative Approaches in Object-Oriented Software Engineering (QAOOSE-2003), Darmstadt, Germany, July 2003.
[16] Mitchell and J.F. Power, 2004. "Run-Time Cohesion Metrics: An Empirical Investigation", in Proc. International Conference on Software Engineering Research and Practice, Las Vegas, Neveda, USA, June 2004, pp.532-537.
[17] Tobias Mayer, Tracy Hall, "A Critical Analysis of Current OO Design Metrics", Software Quality Journal, Vol. 8, No.2, Jun 1999.
[18] Elmasri. R and S. Navathe, Fundamentals of Database systems, Fourth edition, Addison-Wesley, Massachussets, 1999.
[19] Wook-Shin Han, Kyu-Young Whang, Yang-Sae Moon, "A Formal Framework for Prefecting based on the Type-Level Access Pattern in Object-Relational DBMSs", IEEE Transactions on Knowledge and Data Engineering, Vol.17, No.10, 2005, pp.1436-1448.
[20] Calero, C, Ruiz, F., Baroni, A., Brito e Abreu, F., Piattini, M., "An Ontological approach to describe the SQL: 2003 Object-Relational Features", International Journal Computer Standards & Interfaces, Vol. 28, 2006, pp.695-713.
[21] Michura. J, Capretz. M.A.M., "Metrics Suite for Class Complexity", in Proc. International Conference on Information Technology: Coding and Computing (ITCC-05), 2005.
[22] Pressman R.S., Software Engineering: A Practitioners- Approach, McGraw-Hill International Edition, Fifth Edition, 2001.
[23] Bunge. M., Treatise on Basic Philosophy: Ontology II: The World of Systems, Boston, Riedel, 1979.
[24] Baroni, A.L., Coral. C., Mario Piattini and Abreu. F.B., "A Formal Definition for Object Relational Database Metrics", Url: http://:ctp.di.fct.unl.pt/QUASAR/Resources/Papers/2005/baroniICEIS.p df, Visited: January, 2008.
[25] Justus S, and Iyakutti. K., "An Empirical Investigation on the Understandability of ORDB metrics", in Proc. International Conference on Modeling and Simulation. India, 2007.
[26] Kothari. C.R., Research Methodology, Methods and Techniques, Wiley Eastern Limited, ISBN 0852264771, 1990.
[27] E. Weyuker, "Evaluating software complexity measures," IEEE Trans. Software Eng., vol. 14, 1988, pp. 1357-1365.
[28] Zusc. H., "Properties of Software measures", Software Quality Journal, Vol. 1, 1992.
[29] Cherniavsky. J.C and C.H. Smith, "On Weyuker-s axioms for software complexity measures", IEEE Transactions on Software Engineering, Vol. 17, 1991, pp.197-211.
[30] Justus S, and Iyakutti. K., "Object Relational Database Metrics: Classified and Evaluated", in Proc. of International Workshop on Software Engineering, ISBN-10: 3-8322-5611-3, Potsdam, Germany, 2006, pp. 119-131.
[31] Justus S, and Iyakutti. K., "The Theory of Time and Space in Object Relational Databases", Conf. Rec. IEEE International Conference on Computing Intelligence and Multimedia Applications, India, 2007, pp.575-580, doi.ieeecomputersociety.org/10.1109/ICCIMA.2007.410